Adding iSheet entry via POST with populated lookup column

Question

Hi, I'd like to know if it's possible to use the API t to add a row with a lookup column populated. I understand there are some limits to where and how you can use lookup columns generally (i.e. not in an Excel import template) so it might just not be possible, but on the other hand, the isheet GET endpoint does return what I assume is all the data needed to actually find the desired item. As an example, I copied the below from the output of the GET endpoint on an item I manually populated the lookup column on; I then set it as the body of the POST call and it successfully created a row and populated the text field, but not the lookup column. I've tried several different variants of the body with no luck. Would be great to learn if it is indeed a known limitation, or if anyone's figured out any workaround. 546868 https://[our instance]/api/3/isheet/1466/items/546868 546868 https://[our instance]/api/3/isheet/1466/items/546868

Andrew Quinn · Answer

Peter, You've probably found the answer by now, but for the purposes of others having similar questions later down the track... If you are talking about an iSheet Link column (?) then the following payload is required (using JSON format): { "data": { "item": [ { "itemsequence": 1, "externalid": "", "alerteroption": 1, "column": [ { "attributecolumnid": 1111, "rawdata": { "isheetitems": { "isheetitem": [ { "recordid": 9999, "linkname": "Community Test" } ] } } } ] } ] } } Where 1111 is the iSheet Item Link column in the source iSheet, and 9999 is the iSheet Item record id in the target iSheet. You can also optionally supply linkname to set the text for the link - as long as the column has Allow users to rename links enabled. My JSON above was taken from working code, but I'd imagine the XML would look something along the lines of: 9999 Community Test Note: This applies to the following HighQ Sheet API's: POST / {version} /isheet/ {isheetid} /items PUT / {version} /isheet/ {isheetid} /items/ {itemid} developers.thomsonreuters.com/.../bf5a65d2-7bbd-4164-9596-eb6591c4cb1b developers.thomsonreuters.com/.../bf5a65d2-7bbd-4164-9596-eb6591c4cb1b Hope this helps, Andrew

Tax, Audit & Acctg

Legal

Tax, Audit & Acctg

Legal

Developers

Adding iSheet entry via POST with populated lookup column

Top Replies