Integration

The Integration screen allows authorised users to define API calls on the Reconcilor data warehouse. This feature enables dynamic data retrieval, with options to customise filters and configure the data format.

You can create a single, shareable dataset endpoint that returns clean JSON for business intelligence tools, ETL jobs, and custom applications. You define the dataset once, save it, and use the generated external link. Any system with a valid token sends a POST with an empty JSON body to receive the latest data.

This approach is reusable and versionable for many consumers, provides a stable contract with consistent field names, supports rolling windows via Quick Links (for example, Last 7 Days), and is secured with OAuth2 client-credentials. Typical consumers include Python or R, Azure Data Factory or Synapse, Snowflake, and custom integration services.