SOAP XML Parsing

Hi,

     Can you show me the service that you've made in order to obtain the values from the SOAP?

     Basically you'll need to create a service in which you will set the BaseType in the Inputs/Outputs tab to be InfoTable(you may need to set a DataShape for your parameters) and the infotable Type should be Just Infotable, but first I would like to see the service that you have created for this.

Thank you,

Adrian

Hi Rajesh,

did you see this posting: Regarding SOAP based Webservice Call​ and specifically the answer from Pai Chung. It points out how the XML that is returned by a SOAP call can be easily parsed with E4X. You can also use for loops with it, e.g. (based on Pai's example):

// this is what Pai referred to: // var itemKey = xmlDoc.::Body.::GetTopTenPartsResponse.::GetTopTenPartsResult.::JsonRecord.::item.::key.*::string; // let's assume GetTopTenPartsResult has multiple JsonRecord sub-elements then your code could look like the following: //initialize your infotable var myInfoTable = ...; for each (var entry in xmlDoc.::Body.::GetTopTenPartsResponse.::GetTopTenPartsResult){      var itemKey = entry.::JsonRecord.::item.::key.*::string;      // now use this value with an object for an InfoTable row:      var newRow = new Object();      newRow.key=itemKey;      // ... assign other values from XML to object properties     myInfoTable.addRow(newRow); } var result = myInfoTable;