Unanswered

Convert JSON object with dynamic keys to array of keys

(0) Share

Report

Posted on by SH-05111713-0

Hi all,

I'm stuck with this "little" problem for hours now - and I'm getting desperate...

I followed this suggested similar topic: https://community.powerplatform.com/forums/thread/details/?threadid=69bda654-a4b0-46e8-9f55-75d2d08fcab9 without a solution for me (although I have the exact same problem!).

For my `Compose` action (following a `Parse JSON` action) with

replace(string(outputs('JSON_analysieren')), 'body', 'root')

to wrap a `root` around the JSON (instead of `body`), I get this output:

{"root":{"Spalte1":"abc","Spalte2":"bcd","Spalte3":"cde"}}

which seems fine to me.

Next I try

xpath(xml(outputs('Verfassen_2')), '/root/*')

but already the `xml()` part throws the following error:

Unable to process template language expressions in action 'Verfassen_4' inputs at line '0' and column '0': 'The template language function 'xml' parameter is not valid. The provided value cannot be converted to XML: 'Data at the root level is invalid. Line 1, position 1.'. Please see https://aka.ms/logicexpressions#xml for usage details.'.

I just want an array with all the keys (Spalte1, Spalte2, Spalte3) without hard coding them.

Could someone please help me and tell me, what I'm doing wrong?

Thanks and best regards

Stefan

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

Could you explain what you need instead of referring to another post that doesn't seem related to the need? I don't really understand your end goal. Do you want to generate the following JSON array data:

[
{"key": "Spalte1"},
{"key": "Spalte2"},
{"key": "Spalte3"}
]

If so, now I now know your objective. Now show how you are getting the data that you need to transform to the above. If this isn't your end objective, please clarify as to what it is. I don't see how using the xpath for XML data is related to getting something into a JSON array which may be why you are struggling.

Was this reply helpful? Yes No
SH-05111713-0 on at

Like (0)

Report
@David MA

my goal is getting an array with the key / property names.

Either

[ {"key": "Spalte1"}, {"key": "Spalte2"}, {"key": "Spalte3"} ]

or

[ "Spalte1", "Spalte2", "Spalte3" ]

to be able to iterate through an array of not hard coded column names.

Now I'm using `Compose` with

first(outputs('In_Tabelle_vorhandene_Zeilen_auflisten')?['body/value'])

and get the first row of a table from within Excel (from `List rows in a table`):

{ "@odata.etag": "", "ItemInternalId": "xxxxxxx", "Spalte1": "abc", "Spalte2": "bcd", "Spalte3": "cde" }

By using

removeProperty( removeProperty( json( replace( string(outputs('Verfassen')),'@odata.','odata')), 'odataetag'), 'ItemInternalId')

I remove the unrelevant properties and get

{ "Spalte1": "abc", "Spalte2": "bcd", "Spalte3": "cde", }

Then I use `Parse JSON` with the schema

{ "type": "object", "properties": { "Spalte1": { "type": "string" }, "Mitarbeiterkreis": { "type": "string" }, "Spalte2": { "type": "string" }, "Spalte3": { "type": "string" } } }

to get

{ "body": { "Spalte1": "abc", "Spalte2": "bcd", "Spalte3": "cde" } }

Afterwards I use

replace(string(outputs('JSON_analysieren')), 'body', 'root')

and

xpath(xml(outputs('Verfassen_2')), '/root/*')

to end with the mentioned error.

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (1)

Report

Your data and expressions work fine here:

Was this reply helpful? Yes No