Webhook

• Make sure that the JSON object has the correct format (see example below) and that you know the keys. (If you don’t know what your data looks like, you can send it to a webhook data source, click edit then click the View last uploaded data button.)
• Go to https://my.causal.app/data and click on the Webhook button in the New data source section
• Fill in the keys and click on Create webhook data source
• This will generate the Webhook URL that you can send the data to
• After sending data to this URL you can refresh your data source to overwrite the old data.

Example for Looker

Make sure to check out our Looker documentation about the setup in Looker.

This example Look has the three columns “Event Date”, “Country” and “Customers”:

The JSON export will look something like this (this is auto-generated from the 4th bullet under Step 3 here):

{
  "type": "query",
  "scheduled_plan": {...},
  "data": [
    {"Event Date": "2022-02-14", "Country": "UK", "Customers": 5},
    {"Event Date": "2022-02-14", "Country": "USA", "Customers": 6}
  ]
}

Create a new Webhook Data Source and fill in the following fields:

• Data array key: data (the array with the results is stored under the “data” key in the example above. Note: for Looker, this will always be data)
• Date key: Event Date (the key with the dates. This is the name of your column in Looker)
• Cohort key: There are no cohorts in the example above, so you can leave this field empty
• Variable keys: Customers (the key that contains the values (measures). This is the name of your column in Looker. To enter multiple variables, hit enter after typing each variable name.)
• Dimension keys: Country (the key that contains the dimension (dimension). This is the name of your column in Looker. To enter multiple dimensions, hit enter after typing each dimension name.)
• Click Create webhook data source to generate the Webhook URL that you can paste into the Looker Schedule (more details about the Looker setup: Looker)

Dimension Mappings

Just like spreadsheet data sources (e.g. time series with dimensions), you can also send dimension mappings to webhook data sources. For example if you have an Employee dimension and every Employee belongs to a Department. To do that, first configure the Dimensions, then click the Add dimension mapping button. Enter the key that contains the mapping and the names of the dimensions.