The String - JSON Decode Task allows you to decode a JSON string from a file or value/Variable into formatted output.
JSON Decode tab
Map columns to properties
Optionally, you can configure mapping between object properties (including nested ones) and column names in the output.
Output settings / Include field names
Write the column names in the first line of output.
Example input
[
{
"Property1": "Value1",
"Property2": "Value2",
"InnerArray": [{ "Value": "item1" }, { "Value": "item2" }]
},
{
"Property1": "Value3",
"Property2": "Value4",
"InnerArray": [{ "Value": "item3" }, { "Value": "item4" }]
}
]
Example output
Column1 Column2 ArrayColumn
Value1 Value2 item1
Value3 Value4 item3