Downloading a zip file and then extracting the XML file inside

Hi Everyone,

I have developed the attached workflow in which I try to download a zip file from a URL, which changes daily based on the date. Then I try to unzip this file by using a dynamic input. However I am getting the error below. It does not make sense because when I configured the dynamic input tool, I have actually specified the XML file in the zip file.

Please ignore the container in my canvas. That is not part of the workflow, it was just for testing.

Can anyone help me with this problem? Thanks community!!

Dynamic_download_v1.0.yxmd

Download

Accepted answers

MichalM

Hi @aeulusan

The bit that is missing in your workflow is a reference to the file within the zip. Think of the archive as an excel workbook (folder) and the xml as a sheet (file). When telling the dynamic input what you'd like to open, you need to specify the full path workbook and the sheet (zip and the xml file).

What you can do, is to create another field using your formula tool called file path and add a reference to the xml file

[filename]+"|||20190502-gleif-concatenated-file-lei2.xml"

and then use this field within the dynamic input tool

Hope that helps.

Michal

All comments

MichalM

Hi @aeulusan

What you can do, is to create another field using your formula tool called file path and add a reference to the xml file

[filename]+"|||20190502-gleif-concatenated-file-lei2.xml"

and then use this field within the dynamic input tool

Hope that helps.

Michal

aeulusan

Thank you it worked to the point of dynamic input. However after that, my workflow cannot read the XML file inside. You can see attached the problem I am having.

Dynamic_download_v1.0.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703