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
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives