Hello @bgmoreira
You can’t read a file directly from the MID Server folder with just a script in ServiceNow, because the instance has no direct access to the MID Server operating system.
The supported pattern is:
The external system drops the CSV into a known folder on the MID.
From ServiceNow, you trigger a probe or script through the ECC Queue to ask the MID to read the file.
The MID reads the file and sends the content back to the instance via ECC Queue.
Once you have the file content in the instance, you parse it with the sn_impex.CSVParser API.
Example of parsing once you already have the CSV content in a string:
var csv = "name,age,city\nJohn,30,NY\nJane,25,LA"; // file content received
var parser = new sn_impex.CSVParser();
var data = parser.parse(csv);
for (var i = 0; i < data.size(); i++) {
var row = data.get(i);
gs.info("Name: " + row.get("name") + " | Age: " + row.get("age") + " | City: " + row.get("city"));
}
To automate daily, you would:
Create a Scheduled Job to trigger the probe.
The probe reads the file on the MID.
The content comes back via ECC Queue.
Your script parses and loads the data into the target table.
This is the recommended flow: Instance ? MID Probe ? ECC Queue ? Parse in ServiceNow.
