Authenticate and call the integration API

Every client, such as Postman, Python, Excel/Power Query, Power BI, curl and ETL tools, exposes HTTP method, headers and body in different places; however, the steps are the same.

Activity steps:

  1. To request a token, POST /identity/connect/token with:
    • Basic authentication (client_id:client_secret).
    • Form body: grant_type=client_credentials
  2. To call the dataset, POST the External Link URL copied from the configuration with:
    • Header: Authorization: Bearer <access_token>
    • Header: Content-Type: application/json
    • Body: {} (empty JSON object).

Note: See Configure an integration API for how to configure the data and copy the External Link URL.