Forum Discussion

apoorva_mithal's avatar
apoorva_mithal
New Contributor
5 years ago

Salesforce Bulk Query to get deleted records

Hi, is there a way to retrieve deleted records in Salesforce using ‘Salesforce Bulk Query’ snap? It works fine for Salesforce SOQL snap but I can’t see any such option in Bulk snap.

3 Replies

  • Hi @apoorva_mithal,

    If you need to save the records (or the IDs of them) that you’re deleting, then you’d need to first save those. It could be into file(s) or stage table in a database and then you delete them.

    In case the number of rows is high, then I’d split them into chunks and delete chunk by chunk. Before deleting I would save the IDs of those records (and maybe some more columns) and then perform the deletion.

    /Igor

  • Hi @apoorva_mithal,

    But, in general, does the bulk operation offers something like what you expect? I think it’s not supported by any other technology.
    SOQL is a different approach.

    /Igor

    • apoorva_mithal's avatar
      apoorva_mithal
      New Contributor

      Hi @igormicev,
      I am assuming since the data is stored in recycle bin it would be retrievable (might be wrong there!).
      Can you suggest how I can keep up with this and not use SOQL snap instead?