Tuesday
I have an interesting error.
I have an integration that is triggered by the "New/updated" trigger against a Salesforce Object.
In my development Workato workspace this SOQL Where Clause works without issue:
SalesforceStage__c = 'Analysis' OR SalesforceStage__c = 'Cancelled'
But when I deploy the same integration to our UAT Workato Workspace, I get an error even thought both the DEV and UAT Workato Workspaces use a Salesforce App connection to the same Salesforce Sandbox
"message":"\nSalesforceStage__c = 'Analysis' OR SalesforceStage__c = 'Cancelled'\n ^\nERROR at Row:1:Column:731\nunexpected token: 'OR'","errorCode":"MALFORMED_QUERY"
I've tried putting the separate comparisons in parenthesis but it still throws the Unexpected Token error on the OR operator
This is driving me nuts because, as I said, this is working in the lower workato workspace pointed to the same Saleforce environment
Anyone have any suggestions because as it stands now, I may have to wrap the whole integration in an IF to get this to work
Tuesday
Can you paste the full query? or a screenshot of the configuration
Wednesday
I'm using the "New/updated Record" action for the Salesforce App connector so I don't have the full query. I have provided the screenshots of the trigger configuration and the app connection. Both of these are identical to the configuration in our development workato workspace and the error is not thrown by the trigger there. It seems this version is throwing an issue with the "OR". If I remove the OR and leave only one of the conditions it works
Thursday
This might sound too simple, but can you delete the WHERE clause and retype it from scratch instead of editing/pasting into the existing box? The error suggests there's a hidden character (likely a non-breaking space) around the OR that isn't visible on screen but is breaking the SOQL parser. Typing it fresh should clear it.