How to add sheet owner via api
My integration is creating new sheets in Smartsheet. When a new sheet is created, by default the logged in user becomes the owner. But I need to update the owner based on the other system's item owner. When I add the owner email to the SheetObject it throws an error:
{"The attribute(s) sheet.owner are not allowed for this operation."}
It also throws a similar error when I passed in the Smartsheet ownerid:
{"The attribute(s) sheet.ownerId are not allowed for this operation."}
Is there a way to update the owner during the sheet creation via the api, if not directly is there a workaround but still using the api.
Thank you.
Best Answer
-
You probably need to use an Auth token created for the other user to make them the owner by default on sheet creation.
Otherwise, you'd need to create the sheet first, then run a Share Sheet Post to share it with the other user, then an Update Sheet Put to change the owner.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
You probably need to use an Auth token created for the other user to make them the owner by default on sheet creation.
Otherwise, you'd need to create the sheet first, then run a Share Sheet Post to share it with the other user, then an Update Sheet Put to change the owner.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives