Hi Vendim,
I'm pasting here the last DM I shared in case it can be used by other members:
So the loadXmlFile function is deprecated. You can use instead the load (DOMDocument) function (which contains a basic example in the JSAPI documentation) and combine with other reading functions such as getElements and getValue.
For example, for an XML file containing products like this:
<product>
<name>abc</name>
<code>123</code>
</product>
You can start using something like this in a JS activity:
var doc = DOMDocument.load("data/test.xml");
var products = doc.root.getElements("product");
for (var i=0; i<product.length; i++) {
var product = products[i];
var name = product.getValue("name");
var code = product.getValue("code");
}
I don't have much JS knowledge but starting from this you should be able to apply the processing you want on the data, for example to transform the XML in a more readable format. After the JS activity you could use a data loading (file) activity and then update the database.
Florent