The only way to handle missing files I found so far is the URL to file path node. Unfortunately it stops upon error.
I would like to loop on a list of files with file reader, and if a file is missing, have an empty row or an error message added.
I'd appreciate any help, thanks.
Hey Docminus,
The attached workflow appends to your list of files a column that states whether or not the file is missing. You can then filter by this column and get a list of not missing files.
It uses the URL to file path node, and the fact that it fails when it does not find the file.
Of course you can do something similar with the File Reader, but you need to convert the path to a variable and configure the File Reader to read from this location.
Best,
Ferry
Thank you, much appreciated!