Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apr 26, 2023 2:09:48 AM
May 17, 2022 11:16:27 AM
This article covers the usage of the Qlik Application Automation cloud storage blocks and gives design flow examples which apply them. You can also download an example JSON using Google Cloud Storage, and we have compiled a list of links for more in-depth platform connections and atypical usages.
Content
The Available Blocks
Selecting Cloud storage when creating your automation will present you with the following list:
- Open File
The open file block is a read-only block that is used together with the "Move file", "Copy file" and "Read data from a file" blocks. It requires a valid connection to a cloud storage platform or a URL link. - Create File
As the name implies it creates a new file at the suggested location. If the file already exists the automation run will end up in failure.
Warning: this block cannot be used if a file with the same filename exists at that same location. In order to do that you will need to use the overwrite flow rules at the end of this article. - Copy File
This block copies the output from an "Open file" block and sends the stream to a given source path on the target platform. As mentioned now and beforehand, this block needs to be preceded by an "Open file" in the automation flow. - Read Data From File
Reads data from a file opened with the "Open file" block but what is different from the previous one is that the data stream is mostly used only when you need to use the stream for other blocks apart from the native file blocks or to update other files. This block it has several modes of reading data:- Automatic: given the file type and contents we try to approximate the algorithm to use and try to apply it to the file
- CSV: mostly used in conjecture with spreadsheet files and you can choose your own headers and separators to be used in the reading algorithm
- JSON: allows you to fully utilize the Automations format in order to use the read data easier inside an automation
- RAW: reads the file line by line (mostly used for text files)
- Write Line To File
This block writes data to a newly created file with the "Create file" block. As mentioned previously, this block also has several modes in which to write the data stream:
- Automatic: given the file type and contents we try to approximate the algorithm to use and try to apply it to writing to the file
- CSV: mostly used in conjecture with spreadsheet files and you can choose your own headers and separators to be used in the writing algorithm
- JSON: allows you to fully utilize the Automations format in order to use the write data easier inside an automation
- RAW: reads the file line by line (mostly used for text files)
- Save And Close File
The block is used to close opened files by the use of the "Create file" block. You will need to use this block in order to see the target result on the cloud platform. - Delete File
Will delete the file with the filename given found at the target path/location. Mostly used in the overwrite file flow implementation. - Move File
Has mostly the same functionality as the "Copy file" block but instead of leaving the source file at the initial platform, it deletes it. - Check If File Exists
Verifies the existence of the file with the given filename at the target path/location. Again this is mostly used in the overwrite file flow protocol. - List Files
Simply shows you all the files found at the given target path/location.
Verify if File Exists / Delete File Example
Here is an example of how to verify if a file exists prior to creating a new one. This is specifically important when you set up an automation meant to save your result in a target file that might or might not be at the location suggested. Since you cannot create a new file if a previous one exists, you will need to apply the following to your automation:
You can verify if the file exists initially, and, based on the response from that block, either simply create a new file or delete the old file and create a new one to write data to.
Supported Platforms and Connectors
And last but not least, this is a list of supported platforms for the native blocks as well as links to how to connect to them as well as more quirky details they have.
- Amazon S3
- Dropbox
- FTP/SFTP
- Google Cloud Storage (with or without a service account)
- Microsoft Onedrive
- Microsoft Sharepoint
- HTTP (just for the open file block)
- Microsoft Azure Blob Storage
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Hello @retech4s
This is supported. I've attached an example automation (for information on how to import this, see How to import and export automations).
The end result from this test would be:
If you have additional questions or need assistance getting this to work, please post directly in our Qlik Application Automation forum, including potential errors you get.
All the best,
Sonja
