Python SharePoint On-Premise Access List

In this video I will show you how to connect to a On-Premise SharePoint and access a SharePoint list using Python.

Support my Channel

[rrestituti]

Thank you very, very, very much, Lu. I will try this code this week and then I'll tell you if it worked.
You're the man!!!!

[brendansullivan]

Great video! what if you want to also pull the attachments from the list?

[misterprinz]

Hi Lu, very interesting video. Do I need admin rights to access lists on Sharepoint on Prem or is a user with specific rights enough? Thanks a lot :D

[NajamuddinSyed-ux]

Dear good day I have an issue with the SSL certificate when I tried to connect with the method you showed in this video

[saypap]

Hi Lu, need some help. While uploading data to Sharepoint list with dataframe. 9k+ records.
Error - results=envelope[0][0][0][0]
File "...\lxml\etree.pyx", line 1179, ....
IndexError: list index out of range

Got this error with not specific record, sometime it uploads 1187 records, some 754 records or 534 records even. How to correct it

Using python 3.6.1

[abrahamperez]

Hi Lu!, Thanks for these videos, can you make a video where you download several files from a folder shared by a third party?

[stevefull]

Hi Lu, great video!!!. Lu is there a way to delete all SharePoint list entries using python, on-prem. ? Thank you!

[kalyanchakravarthy]

I need some help to list the content inside a folders. For example: /a/b/c using List function i am able to list only the contents of folder "a" but if i pass 'a/b' it says 500 internal server error

[arunamuthaiah]

Hi, is it possible to use the current users credentials by default. I did that in excel VBA. But I couldn't do it in python

[squigglymender]

On the self.site = Site(…) line I am getting the following error:
File “src\lxml\etree.pyx”, line 1178, in
IndexError: list index out of range
I am not sure what this could mean but it seems there’s trouble with authentication?

[poojapatil]

Hii Lu
I am using this code into my official work to ingest data from SharePoint.
But I am getting error as "no such file or directory 'config json' "
I checked the path as well it is correct and I am using as you told, not taking the list part

[LasyteSolutions]

What if you're using windows authentication and don't have a user/pass to use?

[feliperodriguezarrieta]

Shareplum HTTP Post Failed : 403 Client Error: Forbidden for url
I don't know why the error

[saypap]

Hi Lu, Thanks for your detail videos.
In my corporate sp2013 on prem I am able to authenticate and perform operations using Shareplum on Lists but the issue starts with REST API folder access.
I have tried to authenticate with version=Version.v2013 in site authentication its getting authenticated but the moment I try to run sp_Folder = site.Folder('Shared Documents/myfolder') it throws Json Decoder error(Actually the folder and files exists) Kindly help, if I have to perform authcookie but with on prem 2013 I'm not able to move. Getting stuck badly. Please please help.

[elizabethlove]

Hi, Lu. I get an error that says ImportError: cannot import name 'SharePoint' from 'sharepoint'. So I changed 'SharePoint' to 'SharePointSite'. Later I get an error that says (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')])"))). Can you please help me?

[carolinaav]

How to delete whole que data from Sharepoint list?

[RangaSwamyleela]

Hi Lu I'm getting error like super()._init__(f"{msg} : {details}") -- invalid syntax in errors.py package

[willsun]

Hi Lu, i got error: Shareplum HTTP Post Failed : 403 Client Error: Forbidden for url do you have any idea how to fix it? i can get access through web browser though.

[sheldonwang]

Thanks Lu for posting.
I used the same approach (on-premise) to access a list on my Sharepoint and had no issues. But recently after the Sharepoint is upgraded, my Python code does not work anymore, giving error: Shareplum HTTP Post Failed : 403 Client Error: Forbidden for url: https://(Site).

I talked to the Sharepoint admin and found that the authentication has been changed from Windows authentication to SAML authentication. I would think the issues are possibly

- Incorrect settings on the server side, e.g., the server does not allow me to access the List.
- Or, shareplum does not work with SAML authentication

The code is like below.

from shareplum import Site
from requests_ntlm import HttpNtlmAuth
SP_CRED = HttpNtlmAuth('usernamet', 'password')
SP_SITE = Site(SITE_URL, auth=SP_CRED)
SP_LIST = SP_SITE.List('my list name')


I can still access my Sharepoint from Windows after upgrading.

Thanks!