JDBC Driver for Highrise

Build 22.0.8462

CustomFields

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

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462