Data Types - Envisso Integration Hub

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	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"`