Skip to main content

External reporting connector

  • Updated

The external reporting connector allows you to create external URLs to easily access or export your data for use internally or integration into 3rd party reporting platforms. Data can be made available in CSV or JSON data format.

You can find instructions below to:

Setting up an external link

You can create an external reporting connector link by following the below steps:

  1. Navigate to the Integrations page and under External Reporting Connector click "configure".

    integration-tile-external-reporting-connector.png

  2. Click the + icon to create a new external link

    external-reporting-connector-add.png

  3. You'll then be shown the configuration pane:

    create-optimisiation.png

  4. Enter the name of the external platform or, if using as an export, a descriptive name.
  5. Select the account you would like data for. If an account has sub accounts, you'll also have an option to include all sub-accounts.

    account-sub-account-selection.png

  6. Select the authentication type:
    Token (API auth): You must authenticate with the WildJar API and obtain a bearer token to access the data.
    None: Data may be accessed by anyone with the link.
  7. Select either JSON or CSV.
  8. Click Save.
Please note: When creating an external reporting connector for the first time, it can take up to 24 hours for the data to populate and be available at the external URL.

You will be shown the details for your external data connector.

Click the copy icon to copy the public URL:

external-reporting-link.png

Accessing an external reporting connector link

You can access the link for your External Data Connectors by following the below steps:

  1. Navigate to the Integrations page and under External Reporting Connector click "configure".
  2. Select the required connector:

    external-reporting-connector-list.png

  3. In the configuration pane, click the copy button to copy the link:

    external-reporting-link.png

    If exporting a CSV, you can paste it into your browser for the CSV to be generated and downloaded. There is a maximum of 10,000 records per request.

Filtering external reporting connector data

URL parameters can be added to your External Reporting Connector link to filter the data. The below fields are available:

Parameters Description

dateFrom

dateTo

You can use "1 week ago" or a more traditional ISO 8601 date range for the date.

Examples:

limit

The limit parameter can be used to return results between 1 and 10,000.

Examples:
fields

 CSV only. Use ‘ALL’ to preserve the field order. Alternatively, you can comma separate the fields you would like to see in the data.

Examples:

Related articles