Forum Discussion

jkdata's avatar
jkdata
Copper Contributor
Jan 08, 2024

REST API and Pagination

So, I'm having some issues getting all the data from a Rest API into Azure Data Factory. Currently I have everything setup correctly the mapping the source etc. The REST API returns only 100 result...
jkdata's avatar
jkdata
Copper Contributor
Jan 15, 2024

For anyone who might find this page via search engine I did figure out what I needed to do. 

 

As long as "?after=" was in the relative URL value all I needed to do was put the word "after" as a QueryParameter and where it was located in the body response of the json data. For this API it was Body->pagination.endCursor.

  • anelson45's avatar
    anelson45
    Copper Contributor
    Nov 03, 2024

    jkdata 

    Thank you SO much for following up on your original post with the exact solution.  I too am working with Samsara and specifically I was having the same trouble with the pagination rules.  Your clear and easy instructions really helped.  Thank you again!!!

Resources