How to get single value from .xml

Question

I have some xml or excel I want to loop through this document in InDesign script and insert values on defined places this is excel or xml

this I want to get

I don't have so much scripting experiences so I can only this piece of code

var doc = app.activeDocument;
var myFile = File("~/Desktop/test.xml");
var textExcel = doc.textFrames.add();
textExcel.geometricBounds = [50, 80, 10, 150];
textExcel.place(myFile);

but now how I can get a single value? for example in indesign template first paragraph should look like table --> lorem--> 150

Answer 1

You can probably do this with xpath and Document. https://developer.mozilla.org/en-US/docs/Web/API/Document/evaluate

You create a new Document with the xml and you evaluate a xPath.