Product fields represent the near-complete schema for a product in the context of the company of the authorized user. Each company can have a different schema for their products, with various custom fields. In the context of using product fields as a schema for defining the data fields of a product, it must be kept in mind that some types of custom fields can have additional data fields which are not separate product fields per se. Such is the case with monetary, daterange and timerange fields – each of these fields will have one additional data field in addition to the one presented in the context of product fields. For example, if there is a monetary field with the key ffk9s9
stored on the account, ffk9s9
would hold the numeric value of the field, and ffk9s9_currency
would hold the ISO currency code that goes along with the numeric value. To find out which data fields are available, fetch one product and list its keys.
Returns data about all product fields.
/v1/productFields
start
integer
Pagination start
Default
0
limit
integer
Items shown per page
OK
Returns data about a specific product field.
/v1/productFields/{id}
id
integer
required
The ID of the product field
OK
Adds a new product field. For more information, see the tutorial for adding a new custom field.
/v1/productFields
application/json
name
string
required
The name of the field
options
array
When field_type
is either set
or enum
, possible options must be supplied as a JSON-encoded sequential array, for example:[{"label":"red"}, {"label":"blue"}, {"label":"lilac"}]
field_type
string
required
The type of the field
Value | Description |
---|---|
varchar | Text (up to 255 characters) |
varchar_auto | Autocomplete text (up to 255 characters) |
text | Long text (up to 65k characters) |
double | Numeric value |
monetary | Monetary field (has a numeric value and a currency value) |
date | Date (format YYYY-MM-DD) |
set | Options field with a possibility of having multiple chosen options |
enum | Options field with a single possible chosen option |
user | User field (contains a user ID of another Pipedrive user) |
org | Organization field (contains an organization ID which is stored on the same account) |
people | Person field (contains a product ID which is stored on the same account) |
phone | Phone field (up to 255 numbers and/or characters) |
time | Time field (format HH:MM:SS) |
timerange | Time-range field (has a start time and end time value, both HH:MM:SS) |
daterange | Date-range field (has a start date and end date value, both YYYY-MM-DD) |
address | Address field |
Values
varchar
varchar_auto
text
double
monetary
date
set
enum
user
org
people
phone
time
timerange
daterange
address
Created
Updates a product field. For more information, see the tutorial for updating custom fields' values.
/v1/productFields/{id}
id
integer
required
The ID of the product field
application/json
name
string
The name of the field
options
array
When field_type
is either set or enum, possible options on update must be supplied as an array of objects each containing id and label, for example: [{"id":1, "label":"red"},{"id":2, "label":"blue"},{"id":3, "label":"lilac"}]
OK
Marks multiple fields as deleted.
/v1/productFields
ids
string
required
The comma-separated field IDs to delete
OK
Marks a product field as deleted. For more information, see the tutorial for deleting a custom field.
/v1/productFields/{id}
id
integer
required
The ID of the product field
OK