API Databank – Saved selection to PowerBI
- Open Swagger by accessing following path – https://services.oxfordeconomics.com/Swagger
2. Click on /Users directory. In the dropdown, click on GET /api/users/{id} option. Next to id parameter, in the value column, type “me”. Once done, click on Try it out! button.
3. The new sections will appear. In the Response Body section, find “SavedSelection” part, which contain the information on every saved selection in databank under your account. Copy id of a saved selection you wish to access.
4. In PowerBI new project, click on button Get data and chose the Web option.
5. If Web option is not available please select More… option, a new window will pop-up, please select Web option under Other tab.
6. Select Advanced tab
- Fill the first URL part line with https://services.oxfordeconomics.com/api/download
- Second line must be filled with the id you copied in step 3 (Saved Selection Id)
- Third line contains ?includeMetadata=true text. Finally for header parameters, you would have to type them manually as drop down menu will not give you options we are looking for.
- Copy Method and (e) Content-Type parameters just as they are on image.
- For Api-Key parameter, you would have to paste the API access key previously provided to you or you can find it in step 3 as ApiKey.
- Click Ok once all ready.
7. If you are connecting to API from Power BI for the first time, following window will pop-up. Please proceed by clicking Connect, so we can set up anonymous access.
8. Finally, PowerQuery editor should open up with the established connection to saved selection table
9. Click File => Close & Apply
10. The saved data should now be available under the Data tab
