API Loop/Macro question

[craigja]

I have an in-house developed API that returns data 25 records at a time.  It doesnt tell me how many pages there are but there is a hasMore value thats set to 1 and there is also a link to the next set of records which has &offset=25 at the end of the URL, then &offset=50 etc etc.  How do I put this inside a macro so it runs till the hasMore value is o?

[abacon · Accepted solution]

@craigja You will need an iterative macro in your workflow. Here is a video on how to create on - https://www.youtube.com/watch?v=AByfTPqrUrQ

What you need to do is set the macro to run, check if the hasmore value is 1, if so, run through again and add 25 to your offset value that gets passed through.

Bacon

[alexnajm]

Something like this may help in addition! 11 Steps to Create an Iterative Macro for Paginati... - Alteryx Community

[craigja]

Great thanks guys