Salesforce: Returning Archived Rows

I’m using Salesforce nodes to connect to Salesforce and would like to include archived data in the results. I’ve tried these options:

  1. The Salesforce Simple Query node: Node doesn’t return results when adding the filter ‘IsArchived = TRUE’
  2. Salesforce SOQL Node: SELECT Id, Name FROM Account ALL ROWS returns the error unexpected token: ‘ALL’
  3. REST: I am using the Salesforce Connector to the GET Request and am using the credentials input for authentication. This query https://example.lightning.force.com/services/data/vXX.X/queryAll/?q=SELECT+Id,+Subject,+IsArchived+FROM+Task+WHERE+IsArchived=true returns a 401 error [ {
    “message” : “Session expired or invalid”,
    “errorCode” : “INVALID_SESSION_ID”
    } ], even though I just refreshed the OAuth. It seems like the credentials aren’t connecting?

My preference would be to to this using Salesforce nodes.

1 Like

Hi.

It seems Salesforce offers a separate endpoint for these requests (documentation). There is no query parameter isArchived or similiar. Currently, in KNIME Analytics Platform, you can’t change this endpoint.

I went ahead and modified our nodes slightly by adding a configuration option to the Salesforce Simple Query. Do you want to give it a try? Add this zipped update site to your KNIME update site manager and install the modified plug-in:
2025-07-31_knime-salesforce_updatesite.zip (301.3 KB)

(Prototype! Not part of any future release … yet.)

Otherwise, it should also be possible to use generic oauth connector nodes etc to authenticate with Salesforce and then use the GET and POST nodes. But that is more advanced.

Let us know!
– Bernd

3 Likes

This works and is a simple solution, nudge to release it :slightly_smiling_face:

Scheduled to be included in version 5.7.

1 Like

Internal ticket ID: AP-24773
Summary: Salesforce Query nodes with new option to also retrieve deleted and archived items
Fix version(s): 5.7.0

Internal ticket ID: AP-24773
Summary: Salesforce Query nodes with new option to also retrieve deleted and archived items
Fix version(s): 5.7.0