Outputting Data from XML

[Masond3]

HI All, 

I think i am having a Alteryx nightmare this week, and need some assistance.

I have downloaded "Level 1 Data" zip  from the following website.  https://www.gleif.org/en/lei-data/gleif-concatenated-file/download-the-concatenated-file#  (This file comes in XML format)

Reading the following https://www.gleif.org/en/about-lei/common-data-file-format/lei-cdf-format  all the information i require is there.  

From this XML file i am only interested in the following attributes ; 

• LEI
• Legal Name
• Legal Address
• Headquarters Address

I have gone back to basics and read the following article  https://help.alteryx.com/current/designer/reading-xml but i am really confused.

This is my input set up (I can return some attributes but not what i am after. )

The example i am working with is :

Legal Name : Seeliger & Co GmbH
Lei 9845006AYEACK8601C88

Looking forward to your assistance 

[SubratDas5]

Hi @Masond3 , 

I had a quick look at your post and i think you can try to connect directly to the API that they have using the Download Tool and then parse the output and capture the relevant columns that you are interested in. 

The API details are here - https://www.gleif.org/en/lei-data/gleif-lei-look-up-api/access-the-api

[Masond3]

HI, 

Thats correct, but encountered issues with Corp Proxy. This is a one off exercise so Using XML is sufficient in this use case 

[Masond3 · Accepted solution]

Just an update, 

I was finally able to do this (needed to step away from the computer and have a break)

Please see attached workflow. 

Regards
Masond3