Download Tool Error

[amit_limbasia]

Hi Community member,

I am facing some error in Download tool:

I am trying to download data from URL's There are 100's of URL as per Date some date are not exist, so data is unavailable for that particular date. Date I am taking with multirow formula or generate row formula to create all date and URL once Automated 

Workflow contain some date out of which :

URL Exist only for this dates:

2022-11-11
2022-11-14
2022-11-15
2022-11-16
2022-11-17
2022-11-18 

Remaining dates URL may not exist or doesn't reply anything

So Once I run following workflow it return error and stop after first date as second date URL May not exist
Incase 3rd URL Not working then return first 2 date data but in my case 1 4 5 6 7 exist and I require all exist data

Thanks in advance for the best optimized solution:

I already have python tool solution where I Initial check URL exist or not if exist then filter date then use download tool 
But I need this only with Alteryx tool or without Python tool

Thanks in Advance....

[JosephSerpis]

Hi @amit_limbasia one way to tackle this is to wrap the download tool inside a Batch macro which feeds the urls one by one. You will still get the error messaging pop up however the process won't stop when this occurs as the next url will be feed into the download tool. I have uploaded an example to showcase this approach. If you get a version issue error please follow this guide.

[amit_limbasia]

Thanks @JosephSerpis,

Your solution is great, currently I am using batch macros for data download transform, cleansing data by the same way,

I will plan to take it for schedule and use it for link another workflow, Since error is appear workflow don't move to next step. Currently I am doing manual but for scheduler based I need workflow without error if possible.

Thanks for quick reply.