Forum Discussion

rpc1235x's avatar
rpc1235x
New Contributor II
2 years ago

Pagination for Coupa API GET

Hello,

I need to extract all records from several Coupa tables using Coupa API. However Coupa only allows to extract 50 records at a time (Coupa documentation). 

I tried implementing the solution in this thread (link) for invoices and suppliers table by 1) keeping the service URL as normal without adding the "?offset=50&exported=false", 2) In Rest GET snap, adding "Has Next" and "Next URL" as stated in the linked thread 

Has Next: eval(sl.ensureArray($.get('entity',[])).length > 0)

Next URL: lib.conf.getAppConf('coupa').basepath.concat("suppliers?offset=",(snap.out.totalCount + 1) * 50, "&exported=false")

Note that for Next URL I modified the "suppliers?" part. For invoices, I changed to "invoices?" (not sure if this is correct).

Either way, this procedure still only gets me 50 records and marks syntax error in "Has Next" and "Next URL" despite turning green

Has Next syntax error: 

Next URL: 

I would appreciate the help a lot, thank you!!

#coupa #RESTGET #REST #CoupaAPI

No RepliesBe the first to reply