使用powershell从sharepoint下载特定文件夹的CAML查询

Connect-SPOService -Url https://yourdomain.sharepoint.com -Credential admin@yourdomain.onmicrosoft.com

$folderUrl = "/sites/yourSite/Shared Documents/YourFolder"
$query = New-Object Microsoft.SharePoint.Client.CamlQuery
$query.ViewXml = "<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='FileDirRef'/><Value Type='Text'>$folderUrl</Value></Eq></Where></Query></View>"
$items = (Get-SPOList -Identity "YourListName").GetItems($query)

$downloadPath = "C:\Download"
foreach ($item in $items) {
    $fileUrl = $item["FileRef"]
    $fileName = [System.IO.Path]::GetFileName($fileUrl)
    $fileLocalPath = [System.IO.Path]::Combine($downloadPath, $fileName)
    $fileContent = (Get-SPOFile -Identity $fileUrl -AsFile).OpenBinary()
    [System.IO.File]::WriteAllBytes($fileLocalPath, $fileContent)
}