Tech Labs | 14 Jun 2022
API Databank – Saved selection to PowerBI
Technology Team
Oxford Economics
- 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
Related Services
Post
From opportunity to impact – Assessing the economic, societal, and cultural benefits of YouTube in Finland
This study assesses YouTube's contribution to GDP and employment in Finland, and its broader impact on society and culture.
Find Out More
Post
Mahdollisuuksista vaikuttavuuteen – Arviointi YouTuben taloudellisista, yhteiskunnallisista ja kulttuurisista hyödyistä Suomessa
Tässä tutkimuksessa arvioidaan YouTuben vaikutusta Suomen bruttokansantuotteeseen ja työllisyyteen sekä sen laajempaa vaikutusta yhteiskuntaan ja kulttuuriin.
Find Out More
Post
Economic Impacts of The Umbrella Academy Season Two in Ontario
In 2019, production of Season Two of “The Umbrella Academy” resulted in total spending in Ontario of over C$77.3 million.
Find Out More