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
