ODBC Driver for QuickBooks Online

Build 20.0.7587

GETDELETED Statements

You can issue the GETDELETED query to retrieve all records deleted from the live data for the time range specified. This query accepts a datetime value as a filter. You can also use the statement without a filter.

When used on LineItem tables or other 'child entities', GETDELETED will instead return the parent records which have been modified rather than information about the child records which have been deleted. This is a limitation of the QuickBooks Online api.

GETDELETED FROM <table_name>
GETDELETED FROM <table_name> WHERE <search_condition>


<search_condition> ::= 
  {
    <expression> { = | < | <= | > | >= } [ <expression> ] 
  } [ { AND | OR } ... ]

<expression> ::=
  | @ <parameter> 
  | ?
  | <literal>
  
Example Query:
GETDELETED FROM Customers WHERE [MetaData_LastUpdatedTime]>'2018-06-08T06:53:38-07:00'
Note: By putting a CACHE command in front of the query, you can update the cache to remove all values that have been deleted from the data source. This is shown in the query below:
CACHE GETDELETED FROM [TableName]

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587