smiling man with yellow background

Titan X Lab

smiling woman with glasses with blue background

Fix issue with complex (nested) Salesforce condition logic when using parentheses

When using nested conditions for a Salesforce Get or Push to match existing records, using the Parentheses ‘(‘ ‘)’ on a single condition line introduces an additional AND or OR into the SOQL query sent to saleforce resulting in a Malformed_Query error.  (MALFORMED_QUERY:
FirstName = ‘Bob’ ) and and ( ( MobilePhone = ‘+1 234 ^
ERROR at Row:1:Column:99
unexpected token: ‘and’)

Between each condition line there is currently an AND/OR selection dropdown.  The fix could simply be an option ‘–‘ in the AND/OR dropdown so we can stop the additional AND from appearing or just parse query strings and remove any errroneous AND/Or statements.

Comments