Json file query – token from field in each query

[UncleLion]

I want to connect to the database of employees of Polish universities provided by API.
Documentation: https://radon.nauka.gov.pl/api/katalog-udostepienia-danych/dane-polon/polon/reports_employee
Example json: https://radon.nauka.gov.pl/opendata/polon/employees?resultNumbers=100
The API allows you to download (once) 100 lines, the entire database has over 140,000. To download another 100, we need add the token parameter to the address, and the token code is in the previous query. So in the query we have: result list and pagination record. In pagination record we find maxCount and token field.

Example json with token: https://radon.nauka.gov.pl/opendata/polon/employees?resultNumbers=100&Token=MTY1NDA3OTE5MDA5NQ==

(sometimes they change tokens so static list does not solve the problem)
How do you create a query that takes a token from the first query, pastes it into the second link, then from the second to the third, and so on?

[Anonymous]

Hi @UncleLion ,

Refer to:

Call Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API | Part Two...

Solved: REST API Get Access Token - Microsoft Power BI Community

Generate dynamic token and get data from Custom API in Power BI

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