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:

"file:C:\\BATCH\\metadatareport\\postbatch_metadata1528411858.csv"

 

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?

Outcomes