JSON

The JSON function interprets the input as a variant type containing JSON formatted data.
Converts the input value's data type, but does not otherwise change the input value.
Does not apply JSON formatting.

Usage

JSON(input)

input (required) The input you would like to be interpreted as JSON.

Columns that are cast as JSON can be unravelled using the "Extract columns..." option on the column's dropdown menu.

Example

[Cust Json] = Json([Cust Json (Text)])
  • Returns:

 

See Also

Was this page helpful?
Yes No