Extract data from parsed JSON

[simonmng]

I have parsed JSON’s where the rows in the column now looks as a string like this:

{teststeps=[{“name”:“KollisionJock”,“description”:null,“verdict”:“NONE”,“expectedResult”:“”,“oType”:“TestStep”}

or

{teststeps=[{“name”:“Status:Holdtherecord LiveJob”,“description”:fill,“verdict”:“PASSED”,“expectedResult”:“Flowblow7 255 ‘OKAY’”,“dType”:“TestStep”},{“name”:“Status: reedKoll LiveFoll”,“description”:null,“verdict”:“PASSED”,“expectedResult”:“Loloky 123456 255 ‘OKAY’”,“pType”:“TestStep”},{“name”:“Status: TesttheReplay”,“description”:null,“verdict”:“PASSED”,“expectedResult”:“POL 123407 ‘True’”,“dType”:“TestStep”},{“name”:“savethePlanet”,“description”:null,“verdict”:“NONE”,“expectedesult”:“”,“eType”:“TestStep”}], name=Action, description=null, verdict=PASSED, expectedResult=, pType=LiveFolder}

I always need only the name and the verdict like name-verdict, name-verdict, name-verdict… so at the example from the first one there should only be: KollisionJock-NONE

Do i need to parse the JSON different or can this be realised like this?

how can this be realised?

[JPollet]

Hi,
How did you parse the JSON ? The stings mentionned are no more JSON so you can’t use JSON Path node. Yet you can extract information with JSONPath like (nodes above and) [?(@.name)]
Best,

[simonmng]

i parsed it like this so it is in one line as a string, so ithought i could just do an string manipulation. But maybe thats the wrong way

[JPollet]

You can do some thing like that to extract the values of the node name. You have to take care of the structure of the JSON (collection or not). I try to mimic your initial file.

[simonmng]

Thank you for your help!
Best regards