Limitations

Following are the limitations:

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