Salesforce Trigger Error after deploying to another workspace

rharkness — Tue, 07 Jul 2026 15:41:22 GMT

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

topic Salesforce Trigger Error after deploying to another workspace in Workato Pros Discussion Board

Salesforce Trigger Error after deploying to another workspace