Limitations
Note these limitations:
- Create/Update:
- Insert/Upsert fails if Not Null columns are blank or do not exist
- Insert/Upsert fails if values of Unique columns are not unique for a particular batch
- In order to avoid a rolback exception, keep the value of Batch count to commit to 1
- Read:
- For custom entities, Select operation is only applicable on joins with Contacts entity
- Filter:
- Supported filters are =, !=, >, <, >=, <=
- There is no support for IN and NOT IN condition operators when providing more than one values
- There is no support for Joins between entities
- OR conditional operator is supported only for Accounts and Contacts entities
- AND conditional operator can be used only between two conditions
- = filter does not always work on fields having timestamp data type