Re: Get JSON Properties List
I've based the JSON data on the following. Note that this has a "name" field within "labels" as well as "A", "B" and "C".
{
"Status Code": 200,
"headers": {},
"body": {
"data context": "xyz",
"response": {
"data type": "xyz",
"output": {
"Count": 1,
"Layout": "",
"tables": {
"type": ""
},
"labels": {
"name": "",
"A": {},
"B": {},
"C": {}
}
}
}
}
}
Below is the full flow. I'll go into each of the actions.
JSON is a Compose that contains the JSON data you provided (as shown above).
Select uses the following expressions to extract out the names. Note that this converts your JSON to XML then uses XPath to extract the data.
//From (Option 1)
//If you wanted to get all names from within "labels" including "name".
xpath(xml(json(concat('{"root": { value:', outputs('JSON'), '}}'))), '//response/output/labels/*')
//From (Option 2)
//If you wanted to get all names from within "labels" excluding "name".
xpath(xml(json(concat('{"root": { value:', outputs('JSON'), '}}'))), '//response/output/labels/*[name(.) != "name"]')
//Map
xpath(item(), 'name(/*)')
After running the flow (with the second From expression to exclude "name") we would get the following.
