Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Smartsheet API linkInFromCell
Hi,
I am trying to use the Smartsheet API to insert a new row which contains regular cells and 'link cells from another Smartsheet'. Currently, I can only do this in two steps:
1. create new row only with regular cells
2. add 'link cells from another Smartsheet' to this new row
API call: "https://api/smartsheet.com/1.1/sheet/sheetId/rows"
row data object:
[{
columnId: columnId1,
value: null,
linkInFromCell: {
columnId: columnId,
rowId: rowId,
sheetId: sheetId,
sheetName: sheetName
}
},
{
columnId: columnId2,
value: null,
linkInFromCell: {
columnId: columnId,
rowId: rowId,
sheetId: sheetId,
sheetName: sheetName
}
}]
If I do them together in a single step, I always reveive this error: "The attribute(s) cell.linkInFromCell are not allowed for this operation."
Is there a way that I can do it in a single step? Thanks for any suggestion or idea.
Best,
Yueying
Comments
-
Unfortunately it's not currently possible to add cell links when POSTing a new row to a sheet. A cell link can only be added to an existing cell -- so the two step process that you describe (1-add new row, 2-update row to add cell links to some cells) is the only way to add cell links via the API.
-
Kim,
where would you recommend going for API tips. GitHub, stackoverfow. I am trying to parlay my google sheets javascript API experience to SmartSheet, but I am not sure where to start.
Thanks,
Brett
-
Thanks for replying, Kim.
-
@Yeuying Cui -- happy to help.
@Brett -- great question. I'd recommend that you post API-related questions to Stack Overflow (using the smartsheet-api tag). That way, you'll get answers to your questions AND others may also benefit from the information in the future. Additionally, I'd definitely suggest that you review the API documentation and checking out the other Developer resources linked to from our Developer Portal.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives