Export column headers
In Data Flow, you decide to display either the dimension names or the dimensions names plus the dimension group names, to get more context:
Bear in mind that this setting has to be saved to update the Data Flow stream.
In Data Flow, you can decide which character to be used for the decimal separator: dot v. comma.
Bear in mind that this setting has to be saved to update the Data Flow stream. E.g. if you need to download a test file, save this setting first and then download the file.
The Data Flow API outputs files in two formats: JSON and CSV.
This format can be selected in the top right of the export bar or un the url link itself.
Note: The format can be changed on the fly directly in the URL without having to edit the flow, change the format and save the changes.
Tip: The JSON format is bigger than the CSV format, we recommend using CSV for quicker download times. If you still prefer the JSON format, you can request a compressed file via the URL call to reduce the file size.
Additional information is available on file compression via the : API Technical Documentation.
Saving a flow
Once you have created a flow, name it and click “Save”
If you save your changes to an existing flow you will receive the following error message: ”You have 7 days to delete or edit the current Data Flow call with your technical services”
Data Flow refreshes every hour or every half hour.
The format to query using a hourly format is the following: YYYY-MM-DDTHH
When you click on “Copy the URL”, do not forget to specify a time at which you’d like to extract the data so that it functions properly.
The format to query using a half-hour format is the following: start:'yyyy-MM-ddTHH:mm',end:'yyyy-MM-ddTHH:mm'
To query every half-hour, you must specify the starting & the ending minutes:
For the first 30 minutes of every hour: start: 00; end: 29
For the second 30 minutes of every hour: start: 30; end: 59
Data is only available for complete hour or half-hour timeframes. We are currently subject to 3 to 5 minute delays for real time data. We therefore recommend waiting 10 minutes before requesting data from the previous hour in order to reduce the occurrence of the "Data Not Ready" error.
In the half-hour format, for example:
The only valid values the “mm” placeholder at “start:” can hold are “0” or “30”
The only valid values the “mm” placeholder at “end:” can hold are “29” or “59”
To query data for 30 minutes at 4PM on the 25th of July 2018 (4:00PM to 4:29PM)
To query data for 30 minutes at 9:30AM on the 25th of July 2018 (9:30AM to 9:59AM)
Deleting a flow
From the Data Flow homepage you may: delete an existing flow, rename it, or edit it.
To delete multiple flows, select them at the left of the table, then click the "Delete" button above.