Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Parse multi-level nested XML from API

5 - Atom

Hi

 

I am having a hard time getting the XML parse tool to work as I want. 

 

From the API I get an XML output per geographic site (site id field). The XML contain waste transactions per waste type. I am able to parse the tags that I need (marked with red in the attached picture), but when I make the second parse, then each waste type get joined with the transactions for all waste types. The wanted action is that the parse result in the transactions associated to each waste type.

 

I have attached sample output from the API and workflow (included comments) with the parse tool that I have tried.

Please notice that I am not receiving a XML file, but uses the download tool (see screen dump of workflow below). 

 

Any help in this is highly appreciated - thanks!

 

Let me know if you need any more details. 

 

2020-03-24_14-42-32.png

 

sjhj_0-1585060607984.png

 

 

Highlighted
14 - Magnetar

Shouldn't you return the Outer XML of quantitativeQuestion in your 1st XML parse and use that as the source field in your 2nd XML Parse tool? The result of the 2nd XML parse then looks like this

DavidP_0-1585235797229.png

 

and the output of the 3rd XML Parse looks like this:

 

DavidP_1-1585235994758.png

 

 

Highlighted
5 - Atom

Hi David

 

Great - thanks. It seems to parse as expected. Simple and straight forward

 

Best regards

Simon

Labels