Looping through API

[gesh2112]

Hello,

I am connecting through Alteryx to our Oracle CRM using an API.  The API I am using the most records it will return is 500.  I need to pull the full Customer list from the system so that means I will have to run the API a lot of times to get the full listing.  

I have the workflow set up so it working exactly what I need for the first 500.

Is there a way in Alteryx to have it loop through the API to get the full list?

[IraWatt]

Hey @gesh2112,

Absolutely, what you want is a macro probably iterative but I would also look at batch. The community has some great videos on them - https://community.alteryx.com/t5/Interactive-Lessons/Creating-an-Iterative-Macro/ta-p/657925 . I've used them before to loop through API's with similar constraints. 

Any questions or issues please ask :)
HTH!
Ira