Excel Add-In for Cvent

Build 26.0.9655

CustomFields

Returns data from the CustomFields table.

Table Specific Information

SELECT

The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:

  • Id supports =,!=
  • Code supports =,!=
  • Category supports =
  • LastModified supports =,!=,>,<,>=,<=

All other filters are handled client-side. The following is an example of a SELECT statement: 

select * from CustomFields where Id='lastNameValue' or LastModified <= '06/11/2020'

INSERT

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

UPDATE

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655