Cmdlets for Dynamics 365 Finance and Operations

Build 21.0.7930

Update-D365FinOp Cmdlet

Parameters   Output Objects  

Updates Dynamics 365 Finance and Operations data.

Syntax

Update-D365FinOp [parameters]

Remarks

The Update-D365FinOp cmdlet allows you to use a syntax similar to SQL UPDATE statements to update Dynamics 365 Finance and Operations data.

$conn = Connect-D365FinOp -OrganizationUrl "https://myaccount.operations.dynamics.com/"
Update-D365FinOp -Connection $conn -Table "Accounts" -Columns @("Name") -Values @("Jon Doe") -Id "'00000000-0000-0000-0000-000000000000'"
The Where parameter can also be used to specify the primary key of the table:
Update-D365FinOp -Connection $conn -Table "Accounts" -Columns @("Name") -Values @("Jon Doe") -Where "AccountId = ''00000000-0000-0000-0000-000000000000''"
The primary key can also be passed to the cmdlet along the pipeline:
Select-D365FinOp -Connection $conn -Table Accounts -Where "Name = 'MyAccount'" | Update-D365FinOp -Columns @("Name") -Values @("MyAccount 2")

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930