How to execute Alteryx workflow with limited rows

[nisarghande]

I have below the Columns which is DateFrom and DateUpto, We are loading historical data through the api, API have some limitations, I wanted to call apis by monthly basis, We have parrameter for api which is Datefrom and DateUpto, I have Values for 2 years, wanted to pass this values in chunk, how I can break this table through Alteryx and forward the values in sequence for

DateFrom DateUpto DateMonth
2018-01-01 2018-01-07 1
2018-01-08 2018-01-14 1
2018-01-15 2018-01-21 1
2018-01-22 2018-01-28 1

2018-01-29 2018-02-04 2
2018-02-05 2018-02-11 2
2018-02-12 2018-02-18 2
2018-02-19 2018-02-25 2

[atcodedog05]

Hi @nisarghande 

Just want to confirm when you say API you are using the download tool right.

[atcodedog05]

Hi @nisarghande 

Here is how you can do it.

Workflow:

Each row can be converted to API url with parameters. This way each row is an URL endpoint for a chunk of data that will be fetched.

Hope this helps : )

[atcodedog05]

Hi @nisarghande 

Or you can also follow batch macro method. Here are some resources on it.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

Hope this helps : )