Web Scraping off Webpage

cmiller9115

Newer to alteryx any responses are appreciated. Trying to parse an xlsx file from a webpage and having issues getting to the actual file when using the down load tool. Below is the link to the webpage along with a screen shot of where the xlsx file is embedded. I have also attached an example workflow. Any suggestions on how to use the down load tool/other means within Alteryx to down load the xlsx file and be able to get the data into a useable format? 

https://www.fedex.com/en-us/service-alerts.html 

Embedded XLSX file from within HTML

FedEx_Service_Update_2019_09_04_PM_Hurricane_Dorian_vf_955560470.xlsx

Fedex Webpage Workflow.yxmd

SamDesk

Hello @cmiller9115,

Firstly your input URL was missing an "h" from "https".

Secondly, choosing to download the file to your filename field means you can then call this same field in your dynamic input tool. You will, however, have to append a sheet name to your filename so Alteryx knows which sheet of the spreadsheet to load, e.g:

[Filename]+"|||FedEx Custom Critical$"

Sam 🙂

Fedex Webpage Workflow.yxmd