question

PrapulKumarDongari-0385 avatar image
0 Votes"
PrapulKumarDongari-0385 asked MartinJaffer-MSFT commented

How to Access Data From Rest API which has PagingToken

Hi team, I want to pull the data from rest api using Paging Token .How to use Paging Token in ADF copy Activity.201586-pagingtoken.png201646-adf-copy.png


azure-data-factory
pagingtoken.png (6.6 KiB)
adf-copy.png (19.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @PrapulKumarDongari-0385,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help.

Thanks
Martin

0 Votes 0 ·

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered MartinJaffer-MSFT commented

Hello @PrapulKumarDongari-0385 ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is how to get the pagingToken to use in pagination rules .

I can help you with how to reference it, the Value portion. However what goes in the Name portion depends on your REST api. It might go in header or in url or in request body (unless it is Get. Get doesn't have body).

It looks like the pagingToken is in the outermost level of a JSON. Set Value to Body, and then write in $.pagingToken . I made picture below guessing what way your api expects. I can't do better without more information.

202421-image.png
Please do let me if you have any queries.

Thanks
Martin


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators



image.png (26.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MartinJaffer-MSFT thanks for your valuable reply,
I tried the scenario with your solution by using GET Method it is not working can you give solution what i have to use as my request body is GET.202463-adf-pagination-rule.png202511-copy-output.png202521-json-result.png


0 Votes 0 ·
copy-output.png (28.1 KiB)
json-result.png (7.5 KiB)
MartinJaffer-MSFT avatar image MartinJaffer-MSFT PrapulKumarDongari-0385 ·

So, whether to use GET or POST or something else, and what header or body part to use... this information should be explained by whatever website you are using. This is not something I can tell you. You need to look at your website's documentation.

The Value part is where to look for the pagingToken in the response, and the Name part is where to put the pagingToken in the next request. @PrapulKumarDongari-0385

0 Votes 0 ·