Articles in this section

Data type validation

Tom Santiago
Updated

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.

Date

See Format date and time in ISO8601