我正在尝试使用Shareplum从Sharepoint获取一个项目列表,但是它似乎给了我一个错误,仅仅访问这个站点:
from shareplum import Site, Office365
from shareplum.site import Version
main_link = 'https://xxxxxxx.sharepoint.com'
whole_link = 'https://xxxxxxxxx.sharepoint.com/sites/TheSiteNeededToRun'
###LINE GIVING THE ERROR###
cookie = Office365(main_link, username=usr, password=pwd).GetCookies()
###LINE GIVING THE ERROR###
site = Site(whole_link, version=Version.v365, authcookie=cookie)
mnps_list = site.List(mnps_list_name)
data = mnps_list.GetListItems('All Items')
这是一个完全的错误(最后,它说了一些关于“失败”的内容,因此标题):
C:\Users\victoraz\Documents\auto-mnp>python access-sp.py
Traceback (most recent call last):
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connection.py", line 156, in _new_conn
conn = connection.create_connection(
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\util\connection.py", line 61, in create_connection
for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\socket.py", line 953, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 11001] getaddrinfo failed
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 665, in urlopen
httplib_response = self._make_request(
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 376, in _make_request
self._validate_conn(conn)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 994, in _validate_conn
conn.connect()
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connection.py", line 300, in connect
conn = self._new_conn()
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connection.py", line 168, in _new_conn
raise NewConnectionError(
urllib3.exceptions.NewConnectionError: <urllib3.connection.VerifiedHTTPSConnection object at 0x000001C909FA5580>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\requests\adapters.py", line 439, in send
resp = conn.urlopen(
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 719, in urlopen
retries = retries.increment(
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\util\retry.py", line 436, in increment
raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='login.microsoftonline.com', port=443): Max retries exceeded with url: /extSTS.srf (Caused
by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x000001C909FA5580>: Failed to establish a new connection: [Errno 11001]
getaddrinfo failed'))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\shareplum\request_helper.py", line 16, in post
response = session.post(url, **kwargs)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\requests\api.py", line 119, in post
return request('post', url, data=data, json=json, **kwargs)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\requests\api.py", line 61, in request
return session.request(method=method, url=url, **kwargs)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\requests\sessions.py", line 530, in request
resp = self.send(prep, **send_kwargs)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\requests\sessions.py", line 643, in send
r = adapter.send(request, **kwargs)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\requests\adapters.py", line 516, in send
raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='login.microsoftonline.com', port=443): Max retries exceeded with url: /extSTS.srf (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x000001C909FA5580>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\victoraz\Documents\auto-mnp\access-sp.py", line 11, in <module>
cookie = Office365(main_link, username=usr, password=pwd).GetCookies()
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\shareplum\office365.py", line 88, in get_cookies
sectoken = self.get_security_token(self.username, self.password)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\shareplum\office365.py", line 66, in get_security_token
response = post(requests, url, data=body)
File "C:\Users\victoraz\AppData\Local\Programs\Python\Python39\lib\site-packages\shareplum\request_helper.py", line 20, in post
raise ShareplumRequestError("Shareplum HTTP Post Failed", err)
shareplum.errors.ShareplumRequestError: Shareplum HTTP Post Failed : HTTPSConnectionPool(host='login.microsoftonline.com', port=443): Max retries exceeded with url: /extSTS.srf (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x000001C909FA5580>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))
我怀疑函数.GetCookies(),,因为我注释了几乎所有东西,从.GetCookies()到最后一行,并且没有异常地运行模块(尽管程序也没有做任何事情)。
发布于 2021-03-30 06:25:36
我的测试代码:
from shareplum import Site
from shareplum import Office365
from shareplum.site import Version
authcookie = Office365('https://contoso.sharepoint.com/', username='amos@contoso.onmicrosoft.com', password='password').GetCookies()
site = Site('https://contoso.sharepoint.com/sites/dev/', version=Version.v2016, authcookie=authcookie)
list=site.List("test3");
data=list.GetListItems("All Items");
print(data)
测试结果:
检查是否启用了多因素身份验证。
https://stackoverflow.com/questions/66858299
复制相似问题