英文:
Download a file from REST API and upload to Sharepoint without need for intermediate storage
问题
这是你的内容的翻译：
我在这里的第一篇帖子，因为我是新手脚本/编程。我有一个要求，需要通过REST API从外部服务下载文件，然后将这些文件上传到SharePoint。我已经编写了一个可以完成此操作的脚本，但它使用了中间本地存储，因为脚本使用两个不同的函数来实现此目的（使用 **Invoke-RestMethod** 本地下载，然后使用 **Connect-PnPOnline** 和 **Add-PNPFile** 从本地上传到SharePoint）我想要做的是，在不使用本地存储的情况下实现这一点，因为我想将其移到无服务器Azure函数中。以下是我的脚本。欢迎提供有关如何简化以实现去除本地存储的任何反馈。请注意，这仍然是一个原型，所以一旦我完成基本功能，我还将外部化所有凭据信息。```plaintext# 用于连接API并下载录音的脚本# 定义连接到API的链接$download_endpoint = 'https://api.externalservice.com/download';# 定义下载文件$recording = 'C:\Users\UserName\filename.mp3';# 定义用于连接到API的安全凭据$api_key = 'pk_xxxxxxxxxxxxxxxxxxxxxxxxxxxxx';$api_secret = 'sk_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';# 连接到API$auth = $api_key + ':' + $api_secret$Encoded = [System.Text.Encoding]::UTF8.GetBytes($auth)$authorizationInfo = [System.Convert]::ToBase64String($Encoded)$headers = @{@"Authorization"="Basic $($authorizationInfo)"}Invoke-RestMethod -Uri $download_endpoint -OutFile $recording -Headers $headers# 设置用于SharePoint网站和库的变量$tenant = "companyname.onmicrosoft.com";$siteURL = "https://companyname.sharepoint.com/site";$libraryName = "Test";# 定义用于连接到SharePoint的凭据$applicationID = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";$certpath = "C:\Users\UserName\companyname.pfx";$password = "XXXXXXXXXXXXXX";# 使用现代身份验证连接到SharePoint OnlineConnect-PnPOnline -Url $siteURL -ClientId $applicationID -CertificatePath $certpath -CertificatePassword (ConvertTo-SecureString -AsPlainText $password -Force) -Tenant $tenant# 将文件上传到库Add-PnPFile -Path $recording -Folder $libraryName# 从SharePoint Online断开连接Disconnect-PnPOnline
英文:
My first post here, as I am newb to scripting/programming.
I have a requirement to download files from an external service via a REST API and then upload those files to SharePoint. I have put together a script that can do this, but it uses intermediate local storage, as the script uses two different functions to achieve this (download locally using Invoke-RestMethod and upload from local to SharePoint using Connect-PnPOnline and Add-PNPFile
What I would like to do, is achieve this without using local storage, as I would like to move this to a serverless Azure Function.
Below is my script. Any feedback on streamlining this to achieve the removal of local storage are appreciated.
Just a note, this is still a prototype, so I will also externalise all the credential information once I have the base functionality working.
# Script to connect to API and download recordings# Define links to the API$download_endpoint = 'https://api.externalservice.com/download'# Define the download file$recording = 'C:\Users\UserName\filename.mp3'# Define security credentials for connecting to the API$api_key = 'pk_xxxxxxxxxxxxxxxxxxxxxxxxxxxxx'$api_secret = 'sk_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'# Connect to the API$auth = $api_key + ':' + $api_secret$Encoded = [System.Text.Encoding]::UTF8.GetBytes($auth)$authorizationInfo = [System.Convert]::ToBase64String($Encoded)$headers = @{"Authorization"="Basic $($authorizationInfo)"}Invoke-RestMethod -Uri $download_endpoint -OutFile $recording -Headers $headers# Set variables for the SharePoint site and library$tenant = "companyname.onmicrosoft.com"$siteURL = "https://companyname.sharepoint.com/site"$libraryName = "Test"# Define credentials for connecting to SharePoint$applicationID = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"$certpath = "C:\Users\UserName\companyname.pfx"$password = "XXXXXXXXXXXXXX"# Connect to SharePoint Online using modern authenticationConnect-PnPOnline -Url $siteURL -ClientId $applicationID -CertificatePath $certpath -CertificatePassword (ConvertTo-SecureString -AsPlainText $password -Force) -Tenant $tenant# Upload the file to the libraryAdd-PnPFile -Path $recording -Folder $libraryName# Disconnect from SharePoint OnlineDisconnect-PnPOnline
答案1
得分: 1
Add-PnpFile有一个-Stream参数，您可以使用它来替代-Path。在这种情况下，您可以将Invoke-RestMethod更改为Invoke-WebRequest，并使用返回的对象的.RawContentStream Property中包含的MemoryStream。代码保持基本相同，只需要进行以下修改：
$req = Invoke-WebRequest -Uri $download_endpoint -Headers $headers -UseBasicParsing# 在此连接，保持不变# 然后上传使用`-Stream`# 此外，在这个ParameterSet中，`-FileName`是必需的Add-PnPFile -Stream $req.RawContentStream -Folder $libraryName -FileName somefile.ext
英文:
Add-PnpFile has a -Stream parameter which you can use instead of -Path. In that sense, you could change Invoke-RestMethod for Invoke-WebRequest and use the MemoryStream included in the .RawContentStream Property of the returned object. The code remains about the same and only requires these modifications:
$req = Invoke-WebRequest -Uri $download_endpoint -Headers $headers -UseBasicParsing# Connect here, stays the same# Then upload uses `-Stream`# Also, in this ParameterSet `-FileName` is MandatoryAdd-PnPFile -Stream $req.RawContentStream -Folder $libraryName -FileName somefile.ext
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论