AnsweredAssumed Answered

I need help with small script

Question asked by rbjork on Jun 12, 2018
Latest reply on Jun 12, 2018 by rbjork

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?