Clone sheet and reports between accounts

JamieDixon

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?

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.