First let’s focus on the ‘YES’ part of the condition. Link it to the previous block and add the following condition:ĭ. Now search for the ‘Condition’ block to drag and drop it into the automation. The previous block will return ‘True’ if the file exists, and ‘False’ if it doesn’t. Now select the ‘Check If File Exists’, drag and drop it into the automation and link it to the Start block.Ĭ.
The first two steps are similar as in the two previous use casesī.
Use the output from the previous block as input.Į. Drag and drop the ‘Read Data From File’ and link it to the previous block. Add the file directory, filename and file extension under ‘Path’, e.g./4bxH6V4ac9zoAxZU.csvĭ. You can use ‘do look up’ to search across your S3 account. Drag and drop the block into the automation, link it to the Start block and fill in the required parameters, ie. Now use the ‘Open File’ block from the listĬ. The first two steps are similar as described beforeī.
The Amazon S3 connection, however, supports advanced use cases such as generating a URL that grants temporary access to an S3 object, or download a file from a public URL and upload this to Amazon S3. The Cloud Storage connector supports additional building blocks to copy files, move files and check if a file already exists in a bucket, which can certainly help with additional uses cases. It will provide some examples of basic operations such as listing files in a bucket, opening a file, reading from an existing file, creating a new file in a bucket, and writing lines to an existing file. This article though focuses on the available blocks in the native Cloud Storage connector in Qlik Application Automation to work with files stored in S3 buckets. Example of automation using the Amazon S3 connector to output a paginated list of regions and buckets in each region (not covered in this article): To get the information and metadata of regions & buckets, use the Amazon S3 connector.
To create, update and delete files, it’s highly recommended to use the native Cloud Storage connector. The native Cloud Storage connector and the specific Amazon S3 connector. Inside Qlik Application Automation, the Amazon S3 functionality is split into 2 connectors.