I am trying to download the excel file from URL like below. But it failed as I tried several times. There's a message "access denied" in the download data in one of the tries.
Could someone help on this? Maybe just build a simple flow to download this one?
http://www.safe.gov.cn/safe/2020/0731/16814.html
So this is just a start. If that can be done, actually I need to download the file dynamically in this URL according to the month selected.
http://www.safe.gov.cn/safe/gzhbdmyzslb/index.html
As I see, the number after the date changes for each. Not sure how to configure that either.
http://www.safe.gov.cn/safe/2020/0930/17259.html
BTW, sorry that the web supports Chinese characters only.
Hi @JokeFun , here is the downgraded version of the macro attached, to downgrade the version of the workflow you can open the workflow in the notepad and change yxmd version.
Regarding the error issue, here is the screenshot, I am able to fetch the data.
You can check with your IT team regarding this issue and as said our versions are different so give this a try if it works for you.
In, headers you can add this configuration.
Name Value
Another possible solution is :
In the Download tool configuration, uncheck "Encode URL".
If it still doesn't work kindly refer to this post as I suggested earlier you need to check with your IT team.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-Fail-Proxy-Authentication-issue/td-p/764
I hope this works for you.
Thanks.
HI @JokeFun , for me this seems to work fine please refer to the screenshot.
Also I tried passing your link-
After this I applied some transformations and fetched the links with dates.
Is this what you are looking for?If yes, kindly mark this post as solution.
Hi @grazitti_sapna ,
Thanks a lot! Would you please kindly share the file?
Cheers!
