Illustrated below is an example of a flow that has an SFTP trigger to check for new files every 10 minutes. If a new file is found, the flow will process, unzip a list of files from the zipped folder using the Zip List reader step and then save the filenames to a MySQL table.

If a new file is found in the SFTP Server path, the flow will begin processing and unzip the list of files that is in the zipped folder. To set up an SFTP trigger to check for new files every 10 minutes, press the Control (Ctrl) button on your keyboard and left-click to select the required multiple timeslots from the list as shown in the image below. It is set to check every 10 minutes. The path highlighted is the trigger path.

The SFTP Server source step shown in the image below is used to retrieve a file from the server.

To add a Zip List Reader step in a flow, follow the below instructions:
​

1. Click on the highlighted icon as shown in the below image.

2. The below page will appear. Select or search for a Reader step to pull out the source data. Click on the Reader tab and select Zip List as shown in the image below.

Illustrated in the image below is the configuration that is available in the Zip List Reader step.

Recursive Checkbox
​

This is used to decide if all files in the subdirectories should be listed. The checkbox is selected by default when the Zip List Reader step is added.

The below page shows the output from the Zip List reader step that lists the files from the zip file.

In the MySQL destination step, an Upsert is done to check if the file name exists and to save any new file names in the table.

To use a Zip List Reader step, follow the instructions below:

1. Click on the play button on the Zip List step as highlighted in the image below:

2. Click the highlighted are in the image below to upload a file.

3. Click the Test button as shown in the image below.