[EN] Snoobi Datafeed and parameters

Modified on Fri, 24 May, 2024 at 10:08 AM

Snoobi Datafeed Usage -- Updated for December 2023 Release

All Snoobi Datafeeds are in the form of a link to the Snoobi Datacenter and may contain one or more parameters.

An example (non-functional):

https://data.snoobi.eu/snoobidata/6628a14966d6e6228a1e966dae62282?maxrow=1000&format=csv

The Snoobi Datafeed extracts data from the Snoobi servers for a specified Snoobi metrics panel for a single Snoobi account.
The data is returned in a normalized format (json, csv or Excel-style csv).

Snoobi datafeed are always custom-made and optimized to contain the required metrics.

For security reasons, invalid Snoobi code Datafeed requests do not produce an error message. If the Datafeed is not used for 90 days, then it will automatically be reset to 'Static' meaning no data will be returned upon use but the Datafeed can be reactivated at any time by a request from a Snoobi account administrator.

The Snoobi Datafeed is subject to a 'fair use' policy with respect to the amount of data returned and the number of datafeed requests in a time period.

See below for an overview of the default parameters. The first parameter is always preceeded by a questionmark, subsequent parameters with '&'. Parameters can appear in any order. Some parameters such as maxrow,startdate, enddate, days and format are optional and depend on specific implementations.

Parameter	Usage	Example
maxrow	Determines how much data is returned (optional)	&maxrow=1000
startdate	Startdate (can include time) Format YYY-MM-DD and THH:MM:SS	&startdate=2022-01-01T12:00:00 or &startdate=2022-01-01
enddate	Enddate (can include time) Format YYY-MM-DD and THH:MM:SS	&enddate=2022-01-08T18:00:00 or &enddate=2022-01-08
If no startdate is present, then startdate=today-7 days. If no enddate is present, then enddate=now If both are not present, then the default period is 7 days, including today until now. The typical delay for data to appear in the account is a few minutes, but can be more for very large datasets, or time-out completely without warning.
days	Provides data back from today until nnn days before. If ommitted, then the standard start- and end dates apply. If start- and enddates are also ommitted, then days is standard today - 7 for data from the last 7 days. If only enddate is used then days counts backwards from the end date and includes that end date, for instance if enddate=2023-12-10 and days is set to 'days=3' then data from Dec 08 until Dec 10 is returned. Days has a maximum of 180.	&days=14
format	NOTE: If format is omitted, then default output is json
	format=csv If no delimiter is present, then default to comma-delimited The format parameter cannot be used together with the excel parameter.	&format=csv
	delimiter=tab or delimiter=semicolon Delimited csv values with tab or semicolon	&format=tab or &format=semicolon
excel	excel=1, comma delimited, period for decimal fractions excel=2, semicolon delimited, comma for decimal fractions Date and time representation = YYYY-MM-DD HH:MM:SS The excel parameter cannot be used together with the csv parameter	&excel=1 or &excel=2
Other	Other parameters can include sorting, filtering or segmentation on any Snoobi Analytics metric

Standard Snoobi Datafeed has no additional parameters, filtering and selection can then be done in the BI-tool or Excel.

However, there are many options to fine-tune the resulting dataset with segmentation and filtering to match how the data will be used. Contact Snoobi Customer Support for questions.