Microsoft365 Tip　SharePointファイル操作方法あれこれ

Install-Module SharePointPnPPowerShellOnline
Import-Module SharePointPnPPowerShellOnline
$Credential = Get-Credential
$SiteUrl = "https://hj545rkw.sharepoint.com/sites/SPFile"
Connect-PnPOnline -Url $SiteUrl -Credentials $Credential

Get-PnPFolderItem -FolderSiteRelativeUrl "Shared Documents/General"

Name        Type Items/Size Last Modified     
----        ---- ---------- -------------     
Book.xlsx   File      11547 2023/03/28 0:04:07
ドキュメント.docx File          0 2023/03/28 0:04:16

$ServerRelativeUrl = (Get-PnPFolderItem -FolderSiteRelativeUrl "Shared Documents/General" | Where {$_.Name -eq "Book.xlsx"}).ServerRelativeUrl 
Get-PnPFile -Url $ServerRelativeUrl -Path c:\ -FileName Book.xlsx -AsFile

$FileId = (Get-PnPListItem -List "Shared Documents/General" | Where {$_.Fieldvalues["FileLeafRef"] -eq "Book.xlsx"}).Id
Move-PnPListItemToRecycleBin -List "Shared Documents/General" -Identity $FileId -Force

Get-PnPRecycleBinItem | Where {$_.Title  -eq "Book.xlsx"} | Restore-PnPRecycleBinItem -Force

Clear-PnPRecycleBinItem -Force

Import-Module Microsoft.Graph.Files
Import-Module Microsoft.Graph.Sites
Connect-MgGraph

$SiteId = (Get-MgSite -Search "SPFile").Id
$DriveId = (Get-MgSiteDefaultDrive -SiteId $SiteId).Id

Get-MgDriveItemChild -DriveId $DriveId -DriveItemId "root"

$DriveItemId = (Get-MgDriveItemChild -DriveId $DriveId -DriveItemId "root" | Where {$_.Name -eq 'General'}).Id
Get-MgDriveItemChild -DriveId $DriveId -DriveItemId $DriveItemId　| Select Name

Name       
----       
Book.xlsx  
ドキュメント.docx

$FileName = "Book.xlsx"
$HashTable = (Get-MgDriveItemChild -DriveId $DriveId -DriveItemId $DriveItemId | Where {$_.Name -eq $FileName}).AdditionalProperties
$DownloadUrl = $HashTable["@microsoft.graph.downloadUrl"]
Invoke-WebRequest -Uri $DownloadUrl -OutFile ”C:\$FileName”

$IteamId = (Get-MgDriveItemChild -DriveId $DriveId -DriveItemId $DriveItemId | Where {$_.Name -eq $FileName}).Id
Remove-MgDriveItem -DriveId $DriveId -DriveItemId $IteamId

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client") > $null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Client.Runtime") > $null

$UserName = "アカウント"
$Password = ConvertTo-SecureString 'パスワード -AsPlainText -Force
$SiteURL = "https://hj545rkw.sharepoint.com/sites/SPFile/"
$Credential = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName, $Password)
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Context.Credentials = $Credential
$objWeb = $Context.Web
$Context.Load($objWeb)
$Context.ExecuteQuery()

$ObjList = $Context.Web.Lists.GetByTitle("ドキュメント")
$CamlQuery = New-Object Microsoft.SharePoint.Client.CamlQuery
$CamlQuery.ViewXml = "<View/>"
$ListItems = $ObjList.GetItems($CamlQuery)
$Context.Load($ListItems)
$Context.ExecuteQuery()
$listItems | Where {$_.FileSystemObjectType -eq "File"} | % {
    $_["FileLeafRef"]
}

$ObjList = $Context.Web.Lists.GetByTitle("ドキュメント")

$Folder = $objWeb.GetFolderByServerRelativeUrl("https://hj545rkw.sharepoint.com/sites/SPFile/Shared%20Documents/General")
$Context.Load($Folder)
$Context.ExecuteQuery()

$CamlQuery = New-Object Microsoft.SharePoint.Client.CamlQuery
$CamlQuery.ViewXml = "<View/>"
$CamlQuery.ViewXml = 
@"
<View Scope='Recursive'>
<Query>
</Query>
</View>
"@
$CamlQuery.FolderServerRelativeUrl = $Folder.ServerRelativeUrl

$ListItems = $ObjList.GetItems($CamlQuery)
$Context.Load($ListItems)
$Context.ExecuteQuery()
$ListItems = $ObjList.GetItems($CamlQuery)
$Context.Load($ListItems)
$Context.ExecuteQuery()
$listItems | % {
    $_["FileLeafRef"]
}

$RelativeUrl = "/Sites/SPFile/Shared%20Documents/Book.xlsx"
$FilePath = "C:\Book.xlsx"
$FileInfo = [Microsoft.SharePoint.Client.File]::OpenBinaryDirect($Context, $RelativeUrl)
$WriteStream = [System.IO.File]::Open($FilePath,[System.IO.FileMode]::Create)
$FileInfo.Stream.CopyTo($WriteStream)
$WriteStream.Close()

$objFile = $context.Web.GetFileByServerRelativeUrl("/sites/SPFile/Shared%20Documents/Book1.xlsx")
$Context.Load($objFile)
$Context.ExecuteQuery()
$objFile.Recycle()
$Context.ExecuteQuery()

$objWeb.RecycleBin.MoveAllToSecondStage()
$Context.ExecuteQuery()

$Site = $Context.Site
$RecycleBinCollection = $Site.RecycleBin
$Context.Load($Site)
$Context.Load($RecycleBinCollection)
$Context.ExecuteQuery()
$Id = ($RecycleBinCollection | Where {$_.Title -eq "Book1.xlsx"})[0].Id
$RecycleBinItem = $Context.Web.RecycleBin.GetById($Id)
$RecycleBinItem.Restore()
$Context.ExecuteQuery()

$Site.RecycleBin.DeleteAll()
$Context.ExecuteQuery()

$objFile = $objWeb.GetFolderByServerRelativeUrl("/sites/SPFile/Shared%20Documents/Book1.xlsx")
$objFile.DeleteObject()
$Context.ExecuteQuery()