Object Data Type

Contents:

Expand all Collapse all

NOTE: Designer Cloud Educational is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

An Object data type is a method for encoding key-value pairs. A single field value may contain one or more sets of key-value pairs.

An Object data type is identified as a set of nested objects in the following format:

{"key":"value"}
{"New York":"NY"}
{"California":"CA"}

Notes:

Individual values of an Object type must have unique keys. Values, however, may be repeated.
The order of key-value pairs is not guaranteed.
The \n and \t escaped characters are supported in inputs for this data type.

NOTE: The Designer Cloud application recognizes up to 250 unique keys in a column of Object data type.

See Also for Object Data Type:

Page:

Nest Transform
Page:

ARRAYSTOMAP Function
Page:

FILTEROBJECT Function
Page:

KEYS Function
Page:

PARSEOBJECT Function
Page:

EXAMPLE - Nest and Unnest JSON Records
Page:

EXAMPLE - Nest JSON Records
Page:

EXAMPLE - Extract Object Values
Page:

Working with Objects
Page:

Import Flow

Send Feedback

Page tree

Object Data Type