Skip to main content
  • Home
  • Get Help
  • Troubleshooting
  • Salesforce error: Could not find any records of "Account" object: Salesforce returned a MALFORMED_QUERY error

I’m trying to upload Files to a Salesforce Account record based on the inputs from a digital form. Because a user will not know the exact string that their account is set as in the org, I figured the Salesforce SOQL could use a LIKE operator to find similar strings to upsert on.

 

However, I’m getting a malformed query error. Has someone done something similar before?

 

Hi @realjustinjax 

Help: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_conditionexpression.htm

 

Use the Find Object by Query Search

Tips for building a SOQL WHERE clause for your search:

  • Confirm all fields included in your query have appropriate field accessibility and aren’t hidden.
  • Fields names don’t have to be wrapped with quotation marks.
  • Field values should usually be inside single quotation marks (e.g. 'John Doe').
  • Avoid using double quotation marks (").

WHERE clause examples:

  • Name = 'John Doe' AND Status = 'Active'
  • CreatedDate > 2011-04-26T10:00:00:08:00
  • Name LIKE 'A%'

Reply


Terms & Conditions