Parameters   Output Objects  

Updates HubSpot data.

Syntax

Update-HubSpot [parameters]

Remarks

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

$conn = Connect-HubSpot
Update-HubSpot -Connection $conn -Table "Contacts" -Columns @("Country") -Values @("U.S.A") -Id "123456789"

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

Update-HubSpot -Connection $conn -Table "Contacts" -Columns @("Country") -Values @("U.S.A") -Where "Id = '123456789'"

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

Select-HubSpot -Connection $conn -Table Contacts -Where "VID = '123456789'" | Update-HubSpot -Columns @("VID") -Values @("123456789 2")