KNOWLEDGE BASE

Error "MALFORMED_QUERY" When Connecting to Salesforce Custom Query


Published: 18 Dec 2023
Last Modified Date: 18 Dec 2023

Issue

When connecting to a custom query for a Salesforce data source, the following error may occur:

Unable to complete action
An unknown error related to remote content was detected (500)
Error Code: 621E4DE8
MALFORMED_QUERY

Environment

  • Tableau Desktop
  • Salesforce.com

Resolution

Use the Developer Console in Salesforce to validate and build SOQL queries. For instructions, see Get Started with SOQL Queries.

Note: You will need a Trailblazer account (which you can set up for free) to access the content on the above page.

For information about the user permissions needed to use the Developer Console, see Open the Developer Console.

 

Cause

Salesforce Object Query Language (SOQL) doesn’t support all advanced features of the SQL SELECT command. For example, as stated in this Salesforce document, you can’t use SOQL to perform arbitrary join operations, use wildcards in field lists, or use calculation expressions. 

For instance, the UNION operator and aliasing fields are not supported in SOQL. Read more at:
Did this article resolve the issue?