Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Sharepoint Input/Output Connector Tools:Sharepoint URL Error

NancyS
8 - Asteroid

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!

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @NancyS 

 

What is the issue you are facing ?

NancyS
8 - Asteroid

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
22 - Nova
22 - Nova

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
8 - Asteroid

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!

Labels