soql in java to fetch the deleted records

Question

I have a scenario where I would like to fetch all the deleted records at salesforce end and send to UI using java.

I tried with the following SOQL:

SELECT Id, IsDeleted, CreatedDate, LastModifiedDate FROM Note ALL ROWS

I end up with response as:

[ {
  "message" : "ALL ROWS not allowed in this context",
  "errorCode" : "MALFORMED_QUERY"
} ]

Can someone help me on this?

You need to use the queryAll call / endpoint instead of using ALL ROWS — superfell
@superfell: Thanks for the suggestion. queryAll did work for me. — David Sam

Egor Egor · Accepted Answer · 2016-01-18T21:37:59

The "ALL ROWS" option is only supported by Apex SOQL queries. You can't use it with REST calls or in the developer console.