Create and Update a file in the Space:DataFiles area for use in Qlik Sense Load Script

[chriscammers]

I am going to connect to an API via an automation since there is a connector avialable but then I want to send the data I  retreive into a DataFile in a Space where Qlik Sense can pick it up and use it in a dashboard. The blocks around dataFiles are very confusing and none of them seem to have the content field where I can put the data itself.

Any clarifications or advice on the Datafile blocks are welcome. I have done some scripting on Qlik-Cli to upload data files from a local machine but this is all cloud and the blocks don't seem to fit with the way the qlik-Cli worked.

Thanks

[marksouzacosta]

Hi @chriscammers,

The process is to get the file using one of the many Open File connectors, then upload the file to the Temporary Content and then finally Import the file from the Temporary Content to your Space. Be aware there is a 100MB file size restriction in the process........., yes, 100MB.

Regards,

Mark Costa

[DaveChannon]

@chriscammers can you connect to the sources directly with the Qlik Sense REST connector? It might be more suitable for your use case. What format is the source?

If you wish to create simple data files (in this case 20MB or less) then you can create CSV, TXT or JSON files using the base64 encoded blocks in the Platform Operations connector in automations, but ideally you would use Sense to source the data directly.

[chriscammers]

I did actually fix my issue by using the REST connector in a Qlik Sense load script. I was hoping to leverage an automation because there was a connector for the API included in the automation. Luckily the REST API was not very complicated.

[marksouzacosta]

What we do sometimes is to use Qlik APIs behind AWS Lambda functions and call the lambda functions within Qlik Automations. That way we can fully customize our process and make them easier to consume in other workflows.