The issue is that when using a sharepoint Input node, and pointing it to a CSV file, the node is failing to read in the data from the CSV and is returning no data.
If I use an .xlxs file and import the same data, the flow runs just fine both locally and when using sharepoint nodes to connect to the data.
The flow basically needs to pen up a CSV file and join it with some new data each day, then overwrite the same CSV file with the new data appended to it. this will then run on the server on a daily basis.
So far, in testing, it has all worked fine with Excel Workbooks .xlxs files but when we move it to a CSV input and output, it fails on the CSV input right at the beginning.
For reference, the CSV file was created by Alteryx after we tried it with .xlxs as the input and .csv as the output. So Alteryx should have no trouble reading the CSV as it created it.
