| Type | Definition | Example |
|---|---|---|
string | A sequence of characters — letters, numbers, and symbols. Typically enclosed in quotes. | "Hello world" |
boolean | One of two possible values: TRUE or FALSE. Typically not enclosed in quotes. | TRUE |
date | An ISO 8601 date string. | "2024-01-30" |
datetime | An ISO 8601 datetime string. Ideally UTC with a Z designator or UTC offset. | "2024-01-30T12:00:00Z" |
currency | Three-letter currency code (ISO 4217 alpha-3). | "SGD" |
country | Two-letter country code (ISO 3166 alpha-2). | "SG" |
integer | A whole number (positive, negative, or zero) — no fractional part, up to int64. Typically not enclosed in quotes. | 1000000 |
decimal | A number with a whole and fractional part. Only a dot as the decimal separator. Up to 5 fractional digits; whole part up to int64. Typically not enclosed in quotes. | 20.50 |
url | A URL where the protocol (http:// or https://) can be omitted. | "www.example.com" |
timezone | A timezone name from the latest tz database. | "Asia/Singapore" |
enum | A string that must exactly match one of a predefined set of allowed values. Uppercase preferred. | "PENDING" |
Data Dictionaries
Data Types
Valid data types and expected formats for CSV columns.
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.