Loop in Alteryx to fetch data from an API which allows only 50 Req Per Run

Hi All,

I have an Alteryx workflow where i am manually creating the xml code and send the request to an API to fetch data but the API only allows 50 request per run so i need to loop through and change the request value ( for Eg record 1-50 in the first run then 50 -100 in the second run and so on ). How to go about in doing this any idea would be helpful.

Thanks

Ashwin

API

Download

Accepted answers

afv2688

Hello @Ashwin1 ,

The easiest way for that could be to insert your workflow inside a batch macro and change the values after every request.

If you don't know how to create batch macros I may be able to create a dummy one for you.

I think this would be the best idea.

Regards

All comments

afv2688

Hello @Ashwin1 ,

The easiest way for that could be to insert your workflow inside a batch macro and change the values after every request.

If you don't know how to create batch macros I may be able to create a dummy one for you.

I think this would be the best idea.

Regards

Ashwin1

Thanks Much @afv2688 for getting back to me.. I am not allowed to use Macros at the moment in my workplace .

Ashwin

afv2688

Well then it depends on how you would do the changes then and how your wokflow looks.

Something more manual would be to add a constant that you could change manually after every run.

You would just need to change the value every time:

You just need to change the value in your workflow with the name of the constant and after that change it every time.

Please also remember that not knowing how your workflow looks like limits my responses to what comes to mind.

Regards

Ashwin1

Thanks for that .. i will attach my workflow so you will get a better idea.

This is how my workflow looks like.. Right at the end after the 'Block until done' the first flow creates a txt file with all the data which has to be sent to the API and the 2nd flow to the run command which runs a curl command which fetches the data from the API.