topic Re: Is there a way to open/read data files via QAA? in Qlik Automate

Is there a way to open/read data files via QAA?

tolange — Wed, 22 Jan 2025 10:34:17 GMT

Hi QAA team and users,

I've been working with the QAA blocks related to Data Files (both in the Qlik Cloud and the Platform Ops connectors). I can list/get files, copy/move files, create/delete files etc.

What I am so far not able to do is to open an existing file & read its contents line by line as is possible via other file/cloud provider connectors (S3, dropbox etc.).

Are there connectors for that already? Are there endpoints for this but no QAA blocks yet? Or is this something that is currently not supported in the Qlik Cloud file system/logic at all?

Thanks!

Re: Is there a way to open/read data files via QAA?

salmankojar — Wed, 22 Jan 2025 11:26:28 GMT

Hi @tolange can you please describe what file format you want to open and read?

Re: Is there a way to open/read data files via QAA?

tolange — Wed, 22 Jan 2025 12:58:32 GMT

My initial requirement was CSV - but this is not of major importance. Flat files in general is what this is about (csv, txt, maybe also json etc.)

Re: Is there a way to open/read data files via QAA?

salmankojar — Thu, 23 Jan 2025 04:11:12 GMT

Hi @tolange you can use open file block to first Open your file located in one of the storage connectors and then after use Read Data from file block to read the file line by line. using this block you can read Csv/Json file both.

Re: Is there a way to open/read data files via QAA?

tolange — Thu, 23 Jan 2025 08:25:17 GMT

Hi and thanks, I am aware of this connector/these blocks. Unfortunately, this - to my knowledge - is not available for Qlik Cloud's own file system and thus the Data Files stored in a Qlik tenant. It is only available for external connectors such as S3, Dropbox etc.