Restore-RecycleBinItems.ps1

[CmdletBinding(SupportsShouldProcess)]
param(
    # The URL of the Sitecollection where the recycle bin is.
    [Parameter(Mandatory)]
    [string]
    $SiteUrl,

    # Full Path of CSV file of Get-AllRecycleBin.ps1
    [Parameter(Mandatory)]
    [string]
    $Path
)

function Restore-RecycleBinItem {
    param(
        [Parameter(Mandatory)]
        [String]
        $Id
    )
    
    $siteUrl = (Get-PnPSite).Url
    $apiCall = $siteUrl + "/_api/site/RecycleBin/RestoreByIds"
    $body = "{""ids"":[""$Id""]}"

    Write-Verbose "Performing API Call to Restore item from RecycleBin..."
    try {
        Invoke-PnPSPRestMethod -Method Post -Url $apiCall -Content $body | Out-Null
    }
    catch {
        Write-Error "Unable to Restore ID {$Id}"     
    }
}

$ErrorActionPreference = 'Continue'
$InformationPreference = 'Continue'

Connect-PnPOnline -Url:$SiteUrl -UseWebLogin

@($(Import-Csv -Path:"$Path")).ForEach({
    $csv = $PSItem
    Write-Information -MessageData:"Restore item $($csv.Title)"
    Restore-RecycleBinItem -Id $($csv.ID)
})

@pmatthews05 - you can tell me to do you one you know :)
Ok, I can confirm that I am now connecting via an appid and secret, I am able to connect and call Get-PNPAccessToken which returns the token.

I am unable to perform a recovery though, I am still getting errors but can almost taste success
In line 51 you are setting a variable '$AccessToken' should this not be $AppToken as this is what is looping from Line 53.

Hi, first off thanks for all your work on putting this together, it is much appreciated and is helping immensely in getting past the daft limit in the pnponline Powershell module.

I've run into a glitch though in the restore phase and wondered if you could see anything jumping out at you. I am running the Powershell module as an admin, and I can obtain the token by logging in, but when I try the restore I am getting the following error for each item in the recycle bin. It may well be me just being daft and missing something :)

The csv file generates fine, so if you have a couple of minutes and can point me in the right direction, that would be fantastic thanks.

_**Restore-RecycleBinItem : Cannot bind argument to parameter 'AppToken' because it is an empty string.
At D:\Restore-RecycleBinItems.ps1:56 char:71

• ... e-RecycleBinItem -SiteUrl $SiteUrl -Id $($csv.ID) -AppToken $AppToken

•                                                             ~~~~~~~~~
  

  • CategoryInfo : InvalidData: (:) [Restore-RecycleBinItem], ParameterBindingValidationException
  • FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Restore-RecycleBinItem**_

And now I have opened my eyes, I have spotted it, sorry to have troubled you.

In the restore-recyclebinitems.ps1 file the variable is $AccessToken but the variable called by line 56 -apptoken had $AppToken as the variable.

Changed the variable and it's working perfectly, and I am sorry to have bothered you.

Superb work by the way, it's a true lifesaver.

Kind Regards

Tony

@Tony-Law,
Thank you for spotting my mistake, yes I had the wrong parameter passed in. One called $AccessToken and the other one called $AppToken.

I have updated my Gist to correct this.

Regards

Paul

@pmatthews05 - you can tell me to do you one you know :)
Ok, I can confirm that I am now connecting via an appid and secret, I am able to connect and call Get-PNPAccessToken which returns the token.

I am unable to perform a recovery though, I am still getting errors but can almost taste success
In line 51 you are setting a variable '$AccessToken' should this not be $AppToken as this is what is looping from Line 53.

Sorry @ZeeGy-net, I've just seen this comment, and noticed you too told me that my variable was incorrect. Thank you to you too.

This was very useful thank you.

I am currently restoring ~150,000 items. I've used Co-Pilot to add a counter to the my script. You may find it useful

# Get the total number of rows in the CSV file
$TotalRows = (Import-Csv -Path:"$Path").Count

# Initialize a counter for the current row
$CSVRow = 0

# Loop through each row in the CSV file
@($(Import-Csv -Path:"$Path")).ForEach({
    $csv = $PSItem

    # Increment the counter by one
    $CSVRow++

    # Write the information message with the desired format
    Write-Information -MessageData:"Restoring item $CSVRow of $TotalRows. Item $($csv.Title)"

    # Restore the recycle bin item with the given ID
    Restore-RecycleBinItem -Id $($csv.ID)
})

Hi @SharkEyes93 thank you for your suggestion.

There is a newer better version of this script which can be found at PNP Script Samples. It batches and runs a bit quicker.

https://pnp.github.io/script-samples/bulk-restore-from-recyclebin/README.html?tabs=pnpps

Feel free to Co-pilot the script and improve on it, I think you will get a PNP PowerShell script badge if you make any updates that get accepted into the Pull Request.