TDV Adapter for Highrise

Build 21.0.8137


Return all custom fields used in the account.

Table Specific Information


Retrieve Custom Fields created for your account.

SELECT * FROM CustomFields

You can also retrieve Custom Fields by type.

SELECT * FROM CustomFields WHERE type='deal'


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')


Change the Label of a field by providing its Id.

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


Delete a Custom Field by specifying its Id.

DELETE FROM CustomFields WHERE Id='4321'


Name Type ReadOnly References Description
Id [KEY] Integer True

The unique identifier of the custom field.

Label String False

The label for the custom field.

Type String True

The type for the custom field.

The allowed values are party, deal.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137