Forum Discussion

manohar's avatar
manohar
Contributor
3 years ago
Solved

Coupa API GET

hi there, I need to call Coupa API to do a GET but their API only lets me get 50 records at a time, but they have over 7000 records that I need to pull. how can I increament my url https:/...
  • alchemiz's avatar
    alchemiz
    3 years ago

    hasNext: eval(sl.ensureArray($.get(‘entity’,)).length > 0)
    nextUrl: lib.conf.getAppConf(‘coupa’).basepath.concat(“supplier_information?offset=”,(snap.out.totalCount + 1) * 50, “&exported=false”)

alchemiz's avatar
alchemiz
Contributor III
3 years ago

Hi @manohar ,

Good day, before what I did was…

Set the has next property where you check the returned entity of coupa api

eval(sl.ensureArray($.get(‘entity’,)))

then for the next page

‘’.concat(‘https://instance.coupahost.com/api/invoices?offset=’, (snap.out.totalCount + 1) * 50, ‘&exported=false’)

then set pagination interval maybe 1 or 2 secs

Hope this helps

Thanks,
MM

manohar's avatar
manohar
Contributor
3 years ago

Hi @alchemiz , thank you for your help.

I have tried but still gets me only 50 records. I am sure, I am not doing right. Please check the pipeline that I tried to build. Can you please tell me whats missing?

CoupaExtract_2023_01_24.slp (23.6 KB)

Thank you,
Manohar

  • alchemiz's avatar
    alchemiz
    Contributor III
    3 years ago

    hasNext: eval(sl.ensureArray($.get(‘entity’,)).length > 0)
    nextUrl: lib.conf.getAppConf(‘coupa’).basepath.concat(“supplier_information?offset=”,(snap.out.totalCount + 1) * 50, “&exported=false”)

    • manohar's avatar
      manohar
      Contributor
      3 years ago

      thank you very much. that did it.

      • alchemiz's avatar
        alchemiz
        Contributor III
        3 years ago

        Good to know, glad to be of help 😀

    • rpc1235x's avatar
      rpc1235x
      New Contributor II
      3 years ago

      Hello alchemiz manohar ,

      I am having the same challenge as the original poster. However, when adding Has Next and Next URL. I get this error. Is there an additional step that I need to do like import an expression library? I am also using 

      https://instance.coupahost.com/api/invoices?offset=50&exported=false

       

       

      • alchemiz's avatar
        alchemiz
        Contributor III
        3 years ago
        hasNext: eval(sl.ensureArray($.get('entity',)).length > 0)

nextUrl: 'https://instance.coupahost.com/'.concat('supplier_information?offset=', (snap.out.totalCount + 1) * 50, '&exported=false')

        Try enclosing the string with a single-quote or double-quotes
        Since you don't have the expression file, it basically just getting the Coupa API base path