Hello everyone, I am trying to help with an old system that returns thousands of lines similar to the text below.
The only thing I need to do is convert it to a datagrid.I can prebuild the datagrid with the correct cloumns but what is the best way in extracting the data out of the xml format? I was pretty certain a couple of years ago you could take xml data directly into a datagrid if the datagrid was already built with the correct column headers matching the nodes ; in a single command? I could do repeat loops similar to * put* field "xmlResponse" into tResponse *put* revCreateXMLTree(tResponse, false, true, false) into tDocID *put* revXMLNodeContents(tDocID, "/Envelope/Body/GetCPEBySerialSearchResponse/CPEList/CPE/id") --changing the "id" to serial and then username ..etc Any suggestions on the best method is appreciated. regards, ============================================================ Sample of xml response is below ============================================================ <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd=" http://www.w3.org/2001/XMLSchema" xmlns:gbadmin="urn:gbadmin-api-3-1-0"> <SOAP-ENV:Body SOAP-ENV:encodingStyle=" http://schemas.xmlsoap.org/soap/encoding/"> <gbadmin:GetCPEBySerialSearchResponse> <CPEList xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="gbadmin:CPEStruct[2]"> <CPE> <id> 2</id> <serial> CP1238RA52F</serial> <username> </username> <password> </password> <ipaddr> 192.168.1.254</ipaddr> <mfr-id> 3</mfr-id> <dm-id> 4</dm-id> <last-comm-tm> 2014-09-10T04:28:59Z</last-comm-tm> <updated-tm> 2014-09-10T04:28:59Z</updated-tm> <created-tm> 2014-09-10T01:55:45Z</created-tm> </CPE> <CPE> <id> 3</id> <serial> CP1238RA52G</serial> <username> </username> <password> </password> <ipaddr> </ipaddr> <mfr-id> 3</mfr-id> <dm-id> 4</dm-id> <last-comm-tm> 2014-09-20T11:33:29Z</last-comm-tm> <updated-tm> 2014-09-20T11:33:29Z</updated-tm> <created-tm> 2014-09-20T11:33:29Z</created-tm> </CPE> </CPEList> </gbadmin:GetCPEBySerialSearchResponse> </SOAP-ENV:Body> </SOAP-ENV:Envelope> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode