Query the records in the Recycle Bin in your CRM account.

View-Specific Information

Accessing this view requires additional OAuth scopes. If you are switching to the v8 schema from another schema, you must reauthenticate with Zoho CRM. To reauthenticate, invalidate the previous persisted OAuthAccessToken by executing the 'RESET CREDENTIALS' query.

Select

The driver uses the Zoho CRM API to process WHERE clause conditions built with the following columns and operators.

• Id supports the '=' operator.
• DisplayName supports the '=', '!=', 'LIKE' and 'NOT LIKE' operators.
• ModuleApiName supports the '=' and '!=' operators.
• DeletedTime supports the '=', '!=', '>' and '<' operators.

For example, the following queries are processed server side:

SELECT * FROM RecycleBin WHERE Id = '1170218000000570531';
SELECT * FROM RecycleBin WHERE DisplayName = 'text';
SELECT * FROM RecycleBin WHERE DisplayName != 'text';
SELECT * FROM RecycleBin WHERE DisplayName LIKE '%text%';
SELECT * FROM RecycleBin WHERE DisplayName LIKE '%text';
SELECT * FROM RecycleBin WHERE DisplayName LIKE 'text%';
SELECT * FROM RecycleBin WHERE DisplayName NOT LIKE '%text%';
SELECT * FROM RecycleBin WHERE ModuleApiName = 'Leads';
SELECT * FROM RecycleBin WHERE ModuleApiName != 'Leads';
SELECT * FROM RecycleBin WHERE DeletedTime = '2001-01-01 23:00:00.0';
SELECT * FROM RecycleBin WHERE DeletedTime != '2001-01-01 23:00:00.0';
SELECT * FROM RecycleBin WHERE DeletedTime > '2001-01-01 23:00:00.0';
SELECT * FROM RecycleBin WHERE DeletedTime < '2001-01-01 23:00:00.0';

Columns