Storing Data in QVD using Qlik App Automation

[_amiiine_]

Hello everyone,

I have a question regarding Qlik App Automation. Through Qlik App Automation, I query an API using the 'Raw API List Request With No Paging' block, and I store my data in an Excel workbook. However, I would like to store my data in a QVD file instead. Is this possible, and if so, how can I do it ?

Thank you in advance for your response.

[JandreKillianRIC]

Hi @_amiiine_ 

I dont think this is possible, but as a workaround you can create a Qlik App that reloads the data from Excel and store it to a qvd. You can use the same automation to start the reload that stores this as a qvd. 

Regards Jandre

[tolange]

I was also looking into this. You would need to create the base64 equivalent of the qvd file - generally possible via some custom code. Then you could write it into Data Files. But to create a qvd, as opposed to csv, you need an external library and that is not possible in QAA custom code blocks unfortunately.

So Jandre's workaround - creating a csv/txt or whatever and having a load script transform it - would also be my suggested approach.

[_amiiine_]

Hi @JandreKillianRIC 

Thank you for your response.

[_amiiine_]

Hi @tolange 

Thank you for your response.

[JandreKillianRIC]

Hi @_amiiine_ 

Would the solution work based on my reply? 

As mentioned, This is not possible "yet" based on my knowledge/ research. 

Regards Jandre 

[_amiiine_]

Hi Jandre,

Thanks for your response! I ended up storing the data in an Excel file and processing it from there.

Appreciate your help!

Best regards,
Amine