Using Python to Connect/ Download file from SharePoint 2013

Question

Seek your guidance, I am new @Python and in learning phase.

Problem Statement: I want to connect & Download the xlsx file from my office SharePoint 2013 site.

Steps so far:

import sharepy
s = sharepy.connect("https://office.XXX.com/sites/pkdyns")
r = s.getfile("https://office.XXX.com/sites/pkdyns/Shared%20Documents/YYYY.xlsx")
r = s.getfile("https://office.XXX.com/sites/pkdyns/Shared%20Documents/YYYY.xlsx", filename="/PYTHON/YYYY.xlsx")

After this I dont see the downloaded file, not sure if it ran or not, using Jupyter Notebook but it didnt throw up any error. Please suggest.

Please format your code properly, click here to learn how.

rizerphe
– rizerphe

2020-05-13 07:23:41 +00:00
Commented May 13, 2020 at 7:23 — rizerphe
– rizerphe, Commented May 13, 2020 at 7:23

Baker_Kong · Accepted Answer · 2020-05-14 02:58:01Z

2

sharepy library seems to only support sharepoint online.

SharePy - Simple SharePoint Online authentication for Python

Below is a sample about how to download file from sharepoint, you may take a reference( it uses another library):

from office365.sharepoint.client_context import ClientContext
from office365.sharepoint.file import File

ctx = ClientContext.connect_with_credentials(url,UserCredential(username, password))
web = ctx.web
ctx.load(web)
ctx.execute_query()
print "Web title: {0}".format(web.properties['Title'])
 
path = "../../tests/data/SharePoint User Guide.docx"
response = File.open_binary(context, "Shared Documents/SharePoint User Guide.docx")
response.raise_for_status()
with open(path, "wb") as local_file:
     local_file.write(response.content)

answered May 14, 2020 at 2:58

Baker_Kong

1,8991 gold badge8 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Python to Connect/ Download file from SharePoint 2013

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related