topic Re: Copy Sheets from One Application to another using Automations in Qlik Automate

Copy Sheets from One Application to another using Automations

AJDoc31 — Sun, 23 Mar 2025 20:41:24 GMT

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!

Re: Copy Sheets from One Application to another using Automations

henrikalmen — Mon, 24 Mar 2025 09:57:25 GMT

This is a duplicate post of https://community.qlik.com/t5/Application-Automation/Copying-Sections-of-Data-Load-Editor-Using-Automation/td-p/2511123

Re: Copy Sheets from One Application to another using Automations

AJDoc31 — Tue, 15 Apr 2025 18:36:43 GMT

no, it is not.

Re: Copy Sheets from One Application to another using Automations

Shai_E — Wed, 16 Apr 2025 13:29:56 GMT

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

Re: Copy Sheets from One Application to another using Automations

AJDoc31 — Wed, 16 Apr 2025 13:54:25 GMT

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.