Power Query
published
Search
K
Comment on page

Json.FromValue

Json.FromValue

Produces a JSON representation of a given value.
function (optional value as nullable any, optional encoding as nullable any) as binary

Description

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:

Category

Text.Conversions from and to text

Examples

Convert a complex value to JSON.
Text.FromBinary(Json.FromValue([A={1, true, "3"}, B=#date(2012, 3, 25)]))
"{""A"":[1,true,""3""],""B"":""2012-03-25""}"