Data360 Analyze

Hello, i am using the Sharepoint 365 download node.

I can download a file from Sharepoint, to a staging directory and then upload it into Sharepoint again.

Assume it's an excel file i want to download from Sharepoint, would it be possible to just read in the data from the excel file into Data 360 from Sharepoint instead of downloading the file into a directory, and then uploading it into sharepoint?

An example is the "Excel file" node, where i just specify a directory and read in the data.

Long story short:

Unfortunately no, that is not possible

Longer story:

The Download for SharePoint 365 node can output the data received from SharePoint to a file or to a field. This can be useful when dealing with data files such as JSON that can then be processed directly by the JSON Data Node (as it supports the 'JsonData (from Data Field)' source option. 

However, the source options supported by the Excel File node can be the filename (as a literal value) or the name of the input filed that contains the filename.

Excel files are binary files. Data360 Analyze does not support binary data in data records and as such binary data needs to be base64 encoded. The Download for SharePoint 365 node does support the encoding of binary data downloaded from SharePoint, which can then be output in a specified output field. But, as there is no source option to accept the (encoded) file data in a data field, the content cannot be read by the Excel File node.

The other issue is the Upload for SharePoint365 node requires the file or directory path of the files to be uploaded to be specified. There is no mechanism to accept the data for a file and convert it to the expected file format. The Upload for SharePoint365 node leverages the Microsoft Graph API which expects to upload a file from a specified filepath.