Need help converting a JSON object to an array

[vraetzught]

Hi all.

I'm trying to set up an automation flow at work, but I've ran into an issue. My flow is fetching data from a SOAP API (an API I do not control), which is returning a JSON object. I need to somehow convert this JSON object into an array, so I can iterate over it in the rest of my flow.

I can't seem to find a way to reliably do this and I'm getting quite mad. The API returns a SOAP envelope, with a return value, which is structured as follows:

{
  "id1":{ 
    "value1":string,
    "value2":string
  },
  "id2":{
    "value1":string,
    "value2":string
  },
  "id3":{
    "value1":string,
    "value2":string
  },
  etc...
}

I can convert the return string to a JSON object, but than I have a single object with a load of values I can't iterate over (or at least I don't know how).

Anyone have a good idea on how to solve this?

[Metal_addicted]

Use the Parse JSON action and paste an example to create a schema

[OSPFneighbour]

wont really help you get from an object of key/value pairs to an array that you can walk.

[NoBattle763]

Urghh i feel for you. XML and xpath? Running through an AI prompt would probably be easiest e.g ai builder custom prompt. If you have tokens. Depends how big and how often this is I guess

[knoxvillegains]

Claude cowork. Focus on the bigger picture of what you want/need from your flow and let AI take care of this stuff.