(InputData) =>
let
JsonOutput = Json.FromValue(InputData),
OutputText = Text.FromBinary(JsonOutput)
in
OutputText
let
Source = Excel.CurrentWorkbook(){[Name="Sales"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(
Source,
{{"Month", type text}, {"Sales", Int64.Type}}),
Output = GetJson(#"Changed Type")
in
Output
[
{"Month":"January","Sales":1},
{"Month":"February","Sales":2},
{"Month":"March","Sales":3}
]
GetJson({"Apples", "Oranges", "Pears"})
["Apples","Oranges","Pears"]
GetJson({{1,"Apples"}, {2,"Oranges"}, {3,"Pears"}})
[[1,"Apples"],[2,"Oranges"],[3,"Pears"]]
GetJson([month="January", product="Apples", sales=1])
{"month":"January","product":"Apples","sales":1}
GetJson(
[
product="Apples",
colours={"Red","Green"},
sales=
#table({"Month", "Sales"},
{
{"January", 1},
{"February", 2}
}
)
]
)
{
"product":"Apples",
"colours":[
"Red",
"Green"
],
"sales":[
{
"Month":"January",
"Sales":1
},
{
"Month":"February",
"Sales":2
}
]
}