I've got the Salesforce API returning data, but it's returning that data as an XML Object.
The XML Looks like so:
Code:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sf="urn:sobject.partner.soap.sforce.com">
<soapenv:Header>
<LimitInfoHeader>
<limitInfo>
<current>2</current>
<limit>15000</limit>
<type>API REQUESTS</type>
</limitInfo>
</LimitInfoHeader>
</soapenv:Header>
<soapenv:Body>
<queryResponse>
<result xsi:type="QueryResult">
<done>true</done>
<queryLocator xsi:nil="true"/>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CC978213</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD355119-A</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD355120-B</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD451796</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD656092</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CC213425</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CC634267</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD439877</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CC947211</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD736025</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber>CD355118</sf:AccountNumber>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber xsi:nil="true"/>
</records>
<records xsi:type="sf:sObject">
<sf:type>Account</sf:type>
<sf:Id xsi:nil="true"/>
<sf:AccountNumber xsi:nil="true"/>
</records>
<size>13</size>
</result>
</queryResponse>
</soapenv:Body>
</soapenv:Envelope>
Try as I can, I can't get the list of Account numbers out of this XML.
Code:
Move (wsquery(oSForce,"select AccountNumber from Account")) to hObj
Get FindNodeList of hObj "results" to hRecords
Get FirstChild of hRecords to hoNode // get the first node
While (hoNode<>0)
Get ChildNodeValue of hoNode "AccountNumber" to sAccount
Showln sAccount
Get NextNode of hoNode to hoNode // now get next sibling node, destroy current node
Loop
What extra / different steps do I need here.