JSON_SERIALIZE

Description

Returns the provided value as a JSON string.

Syntax

JSON_SERIALIZE(json) -> String

Parameters

ParameterData TypeRequiredDescription
jsonObjectYesThe value to serialize into a JSON string.

Example

JSON_SERIALIZE(VLOOKUP_ALL("Contact", "FirstName, LastName", "AccountId", Id))
-- Returns the list of matching Contact field maps serialized as a JSON string, e.g. 
-- [{"FirstName":"Jane","LastName":"Doe","Id":"003DC00000cy97rYAA","AccountId":"001DC00000yTLiRYAW"},
-- {"FirstName":"John","LastName":"Smith","Id":"003DC00000cy97sYAA","AccountId":"001DC00000yTLiRYAW"}]

Related Formulas