Change Spaces for all QVD files

[gordon_ash]

Hi folks,

I have to move all the QVDs from Spaces to the Shared space - I have seen various articles on REST calls, powershell scripts to make API calls - I implemented in Postman a simple to get a list of spaces and although it kind of works it couldn't get all of the spaces we have. I have checked the spaces one by one for permissions and the account I use has all of the permissions available so I don't believe that is the issue - is there a bug in the API or more probably am I calling it incorrectly?

In postman I use the bearer token, newly created in case that is the issue, then the URl is 

https://XXXXX.qlikcloud.com/api/v1/spaces/

The resulting JSON  only pulls 10 spaces but I have 30 - is there something else I need to do to get the full list?

Thanks

[saif_khan]

I have faced the same issue while getting app list in PowerShell using Qlik-cli. The solution I found was to append --limit [number] at the end of the command. I put a large number so it doesn't miss any app. 

For example, you can write a following command to get list of apps:

qlik app ls --limit 20

[fmarvnnt]

Why don't you Load QVD then Store on a different space?  https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS... .

Maybe I'm too simply,

😉

FMa

[Kayleigh_Milewski · Accepted solution]

Here's a simple script to move qvds one at a time. You could modify it to loop through all tables in a space.

//Change variable to name of data file you are moving
LET vTable = 'QVDName';

[$(vTable)]:
//Change file path to OLD location you are retrieving the data file from
LOAD
*
FROM [lib://OldSpaceName:DataFiles/$(vTable).qvd]
(qvd);

//Change file path to NEW location you are storing the data file
STORE [$(vTable)] INTO [lib://NewSpaceName:DataFiles/$(vTable).qvd];

You will have to delete the qvds from the old space. 

[gordon_ash]

This is great to know , I never thought to append an explicit limit, I will give this a go when I get the chance.

Thanks Very much for sharing.