Data type validation

Tom Santiago

Updated March 19, 2024 09:38

Data type validation

Data type validation error messages occur when the destination data type is mapped to an invalid source data type. If the destination field data type can't be mapped to the source data type, an error message describing the data type mismatch displays, and you are unable to save your settings until your attempted mapping configuration makes sense. The following table describes the data type validation rules.

Destination data type	Invalid source data types	Valid source data types and mapped behavior
string	N/A	string: Map as-is. number: Convert number to string. boolean: Convert boolean to string. [string]: Save string array as single string value. [number]: Save number array as one string value. [boolean]: Save boolean array as one string value. object: Stringify the whole object. [object]: Stringify the whole object array.
number	boolean [string] [number] [boolean] object [object]	string: Must be a number in string format. number: Map as-is.
boolean	[string] [number] [boolean] object [object]	string: Must be one of the following: True or False (case insensitive) T or F (case insensitive) 0 or 1 boolean: Map as-is.
[string]	N/A	string: Converts string value to string array. number: Converts numeric value to string array. boolean: Converts boolean to string and stores as a string array. [string]: Map as-is. [number]: Converts individual array values to strings and stores as a string array. [boolean]: Converts individual array values to strings and stores as a string array. object: Stringifies the object and adds the string as the first element of a string array. [object]: Stringifies each object and stores each object as an individual element of a string array.
[number]	boolean [boolean] object [object]	string: Converts a number in string format to a number array. number: Converts number to number array. [string]: Converts to number array only if all the individual values are numbers in string format. [number]: Map as-is.
[boolean]	object [object]	string: Converts the string to boolean and stores as an array only if the string is one of the following values: True or False (case insensitive) T or F (case insensitive) 0 or 1 number: Converts the number to boolean and stores as an array only if the number is 0 or 1. boolean: Converts the boolean value to an array. [string]: Converts to [boolean] only if every string is one of the following boolean values: True or False (case insensitive) T or F (case insensitive) 0 or 1 [number]: Converts to [boolean] only if all numbers are 0 or 1. [boolean]: Map as-is.
object	string number boolean [string] [number] [boolean] [object]	object: Map as-is.
[object]	string number boolean [string] [number] [boolean]	object: Map as source for array. [object]: Map as source for array.