JsonEncode

The JSONEncode() function encodes the given value to a json literal.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that contains a JSON literal. Returns null if the value is unknown.

Syntax

JsonEncode(value)

JsonEncode(List(1,2,3)) => [1,2,3]

Parameters

Name	Type	Required	Description
value	text, numeric, yes/no, list	☑️	values of these types can be used.