我正在尝试用Python语言获取SharePoint列表的任何可能方法。我能够通过以下视频连接到SharePoint并使用Rest API获取XML数据:https://www.youtube.com/watch?v=dvFbVPDQYyk...但是不确定如何将列表数据导入python。最终目标是获得SharePoint数据并每天导入SSMS。
这是我到目前为止所拥有的..
import requests
from requests_ntlm import HttpNtlmAuth
url='URL would go here'
username='username would go here'
password='password would go here'
r=requests.get(url, auth=HttpNtlmAuth(username,password),verify=False)
我相信这些将是下一步。我真的只需要帮助从SharePoint获得数据的Excel/CSV格式,最好是这样,从那里应该很好。但是任何建议都会很有帮助..
#PARSE XML VIA REST API
#PRINT INTO DATAFRAME AND CONVERT INTO CSV
#IMPORT INTO SQL SERVER
#EMAIL RESULTS
发布于 2019-09-20 00:42:07
from shareplum import Site
from requests_ntlm import HttpNtlmAuth
server_url = "https://sharepoint.xxx.com/"
site_url = server_url + "sites/org/"
auth = HttpNtlmAuth('xxx\\user', 'pwd')
site = Site(site_url, auth=auth, verify_ssl=False)
sp_list = site.List('list name in my share point')
data = sp_list.GetListItems('All Items', rowlimit=200)
发布于 2019-03-21 21:48:06
我知道这不能直接回答您的问题(您现在可能已经有答案了),但我会尝试一下SharePlum库。它应该希望simplify你与SharePoint交互的过程。
另外,我不确定您是否需要将数据导出到csv中,但是,您可以更直接地使用connect directly to SQL Server并插入数据。
我只会把这个加到评论里,但还没有足够高的声誉。
发布于 2020-01-28 03:50:51
这可以使用SharePlum和Pandas来完成以下是工作代码片段
import pandas as pd # importing pandas to write SharePoint list in excel or csv
from shareplum import Site
from requests_ntlm import HttpNtlmAuth
cred = HttpNtlmAuth(#userid_here, #password_here)
site = Site('#sharePoint_url_here', auth=cred)
sp_list = site.List('#SharePoint_list name here') # this creates SharePlum object
data = sp_list.GetListItems('All Items') # this will retrieve all items from list
# this creates pandas data frame you can perform any operation you like do within
# pandas capabilities
data_df = pd.DataFrame(data[0:])
data_df.to_excel("data.xlsx")
如果这有帮助,请打分。提前谢谢你!
https://stackoverflow.com/questions/42903036
复制相似问题