Update-ActCRM Cmdlet
Updates Act! CRM data.
Syntax
Update-ActCRM [parameters]
Remarks
The Update-ActCRM cmdlet allows you to use a syntax similar to SQL UPDATE statements to update Act! CRM data.
$conn = Connect-ActCRM -URL 'https://myActCRMserver.com' -User 'myUser' -Password 'myPassword' -ActDatabase 'MyActDB
Update-ActCRM -Connection $conn -Table "Activities" -Columns @("Company") -Values @("Sample subject") -Id "1"
The Where parameter can also be used to specify the primary key of the table:
Update-ActCRM -Connection $conn -Table "Activities" -Columns @("Company") -Values @("Sample subject") -Where "Id = '1'"
The primary key can also be passed to the cmdlet along the pipeline:
Select-ActCRM -Connection $conn -Table Activities -Where "FullName = 'Anna'" | Update-ActCRM -Columns @("FullName") -Values @("Anna 2")