JSON

JSON query

Extracts a JSON value and converts it to a SQL JSON-formatted STRING. –> learn more

JSON_QUERY(@expression, @expression_2)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@expression_2	literal	any string	true	-

JSON value

Extracts a JSON scalar value and converts it to a SQL JSON-formatted STRING, removing outermost quotes and un-escaping return values –> learn more

JSON_VALUE(@expression, @expression_2)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any string	true	-
@expression_2	literal	any string	false	($)