The following data types are used throughout the Squirro platform:
All APIs support the input and output of JSON data.
JSON is a text format to represent simple data structures. Libraries to read and write JSON data are available for almost all programming languages. See the extensive table on http://json.org/.
For more information about JSON, see JSON on Wikipedia.
Date and Time#
Date/time values are always in UTC in the format
Reference: For more information, see Date Format.
Language codes are always a 2-character long lower-case string (e.g.
ar). For more information, see:
Unique identifiers are generated as 22-character long case-sensitive strings (e.g.
Geographical locations include latitude followed by longitude and can be expressed as:
Single point: string with latitude and longitude as floating point numbers (separated by comma), e.g.
Rectangle: string with latitude and longitude as floating point numbers (separated by comma) of the top-left and bottom-right corner (separated by semi-colon), e.g.
For more information, see:
Formatted content is represented as HTML. When dealing with such content, special characters must be escaped. Most programming languages provide utilities for this, such as Python with the