Parsing this complicate JSON

[gonhaddock]

Hi @simonmng
You can use the workflow from the previous topic:

Extract number sequence

Hello @simonmng It seems to me that the structure of a JSON file is not standard, the square brackets correlation is missed; besides that, there’s a comma missed in the group separation… the structure should be like this (being aware of quotation type): [{"rel": "self", "href": "https://.net/api/report/eExecution/12345678"}, { "rel": "self", "href": "https://oup.net/api/ret/cution/12345677"}] Take a look in this post: Then a standard JSON extract workflow can be applied. You should check y…

You would have just to call single queries for the desired fields, in the ‘JSON Path’ node.

BR