Questions tagged [shareplum]

SharePlum is a Python package that offers an easy way to work with SharePoint services. It handles all of the messy parts of dealing with SharePoint and allows you to write clean and Pythonic code.

Website: https://pypi.org/project/SharePlum/

47 questions
4
votes
2 answers

SecureAuth cause - ShareplumRequestError: Shareplum HTTP Post Failed : 403 Client Error: Forbidden for url

We are trying to access sharepoint and we are succeeding depending on whether or not the specific sharepoint section is protected with "SecureAuth". The program works fine if the url is not protected with "SecureAuth", but if this URL is protected…
Enrique Benito Casado
  • 1,914
  • 1
  • 20
  • 40
4
votes
3 answers

Convert Sharepoint List into Pandas Dataframe

I have a table in Sharepoint that I'm wanting to convert into a Pandas Dataframe. I've largely used this question to try and frame a solution Get SharePoint List with Python. I'm having issues however. Here is what I have so far... import pandas as…
Hofbr
  • 868
  • 9
  • 31
2
votes
1 answer

python sharepoint - Error validating credentials due to invalid username or password

I want to automate downloading a zipfile on another organization's sharepoint site that they have shared with my organization, inviting us as a guest using a generic company email address so we can access the files. To gain access, I provide the…
geoJshaun
  • 637
  • 2
  • 11
  • 32
2
votes
2 answers

shareplum is only returning 7 columns from SharePoint List

I am trying to pull data from a view I made in SharePoint and the connection works and the data is pulled but only 7 of the 10 columns are being returned. I tried both a normal GetListItems and also using field names. I tried different views and the…
Mike - SMT
  • 14,784
  • 4
  • 35
  • 79
1
vote
1 answer

Unable to Authenicate - AADSTS50059: No tenant-identifying information found in either the request or implied by any provided credentials

Been trying to access SharePoint list and download the data as a CSV using Python for a use case. Once we arrive at the authentication step, we get the error "('Error authenticating against Office 365. Error from Office 365:', 'AADSTS50059: No…
1
vote
1 answer

Authentication Failure: AADSTS50005 while downloading files from sharepoint

My requirement is to download single or multiple files from a folder in sharepoint. I have tried using shareplum and sharepy. Both are giving the below error: Error authenticating against Office 365. Error from Office 365:', "AADSTS50005: User…
saj1807
  • 11
  • 1
1
vote
1 answer

Python - how to get access to SharePoint site without access to root

I'm trying to read data from an HTML table that on a site with a URL like https://mysharepoint.sharepoint.com/sites/mySite/sitepages/tables And I only have access to the "mySite" site. I've tried using shareplum like their documentation: from…
Lophyre
  • 11
  • 1
1
vote
1 answer

Python Shareplum getListItems query

Looking for direction with Python & Shareplum. I am trying to run the following query (very much from the shareplum document), fields = ['ID', 'Title', 'RaceDate', 'RaceNumber'] query = {'Where': ['And', ('Eq', 'Title',…
MdM
  • 81
  • 2
  • 9
1
vote
0 answers

getting error as list index out of range while connecting to sharepoint using python

i am getting error in below code as list index out of range from shareplum import Site from shareplum import Office365 from shareplum.site import Version authcookie = Office365('http://XXXXX.sharepoint.com/', username='XXXXXXXXXX',…
1
vote
2 answers

Using Shareplum to download, alter and then upload a file to sharepoint

Exactly as the title says, I have this code from shareplum import Site from shareplum import Office365 from shareplum.site import Version authcookie = Office365('https://mysite.sharepoint.com/', username='username',…
neeko_vo
  • 11
  • 1
  • 3
1
vote
0 answers

Python sharepoint connection - unable to access

I am trying to access my sharepoint site using python. The sharepoint URL looks something like this: https://companyname.sharepoint.com/teams/mysitename. Following tutorials online on creating sites in sharepoint, somehow my site URL becomes…
Kalamazoo
  • 111
  • 1
  • 10
1
vote
0 answers

'RequestsCookieJar' object is not callable

Hi stackoverflow community! I'm trying to authenticate in SharePoint using Office365 from shareplum. I'm able to get a jar of cookies successfully: authcookie = Office365('https://enterprise.sharepoint.com' username='user@enterprise.com',…
Tiagão
  • 11
  • 3
1
vote
1 answer

Why does a Where clause cause more data to be returned?

I have a script that uses shareplum to get items from a very large and growing SharePoint (SP) list. Because of the size, I encountered the dreaded 5000 item limit set in SP. To get around that, I tried to page the data based on the 'ID' with a…
ChiefTwoPencils
  • 13,548
  • 8
  • 49
  • 75
1
vote
0 answers

Shareplum : ConnectionResetError: [WinError 10054] An existing connection was forcibly closed by the remote host

I'm importing .xlsx file to Sharepoint using Shareplum, i found that when the excel is more then 30MB i get the error ConnectionResetError: [WinError 10054] An existing connection was forcibly closed by the remote host i added a sleep but problem…
1
vote
0 answers

Sharepoint inserts usning shareplum library

I have a sharepoint list in which I am trying to add a new item.The list has an owner column of the type "Users" . My code fails to insert a new row with empty value for this column. It fails with an "Attribute Error" stating " Cannot insert ' '…
sourabhi
  • 37
  • 2
  • 4
1
2 3 4