Download and use the excel from webpage in workflow

[hanz_e]

Hello,

I am attempting to create a workflow that utilizes the Excel file available at the following link:GHG Emission Factors Hub | US EPA. Since multiple files are available on the page, I always want to use the latest file. So I want the workflow to donload the required file from the link I provide, download it, and then use it as input for subsequent steps in the workflow using a Dynamic Input tool.

I tried a workflow using the Download tool; however, the downloaded file consistently becomes corrupted, so can not use for further processing.

How can I ensure the workflow downloads the complete data file correctly and integrates it with the Dynamic Input tool?

Thank you for your assistance.

[apathetichell]

1) use a batch macro - not dynamic input - google around this forum if you don't know how to do it.

2) include 

User-Agent

PostmanRuntime/7.41.2

in your headers of your download tool. include a filename (like test.xlsx) - download to that filename.