API Pagination from Dynatrace

[Esteban_]

Hello.

I need to paginate the information from Dynatrace API.

The way the API pagination works is:

1- The origin is WEB and the API format is:

url:

https://xxxxxxxx.live.dynatrace.com/api/v2/problems

Headers:

pageSize=500 (size of page, in this case 500 which is the maximum)

from=now-1M (period)

Authentication:

api-token=xxxxxxxx

The curl is: 

https://xxxxxxxx.live.dynatrace.com/api/v2/problems?pageSize=500&from=now-1M&api-token=xxxxxxxx

2- The result is:

where:

totalcount = Total of events

pagesize = Total of events which are imported in this query

nextpagekey = Is the key that will be necessary to perform pagination

problems = List that cointains the important information

warnings = Will not be used

3- Now pagination must now be done:

For pagination is necessary to change the API headers.

NEW API:

url:

https://xxxxxxxx.live.dynatrace.com/api/v2/problems

Headers:

nextPageKey = key obtained previously

Authentication:

api-token=xxxxxxxx

The curl is: 

https://xxxxxxxx.live.dynatrace.com/api/v2/problems?nextPageKey=xxxxxxxx&api-token=xxxxxxxx

4- The result is:

this query brought the last 39 events.

In this case there is not nextpagekey in the results, that means this is the last page, so this is the end.

The problem i have is that i need to automate this process, but I have not been able to create a script that performs this pagination automatically, which generates a single variable that contains all the "problems" information of all the pages.

I'll appreciate if you can help me to build this in power query.

Regards

[lbendlin]

Check this document and sample function

Handling paging for Power Query connectors - Power Query | Microsoft Learn

[Esteban_]

Hi, thanks for your answer.

I reviewed the documentation, but it is still somewhat confusing, since I previously tried to use this function without success.

[lbendlin]

What have you tried and where are you stuck?