This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, I have a SharePoint site where we have a lot of Excel-files I like to read. The excel-files also include properties in added customized columns in SharePoint, that consist of important information. I'm using Alteryx Designer x64 v2018.2.6.51223.
With the tool SharePoint Tool Input, I got the following columns regarding the files:
Field Type Size
Modified DateTime 19 Modified By V_WString 255 Company Code V_WString 10 (added customized column in SharePoint) Created By V_WString 255 Created DateTime 19 Version V_WString 255 Content Type V_WString 255
In addition, I tried to extract the files using the Directory-tool, both with an UNC-path and to a synchronized folder on my C-drive. In both cases I got all the files with the given columns:
The directory input tool only gives you information about files within a specific folder, in order to read a file into Alteryx off the back of this you need to use the 'dynamic input', have a look at this and let us know if you have any follow up questions.
I have tried out the dynamic input, but are not able to see that this tool give me any file-properties, only the content in the file. I need to get out the customized file properties that are assigned to the files, and also created as columns in SharePoint. Is that possible?
With this connection I can create an Excel-file where all wanted information is included, and I can import that file into Alteryx. Based on the filenames and path/link; I assume it is relatively easy to batch-process of the files from SharePoint in Alteryx. BUT then I need to manually update the Excel-file each time I run the process. This is not sustainable in order to schedule the task.
Two questions to this:
Is it possible to connect directly to the query in Alteryx? How?
Is it alternatively any way I can get Alteryx to trigger an update of the Excel-sheet, based on the query from SharePoint? How?