Load files from SharePoint in Python

Question

So I am trying to load files located in (sub)directories in Python using this bit of code:

import json

from office365.runtime.auth.authentication_context import AuthenticationContext
from office365.runtime.client_request import ClientRequest
from office365.runtime.utilities.request_options import RequestOptions

ctx_auth = AuthenticationContext(url)
if ctx_auth.acquire_token_for_user(username, password):
  request = ClientRequest(ctx_auth)
  options = RequestOptions("{0}/_api/web/".format(url))
  options.set_header('Accept', 'application/json')
  options.set_header('Content-Type', 'application/json')
  data = request.execute_request_direct(options)
  s = json.loads(data.content)
  web_title = s['Title']
  print("Web title: " + web_title)
else:
  print(ctx_auth.get_last_error())

But I am getting the following error:

Cannot get binary security token for from https://login.microsoftonline.com/extSTS.srf An error occurred while retrieving auth cookies from https:/DOMAIN.website/siteDocuments/Document/example/

Now the Microsoft link says the endpoint only accepts POST requests. Received a GET request.

Is there any workaround for this? Thanks.

found a solution for this? Still not working for me. Current answer is not working for me. — Chris
– Chris, Commented Mar 21, 2023 at 19:56

JD Long · Accepted Answer · 2023-02-08 18:05:21Z

4

I tested this code on my SP online. Please modify your code as below:

import json

from office365.runtime.auth.authentication_context import AuthenticationContext
from office365.runtime.client_request import ClientRequest
from office365.runtime.http.request_options import RequestOptions

tenant_url= "https://{tenant}.sharepoint.com"
ctx_auth = AuthenticationContext(tenant_url)

site_url="https://{tenant}.sharepoint.com/sites/{yoursite}"

if ctx_auth.acquire_token_for_user("username","password"):
  request = ClientRequest(ctx_auth)
  options = RequestOptions("{0}/_api/web/".format(site_url))
  options.set_header('Accept', 'application/json')
  options.set_header('Content-Type', 'application/json')
  data = request.execute_request_direct(options)
  s = json.loads(data.content)
  web_title = s['Title']
  print("Web title: " + web_title)
else:
  print(ctx_auth.get_last_error())

Result:

edited Feb 8, 2023 at 18:05

JD Long

61k58 gold badges209 silver badges300 bronze badges

answered Apr 24, 2020 at 6:01

Baker_Kong

1,8991 gold badge8 silver badges10 bronze badges

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

3 Comments

0andriy Over a year ago

ModuleNotFoundError: No module named 'office365.runtime.utilities.request_options'

Steven Over a year ago

request_options has been moved to: from office365.runtime.http.request_options import RequestOptions

Chris Over a year ago

not working for me. Still getting the Cannot get binary security token for from...

Collectives™ on Stack Overflow

Load files from SharePoint in Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related