Originally Posted by stomp

Hi SDohmen,

nice to hear that you worked your way through and thanks for giving feedback.

Some comments:



That's why I pointed out XPath for you twice and presented you links for a good and short tutorial. Read the great manuals out there! Read it and you will be lesser dependant on others.



I would suggest to avoid that. With this step, the complexity of the task had risen for no good reason. I understand why you did it(just to get the task done - did that myself in the past), but I recommend to better invest the time to get the data out of the original format. That's most likely possible with jq - even if it needs the work to get familiar with jq. Otherwise you carry the increased complexity, increased error possibility, increased resource footprint with that task from now on.

An alternative to jq may be a small php script, that generates the csv.

If you like, show the original json...

(and sometimes a quick and dirty hack is just fine too)

That's the thing with jq:

Code:

jq -r <data.json ' .searchresults.data[] |
 . as $parent |
 .products[]  |
 ( $parent.idpurchaseorder+";"+.idproduct)'

It's more like the approach that didn't work with xml. ;-)