I have a workflow that generates a CSV files that needs to be uploaded into an FTP. I’m having issues to name the csv file.
The csv file name should come from a previous node but something is not working. I’ve created a simple workflow to reproduce the error (the actual workflow has other inputs and nodes).
Here you can see the error message:
ERROR: Can’t get data for expression under ‘Path’ field
To fetch the data from other nodes that this expression needs, more information is needed from the node ‘SFTP‘
You got me there, I can’t work out what it is after but I did find that using {{ $('File Name').first().json.filename }} will work so assuming the previous node you want the data from has the same name all will be good.
You also don’t need the Spreadsheet node there you can just use the path and the new name in the upload and will rename it on the way up.
I will do some more digging into the node to see if I can work out what is going on.