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.
This KB is an extract of the Inspire 2019 Tips + Tricks and although this tip is not officially supported by Alteryx, we’ve seen it work for a lot of users.
Product - Alteryx Designer
Product - Microsoft Sharepoint
Reading and writing to document libraries in Sharepoint consists in creating a OneDrive sync to your local machine:
Navigate to your library in SharePoint and choose sync:
Run through the OneDrive Sync setup until it has been created on the machine - Make a note of the path selected for the sync.
Now that the library is synced with a local folder, you can read/write to it using Alteryx Designer:
In this example I am writing out a .yxdb file to the local folder
Verify that this file is written on the local folder
Verify that this file is synced with the Sharepoint library
This trick is applicable to Designer usage only.
When implementing this to an Alteryx Server, you will need to :
Make sure the mapping is the same for both Client and Server
Provide the a Run As user / any specific user's credentials with access to that mapped SP location to read and write from.
Additionally, workflows implementing this trick cannot be scheduled. As per this update on our Idea forum, a Windows limitation causes Server to be unable to input information into the related dynamic Windows pop-up.