Lookup Help - Results Mapping With Paging - Not all page results mapped

[davidwoodward]

I am having an issue where I can't seem to get the data from all the pages of a lookup into my results object. I am doing a lookup with Freshservice and it uses a link header. In the lookup I can see in the preview that is navigating to page 9.

On my results mapping I have tried a few options, but the one I thought would be right is data > departments

I have a hook running to loop the items in departments and log a message. You can see that I always only get 30 items. Which is the number of objects returned from one freshservice page.

I am pretty sure I just have something in mapping setup wrong, I just don't know what it is. I would expect to see at least 240+ items in the departments array, since it is showing 9 pages and by default it's 30 records per page.

Thanks

[basvanditzhuijzen]

Based on the preview data it looks like celigo doesnt know how to get to the array of results and treats the response as 1 record.

Try setting the field 'Path to records in HTTP response body' to 'departments' (or add it to the end if you're already using it.)

[davidwoodward]

Thank you! This did the trick.