Skip to main content

Json.FromValue

Produces a JSON representation of a given value.

Syntax​

Json.FromValue(
    value as any,
    optional encoding as TextEncoding.Type
) as binary

Remarks​

Produces a JSON representation of a given value value with a text encoding specified by encoding. If encoding is omitted, UTF8 is used. Values are represented as follows:

  • Null, text and logical values are represented as the corresponding JSON types
  • Numbers are represented as numbers in JSON, except that #infinity, -#infinity and #nan are converted to null
  • Lists are represented as JSON arrays
  • Records are represnted as JSON objects
  • Tables are represented as an array of objects
  • Dates, times, datetimes, datetimezones and durations are represented as ISO-8601 text
  • Binary values are represented as base-64 encoded text
  • Types and functions produce an error

Examples​

Example #1​

Convert a complex value to JSON.

Text.FromBinary(Json.FromValue([A = {1, true, "3"}, B = #date(2012, 3, 25)]))

Result:

"{""A"":[1,true,""3""],""B"":""2012-03-25""}"

Category​

Text.Conversions from and to text