Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/json-funcs.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

JSON Functions

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Hyper supports the SQL:2016 functions for constructing JSON values from SQL data. Use JSON functions to:

Build JSON arrays from a list of values.
Build JSON objects from key-value pairs.
Convert any scalar value to its JSON representation.
Parse and embed pre-formatted JSON documents.

Build JSON values from SQL data:

[json](./json-constructor.md) - Parse a string into a JSON value.
[json_array](./json-array.md) - Build a JSON array from a list of values.
[json_object](./json-object.md) - Build a JSON object from key-value pairs.
[json_scalar](./json-scalar.md) - Convert any scalar value to JSON.

Strings passed as arguments are escaped and become JSON string values. To embed a value as raw JSON instead, pass a json-typed value or use the FORMAT JSON modifier.
The RETURNING clause and the WITH UNIQUE KEYS option from the SQL:2016 standard aren’t supported.

Combine json_object and json_array to build a nested document from table columns.

Returns {"id":42,"name":"Alfons","phone_numbers":["(415) 555-0134"]} for a customer with only a mobile number on file.

Use the json constructor to embed an existing JSON document without escaping it.

Returns {"a":1,"b":{"nested":true}}.

JSON Type
JSON_ARRAYAGG - Aggregate values from a group into a JSON array.
Array Functions