Forum Discussion
Json file query – token from field in each query
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?
1 Reply
- AnonymousNot applicable
Hi UncleLion ,
Refer to:
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.