Are the field names and the object name used in the object's SOQL query case sensitive?


Answer.

  • The fields names used in an object's SOQL select statements are case insensitive. So the query: "SELECT id, NAme FROM Account" should be correct as well.

  • The object names used in a SOQL are case sensitive. So the query: "SELECT id, Name FROM ACCOUNT" should not be handled correctly.

Despite this, there are several exceptions when case of SOQL fields is important:

  • For the Fields Mapping and Data Anonymization, you need to specify fields and object names exactly, because they are case sensitive.
  • When listing sObject field(s) in an externalId setting, it is crucial to ensure that the fields are spelled correctly, as this setting is case-sensitive.
Last updated on 13th Nov 2023