Custom API Field Exceptions

APIs can be used to update and call any data fields which can normally be imported, derived / calculated fields cannot be inserted or updated via APIs.

Since APIs interact directly with the database there are certain fields which need to be called differently when used to call fields in a list, used as part of a filter or when updating fields.

Gender - Internally stored as Sex

State - For English state names / abbreviations this is internally stored as State2