Help decoding this XML

[craigja]

https://data.europa.eu/euodp/en/data/dataset/MiFID_SI

I want to download the lit of Systematic Internalisers from the above website but I cannot figure out how to decode the XML with the XML Parse tool.  After playing about with it, its now been running for over half an hour and seems to be bringing back TB of data but the original XML is under 1Mb!

[andyuttley · Accepted solution]

Hi @craigja 

There may be a better way than below, but posting as you've not had a reply yet....

You can parse from either of the XML or JSON downloads on the URL you've sent. Both options below and attached

Not sure if that gives you what you were after; like I say there may be a different or better way (I'm sure the XML parse tool can be used, for example...) 

Andy 

[craigja]

Can you just confirm Im understanding this correctly, the child is first in the list then the parent?  So in the XML import, lines 1-6 are the child records of 7

Thanks for your help with this though, much appreciated!

[andyuttley]

No problem, hopefully is of some help (I'm new to the XML parsing tool specifically though!) 

Yes, what you've said is correct: lines 1-6 are the child records of 7.

It looks like the [_root_] field is the identifier across the rows, with [type_s] defining which is parent and which are child. 

Hope that's of some help, though I'm still trying to get my head around it myself!

Andy 

[craigja]

Got it all sorted now - added a couple of extra tools and I now have a list of data exactly as I want it.