Salesforce GET many records with Condition: XYZ = null

Questions
1

Salesforce GET many records with Condition: XYZ = null

Using Salesforce node version 1 (Latest)

How do you set a condition for null in the Salesforce node
I suspect the null value is getting converted into a string

ie xyz = ‘null’ rather than xyz = null

I have tried [empty], {{ null }} and {{ ‘null’ }} as an expression aswell.

Current HTTP GET
https://{instance}.my.salesforce.com/services/data/v58.0/query/

Query Parameters
Name: q
Value:
SELECT FIELDS(ALL)
FROM object_name__c 
WHERE xyz__c = null
Limit 10
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @Dwayne_Taylor, I think you need to use Search resource with your custom Querry. Is that what you did?

image
image750×714 34.4 KB