Sharepoint Input/Output Connector Tools:Sharepoint URL Error

[NancyS]

Hi all,

I am using alteryx to delete and update a list on Sharepoint online using Sharepoint Input and output connector tools.

While doing so, I'm facing an issue in Sharepoint URL. Ref: https://help.alteryx.com/current/designer/sharepoint-list-input-tool

The format of the URL of the Sharepoint site I need to access is: https://xyz89.abc.com/sites/dummysite

Need help on this, please.

PS. Using Online/Office 365 in the version dropdown for the Sharepoint Input/Output tool

Thanks in advance!

[atcodedog05]

Hi @NancyS 

What is the issue you are facing ?

[NancyS]

Hi @atcodedog05 , thanks for your response. The error I'm faing is "Remote name could not be resolved". Need to make sure the correct format of the URL to be used in the configuration

[atcodedog05]

Hi @NancyS 

Sorry I haven't this issue before. Hence dont know to fix it.

Maybe this link might be helpful

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Issue-Connecting-to-the-SharePoint-Lis...

[NancyS · Accepted solution]

Update: I was able to solve the problem by using the same url I use for webpage and using in the configuration, Instead of using email id, I used Domain\Username for credentials.

Although after multiple attempts of posting the data on SP, observed that at one time, maximum of 10 rows can be posted on SP online site. Sometimes if one record gets posted on SP, after few minutes it won't. Flashing error: "Partial data written on Sharepoint" . I read somewhere on community that this is because o memory issue? Apparently, Sharepoint Output Tool cannot post beyond 2MB of data. I'm not sure how much of this is true, but if this is true .. the lack of reliability for one record getting posted at one time and getting failure for same record at different time justifies it.

Still looking a workaround to bulk update the data at Sharepoint with or without Alteryx. Open to suggestions. 🙂 

So far I've tried:

1. Exporting a list from MS Access to SP site. Error :"Property not found"
2. Tried to sync Onedrive with SP site, in order to download the list on Ondrive and carry out bulk updates from my system. Error: "Do not have permissions"
3. Third party applications are of not of use in my case because of potential compliance issues.

Thanks in advacne!