Cmdlets for FreshBooks

Build 20.0.7587

Update-FreshBooks Cmdlet

Parameters   Output Objects  

Updates FreshBooks data.


Update-FreshBooks [parameters]


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

$conn = Connect-$psname; -CompanyName 'MyCompany' -Token 'MyToken'
Update-FreshBooks -Connection $conn -Table "Clients" -Columns @("Username") -Values @("Jon Doe") -Id "20050"
The Where parameter can also be used to specify the primary key of the table:
Update-FreshBooks -Connection $conn -Table "Clients" -Columns @("Username") -Values @("Jon Doe") -Where "Id = '20050'"
The primary key can also be passed to the cmdlet along the pipeline:
Select-FreshBooks -Connection $conn -Table Clients -Where "Email = ''" | Update-FreshBooks -Columns @("Email") -Values @(" 2")

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587