Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
AJDoc31
Contributor III

Copy Sheets from One Application to another using Automations

Hello All,

I am creating a standalone application to control other applications in a space. I am ultimately working towards a control of change management. For example, when I update a template I want to click a button to update all subsequent applications to have the same updates as the template. I am currently working on doing this for sheets. 

My issue is, I have a set of ~12 'standard' sheets I want to show in every application. Every application could have additional sheets tailored to the customer. I want to be able to grab all of the sheets (currently using where description is 'Standard Sheet') and copy them into the applications without altering the other sheets.

While building an automation, I see the Copy Sheets block but that only works within the same application. Is there a way to copy a sheet from one application into another using automations? If so, how?

TIA!

Labels (3)
4 Replies
AJDoc31
Contributor III
Author

no, it is not.

Shai_E
Support

Hi @AJDoc31 

Under what connector do you see "Copy Sheet" block?
I see that this can be done outside of QAA with a normal right click and copy sheet from an app to another.

When checking the developer tools i dont see the HTTP request for this action, perhaps it is not a public endpoint.

So i am not sure this can be done via QAA.

Best Regards

AJDoc31
Contributor III
Author

its the duplicate sheet block. but it duplicates the sheet in the same app. the fact it is able to be done with a right click copy and paste means that its possible. it seems like it uses the Qlik Engine API which uses the csrf token or session cookie to authorize that you have access to both apps/sheets. it also seems as if you need to populate all the subsequent objects in the sheet. I'm not entirely sure but it seems like QAA won't be able to handle this. I have tried creating a Node.js server to handle the request and act like the user copying and pasting the sheet but it kept failing authorization. It might be a lost cause but just frustrating that you know its possible.