XML Parse Attribute

Classic Servoy
1

Hey folks - I’m accessing a web service that returns “funky” XML as the response:

<result>
  <record>
    <field name="donor_id" id="donor_id" value="1"/>
    <field name="first_name" id="first_name" value="John D."/>
    <field name="last_name" id="last_name" value="McClurkin"/>
    <field name="middle_name" id="middle_name" value=""/>
  </record>
  <record>
    <field name="donor_id" id="donor_id" value="2"/>
    <field name="first_name" id="first_name" value="Bill"/>
    <field name="last_name" id="last_name" value="Jones"/>
    <field name="middle_name" id="middle_name" value=""/>
  </record>
</result>

That’s literally all it returns. There is no default namespace.

So, I thought it would be a piece of cake parsing it using this:

var str = plugins.http.getPageData("myLongURL")
  var myXML = new XML(str);
  var firstName = myXML.result.record.field.attribute("first_name").toString()

I know that I’m doing something stupid :D but everything I try just winds up with an empty string.

Then I tried:

var firstName = myXML.result.record[0].field.attribute("first_name").toString()

But that just got an error: ```
TypeError: Cannot read property "field" from undefined


I've already had a look at <a class="postlink-local" href="https://www.servoy.com/forum/viewtopic.php?f=22&t=15818&p=85410">viewtopic.php?f=22&t=15818&p=85410</a> and I guess I'm just missing it.

Any pointers would be greatly appreciated!
2

UPDATE - ANSWERED

OK, after a lot of time and effort - I finally found the right syntax:

myXML.record[0].field[1].attribute("value").toString()

I was trying to filter the FIELDS by the VALUE of the “name” property - rather than getting the ATTRIBUTE itself (e.g. “value” rather than “first_name”).

Also, by explicitly calling specific records and fields (with the array notation), then getting the ATTRIBUTE “value” - bingo.

3

XML to be well formed, need a root Node. That root node is implied when you do new XML(string): your object becomes the root. And since you have more than one record and field nodes, they are XMLList (equivalent to arrays).