Hi,
We've been working with our Technical Services team to establish a connection between Alteryx and our institution's Sharepoint, using the Sharepoint List input/output tools.
Between the documentation for the tool from Alteryx and the Microsoft documentation for setting up application authentication, we're running into an 'Access Denied' issue as below:
We are wanting to set up an App-Only connection using a client-ID and secret key, we have set this up in a test environment using
should the scope be something along the lines of https://{site}.sharepoint.com/site/{sitename}/content/web , does anyone know if this is the correct format?
Hey @lcrosby
I agree that Microsoft documentation isn't exactly useful here. I am wondering about the same thing as I haven't connected app-only. Please let me know if you find something new!
Hi @joshuaburkhow,
Just an update - with some wrangling with our Tech Services dept. we finally figured this out. It's not a perfect solution as it's using a slightly older method of connecting but one that Microsoft still support.
The main issue we were having is making sure we were requesting and granting app permissions in Sharepoint at the right level. All this can be administered at the site level. So if you want to give Alteryx access to a particular list in SharePoint, for example, you can do the following;
goto: https://{your domain}.sharepoint.com/sites/{your site}/_layouts/15/appregnew.aspx
here you can generate a client ID and secret key. URLs for domain and re-direct can just be entered as www.localhost.com and https://www.localhost.com respectively.
Next, a site owner needs to goto: https://{your domain}.sharepoint.com/sites/{your site}/_layouts/15/appinv.aspx
Here they can authorise and set permissions, in the XML permissions, after a lot of searching, we figured out the following will give access to list objects;