Update Reports using the API

Tobias Krause

I found an old thread in the community about this, so mayn users are looking for it a long time already.

I need to be able to update reports using the API, most importantly I want to add or change the source sheets of a report using the API.

In my current case I have multiple reports using the same sources and if a new source is added I need to add it manually to all my reports. If the API could do that, this would be awesome.

Paul Newcome

Based on the API documentation, it looks like you should be able to.

https://smartsheet.redoc.ly/tag/reportsObjects

Tobias Krause

Based on the API documentation, it looks like you should be able to.<\/p>

https:\/\/smartsheet.redoc.ly\/tag\/reportsObjects<\/a><\/p>","bodyRaw":"[{\"insert\":\"Based on the API documentation, it looks like you should be able to.\\n\\n\"},{\"insert\":\"https:\\\/\\\/smartsheet.redoc.ly\\\/tag\\\/reportsObjects\",\"attributes\":{\"link\":\"https:\\\/\\\/smartsheet.redoc.ly\\\/tag\\\/reportsObjects\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2023-07-14T12:05:13+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-29T11:58:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385248#Comment_385248","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/385248#Comment_385248

Hi,

thanks for the comment. But as far as I understand this , I can only get a list of the source sheets, but not update it using the API. Correct me if I am wrong.

Paul Newcome

You may be right. Sorry about that. A lot of the things I have seen with the API, if you can get it, you can edit it (not all but quite a bit). Are we not able to edit the "sourceSheets" or "source"? What about the Scope Object piece?

https://smartsheet.redoc.ly/tag/reportsObjects#section/Scope-Object