Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Outputting Data from XML

Masond3
8 - Asteroid

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. )


Capture.PNG



The example i am working with is :

Legal Name : Seeliger & Co GmbH
Lei 9845006AYEACK8601C88

 

Looking forward to your assistance 

3 REPLIES 3
SubratDas5
10 - Fireball

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
8 - Asteroid

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
8 - Asteroid

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

Labels