Parameters   Output Objects  

Searches Smartsheet data.

Syntax

Select-Smartsheet [parameters]

Remarks

The Select-Smartsheet cmdlet allows you to use a syntax similar to SQL SELECT statements to search Smartsheet data.

$conn = Connect-Smartsheet -OAuthClientId 'MyOAuthClientId' -OAuthClientSecret 'MyOAuthClientSecret' -CallbackURL 'http://localhost:33333'
Select-Smartsheet -Connection $conn -Table "Sheet_Test_Sheet" -Columns @("Id","Name") -Where "Favorite='True'"