Below you can read the description of the column types you'll see when using our API documentation.
INTEGER - Whole numbers likes 0,1,2,3, -1,121, etc. There is no separation.
DECIMAL - Representing any real number such as 10.00, 3.14, -7.98. There is always a separation, such as a dot.
PERCENT - It represents a value between 0 and 1. In some cases, it is multiplied by 100 then it represents a value between 0 and 100.
DATETIME - Represents UTC time, e.g. ‘2017-01-12 12:00:00’
DATE - Represents UTC date, e.g. ‘2017-01-12’
BOOLEAN - This data type represents that the column value can either be true or false. If it’s true it holds “1”, if it’s false it holds “”.
LINK - Web address which references to a web resource (URL)
ENUM - This data type consists of a set of value names. Only one of these elements can be the column value of the column of this data type. One of them has to be set.
STRING - Holds a text (e.g. post message)