read the xml file in javascript
function readXmlOffice(xmlFile, state, interest) {
var xmlDoc;
var xmlOfficeID;
if (typeof window.DOMParser != "undefined") {
xmlhttp = new XMLHttpRequest();
xmlhttp.open("GET", xmlFile, false);
if (xmlhttp.overrideMimeType) {
xmlhttp.overrideMimeType('text/xml');
}
xmlhttp.send();
xmlDoc = xmlhttp.responseXML;
}
else {
xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async = "false";
xmlDoc.load(xmlFile);
}
var tagObj = xmlDoc.getElementsByTagName("Table");
for (var i = 0; i < tagObj.length; i++) {
if (tagObj[i].getElementsByTagName("state")[0].childNodes[0].nodeValue == state && tagObj[i].getElementsByTagName("interest")[0].childNodes[0].nodeValue == interest) {
xmlOfficeID = tagObj[i].getElementsByTagName("DefaultOffice")[0].childNodes[0].nodeValue;
}
}
return xmlOfficeID;
}
and xml:
-<Table>
<ItemID>1</ItemID>
<ItemCreatedBy>53</ItemCreatedBy>
<ItemCreatedWhen>2017-01-27T09:53:33+11:00</ItemCreatedWhen>
<ItemModifiedBy>53</ItemModifiedBy>
<ItemModifiedWhen>2017-02-02T21:42:21+11:00</ItemModifiedWhen>
<ItemOrder>4</ItemOrder>
<ItemGUID>ad296c0c-98eb-4404-b8e1-800b3061fa73</ItemGUID>
<State>New South Wales</State>
<Interest>Nursing positions</Interest>
<Email>sam.kelly@nswbc.com.au</Email>
<DefaultOffice>1</DefaultOffice>
</Table>