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.
I have a link to an Excel File that is currently stored on our Sharepoint folder. I also have access to the folder that it is in and can move around in it but I can't seem to download the file automatically either through Power Automate or Alteryx.
I connected the Sharepoint List connector but I didn't see the file when I did that (it also didn't show any file names which I thought was odd).
This is Sharepoint 365.
I also tried using HTTP but didn't have any success.
Has anyone done this? Is this possible with Alteryx? I figure as cloud computing becomes bigger and bigger that this would be more in demand.
Can you establish an App-Only account for your SharePoint site?
We use SharePoint 365 and can access files on the site by using this account. It requires the Alteryx workflow to make a call to the authorization service to get an access token, then passing that token along to another with the request to SharePoint. I can provide more info if it is something that may work for you.
@KP_DMLI would love to hear a little more about how you are successfully connecting. Sounds a little more complicated than my experience and would be interested to hear a little more detail-per-detail instruction.
Here is what I am using for SharePoint with workflow attached. I hope you find it useful!
Note: This information is based on my organization’s infrastructure using Azure Active Directory, SharePoint 365, and authentication at https://accounts.accesscontrol.windows.net/. Your results may vary depending on your organization’s configuration.
The sample workflow makes a call to the authentication web service where a token is returned if authentication is successful. The authentication is passed with subsequent calls to the SharePoint API. The sample calls the SharePoint API to get a list of files, then calls the SharePoint API again to download files. The API is documented at https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service and provides various methods for interacting with SharePoint. I have used Alteryx with the Blob tool to upload files to SP this way.