Loading multiple zip files from S3 to data base

Question

Hi,
I am working on a scenario where I have multiple zip files from same S3 bucket location with file name as Upload* wildcard. I tried below snaps but it’s not working. Any tips?
Multi file reader → Binary to document → Mapper → Zip file reader
Directory browser → S3 file reader → binary to document - mapper → zip file reader
Kindly help.
Regards,
Amar

bojanvelevski · Answer

Hey @amardeep2021,
Add your S3 bucket path to a Directory Browser, following a ZipFile Read snap with $Path added in the “File” field. Don’t forget to check the equal sign to enable expressions.
Hope this helps,
Regards,
Bojan

amardeep2021 · Answer

Thanks Bojan. I have tried the same. But, I don’t see the directory browser output in the zip file reader snap File field. Am I missing something? Please let me know.
Regards,
Amar.

bojanvelevski · Answer

Write down the $Path field even if it doesn’t show up in the input schema. It must be a glitch or something. Here’s the result:

amardeep2021 · Answer

It works! Thanks Bojan.

Forum Discussion

Loading multiple zip files from S3 to data base

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?