Parse dynamic JSON

Like (0) Share

Report

Posted on 2 Nov 2023 20:28:54 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)

Verified answer

Chriddle 7,936 Super User 2025 Season 2 on 03 Nov 2023 at 17:10:38

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: