API Pagination from Dynatrace

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