The Keelvar APIs can be used to export bid, award and event data to Power BI or Excel using Power Query on Windows computers. This article will show how a user can extract data from across all events in their organization.
To complete this guide you will need:
- Power BI or Excel desktop running on a Windows computer
- A valid API key (link)
URL and authorization:
1. In Power BI, click on Get data -> Web.
1a. In Excel, get data -> From Other Sources -> From Web.
2. Click on the Advanced option
3. In the URL parts field enter https://my.keelvar.app/api/feeds/latest-bids?page_size=200
4. In the "HTTP request header parameters field" type Authorization into the left field, then type Bearer followed by a space and paste in your API Key (see screenshot)
5. Finally click ok
Navigating the exported data
The application will send a request to fetch the data from Keelvar and show the results in the power query editor
1. If more than 200 records are returned then a link to the next page of results will also be returned
2. In the table displayed, click on “List”
3. On the top left click on To Table, click ok on the pop up
4. Finally click on the arrow symbol at the top of the column to split the column into multiple columns
5. The table will now show data for up to 200 bids
Using other API Endpoints
In the example above we queried the latest bids endpoint which returns bid data. It is also possible to get award and event data. To send requests to these endpoints simply replace the latest-bids part of the URL with either sourcing-events or awards