DavidSmithnz / sosl_flow_component

SOSL flow component for Salesforce
GNU General Public License v3.0
3 stars 0 forks source link

Apex Error #1

Open NormCopeland opened 2 years ago

NormCopeland commented 2 years ago

Hi @DavidSmithnz , first off, I apologize if this is not the right place to get some help with this component. Let me know if there's a better place to seek assistance. Thanks so much for making this component available. I've been testing this apex action and am getting this error: An Apex error occurred: System.QueryException: line 1:11 mismatched character '&' expecting '}'

I've tried to narrow down where the error lies but have been unable. Is this an issue in the apex or in the values I assigned to the component?

Screen Shot 2021-12-10 at 11 10 46

esnorris commented 1 year ago

We are experiencing similar errors utilizing this from a chatbot. Seems like special characters need to be escaped out of the search query.

Examples:

We're getting around this with a gnarly substitute formula in our flow, but this could be more performant if it was baked into the code.

Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_sosl_find.htm

image

mike-cleaver commented 1 year ago

@esnorris, @NormCopeland can you attach the debug log for the sosl lookup? we are looking for anything starting with '### SoslInvocableMethod'

NormCopeland commented 1 year ago

@mike-cleaver @esnorris Sorry, it's been over a year since I tried to implement this and ended up going in a different direction. I don't have access to the logs.