CustomFields
Returns data from the CustomFields table.
Table Specific Information
The Cvent API allows you to filter by certain fields when querying for data.
The following is an example of a SELECT statement:
select * from CustomFields where Id='lastNameValue' or LastModified <= '06/11/2020'The following is an example of an INSERT statement:
INSERT INTO CustomFields (category, name, code, type)
VALUES('Contact', 'Villa2sds2222', 'customfieldName', 'uniqueCode', 'cityVal', 'Open Ended Text - Comment Box')
The following is an example of an UPDATE statement:
UPDATE CustomFields SET name= 'updatedFirstName' where id = '80B7A193-A807-4B7E-BFEA-787E86DFB40D'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The Id of the CustomFields table. | |
| Category | String | False |
The Category of the CustomFields table. | |
| Name | String | False |
The Name of the CustomFields table. | |
| Code | String | False |
The Code of the CustomFields table. | |
| Required | Boolean | False |
The Required of the CustomFields table. | |
| Type | String | False |
The Type of the CustomFields table. | |
| Order | String | False |
The Order of the CustomFields table. | |
| HelpText | String | False |
The HelpText of the CustomFields table. | |
| DisplayInDataTag | String | False |
The DisplayInDataTag of the CustomFields table. | |
| DefaultTagText | String | False |
The DefaultTagText of the CustomFields table. | |
| ConsentField | Boolean | False |
The ConsentField of the CustomFields table. | |
| DisplayInEventCreationWizard | Boolean | False |
The DisplayInEventCreationWizard of the CustomFields table. | |
| Created | Datetime | False |
The Created of the CustomFields table. | |
| CreatedBy | String | False |
The CreatedBy of the CustomFields table. | |
| LastModified | Datetime | False |
The LastModified of the CustomFields table. | |
| LastModifiedBy | String | False |
The LastModifiedBy of the CustomFields table. | |
| DetailsAnswerFormat | String | False |
The DetailsAnswerFormat of the CustomFields table. | |
| DetailsMinimum | String | False |
The DetailsMinimum of the CustomFields table. | |
| DetailsMaximum | String | False |
The DetailsMaximum of the CustomFields table. |