Context: Using Powerquery in Excel 2016 (Get & Transform) to receive data from a REST API which only accepts content-type: application/json. The content for HTTP POST request is stored in an excel table, which is to be converted to JSON for POST content.
If I use the following example from: https://msdn.microsoft.com/en-us/library/mt637075.aspx:
Request = Text.FromBinary(Json.FromValue([A={1, true, "3"}, B=#date(2012, 3, 25)]))
It returns the error:
Expression error: The name 'Json.FromValue' wasn't recognized. Make sure it's spelled correctly.
Is it possible that the version of Powerquery in-built in Excel 2016 is missing this function? If so, is there another way of transforming the data to JSON in Powerquery?
