Application Integration (On-Premises) : Integration Server Built-In Services : JSON Folder : Data Type Mapping
Data Type Mapping
The following table shows how JSON data types map to Integration Server data types during data conversion.
JSON
Integration Server
object
Document
string
String
number (integer)
Integer or Long Java wrapper. For more information about converting JSON integers, see the decodeIntegerAsLong input parameters in pub.json:jsonStreamToDocument and pub.json:jsonStringToDocument.
number (real)
Float or Double Java wrapper. For more information about converting real numbers, see the decodeRealAsDouble input parameter in pub.json:jsonStreamToDocument and pub.json:jsonStringToDocument.
True/False
Boolean Java wrapper
Array of JSON type
Array of Integration Server type
*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 two-dimensional string array, Integration Server sets the corresponding field in the IS document type to String Table.
*If the JSON object contains a array having different types of objects (for 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:  
Integration Server 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.)
For pub.json:jsonStringToDocument and pub.json:sonStreamToDocument, these kinds of arrays become an Object List of UNKOWN type. For IS document types created from a JSON object using Designer, these kinds of arrays become an Object with a Java wrapper type of UNKNOWN.
Array of null
Object List
null
null
All others
String
Note:  
If an object has a toString() implementation, Integration Server uses that implementation.
If the object does not provide a toString() implementation, Integration Server uses Object.toString(). Object.toString() returns the class name and hexadecimal representation of the hash code of the object, such as "javax.namining.InitialContext@3ae6f00b".
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.
Copyright © 2015- 2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback