Forum Discussion

amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Loading multiple zip files from S3 to data base

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

4 Replies

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor

    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's avatar
    amardeep2021
    New Contributor III

    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's avatar
      bojanvelevski
      Valued Contributor

      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: