Parameters   Output Objects  

Updates Epicor Kinetic data.

Syntax

Update-EpicorERP [parameters]

Remarks

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

$conn = Connect-EpicorERP -Service 'Erp.BO.CustomerSvc' -ERPInstance 'MyInstance' -URL 'https://myaccount.epicorsaas.com' -User 'username' -Password 'password'
Update-EpicorERP -Connection $conn -Table "Customers" -Columns @("Company") -Values @("Jon Doe") -Id "12345"

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

Update-EpicorERP -Connection $conn -Table "Customers" -Columns @("Company") -Values @("Jon Doe") -Where "Id = '12345'"

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

Select-EpicorERP -Connection $conn -Table Customers -Where "CompanyName = 'CompanyName'" | Update-EpicorERP -Columns @("CompanyName") -Values @("CompanyName 2")