Update-ZohoCreator Cmdlet
Updates Zoho Creator data.
Syntax
Update-ZohoCreator [parameters]
Remarks
The Update-ZohoCreator cmdlet allows you to use a syntax similar to SQL UPDATE statements to update Zoho Creator data.
$conn = Connect-ZohoCreator -InitiateOAuth "GETANDREFRESH"
Update-ZohoCreator -Connection $conn -Table "[CData].[Employee Management].Leave_Types" -Columns @("Leave_Type") -Values @("Jon Doe") -Id "98891000000010007"
The Where parameter can also be used to specify the primary key of the table:
Update-ZohoCreator -Connection $conn -Table "[CData].[Employee Management].Leave_Types" -Columns @("Leave_Type") -Values @("Jon Doe") -Where "Id = '98891000000010007'"
The primary key can also be passed to the cmdlet along the pipeline:
Select-ZohoCreator -Connection $conn -Table [CData].[Employee Management].Leave_Types -Where "Leave_Type = 'Sick'" | Update-ZohoCreator -Columns @("Leave_Type") -Values @("Sick 2")