Mapping JSON Data Types

JSON data type

IS data type

object

Document

string

String

number (real)

Float or Double Java wrapper, depending on the option you select for mapping real numbers.

number (integer)

Integer or Long Java wrapper, depending on the option you select for mapping integers.

true/false

Boolean Java wrapper type

array

Array of an Integration Server data type.

If the JSON object contains a two-dimensional string array, Integration Server sets the corresponding field in the IS document type to String Table.

If the JSON object contains a string array, Integration Server sets the corresponding field in the IS document type to String List.

If the JSON object contains a array having different types of objects (example, integer, string, etc.), Integration Server sets the corresponding field in the IS document type to Object List with Java wrapper type as UNKNOWN.

Note:

Designer does not support the following multi-dimensional arrays in JSON objects:

Two-dimensional arrays of data types other than string

Multi-dimensional arrays of three or more dimensions (three-dimensional, four-dimensional, etc.)

array of null

Object List

null

Not supported.

Note:

If JSON text begins with an array at the root and the array is unnamed, when parsing the JSON text, Integration Server uses a fixed name of $rootArray for the array value. The $rootArray field appears in the pipeline. When creating a JSON response, if the pipeline contains $rootArray with an array value at its root, Integration Server discards the $rootArray name and transforms the array value into a JSON array.