Data types and formatting
Coupler.io allows user to work with different data types, so you can represent your data appropriately using specified format and use proper filtering / sorting options. Currently supported data types and formats:
String
String data type stands for alphanumeric characters.
Examples:
- this is a string value
- string
- 123text
- Hello!
Number
Number data type stands for numeric values. Coupler.io supports different data types and formats along with precision described below.
Integer
Whole numbers.
Examples:
- 0
- -1
- 99999999
Decimal
Numbers with a decimal point.
Examples:
- 0.1
- -0.1243
- 11.78
Decimal with precision
Number of digits after decimal point.
Examples:
- precision 1.0: 12.3
- precision 1.00: 22.74
- precision 1.000000: 0.851789
Percent
Percent representation of a numerical value.
Examples:
- 0.2%
- 99%
- -11%
Currency
Currency representation of a numerical value.
Examples:
- $10
- UAH 12
- £2
Percent and Currency formats can be used with precision.
Date and DateTime
Stands for date or datetime values.
Make sure that you have in the source needed columns in 'Date' or 'DateTime' ISO format (e.g. YYYY-MM-DD, YYYY-MM-DD HH:mm).
Date
Examples:
- 2017-05-06
- 1987-02-27
DateTime
Examples:
- 2023-07-11T14:10:33.682Z
- 2023-07-11T13:20:38.489Z
Time Zone
When dealing with Date or DateTime types, you would even have the option to specify which Time Zone to follow:
Boolean
Boolean type that has one of two possible logical values: true or false.
Examples:
- TRUE
- false
- 0
- t
