Page 1 of 1

Exporting data from

Posted: Thu Aug 27, 2020 1:55 pm
by niklaskolster
There are three main ways to export data from
1. The REST API documented here
2. Direct database connection via eg. ODBC
3. From the dashboards

Here we describe method 3 directly from the dashboards.

1. Login to your windsor dashboard at
2. Go to your dashboards and explore the table you want to work with.
explore_chart.png (62.14 KiB) Viewed 9098 times
3. Select the metrics and data you want as you want it, create the transformations you want and copy the url.
select_metrics_export_data.png (113.94 KiB) Viewed 9095 times
The link can be used to get the data into any tool exactly as it looks in the table with the transformations and calculations you have added on the left.
The link for json can be easier to use in R, python and Tableau.
The link for csv can be easier to use in Excel, Google sheets and powerbi.

Here is an example of how to use it with curl.
The same url can be used in any other tool to get the relevant data displayed.

Code: Select all

curl -L<apikey>

  "data": [
      "market": "FR",
      "category": "Floor Scrubbers",
      "productsku": "EX10050135",
      "SUM(itemrevenueeur)": 5875.0,
      "SUM(costeur)": 187.22,
      "SUM(clicks)": 650.0
      "market": "DE",
      "category": "Hand Dryers",
      "productsku": "EX10040150",
      "SUM(itemrevenueeur)": 4466.74,
      "SUM(costeur)": 21.94,
      "SUM(clicks)": 33.0
      "market": "DE",
      "category": "Massage Couches",
      "productsku": "EX10040042",
      "SUM(itemrevenueeur)": 4375.88,
      "SUM(costeur)": 21.47,
      "SUM(clicks)": 12.0