End of Json Example 2:
Solved! Go to Solution.
It's hard to help specifically because there's a lot of trial and error to get the configuration of an api right, and unfortunately I don't know the details of the sap concur api.
But looking at the example json in your post, it seems to me that you are already able to make the first call and get results using an alteryx workflow, right? From the second call onwards you have to use the continuationToken of the current page to call the next page. The only way I know of dealing with this is indeed to use iterative macros. You need to configure the iterative macro to parse the continuationToken of the current iteration, manipulate it properly and then use it as an input for the next iteration. almost exactly the case of the post you referenced.
What specific error/difficulty are you experiencing when trying to adapt the workflows in the post you referenced?
if you make a filter [JSON_Name] = "NextPage" on your macro, the field JSON_ValueString will contain the next URL to feedback the macro. Similar to this one that i have on the cvent case:
*To get a better overall understanding about iterative macros, i suggest that you take a look at this: Creating an Iterative Macro - Alteryx Community