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

Images can be uploaded directly to the Easybases CDN. The link to an image can be posted to your integration if it is already publicly available.

GET Formats: URL

Query Formats: URL

Video

Videos can be uploaded directly to the Easybases CDN. The link to a video can be posted to your integration if it is already publicly available.

GET Formats: URL

Query Formats: URL

File

Files function as a generic type of the photo and video data type. Files can be uploaded directly to the Easybases CDN. The link to a file can be posted to your integration if it is already publicly available.

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