How to read data from a zip file

If you require to read data from a zip file from a source, please follow the below instructions:

NB: The Zip reader step can only be used if you are using a .zip file extension. if another compressed file extension is being used, please contact us at support@synatic.com for assistance.

Illustrated below is an example of a flow where the Relay Based File System step is being used as a source step and we require to pull the data from a zip file in 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 gets returned.

image

The below image is the Relay Based File System source step where we are passing through the highlighted zip file.

image

Illustrated below is the Zip reader step where the Path is left blank. The Path is the path in the compressed file that you want to read from. If left blank, it will read the first file. Thereafter, a Sync Flow is used to reference a flow where the file gets read.

NB: Please note that the path is case sensitive.

image

The below image is the 2nd flow that is being referenced in the Sync Flow. An Excel reader step is being used to read the file since it is an Excel file that was compressed. The data is then being sent to a Buffer destination step.

image