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
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives