How to get Item ID after Powershell Add-SPOFile

Question

I am using Powershell to (bulk) Add-SPOFile to a Sharepoint Online Doclib. I need to Set-SPOListItem properties for the new items in the process, but don't know how to get the Item ID for the newly added file. It would be great if Add-SPOFile returned an ID, or to be able to pipe from Add-SPOFile to Set-SPOListItem? What is the prescribed solution?

I am reading a CSV file, looping through the 288K entries, uploading a file for each entry, then trying to update the item properties. My code looks like this:

Connect-SPOnline -Url https://XXX.sharepoint.com/sites/sedatest -Credentials 'YYY'

$CSVPath = "ZZZ\SODA_CSVData.10.txt"
$SrcPath = "\\MDWeb01\DC\pdf\Released"
$DstFolder = "./SEDA"

$SODAData = import-csv $CSVPath -Delimiter "|"

Foreach ($r in $SODAData)
{
    $UploadFile = "$SrcPath\$($r.Series.Substring(0,1))\$($r.Filename)"
    Write-Host "Uploading $UploadFile"
    Add-SPOFile -Path $UploadFIle -Folder $DstFolder
    $Item = Get-SPOListItem -List SEDA | where {$($_.FileLeafRef) -eq $($r.Filename)}
    Set-SPOListItem -List SEDA -Identity $($Item.Id) -Values @{"LegacyID" = $r.LegacyID}
}

View Source on the doc library suggests that "FileLeafRef" is the right property name:

"ID": "51",
...
"FileLeafRef": "pf2363010800.pdf",
...

Maybe I am not referencing it properly?

Answer 1

If you use Get-SPListItems using where as your filter, you will be able to find the item ID. For instance:

Get-SPOListItems -ListTitle TestList | where {$_.Title -eq "Test Item"}

Do let me know if this helps

Answer 2

This actually made me switch to the following code instead of add-spofile:

$Context = Get-SPOContext

#Retrieve list
$List = $Context.Web.Lists.GetByTitle("DocLib")
$Context.Load($List)
$Context.ExecuteQuery()

#Upload file
Foreach ($File in (dir $folder))
{
$FileStream = New-Object IO.FileStream($File.FullName,[System.IO.FileMode]::Open)
$FileCreationInfo = New-Object Microsoft.SharePoint.Client.FileCreationInformation
$FileCreationInfo.Overwrite = $true
$FileCreationInfo.ContentStream = $FileStream
$FileCreationInfo.URL = $File.Name
$Upload = $List.RootFolder.Files.Add($FileCreationInfo)
$Context.Load($Upload)
$Context.Load($Upload.ListItemAllFields)
$Context.ExecuteQuery()
}

This will give you the ID via $Upload.ListItemAllFields.Id

Answer 3

Turns out there are a couple ways to do this; The first one I found looks like this:

    $Item = Get-SPOListItem -List SEDA -Fields "FileLeafRef" | 
      %{new-object psobject -property  @{Id = $_.Id; Filename = $_["FileLeafRef"]}} | 
      select Id, Filename | where {$_.Filename -eq $($r.Filename)}

    Set-SPOListItem -List SEDA -Identity $($Item.Id) -Values @{"LegacyID" = $r.LegacyID}

But the easier way, and the one I deployed (including the FileCreationInfo approach above), looks like this:

    $FileStream = New-Object IO.FileStream($SrcFilePath,[System.IO.FileMode]::Open)
    $FileCreationInfo = New-Object Microsoft.SharePoint.Client.FileCreationInformation
    $FileCreationInfo.Overwrite = $true
    $FileCreationInfo.ContentStream = $FileStream
    $FileCreationInfo.URL = $_.SedaID
    $Upload = $Files.Add($FileCreationInfo)
    $context.Load($Upload)
    $context.Load($Upload.ListItemAllFields)
    $context.ExecuteQuery()

    Set-SPOListItem -List $listTitle -Identity $($Upload.ListItemAllFields.Id) -ContentType "SEDA Document" -Values $Metadata

Now I just need to figure out how to add a Check-in Comment during this upload/update without multiplying the version count?

Any ideas?