SFDMU Help CenterAre field names and object names in a SOQL query case sensitive?
Answer.
The field names used in an object's SOQL select statements are case-insensitive. Therefore, the query: "SELECT id, NAme FROM Account" should be correct.
The object names used in SOQL are case-sensitive. Therefore, the query: "SELECT id, Name FROM ACCOUNT" may not be handled correctly.
Despite this, there are several exceptions where the case of SOQL fields is important:
- For Fields Mapping and Data Anonymization, you need to specify fields and object names exactly as 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.