How get data from web api using offset?

[aignn]

HI all!

I get data from api, but get only 50 rows. 

Total in api 650 rows.

How get all data from api? It need using offset every 50 row like ?offset=50,?offset=1000 etc

Thank you advanced

[v-yingjl]

Hi @aignn ,

Basically you can use &top to get data from web api, like this:

https://api.applicationinsights.io/v1/apps/DEMO_APP/events/customEvents?$top=1000

 Here is the document introduces it in details that you can refer:

Analyze recent requests using the Events API 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lkalawski]

Hi @aignn.,

Could you please provide an example you want to follow?

Perhaps a parameter would be helpful in this.
1. You create a parameter in Power Query.
2. You set the default value = 50 .
3. You add a parameter to the query, in which you retrieve the data using the API, as a filter, eg for the index.

_______________
If I helped, please accept the solution and give kudos! 😀

[amitchandak]

@aignn , refer if this can help

API pagination
http://sqlcodespace.blogspot.com/2017/09/power-bipower-query-api-response.html
https://datachant.com/2016/06/27/cursor-based-pagination-power-query/
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78