Parameters   Output Objects  

Updates Basecamp data.

Syntax

Update-Basecamp [parameters]

Remarks

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

$conn = Connect-Basecamp -AccountId '1234567' -ProjectId 'abcd1234' -Schema 'V3'
Update-Basecamp -Connection $conn -Table "Projects" -Columns @("Name") -Values @("1000000") -Id "S"

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

Update-Basecamp -Connection $conn -Table "Projects" -Columns @("Name") -Values @("1000000") -Where "Id = 'S'"

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

Select-Basecamp -Connection $conn -Table Projects -Where "Id = 'MyId'" | Update-Basecamp -Columns @("Id") -Values @("MyId 2")