Extracting data out of XML in Deluge
Hi, I'm getting a data through API from GET function such as
get_data = getUrl(" ");
info get_data;
This responds with:
<DTDCREPLY xmlns="http://dtdc.com">
<CONSIGNMENT xmlns="">
<CNHEADER>
<CNTRACK>true</CNTRACK>
<FIELD name="strShipmentNo" value="T04525306"/>
<FIELD name="strRefNo" value="122396659911"/>
<FIELD name="strCNType" value="CP"/>
<FIELD name="strCNTypeCode" value="JF1330"/>
<FIELD name="strCNTypeName" value="SUFFIA CHOWK"/>
<FIELD name="strCNProduct" value="STANDARD"/>
<FIELD name="strCNProdCODFOD" value=""/>
<FIELD name="strOrigin" value="LUDHIANA"/>
<FIELD name="strOriginRemarks" value="Booked By"/>
<FIELD name="strBookedDate" value="24072021"/>
<FIELD name="strBookedTime" value="00:03:26"/>
<FIELD name="strPieces" value="1"/>
<FIELD name="strDestination" value="JALANDHAR"/>
<FIELD name="strStatus" value="Delivered"/>
<FIELD name="strStatusTransOn" value="24072021"/>
<FIELD name="strStatusTransTime" value="1924"/>
<FIELD name="strStatusRelCode" value="SEL"/>
<FIELD name="strStatusRelName" value=""/>
<FIELD name="strRemarks" value="NULL"/>
<FIELD name="strNoOfAttempts" value="1"/>
<FIELD name="strRtoNumber" value=""/>
<FIELD name="strComplaintNo" value=""/>
<FIELD name="strExpectedDeliveryDate" value="26072021"/>
</CNHEADER>
<CNBODY>
<CNACTIONTRACK>true</CNACTIONTRACK>
<CNACTION>
<FIELD name="strCode" value="BKD"/>
This is basically courier tracking details.
Now I need to extract the value of the FIELD with name "strstatus", and "strExpectedDeliveryDate". How do I do that? My end result needs to be
status = Delivered; (Type String)
Expec_date_delivery = 26/07/2021; (Type Date)