Extract JSON Object Properties
Description
The action analyzes the structure of the JSON and extracts metadata about the keys (properties) present in the objects.
Input Arguments
| Input Argument | Type | Description | Required? | Advanced Option? | Default |
|---|---|---|---|---|---|
JSON | String in JSON format | The JSON string to be analyzed. Must be a valid JSON object or array. | ✔️ | ❌ | - |
Extract nested properties | Boolean | Whether to recursively extract properties from nested objects within the JSON . | ❌ | ❌ | Yes |
Output
| Response | Type | Description |
|---|---|---|
Property names as list | Array of Strings | List of all property names extracted from the JSON . |
Properties as list | Array of Objects | List of property details including name, type, and path. |
Power Automate Examples
Extract JSON Object Properties
We use a simple JSON with four pets
Simple JSON with four pets
[
{
"Pet": "Dog",
"Age": 5,
"Color": "Golden",
"Owner": "John"
},
{
"Pet": "Cat",
"Age": 3,
"Color": "Tabby",
"Owner": "Emily"
},
{
"Pet": "Cat",
"Age": 2,
"Color": "Black",
"Owner": "Michael"
},
{
"Pet": "Duck",
"Age": 1,
"Color": "White",
"Owner": "Sarah"
}
]
💡
Looking for the response to this example? Scroll up to see the Output tab.
Known Limitations
⚠️
If you experienced other limitations please get in touch with us!