使用Python通过API上载Sharepoint文件

import requests from shareplum import Office365 from config_s import config_s # get data from config_suration username = config_s['sp_user'] password = config_s['sp_password'] site_name = config_s['sp_site_name'] base_path = config_s['sp_base_path'] doc_library = config_s['sp_doc_library'] file_name = "/Users/Metatrons/Desktop/AutoReport_Structure/test.csv" # Obtain auth cookie authcookie = Office365(base_path, username=username, password=password).GetCookies() session = requests.Session() session.cookies = authcookie session.headers.update({'user-agent': 'python_bite/v1'}) session.headers.update({'accept': 'application/json;odata=verbose'}) session.headers.update({'X-RequestDigest': 'FormDigestValue'})#FormDigestValue response = session.post( url=base_path + "/sites/" + site_name + "/_api/web/GetFolderByServerRelativeUrl('" + doc_library + "')/Files/add(url='a.txt',overwrite=true)", data="") session.headers.update({'X-RequestDigest': response.headers['X-RequestDigest']}) # perform the actual upload with open( file_name, 'rb') as file_input: try: response = session.post( url=base_path + "/sites/" + site_name + "/_api/web/GetFolderByServerRelativeUrl('" + doc_library + "')/Files/add(url='" + file_name + "',overwrite=true)", data=file_input) print(response) print(response.headers) #print(response.headers['X-RequestDigest']) except Exception as err: print("Some error occurred: " + str(err)) print("What the FUUUUUUUUUUUUCK")

1条回答

网友

1楼 · 发布于 2024-04-27 02:36:46

请参考下面的示例，我已经在我的SPO环境中对其进行了测试

import requests
from shareplum import Office365
from config import config

# get data from configuration
username = config['sp_user']
password = config['sp_password']
site_name = config['sp_site_name']
base_path = config['sp_base_path']
doc_library = config['sp_doc_library']

file_name = "test.html"
# Obtain auth cookie
authcookie = Office365(base_path, username=username, password=password).GetCookies()
session = requests.Session()
session.cookies = authcookie
session.headers.update({'user-agent': 'python_bite/v1'})
session.headers.update({'accept': 'application/json;odata=verbose'})

# dirty workaround.... I'm getting the X-RequestDigest from the first failed call
session.headers.update({'X-RequestDigest': 'FormDigestValue'})
response = session.post( url=base_path + "/sites/" + site_name + 
"/_api/web/GetFolderByServerRelativeUrl('" + doc_library + 
"')/Files/add(url='a.txt',overwrite=true)",
                     data="")
session.headers.update({'X-RequestDigest': response.headers['X-RequestDigest']})

# perform the actual upload
with open( r'C:\Users\mengfeik\Documents\test.html', 'rb+') as file_input:
try: 
    response = session.post( 
        url=base_path + "/sites/" + site_name + "/_api/web/GetFolderByServerRelativeUrl('" + doc_library + "')/Files/add(url='" 
        + file_name + "',overwrite=true)",
        data=file_input)
except Exception as err: 
    print("Some error occurred: " + str(err))

print('end...')

相关问题更多 >

编程相关推荐

热门问题

热门文章