04-02-2024 05:09 PM
Hey,
How can I adjust the following Service URL so that it extracts all available records? By default, Coupa API only allows 50 records, this is why I need to implement pagination.
"https://XYZ.coupahost.com/api/invoices?offset=100&created-at[gt_or_eq]="+$date_1+"&created-at[lt_or_eq]="+$date_2
In the past, I have adjusted the pagination for service URLs without dates, but it's proving difficult to adjust with dates
What has worked in the past, in the REST GET:
Service URL: "https://XYZ.coupahost.com/api/invoices"
Has Next: eval(sl.ensureArray($.get('entity')).length > 0)
Next URL: "https://XYZ.coupahost.com/api/invoices?offset="+eval((snap.out.totalCount + 1) * 50)+"%26exported=false"
But when I try to add the dates, I keep getting 400 error code.
Thank you