View Navigation
Product Overview
Account Overview
Integrations
Transforms
Security
Integrations   ->

Send to Databox

The Send to Databox step is a beta step. This means that while it's not a fully built-out integration, it's a preconfigured Send to an API step that makes it easy to get set up and send data to Databox using their API.

Databox is a business analytics platform that enables you to pull and analyze all of your data in one place.

The first thing to do is get an API Token from your Databox account. Click here for instructions on how to find your pre-assigned Databox token.

Once you have it, paste the API Token to the Username field on the Send to Databox step. Leave the Password field blank. This is all you need to do to authenticate with the Databox API.

Custom settings

Now, it's time to configure the rest of the Send to Databox step.

When sending data to the Databox API, you will be sending your data row-by-row. Whether you're sending 1 row of data or 500 rows of data, the way you set up the Body field will not change. You can consult Databox's full API documentation here.

Send multiple metrics

When sending multiple metrics to Databox, the Body field of your Send to Databox step should look something like this:

{
  "data":[
     {
        "$clicks":"{Clicks}",
        "date":"{Date}"
     },
     {
        "$sales":"{Sales}",
        "date":"{Date}"
     },
     {
        "$users":"{Users}",
        "date":"{Date}"
     }
  ]
}

The metrics and attributes wrapped in double-quotes " " are the metrics and attributes in Databox. The values wrapped in double-quote and curly braces {} are the column names that store those values in Parabola.

In this example, 3 metrics are being sent, "clicks", "sales", and "users" with its corresponding values store in the columns {Clicks}, {Sales}, and {Users} respectively. "date" is the attribute we're sending for each metric.

The dollar sign $ before a metric name is mandatory. This character is used to differentiate a metric from its attributes.

Send a single metric

When sending a single metric to Databox, the Body field of your Send to Databox step should look something like this:

{
  "data":[
     {
        "$sales":"{Sales}",
        "date":"{Date}"
     }
  ]
}

In this example, 1 metric is being sent, "sales" with its corresponding value stored in the column {Sales}. "date" is the attribute we're sending for that metric.

Send a metric with multiple attributes

When sending a metric with multiple attributes to Databox, the Body field of your Send to Databox step should look something like this:

{
  "data":[
     {
        "$sales":"{Sales}",
        "date":"{Date}",
        "channel":"{Channel}"
     }
  ]
}

In this example, 1 metric is being sent with 2 attributes.  "sales" is the metric being send with its corresponding value in the column, {Sales}, and "date" and "channel" are the attributes with its corresponding values.

Helpful tips

  • A metric must be purely numeric. If you have currency values or percentages, send only the number, but set up a proper format for your metric in the Databox Designer. Read how to do that here. You can use the Split column or Extract text from column steps to make your values purely numeric.
  • The date, if specified, must confirm to the ISO 8601 standard. Use the Format dates step to get your date values in the required format. Here's a resource you can consult to verify your date format conforms with ISO 8601.

Recipes