Export an automation's Output to a Txt or Csv

[Adfc_NZ]

Hi,

Following up on my topic
https://community.qlik.com/t5/Qlik-Automate/Automation-to-return-an-app-detailed-reload-logs/td-p/25...

I now have the automation to work as expected, its output is the selected app's last reload log.

Now, I need the community help as I've never tried this before: how can I now export that result into a file (Txt or Csv or even QVD?) so that I can then load it into an app?

Basically I want to replicate what Qlik natively does when we look at an app's reload history/log and click the "Download Detailed Log" button which generates a Txt file.

Any help you can send my way will be much appreciated.

Thank you.

[vighnesh_gawad]

Take look at Qlik cloud apis, you can export that info from running those endpoints.

https://qlik.dev/apis/rest/automations/#post-api-v1-automations-id-runs-runId-actions-export 

[Daniele_Purrone · Accepted solution]

Hi @Adfc_NZ ,

something like this works:

Of course, you can choose a different destination than Dropbox, but the "Create File", "Write Line To File" and "Save and Close File" are the blocks you'll need.

[Daniele_Purrone]

As Data for "Write Line To File" you can pick the Output from "Raw API Request"

[grt08]

Hi Dan,

Is there a way to use Create Data File In Space (Qlik Cloud Service block) to directly save the Reload Log to a space\Datafiles?

In my case we don't want to use third party storage to do the same process but wanted to have similar output to save a Reload Log file in text or csv preserving the format of the Reload Log?