GetDeletedAsView
Provides a view of records deleted from core entities such as Customers, Invoices, and Bill Payments, allowing administrators or auditors to track removed data for compliance and reconciliation purposes.
GetDeletedAsView is capable of retrieving the ID and deletion time of QuickBooks Online entities such as Customer, Invoice, BillPayment, though it is not capable of retrieving this information about their children. LineItems are a common example of children, where BillPaymentLineItem is a child of BillPayment. This is a limitation of the QuickBooks Online API.
EntityName is required to be specified in the WHERE clause of a query for this view. Note that EntityName refers to the QuickBooks Online API name, rather than the table name that CData provides. For example, the Vendors table represents Vendor entities. Please refer to the QuickBooks Online API Reference for all entity names.
The following query retrieves deleted record information for the 'Customer' entity:
SELECT * FROM GetDeletedAsView WHERE EntityName = 'Customer'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Specifies the system-generated unique identifier (Id) of the deleted entity record. This value is used to reference or reconcile deleted records when retrieving change data or maintaining synchronization between systems. | |
| EntityName | String | Specifies the name of the deleted entity. This value identifies which QuickBooks Online entity type (such as Customer, Invoice, or Vendor) was deleted so you can filter or process deletions by entity type. | |
| DeletedTime | Datetime | Specifies the date and time when the entity record was deleted in QuickBooks Online. This timestamp allows you to determine when the deletion occurred and supports incremental synchronization or auditing processes. |