Parameters   Output Objects  

Updates QuickBooks Time data.

Syntax

Update-TSheets [parameters]

Remarks

The Update-TSheets cmdlet allows you to use a syntax similar to SQL UPDATE statements to update QuickBooks Time data.

$conn = Connect-TSheets -OAuthClientId "MyOAuthClientId" -OAuthClientSecret "MyClientSecret" -CallbackURL "MyCallbackURL"
Update-TSheets -Connection $conn -Table "Timesheets" -Columns @("JobcodeId") -Values @("Jon Doe") -Id "6"

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

Update-TSheets -Connection $conn -Table "Timesheets" -Columns @("JobcodeId") -Values @("Jon Doe") -Where "Id = '6'"

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

Select-TSheets -Connection $conn -Table Timesheets -Where "JobCodeType = 'regular'" | Update-TSheets -Columns @("JobCodeType") -Values @("regular 2")