topic Re: Storing Data in QVD using Qlik App Automation in Qlik Automate

Storing Data in QVD using Qlik App Automation

_amiiine_ — Tue, 28 Jan 2025 10:28:22 GMT

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.

Re: Storing Data in QVD using Qlik App Automation

JandreKillianRIC — Tue, 28 Jan 2025 12:19:17 GMT

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

Re: Storing Data in QVD using Qlik App Automation

tolange — Tue, 28 Jan 2025 17:53:36 GMT

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.

Re: Storing Data in QVD using Qlik App Automation

_amiiine_ — Wed, 29 Jan 2025 17:13:24 GMT

Hi @JandreKillianRIC

Thank you for your response.

Re: Storing Data in QVD using Qlik App Automation

_amiiine_ — Wed, 29 Jan 2025 17:13:51 GMT

Hi @tolange

Thank you for your response.

Re: Storing Data in QVD using Qlik App Automation

JandreKillianRIC — Wed, 29 Jan 2025 17:20:53 GMT

Hi @_amiiine_

Would the solution work based on my reply?

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

Regards Jandre

Re: Storing Data in QVD using Qlik App Automation

_amiiine_ — Mon, 10 Feb 2025 09:01:15 GMT

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