Extractor (Keboola)

Getting started

This component exports data from the CleverMaps Platform. The export is based on Query definition which can contain properties, metrics and filters from the corresponding CleverMaps project.

Following rules apply:

Properties can be defined across many datasets.
Metrics are defined by their names.
Filters can be defined across many datasets.
Relationship has to exist between datasets.

Configuration

CODE

{
  "project_id": "<YOUR-CLEVERMAPS-PROJECT_ID",
  "#access_token": "<YOUR-CLEVERMAPS-TOKEN>",
  "query": {
    "properties": [
      "<DATASET-NAME-1>.<COLUMN-NAME-1>",
      "<DATASET-NAME-1>.<COLUMN-NAME-2>",
      "<DATASET-NAME-2>.<COLUMN-NAME-1>",
      "<DATASET-NAME-2>.<COLUMN-NAME-2>"
    ],
    "metrics": [
      "<METRIC-NAME>"
    ],
    "filter_by": [
      {
          "property": "<DATASET-NAME-1>.<COLUMN-NAME-1>",
          "operator": "<eq, ne, in, lt, lte, gt, gte, isNull, isNotNull>",
          "value": "<VALUE>"
      }
    ]
  }
}

More about filters operators here Metrics in the section “Operators“.