Clone sheet and reports between accounts

Hi there,

I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically.

I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet.

Since I have quite a number of reports I'd ideally like to either adjust the sheet ID that the reports point to, or have some other solution for cloning between accounts.

I've looked at all API docs etc and it looks like there's no write API for reports.

Is there a way to achieve my end goal?

Find more posts tagged with

Sheets

API and Developers

Reports

Comments

J. Craig Williams

API is nearly non-existent for Reports.

Try Workspaces.

Craig

JamieDixon

Hi, Craig.

Thanks for replying to my question.

I'm not sure what you mean by "Try Workspaces". I'm already cloning the workspaces that contain the reports, I'm just not sure how to make those reports marry up to the sheet in question.

Since I can't alter the sheetId of a report (Because of the API), the only solution I can think of is to somehow change the id of the sheet itself, but the API doesn't support this either.

Have I missed your point? Perhaps there's a way I can get the result I want in a way I haven't thought of?

Cheers ?

J. Craig Williams

Apologies for being cryptic.

Previously, when using performing a copy of a Workspace kept internal links* intact, that is, if I Report referenced Sheet A in the original Workspace, it would change to referencing Sheet A-prime if Sheet A and the Report were in the same workspace.

There is no way, using the API, to change the Reports source otherwise.

Craig

*links in this case is a misnomer or may be confused with cell linking or X-Sheet References, but I mean connected via source referencing.

Sign in to join the conversation!

Quick Links

Trending discussions

Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…