Illustrated in the image below is a flow where the Relay Based File System step is being used as a source step because data needs to be pulled from a zip file on a local machine. The Zip reader step is being used to unzip the zip file. The Sync Flow references the flow where the data from the file will be returned.
The below image is the Relay Based File System source step, where we are passing through the highlighted zip file.
The Zip folder contains an Excel sheet as shown below:
Adding a ZIP Reader Step
To add a ZIP Reader step in a flow, follow the instructions below:
1. Click on the highlighted icon as shown in the image below.
2. The page below will appear. Select or search for a Reader step to pull out the source data. Click on the Reader tab and select ZIP as shown in the image below.
Configuring a ZIP Reader step
Illustrated in the image below is the configuration that is available in the ZIP Reader step.
Path Field
Specify the path of the file that you require to read. The path must be specific to the file that needs to be read.
If the path is not provided, the first file in the folder will be used. The field is case-sensitive, so it must match the exact file name.
Using a ZIP Reader step
The below image is the 2nd flow that is being referenced in the Sync Flow destination step. An Excel reader step is being used to read the file since it is an Excel file that was compressed. The data is then sent to a Buffer destination step. Execute this flow to use the Zip Reader step.
To use a ZIP Reader step, follow the instructions below.
1. Click the Execute Flow button shown in the image below:
2. Click the Create Run button.
The image below shows the records in the Buffer.
