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

David Woodward

• March 22, 2022 23:46
• Edited

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

 

0

• 

  Bas van Ditzhuijzen Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz

  • March 23, 2022 08:33

  

  

  

  

  

  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.)

  1
• 

  David Woodward

  • March 23, 2022 21:51

  

  Thank you! This did the trick.

  0

Please sign in to leave a comment.