Connecting to the OData feed
When the OData (Open Data protocol) feature for your BlueDolphin site has been activated, it will be posible to get data from BlueDolphin in any site that supports OData and basic authentication.
In this article we will demonstrate the use of OData using Microsoft Power BI Desktop.
Open Power BI and choose Get Data. Choose OData Feed and click Connect
|2||Choose Basic and use this URL: https://odata.bluedolphin.valueblue.nl. Click OK|
The following screen will appear:
In field Username, fill in the value that can be found in BlueDolphin, Admin\General under Database
For the Password field, use Datacollection API key.
The following screen appears. Check Objects, Relations and Information and click Load.
|7||The data is now loaded.|
By default in the Objects table, only default fields for an object will be shown, because of performance.
To access the full set of data (questionnaire fields), the query must be edited. In Power BI, click Edit queries:
In the Power Query Editor, on the left side, select the Objects table.
Then click Advanced Editor in the Query menu:
Change the line that starts with Source to:
Source = OData.Feed("https://odata.bluedolphin.valueblue.nl", null, [MoreColumns=true]),
Remove any other arguments in the statement.
A MoreColumns column has now appeared. Click the icon on the right in the column:
Columns that need to be shown can now be selected.
Columns have a specific naming syntax:
<Questionnaire name>_<Question name>, with all spaces removed from the column name.
Select columns and click OK.
|15||Selected columns are now available:|
Differences between current and older versions of OData
- The current OData feed URL is: https://odata.bluedolphin.valueblue.nl (this used to be: https://odata.bluedolphin.valueblue.nl/odata/<customer name>. This means that in older reports, the connection will need to be changed.
- Naming syntax for questionnaire fields has been changed to comply with OData specification. Previously, column names were formatted like: <Questionnaire name> - <Field name>. Currently, this format is: <Questionnaire name>_<Field name>, with spaces removed from the column nam. Therefore, existing queries and reports need to be changed in order to work with the new OData Feed.
Support for converting older OData feed reports to use the new OData feed is obtained by contacting us using ZenDesk or the Contact menu item (via chat) in BlueDolphin.