Other Apps

In case you do not see your dashboarding tool of choice in the official list, you can still output the data through HTTP call that will output the data in the form of CSV or JSON. Most of the apps should be able to consume the data in this format.

Prerequisites

• You already created at least one Source.

How to Create a New Data Flow

1. Click on Flows at the top of the page and proceed with Create Flow in the top right corner .
2. Click on Add Source and choose the source you'd like to include in the flow. You can type the source or connector's name into the search bar to find it faster. You can add more sources or blend two sources in the same flow. Read more about Data Blending here.
3. Once you select your data source, click on Add Destination, followe by navigating to Dashboarding Apps and selecting REST Endpoint.
4. You can Name your flow by typing the name into the top.
5. You can see a Data Preview to ensure the correct configuration of your data.
6. Click on Save Flow.

Obtaining the data

1. After saving flow in Dataddo, the configuration window will appear. If not, or you already closed it, click on the three dots next to the flow and choose Config.
2. You will be provided with HTTP call details. Make sure to include the authorization header in the call.

Output in CSV

You will be provided with an output that has header on the first line, using semicolon (;) as a delimiter and each line ends with \n (UNIX standard). String values containing semicolon are escaped with doublequotes ("").

gasourcemedium;gasessions;gapageviews
(direct)/(none);42;71
www.dataddo.com/referral;5;15
google/organic;124,144
rosemarie.top/referral;1;1

Output in JSON

When a JSON format is requested, the data is provided in the attribute data as an array of arrays. Besides the dataset itself, dataset header information is provided in attribute header and data types are provided in attribute type.

{  
    "data": [  
        ["(direct)/(none)",42,71],  
        ["www.dataddo.com/referral,5,15],  
        ["google/organic",124,144],  
        ["rosemarie.top/referral",1,1]  
    ],  
    "header":[  
        "ga:sourcemedium",  
        "ga:sessions",  
        "ga:pageviews"  
     ],  
     "type":[  
        "string",  
        "integer",  
        "integer"  
     ],  
    "columnID":[  
        "5cc31fe2db15e75a161eaac2",  
        "5cc31fe2ab15d75c171eaac3",  
        "5cd31f32da15d75c163eaae4"  
    ],  
    "totalRows":4  
}