Answered

Parse dynamic JSON

(0) Share

Report

Posted on by darylvogan

274

I need to extract the list of property names from a dynamic json string. The following is a simplified version. How can I get an array of ["xxxxxxx","zzzzzzzzzzzzz"]

{

"xxxxxxx": {

"property redacted": "removed"

"zzzzzzzzzzzzz": {

"content redacted": "removed"

}

All responses (6)

Answers (1)

darylvogan 274 on at

Like (0)

Report

Re: Parse dynamic JSON

this is BRILLIANT! Thank you
Verified answer

Chriddle 7,922 Super User 2025 Season 1 on at

Like (2)

Report
Re: Parse dynamic JSON

Don't do this with string operations 😣

Compose: Your flow's JSON

Select From:

xpath( xml(json(concat('{"root":', outputs('Compose'),'}}'))), '/root/*' )

Select Map:

xpath( item(), 'name(/*)' )

Only downside: You might have to handle XML encoding of characters that are not allowed as node names.

Output:
darylvogan 274 on at

Like (0)

Report

Re: Parse dynamic JSON

This is a good start. There was a lot more to the json that I redacted. That extra content makes the
take(split(string(variables('DynamicJSON')),'}'),sub(length(split(string(variables('DynamicJSON')),'}')),2))
result in a lot more elements, that are still hard to parse. Here is the complete string, but i altered the data.

I really appreciate the assistance!!!!!!!!

{
"Get_items": {
"runAfter": {},
"metadata": {
"operationMetadataId": ""
},
"type": "OpenApiConnection",
"inputs": {
"host": {
"connectionName": "",
"operationId": "",
"apiId": ""
},
"parameters": {
"dataset": "",
"table": ""
},
"authentication": ""
}
},
"Get_items_2": {
"runAfter": {
"Get_items": [
"Succeeded"
]
},
"metadata": {
"operationMetadataId": ""
},
"type": "",
"inputs": {
"host": {
"connectionName": "",
"operationId": "",
"apiId": ""
},
"parameters": {
"dataset": "",
"table": ""
},
"authentication": ""
}
}
}
darylvogan 274 on at

Like (0)

Report

Re: Parse dynamic JSON

agree, i tried that
v-bofeng-msft on at

Like (1)

Report

Re: Parse dynamic JSON

Hi @darylvogan ,

I've made a test for your reference:

1)

take(split(string(variables('DynamicJSON')),'}'),sub(length(split(string(variables('DynamicJSON')),'}')),2))

2)

split(split(item(),'"')[1],'"')[0]

Result

Best Regards,

Bof
lbendlin 8,041 Super User 2025 Season 1 on at

Like (0)

Report

Re: Parse dynamic JSON

replace the outer { and } with [ and ]

Edit: no, doesn't work.