Excel node fails when trying to import data from a file in SharePoint.
Can't use the sharepoint path in the excel node directly so using the 'Download for sharepoint 2010' node first to access the folder and then using the excel node to import data into lavastorm but getting an error message 'ERROR: Parameter FilenameExpr references the file: E:\Shared Documents\Mojo Automation\M19 - Wholesale invoice preparation and journal automation - TA1TA2\Inputs\XXXX.xlsx. However this file does not exist on the file system.
Error Code: brain.node.referencedFileDoesNotExist'
Looks like excel node works only when complete path is provided , how to overcome this as we need to pull data from files on sharepoint.
Please sign in to leave a comment.