I'm trying to load the content of a csv file into filemaker using a script which used a REST call to return the path to the file. The script is the following:
Go to Layout ["TnT" (Copy of Dennis): Animation:None]
Show All Records
Insert from URL [Select; With dialog: On; $$json; "http://localhost:5110/getlastmetafile"]
Set Variable [$filepath; Value: JSONGetElement ($$json: "filename")]
Import Records [With dialog: On; "$filepath"]
The server response to "Insert from URL" is the following:
Filemaker responds with popup stating the following:
"The file "C:\BATCH\metadatareport\postbach_metadata1528411858.csv" could not be found and is required to complete this operation."
But this file does exist at that location. What am I doing wrong?