Type functions

Json

View as Markdown

The Json function converts a value to JSON (or GeoJSON when converting geography data).

This function isn’t compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

Syntax

Json(input)

Function arguments:

input
(required) The data to convert to JSON

Notes

  • On connections that support geography, the Json function can be used to convert valid geography data to GeoJSON. For more information, see the second example in examples.
  • In GeoJSON and the Geography data type, coordinate order is always longitude, latitude.

Examples

Json([Cust JSON as Text])

Returns Json values for the variant data in the Cust JSON as Text column.

Json(MakePoint(179, 90))

Converts the geography point (179, 90) to GeoJSON, and returns {"coordinates":[179,90],"type":"Point"} as variant data.