Authentication for downloading excel file from direct sharepoint link (python)

Question

I'm trying to write some python code to download an excel file, given a direct link. The link is a sharepoint direct download link. I'm getting a 404 unauthorized error when running the code, which I know is because I need to somehow correctly put in the username and password for the sharepoint.

My code snippet looks like this:

username = 'abc'
password = '123'
url = 'http://example.com/spreadsheet.xls'
r = requests.get(url, auth=HTTPBasicAuth(username, password))
print(r)
# <Response [401]>

I haven't even gotten to the downloading portion if I can't get the authentication right. If the code works, I should expect the value of r to be 200, but I get the value 401, which is an unauthorized error. I'm sure that my username and password are both correct.

Any help would be appreciated. Thanks!

vivek · Accepted Answer · 2017-03-31 06:46:42Z

1

The authentication you are using could be wrong. Replace HTTPBasicAuth with NTLM auth or HttpNegotiateAuth.

from requests_ntlm import HttpNtlmAuth, HttpNtlmSspiAuth
auth = HttpNtlmSspiAuth()

from requests_negotiate_sspi import HttpNegotiateAuth
auth = HttpNegotiateAuth()

answered Mar 31, 2017 at 6:46

vivek

296 bronze badges

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

Collectives™ on Stack Overflow

Authentication for downloading excel file from direct sharepoint link (python)

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