Parameters   Output Objects  

Deletes Smartsheet data.

Syntax

Remove-Smartsheet [parameters]

Remarks

The Remove-Smartsheet cmdlet allows you to use a syntax similar to SQL DELETE statements to delete Smartsheet data.

$conn = Connect-Smartsheet -OAuthClientId 'MyOAuthClientId' -OAuthClientSecret 'MyOAuthClientSecret' -CallbackURL 'http://localhost:33333'
Remove-Smartsheet -Connection $conn -Table "Sheet_Test_Sheet" -Id "123456"

The Where parameter can also be used to specify the primary key:

Remove-Smartsheet -Connection $conn -Table "exTablePowershell;" -Where "Id = 123456"

The primary key can also be passed to the cmdlet along the pipeline:

Select-Smartsheet -Connection $conn -Table Sheet_Test_Sheet -Where "Favorite = 'True'" | Remove-Smartsheet