# Query Deleted Records in Salesforce

**URL:** <https://connective.celigo.com/t/query-deleted-records-in-salesforce/674>\
**Category:** Integrator.io\
**Tags:** database, recycle-bin, query-parameters, export, salesforce\
**Created:** [August 25, 2022, 1:03pm UTC](https://connective.celigo.com/t/query-deleted-records-in-salesforce/674 "2022-08-25T13:03:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alandepew](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/alandepew/32/7274_2.png) [@alandepew](https://connective.celigo.com/u/alandepew)\
**Post date:** [August 25, 2022, 1:03pm UTC](https://connective.celigo.com/t/query-deleted-records-in-salesforce/674/1 "2022-08-25T13:03:13Z")

</div>

How can I query deleted records in a Salesforce export? I have tried adding the "ALL ROWS" hint but get an error "ALL ROWS not allowed in this context".

---

<div class="post-metadata">

**Author:** ![davidromstad](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@davidromstad](https://connective.celigo.com/u/davidromstad)\
**Post date:** [September 2, 2022, 4:20pm UTC](https://connective.celigo.com/t/query-deleted-records-in-salesforce/674/2 "2022-09-02T16:20:13Z")

</div>

Looking for the same. We are attempting to pull deleted Quote Line Items. There are a couple work arounds but nothing related to Celigo that I am seeing.

---

<div class="post-metadata">

**Author:** ![ravisingh](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/ravisingh/32/6981_2.png) [@ravisingh](https://connective.celigo.com/u/ravisingh)\
**Post date:** [September 21, 2022, 12:44pm UTC](https://connective.celigo.com/t/query-deleted-records-in-salesforce/674/3 "2022-09-21T12:44:00Z")

</div>

You can use an HTTP export and make a GET call to query deleted records.  
E.g. relative URI /services/data/{version}/queryAll/?q=select+name,+id+from+account+where+isDeleted+=+TRUE

 ![5301043caa20740200000001-2c6812643d54468e936886aa86989b89.jpg](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0d4e3aa35e50f819f4e8f0e5285d5f8dfbd5beba.jpeg)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [January 9, 2025, 12:03am UTC](https://connective.celigo.com/t/query-deleted-records-in-salesforce/674/4 "2025-01-09T00:03:31Z")

</div>

@davidromstad @alandepew FYI this is possible now with a simple checkbox on exports to include archived and deleted records.