使用Python从Sharepoint读取Excel文件

Question

我必须阅读一个excel文件存储在Sharepoint使用Python，使用下面的代码。我得到以下错误:

从XML响应中检索令牌时发生错误:AADSTS53003:访问已被条件访问策略阻止。访问策略不允许颁发令牌

当我登录到Sharepoint时，它是两步认证:

第一个:Username &密码

第2次:在我的手机中批准Microsoft Authenticator应用程序的登录请求。

如何在Get请求中合并两步身份验证?

url = 'https://COMPANY.sharepoint.com/sites/XXXX'
path = '/Shared%20Documents/XXX.xlsx'
username = 'my-username'
password = 'my-password'
ctx_auth = AuthenticationContext(url)
if ctx_auth.acquire_token_for_user(username, password):
ctx = ClientContext(url, ctx_auth)
web = ctx.web
ctx.load(web)
ctx.execute_query()
print("Authentication successful")

Answer 1

您可以参考以下代码

import requests
from requests.auth import HTTPBasicAuth
file = "https://content.potatocompany.com/workspaces/PotatoTeam/Shared Documents/XYZ errors/XYZ Errors_Confirm.xlsx"

username = 'myUsername'
password = 'myPassword'

resp=requests.get(file, auth=HTTPBasicAuth(username, password))
output = open('test.xlsx', 'wb')
output.write(resp.content)
output.close()