Forum Discussion

reachsenthil's avatar
reachsenthil
New Contributor
3 years ago

Need to chunk files and hit the api for each record

Need to chunk files and hit the api for each record. Restriction on api to hit only 1000 records per request. The input has millions of records. how to handle this in same pipeline

3 Replies

    • reachsenthil's avatar
      reachsenthil
      New Contributor

      Hi @Soni37 , I am using REST GET to hit the url with parameters and get the response and load to table. so the restriction is to hit api for 1000 records per request

      • Abhishek_Soni37's avatar
        Abhishek_Soni37
        Contributor

        You can use Group By N snap to create a batch of requests before feeding it to REST Get snap.
        Test_Expression_2023_06_22.slp (3.8 KB)

        The response will look like this: In my case, I created a group of 8 records.

        Let me know if it works. 🙂