Sorry for the late reply. It took a while and help from some friends who have more knowledge also about this subject. He told me the same thing and gave me a short example of what is possible. With that example i was able to product the line below:

Code:

xmlstarlet sel -T -t -m "/searchresults/data/products" -v ../idpurchaseorder -o ";" -v ../idsupplier -o ";" -v ../purchaseorderid -o ";" -v ../purchased_at -o ";" -v idproduct -o ";" -v productcode -o ";" -v price -o ";" -v amount -o ";" -v amountreceived -n purchaseorders.xml > purchaseorders.csv

I was not aware that you could "backtrack" the tree and get the main info added to the product info. It most likely isn't the cleanest solution but at least it works great.





Thank you for this. I always try my best to get as much as possible done myself. Only if i am really stuck i will post the question and even that is most likely days after i got stuck. I find it important to try and test myself although sometimes that is not possible. For each problem it is of course searching for the best solution and even though i dont fully understand xmlstarlet it gave me the best results for all the scripts i have used it on. I seen several attempts with sed etc but they where so confusing or gave me weird outputs (Its like opening a door with a hammer instead of the key ) that i wanted to use a program that is specifically designed for this and that was/is xmlstarlet.


I do have to add though that i cheated a bit as i got json data before the xml and i transformed it to the xml to actually get the proper data for it. Since i do lack the knowledge to get all json data (although i did try it with jq first), i decided to look for the transformation (Decoding JSON to a PHP Array and then converting it to XML. . GitHub) and then get all data with xmlstarlet. This last part was almost correct then except for the backtracking that i did not know.