INVALID_QUERY_FILTER_OPERATOR for Salesforce Search Objects

Hi,

It appears that the Search criteria is not converting the operators

Id:"a0d700000045QEMAA2 ",
Expense_Status__c:"Invoiced",
Search for:"Expenses__c"

The output is a error

400 Bad Request: [{"message":"\nAmount__c FROM Expenses__c WHERE Id = 'a0d700000045QEMAA2 ' AND Expense_Status__c\n ^\nERROR at Row:1:Column:1732\ninvalid ID field: a0d700000045QEMAA2 ","errorCode":"INVALID_QUERY_FILTER_OPERATOR"}]

Please resolve this issue.

Thanks and Regards

Praveen Reguri

Adam Goh

said almost 9 years ago

Hi Praveen,

The Id used for Search Expenses had been an invalid ID. A correct ID in Salesforce is 15 digit, as shown in your Record in Salesforce. You might want to remove MMA2 from your input to get the right ID a0d700000045QEMAA2. This will look for an Expense with the recordID of a0d700000045QE

If you wish to use the RecordID from Search Expense's result, you will need to use the RecordID Data pill from the output on the right. You can either use it from the output step to get the first result's RecordID, or have a repeat action and a conditional action to look for a specific Record. In plain English, it would say: "For each Search Expenses found in Step 1, if the Account name equals X, then do the actions below".

Regards,

Adam Goh

Let Workato recipes do the work for you!

+1 (844) GO-WORKATO | www.workato.com

Ticket: https://support.workato.com/helpdesk/tickets/1633

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem