Sharepoint_Databricks_Issues

Question

Hello Team,

I am trying to read the data from sharepoint from databricks and try to run the below commands .

auth = sharepy.auth.SharePointOnline(username="svc_bireporting@xyz .com",password="1234")
r = requests.get("https://abcd.sharepoint.com", auth=auth)

create session/connection to SharePoint

auth = sharepy.auth.SharePointOnline(username="svc_bireporting@xyz .com",password="1234")
auth.login_url="https://abcd.sharepoint.com/sites/bisd"
s = sharepy.SharePointSession(site, auth=auth)

I am getting error :

AuthError: Token request failed. Invalid server response

Please advise whether it is becuase of wrong URL/USERNAME/PASSWORD.

Regards
RK

Answer 1

Hello @Rohit Kulkarni ,

Thanks for the question and using MS Q&A platform.

From the above code - I don't find a varaible named site and this could be the reason for the error message:

s = sharepy.SharePointSession(site, auth=auth)   

Try to replace site with r and see if that works:

s = sharepy.SharePointSession(r, auth=auth)   

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators