topic Re: Duplicate DataFiles and move them to another space in Qlik Automate

Duplicate DataFiles and move them to another space

achampire — Tue, 21 Mar 2023 16:47:43 GMT

Hello all,

I am searching a way to easily duplicate DataFiles from a choosen space and move all duplications on another space (like a ctrl+c + ctrl+v on windows.

I found some Qlik Cloud Service blocks that can be interesting (like the Patch Dataset or update dataset) but I don't know if those can answer the question.

Do you guys have an idea to answer this need ?

How are you using Patch Dataset and Update Dataset ?

Alexandre CHAMPIRÉ

Re: Duplicate DataFiles and move them to another space

AfeefaTk — Thu, 23 Mar 2023 09:45:41 GMT

Hi @achampire

I am not sure if the update/patch dataset blocks can be used to copy the apps to different space.

I can see an API call to change the space of the dataset.

https://qlik.dev/apis/rest/data-files#%23%2Fentries%2Fv1%2Fdata-files%2F-id%2Factions%2Fchange-space-post

We don't have a block in Qlik Cloud Services connector to do this.

But you can try using the Call URL block to make an API call.

Also if you want the dataset to be in both spaces this won't work.

I am checking internally to see if it's something achievable using the Patch dataset block or by any other means in QAA.

Thanks

Re: Duplicate DataFiles and move them to another space

achampire — Thu, 23 Mar 2023 10:12:41 GMT

Hi @AfeefaTk

Thank you for your answer.

Is there a block in automation (or an API endpoint) in order to perform a data files duplication ? I guess there is one because we can do this on Qlik Cloud Hub while accessing Space detail > Data source > Data Files.

Re: Duplicate DataFiles and move them to another space

AfeefaTk — Thu, 23 Mar 2023 14:44:42 GMT

Hi @achampire

At the moment it's not possible to achieve this using automation due to a few reasons

We don't have dedicated block in the QCS connector to copy datafile to a space.
Raw API Request block cannot be used as the datafiles API is not enabled in the block
Call URL block cannot be used as it only allows application/json content type and the copy datafile to space API uses multipart/form-data content type.

This can be achieved using API by following the below steps

Get Id of the connection to the space
Curl Request :
curl --location 'https://{tenantURL}/api/v1/data-files/connections?SpaceId=space_id' \
--header 'Authorization: Bearer xx'
Get id of the datafile you wish to copy by passing the connection ID received from the above step as query parameters
Curl Request :
curl --location 'https://{tenantURL}/api/v1/data-files?connectionId=connection ID' \
--header 'Authorization: Bearer xx'
Copy datafile to space using the id of the source data file, and the connectionId of the space you want to land it into
Curl Request :
curl --location 'https://{tenantURL}/api/v1/data-files' \
--header 'Authorization: Bearer xx' \
--form 'json="{\"name\":\"test.qvd\",\"connectionId\":\"your-connection-id\",\"sourceId\":\"your-space-id\"}"'