Convert text to record

[smpa01]

@ImkeF @AlexisOlson 

I am making an API call that returns a json as text like this

let
    Source = "{
	""header"": [""[Value]""],
	""rowCount"": 1,
	""data"": [
		[2.0]
	]
}",
    #"Converted to Table" = #table(1, {{Source}})
in
    #"Converted to Table"

 I want to retrieve the value of "data" and what is an efficient way of doing it. Is it possible to convert this into a PQ Record with any built-in API so that I can progrmatically access them. It already contains the key value pairs.

Thank you in advance.

[AlexisOlson · Accepted solution]

Power Query has built-in JSON parsing.

let
    Source = "{
	""header"": [""[Value]""],
	""rowCount"": 1,
	""data"": [
		[2.0]
	]
}",
    #"Parsed JSON" = Json.Document(Source)
in
    #"Parsed JSON"

To grab just 2.0,

Json.Document(Source)[data]{0}{0}

[smpa01]

@AlexisOlson  Smashing !!!