Celigo Mapping - Dynamic Salesforce Search (lookup)

Integration Apps
, , , ,
1

In my search filters I have to be sure that all empty values for certain field are disregarded.

I would like to have the following criteria in place: Netsuite__Id NOT EQUAL null

Below is the syntax of my current formula:

5301043caa20740200000001-f1af4d01971f4d5381bf4e3afe7de5b5.png

(it's 2x single quote sign ')

SQL representation: (Netsuite_Internal_Id__c != '')

Is this syntax correct?

2

Hi SKIE Solutions,
Yes it's the right syntax (Netsuite_Internal_Id__c != ''). Please let us know if you face any issues with the above syntax.