Newer Version Available

This content describes an older version of this product. View Latest

API Field Properties

Fields on objects represent the details of each object and are analogous to columns in a database table. Each field on each object has one or more of the following properties:

Property Description
Autonumber The API creates an autonumber.
Create Value for the field can be specified during create using the API.
Defaulted on create When created, a default value is supplied if no other value is specified.
Delete Value for the field can be deleted using the API.
Filter Can be used as filter criteria in a SOQL query FROM or WHERE clause.
Group Can be included in the GROUP BY clause of a SOQL query (true) or not (false). Available in API version 18.0 and later.
idLookup Can be used to specify a record in an upsert call. The Id field of each object has this property and some Name fields. There are exceptions, so check for the property in any object you wish to upsert.
Nillable The field can contain a null value.
Query The field can be queried with SOQL using the API.
Replicate The value of the field can be replicated using the API.
Restricted picklist A picklist whose values are restricted to those values defined by a Salesforce admin. Users can’t load unapproved values through the API.
Retrieve Value of the field can be retrieved using the API.
Search Indicates whether the object can be searched via the API.
Sort Indicates whether a query can sort on this field (true) or not (false).
Update Can be updated using the API.