[EN] Snoobi Datafeed and parameters

Modified on Fri, 24 May 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.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article