I’m using sandbox connection.
My search query is Processing_time_in_days__c = null AND (Status = 'New' OR Status = 'In progress')
I select the option “Return first search result” but the test still returns thousands of records, so I cannot send the fields to open AI to analyze (too many characters, and Open AI has a limit).
Why is it happening?
Best answer by SamB
Sorry to hear you’re getting a “MALFORMED_QUERY” error with that approach
The Find Record by Query action has a field that looks like it should allow you to set the maximum number of records that are returned:
Can you try setting that field to 1 and let us know whether that does the trick?
+11Hi
It sounds like the query is overriding the “Return first search result” setting. I’d recommend flagging that with our Support Team in case it’s a bug: https://zapier.com/app/get-help
In the meantime, you can try reducing the number of results returned by adding a LIMIT clause to your query. For example you’d want something more like:
SELECT Processing_time_in_days__c, Status
FROM YOUR_OBJECT_API_NAME_GOES_HERE__c
WHERE Processing_time_in_days__c = null
AND (Status = 'New' OR Status = 'In progress')
LIMIT 1Give that a try and let me know how it goes! 🙂
I added Limit 1 to the query and Zap returns an error message 😭
Salesforce returned a MALFORMED_QUERY error. Please make sure you are entering valid data or use the help link below to contact Zapier support for more information / assistance.
+11Sorry to hear you’re getting a “MALFORMED_QUERY” error with that approach
The Find Record by Query action has a field that looks like it should allow you to set the maximum number of records that are returned:
Can you try setting that field to 1 and let us know whether that does the trick?
You are right, when I use a different action Find record (singular) I can enter the maximum number. Thanks a lot, now I can use it for the next steps.
+11That’s great news,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.