Platform: Ability to Obtain Removed Records Through DAC-Based OData

In MYOB Acumatica 2024.2.1, a technical specialist can obtain removed records through the OData interface that retrieves data from data access classes (DACs)—that is, the DAC-based OData interface.

The removed records are stored in the database if the corresponding database table has the DeletedDatabaseRecord column. For details about this mechanism, see Preservation of Deleted Records (DeletedDatabaseRecord).

Retrieval of Removed Records

By default, the removed records are not returned if a technical specialist requests data through the DAC-based OData interface. To retrieve the removed records, the technical specialist needs to specify the PX-ApiDeleted HTTP header with the SHOW value in the request.

For example, the following request retrieves both removed customer records and customer records that have not been removed.

GET /2024R2/t/U100/api/OData/DAC/Customer?
$select=BAccountID,DeletedDatabaseRecord HTTP/1.1
Host: localhost
PX-ApiDeleted: SHOW