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.
Thinking about loading SharePoint metadata to Alteryx Connect?
As you probably know, there is no standard out-of-the-box metadata loader built for loading SharePoint metadata. However, there are options how to achieve that using the Files Loader. Let's have a look at the 2 easiest ways how to do that!
Sync your SharePoint files with the OneDrive sync app
If your organization is using the Office 365 business suite or SharePoint Server 2019, you can synchronize your SharePoint files to a folder on a server/local computer.
Open the SharePoint via Internet Explorer and select 'Keep me signed in' before entering your credentials.
Use the Map Network Drive wizard to map the site as network drive. In the 'Folder' field, post the whole address of your SharePoint site and delete the part highlighted below. Don't forget to tick 'Connect using different credentials'.
Once the site is mapped, it will appear in the network locations in 'This PC'. Open one file of your choice located on your SharePoint directly from the File Explorer. You will be asked for credentials. If available, choose to remember the credentials. This is just a precaution for the metadata to be loaded correctly and fully (without opening a file and saving the credentials, only file names without the sheet/column metadata might appear in Connect).
Now you need to locate share path of the mapped site using the Command Prompt. Use the command NET USE and locate the share path in the results.
Now you can use the Alteryx out-of-the-box Files Loader to load the metadata into Connect (Use the share path in the 'Path to load' field).
Are the solutions working for you? Do you have a better solution? Let me know.