Hi All, as part of a work flow i have to parse some XML that im reading via an API
I pass a job ID to the api and get this response back:
<Response api-method="Job/CustomField">
<Status>OK</Status>
<CustomFields>
<CustomField>
<ID>225109</ID>
<Name>Probability of win (%)</Name>
<Number>20</Number>
</CustomField>
<CustomField>
<ID>221125</ID>
<Name># Street Suburb City PO Box</Name>
<Text>71 Sunrise Ave Murrays Bay 900</Text>
</CustomField>
<CustomField>
<ID>219331</ID>
<Name>NZTM 2000 Easting</Name>
<Number>1755638</Number>
</CustomField>
<CustomField>
<ID>219352</ID>
<Name>NZTM 2000 Northing</Name>
<Number>5933369</Number>
</CustomField>
</CustomFields>
</Response>
I need to extract the "Number" value below the NZTM 2000 Easting and the "Number" Value below the NZTM 2000 Northin so i can create a vertex I have used the xml fragmenter and flattener to get close but not quite right... errors occur if the first "number" in the xml is empty (ie the probability of win %) and also the output is on 3 rows instead of one row with 3 columns :
i get this:
2017556385933369i want this
2017556385933369Any help or suggestions much appreciated.. I have read the xml tutorials which were very helpful but im still running my "L" plates on xml parsing.....
Thanks Steve
Best answer by nielsgerrits
View original