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. |