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".
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.
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
@davidromstad @alandepew FYI this is possible now with a simple checkbox on exports to include archived and deleted records.