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