Easybase Data Types

Easybase constrains data to specific types that can be queried or retrieved in various formats.



Number


This data type contains all raw numbers including integers, floats, etc.


GET Formats: Number
Query Formats: Number, String containing number



Text


Raw text is best stored in this data type. For text with formatting (WYSIWYG) look at the ‘Rich Text’ type.


GET Formats: String
Query Formats: String



Time


This data type represents times, without a corresponding date.


GET Formats: Total minutes, HH:MM 24h, HH:MM 12h
Query Formats: Total minutes, HH:MM 24h, HH:MM 12h, hh:mm



Date


This data type represents a date. Dates will be stored in UTC format.


GET Formats: MM/DD/YYYY, YYYY/MM/DD, dd-mmm-yyyy, dd.mm.yyyy, UNIX Stamp, ISO String, Date object
Query Formats: MM/DD/YYYY, YYYY/MM/DD, dd-mmm-yyyy, dd.mm.yyyy, UNIX Stamp, ISO String, Date object



Image



GET Formats: URL
Query Formats: URL



Video



GET Formats: URL
Query Formats: URL



File



GET Formats: URL
Query Formats: URL



Location


Locations are stored as coordinates that can be used to perform geospatial queries. Easybase provides a visual way to create these objects using Maps API.


GET Formats: Preview image, “lat, lon”, Common name
Query Formats: “lat, lon”, array of two numbers



Boolean


The most primitive of the data types, the boolean can be in 1 of 3 states; true, false, or null.


GET Formats: 1/0, T/F
Query Formats: 1, 0, true, false, string of any of preceding



Rich Text


Rich text adds the capability of basic formatting (font size, adding images). It is synchronously converted to raw HTML. The raw HTML can be injected directly into a website or app for more text flexibility.


GET Formats: HTML String
Query Formats: HTML String