Iterative macro and the Union tool.

Question

Hi,

I have an iterative macro that makes an API call. It will have a query string like this: "...?pageNumber=1".

Depending on "pageCount", I will iterate that macro making the same API call request for data, but each time I call it in the iterative macro the pageNumber value will increment.

Can the Union tool preserve iterations of data delivered for each iteration of the macro?

When each pageNumber of data has been delivered, the macro exits into the main workflow where processing begins.

I'm getting only the data from pageNumber=1, but not any subsequent pages. I should get 2 because of pageCount. The macro does iterate the pageNumber but I'm beginning to think the Union tool does not preserve the data from the previous iteration.

I would appreciate assistance on how I should properly go about this.

Chris

SPetrie · Accepted Answer

Whatever you send to the final output tool each iteration is what should come out at the end.

If you are getting page 1 each time, it sounds like its being fed the url for page 1 multiple times.

I used the catfacts api to create this macro that goes through its pages to show how it should be working.

Are you sure its updating your url with the new page number before being sent to the download tool?