Before you start
The OData feed should be used to extract data for reporting purposes only. To start using the feed:
- Choose which environment you would like to connect to.
- Create an account on that environment.
- Familiarize yourself with the definitions.
- You are now ready to start using the OData feed using the OData endpoints specified below. Also check out our Microsoft Excel how to.
Endpoints
| Environment | OData Endpoint |
|---|---|
| Production | https://api.mypup.app/odata/v1 |
| Staging | https://api.staging.mypup.app/odata/v1 |
Notes
Reporting Only
The OData data export interface should only be used by (third party) reporting tools such as Microsoft Power BI or Microsoft Excel (using power query). We do not allow the OData interface to be used for anything other than reporting.
Authentication
With the OData interface you can either use the Basic or Bearer authentication method. It is preferred to use Bearer authentication where possible.
When using Microsoft Excel (Power Query) or Microsoft Power BI you need to use Basic authentication.
Respect Account Privacy
Using these OData feeds you gain access to personal information. Please use the data it exports wisely, with respect to the GDPR.