Accessing data from Sharepoint through alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team
Hope you are well. I need help.
All my data currently is saved in sharepoint and its important for us to access these data through alteryx. But we tried connecting through alteryx but its not working. Can you please share how to go about it?
Thanks
Sri
- Labels:
- Connectors
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sriniprad08 ,
there's a connector for working with Files in Sharepoint 365. Just download the yxi file, open it in Designer and you'll get two tools added to your Connectors tab.
Unfortunately there's an issue with 21.3.2, where the auth cannot proceed. And you need at least Designer 21.2.2 version.
Another limitation is that for scheduling on Server you need to provide your own Azure app as Service principal.
Try our Beta data connectors at https://bit.ly/3Ae8HgY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VojtechT
Thank you very much. We are still exploring this and experiencing some issues internally.
Cheer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sriniprad08 , feel free to send me an email to vtalasek@alteryx.com describing your issues and maybe I will be able to help. Or post it here, whatever suits you better.
Try our Beta data connectors at https://bit.ly/3Ae8HgY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VojtechT
Sure. Really appreciate it. Will keep you posted. We recently upgraded to 2021.3 and we dont have cloud.
Thank you again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In such case please follow the link in my signature where you'll find Beta of the new version of the connector which supports On-prem as well.
Try our Beta data connectors at https://bit.ly/3Ae8HgY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VojtechT ,
Thank you for sharing. I tried the beta version. But its giving me the below error.
can you please help?
thanks
Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sriniprad08 ,
are you sure about the 2021.3 version? We tried to reproduce the error, but did not succeed. And the error does not look like something wrong with the connector itself, rather the missing python SDK on your machine.
Maybe the connector was not installed properly - could you delete the connector and install it again?
(go to %APPDATA%\Alteryx\Tools\ and delete both "sharepoint_1.1.0" and "sharepoint_1.1.0_env" folders - or something that looks similar.. I don't remember exactly the names - and install the yxi again,)
Try our Beta data connectors at https://bit.ly/3Ae8HgY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VojtechT ,
Thank you so much for the kind reply. Yes you are right this could be the possible reason what you mentioned will try and get back.
Cheers,
Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sriniprad08 ,
we have uploaded a newer version of the connector. Still Beta, but maybe there was something wrong with the one you tested. If you're still facing the issue, could you please try the new version? Thank you.
Try our Beta data connectors at https://bit.ly/3Ae8HgY
