Data Types

the table below outlines all valid data types and their expected formats following these specifications will ensure your csv files are processed correctly by the envisso platform and prevent validation errors each data type has an example showing exactly how the data should appear in your csv columns type name definition string a sequence of characters strings are used to store text and can include letters, numbers, and symbols they are typically enclosed in quotes example "hello world" boolean a boolean represents one of two possible values true or false they are typically not enclosed in quotes example true date a string representing a date formatted as an https //en wikipedia org/wiki/iso 8601 date example "2024 01 30" datetime a string representing a datetime formatted as an https //en wikipedia org/wiki/iso 8601 datetime ideally, datetime will be in utc with a timezone designator of "z" or alternatively with a designator represented as an offset from utc (+00 00) example "2024 01 30t12 00 00z" currency a string representing a currency, formatted as a three letter currency code according to the https //en wikipedia org/wiki/iso 4217 standard in its alpha 3 format example "sgd" country a string representing a country code, formatted as a two letter country code according to the https //en wikipedia org/wiki/iso 3166 standard in its alpha 2 format example "sg" integer an integer value is a whole number that can be positive, negative or zero, does not have a fractional part, and can be as large as an int64 they are typically not enclosed in quotes example 1000000 decimal a decimal value is a number that consists of a whole and a fractional part only a dot can be used as the decimal separator the fractional part can have up to 5 digits and the whole number part can be as large as an int64 they are typically not enclosed in quotes example 20 50 url a string representing a url where the protocol (http // or https //) can be omitted example "www example com" timezone a string representing a timezone name according to the latest version of the https //www iana org/time zones example "asia/singapore" enum a string that must exactly match one of a predefined set of allowed values values can be either uppercase or lowercase, but uppercase is preferred example "pending"