Report-API
The Report API can be used to generate and retrieve Europace reports.
Documentation
The latest OpenApi specification in json format is available at any time at https://report.api.europace.de/documentation
.
can be downloaded.
API use cases
- use Europace reports in dataware house ETL jobs
- provide Europace reports in sales tools
Overview Europace Reports
The following reports can be called with this API:
Name | Endpoint | Required Scope | File Type/Encoding | Content Description. |
---|---|---|---|---|
Vertriebs-Rohdaten-Report | /rohdaten | report:rohdaten:lesen | zip/UTF-8 | all relevant data of Vorgänge, Anträge, Bausteine and Provisionen of the advisor Data older than 2014 will not be delivered. |
Produktanbieter-Report | /produktanbieter | report:produktanbieter:lesen | csv/UTF-8 | the essential data of Anträge with state and Vertriebsorganisation |
Vertriebsreport | /vertrieb | report:rohdaten:lesen | csv/UTF-8 | the “EUROPACE Report Vertrieb”. |
Smart Facts Vertrieb | /smartfactsvertrieb | report:rohdaten:lesen | XLSM | the “EUROPACE Report Vertrieb” with a graphical interface |
Smart Facts Produktanbieter | /smartfactsproduktanbieter | report:produktanbieter:lesen | XLSM | the “EUROPACE Report Produktanbieter” with a graphical interface |
Quickstart
The report creation is asynchronous to avoid network timeouts during the report creation. Active testing is required for the completion of the report.
The procedure is the same for all Europace reports:
- request report
- query report status
- retrieve report data
To help you test our APIs and your use case as quickly as possible, we’ve put together a Postman Collection for you to easily follow along.
The previous day’s data will be available around 5:00 am.
Example: Requesting a raw sales data report
Authentication
Please use to get access to the report API.
Which scope you need for which report you can see in the Overview Europace-Reports.
:warning: Note . The report for the identity of the OAuth token is always supplied. To retrieve a report for another person/organisation, impersonated or another client should be used if necessary. For the Produktanbieter-Report, the Produktanbieter must be authenticated as the client.
1. request report
With the request, the generation of the report is started at Europace. This process can take several minutes depending on the complexity and the requested time period. The valid parameters for the report creation can be found in the corresponding report description.
Request for Vertriebs-Rohdaten-Report:
curl --location --request POST 'https://report.api.europace.de/rohdaten' \
--header 'X-Trace-Id: ' \
--header 'Authorization: Bearer {access-token}' \
--data-raw '{
"fromDay": "2020-01-01"
}'
Response:
Header:
- Status: 202 ACCEPTED
- Location: /rohdaten/{report-processing-id}
The header variable Location
points to the endpoint for the next step: to query the report status.
2. query report status
This step is the same for all Europace reports.
Request:
curl --location --request GET 'https://report.api.europace.de/rohdaten/{report-processing-id}' \
--header 'X-Trace-Id: ' \
--header 'Authorization: Bearer {access-token}'
(a) Response if the report is still in progress:
Header:
- Status: 200 OK
Body:
{
"status": "PROCESSING"
}
Please query again in 20s (recommendation).
(b) Response if the report has been created:
Header:
- Status: 303 SEE OTHER
- Location: https://{path-to-file}
The header variable ‘Location’ points to the report data.
3. retrieve report-data
This step is the same for all Europace reports.
The URL pointing to the result data is only valid for a limited period of time. Anyone who has this URL can access the report.
Example for {path-to-file}:
https://greta-462912489437-eu-central-1.s3.amazonaws.com/prod/{reporttyp}/{report-processing-id}/Ep2_Reports_....zip?X-Amz-Security-Token=...&X-Amz-Signature=...
Request:
curl --location --request GET 'https://greta-462912489437-eu-central-1.s3.amazonaws.com/prod/{reporttyp}/{report-processing-id}/Ep2_Reports_....zip?X-Amz-Security-Token=...&X-Amz-Signature=...
Response:
Header:
- Status: 200 OK
Body:
<File>
The file type of <file>
is described in the Overview Europace Reports. To facilitate opening with Excel, the encoding is UTF-8 with Byte Order Mark (BOM).
Terms of use
The APIs are made available under the following Terms of Use.
Support
If you have any questions or problems, pls contact devsupport@europace2.de.