Remove-DynamicsNAV Cmdlet
Deletes Microsoft Dynamics NAV data.
Syntax
Remove-DynamicsNAV [parameters]
Remarks
The Remove-DynamicsNAV cmdlet allows you to use a syntax similar to SQL DELETE statements to delete Microsoft Dynamics NAV data.
$conn = Connect-DynamicsNAV -URL "http://myserver:7048" -ServerInstance "DYNAMICSNAV71" -Password "MyPassword" -User "MyServer\MyUser"
Remove-DynamicsNAV -Connection $conn -Table "Customer" -Id "http://myserver:7048/DynamicsNAV71/OData/Customer('01234567')"
The Where parameter can also be used to specify the primary key:
Remove-DynamicsNAV -Connection $conn -Table "exTablePowershell;" -Where "Id = http://myserver:7048/DynamicsNAV71/OData/Customer('01234567')"
The primary key can also be passed to the cmdlet along the pipeline:
Select-DynamicsNAV -Connection $conn -Table Customer -Where "Name = 'CData, Inc.'" | Remove-DynamicsNAV