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 rollback 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
    • There is support for AND and OR operation conditional operators only for Accounts and Contacts entities
    • There is support for only AND conditional operator. It does not work for rest of the entities on the column
    • = filter does not always work on fields having timestamp data type