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:
The Salesforce Simple Query node: Node doesn’t return results when adding the filter ‘IsArchived = TRUE’
Salesforce SOQL Node: SELECT Id, Name FROM Account ALL ROWS returns the error unexpected token: ‘ALL’
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” : “INVALIDSESSIONID”
} ], 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.