How to Fill listbox records with data from XML soap response (1 Viewer)

[arkadis]

I have the following SOAP-XML response and i wand to load this currecnt xml each time the form witch holds the listbox loads.
Any idea?

I have a function called WBs_conn witch gives me the response text.
Some fields in XML response might be missing from time to time
The XML response.

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body><get_waybillsResponse xmlns="http://tempuri.org/">
<get_waybillsResult>
<WAYBILL_LIST xmlns="">
<WAYBILL>
<ID>4119</ID>
<TYPE>2</TYPE>
<CREATE_DATE>2012-02-14T17:29:11</CREATE_DATE>
<BUYER_TIN>12345678910</BUYER_TIN>
<BUYER_NAME>??????? ???????</BUYER_NAME>
<START_ADDRESS>?????????? ???????? 44</START_ADDRESS>
<END_ADDRESS>???????????</END_ADDRESS>
<DRIVER_TIN>01001063711</DRIVER_TIN>
<DRIVER_NAME>?????? ???????????</DRIVER_NAME>
<TRANSPORT_COAST>0</TRANSPORT_COAST>
<STATUS>-2</STATUS>
<ACTIVATE_DATE>2012-02-14T17:29:11</ACTIVATE_DATE>
<FULL_AMOUNT>6</FULL_AMOUNT>
<CAR_NUMBER>TZT740</CAR_NUMBER>
<WAYBILL_NUMBER>0000001584</WAYBILL_NUMBER>
<CLOSE_DATE>2012-04-06T12:48:35</CLOSE_DATE>
<S_USER_ID>19954</S_USER_ID>
<IS_CONFIRMED>0</IS_CONFIRMED>
<IS_CORRECTED>0</IS_CORRECTED>
<BUYER_ST>0</BUYER_ST>
</WAYBILL>
<WAYBILL>
<ID>120073959</ID>
<TYPE>2</TYPE>
<CREATE_DATE>2014-06-01T19:32:38</CREATE_DATE>
<BUYER_TIN>12345678910</BUYER_TIN>
<BUYER_NAME>??????? ???????</BUYER_NAME>
<START_ADDRESS>??????? ?????????</START_ADDRESS>
<END_ADDRESS>??</END_ADDRESS>
<TRANSPORT_COAST>0</TRANSPORT_COAST>
<STATUS>8</STATUS>
<ACTIVATE_DATE>2014-06-01T19:32:38</ACTIVATE_DATE>
<FULL_AMOUNT>.1</FULL_AMOUNT>
<S_USER_ID>0</S_USER_ID>
<IS_CONFIRMED>0</IS_CONFIRMED>
<IS_CORRECTED>0</IS_CORRECTED>
<BUYER_ST>0</BUYER_ST>
</WAYBILL>
<WAYBILL>
</WAYBILL_LIST>
</get_waybillsResult>
</get_waybillsResponse>
</soap:Body>
</soap:Envelope>

 

[Rx_]

It is the day before Christmas Eve, so I won't have much time.
http://www.access-programmers.co.uk/forums/showthread.php?t=242332
This is a post of mine that might help get you started.
http://www.access-programmers.co.uk/forums/showthread.php?t=269507
http://www.access-programmers.co.uk/forums/showthread.php?t=248439
http://www.access-programmers.co.uk/forums/showthread.php?t=243732
http://www.access-programmers.co.uk/forums/showthread.php?t=233388
Example: take XML - create a new table - the table could be used to create a listbox
http://www.access-programmers.co.uk/forums/showthread.php?t=242332

The term XML doesn't search well from within this site. Use Google to search access-programmers XML to find a few more.

Please post any code that you create as it might be useful to others to build upon.