Return all custom fields used in the account.

Table Specific Information

Select

Retrieve Custom Fields created for your account.

SELECT * FROM CustomFields

You can also retrieve Custom Fields by type.

SELECT * FROM CustomFields WHERE type = 'deal'

Insert

To insert a new Custom Field, provide the Label. Only Custom Fields of type 'party' can be created.

INSERT INTO CustomFields (Label) VALUES ('My new Custom Field')

Update

Change the Label of a field by providing its Id.

UPDATE CustomFields SET Label = 'Test' WHERE Id = '4321'

Delete

Delete a Custom Field by specifying its Id.

DELETE FROM CustomFields WHERE Id = '4321'

Columns