Exhibitors

Returns data from the Exhibitor 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 =
Deleted supports =
EventId supports =,!=

All other filters are handled client-side.

The following is an example of a SELECT statement:

SELECT * FROM Exhibitors WHERE Id='cventId' OR Created <= '06/11/2020'

INSERT

The following is an example of an INSERT statement:

INSERT INTO Exhibitors (EventId, Name) 
VALUES('DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD', 'exhibitorName')

UPDATE

The following is an example of an UPDATE statement:

UPDATE Exhibitors SET name = 'UpdatedName', EventId='e0ce6b11-2c5c-48b2-8104-b71ace5eed13'
 WHERE EventId='DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD' AND ID='462af84e-be35-4082-ac38-3cda475dd1de'

DELETE

The following is an example of a DELETE statement:

DELETE FROM Exhibitors where EventId='DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD' and id = 'attendeeId'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Id of the Exhibitor table.
ProfileLogoId	String	False		The ProfileLogoId of the BudgetTotals table.
ProfileLogoUrl	String	False		The ProfileLogoUrl of the Exhibitor table.
BannerId	String	False		The BannerId of the Exhibitor table.
BannerUrl	String	False		The BannerUrl of the Exhibitor table.
Name	String	False		The Name of the Exhibitor table.
Description	String	False		The Description of the Exhibitor table.
Code	String	False		The Code of the Exhibitor table.
SourceId	String	False		The SourceId of the Exhibitor table.
Location	String	False		The Location of the Exhibitor table.
Email	String	False		The Email of the Exhibitor table.
MobilePhone	String	False		The MobilePhone of the Exhibitor table.
WorkPhone	String	False		The WorkPhone of the Exhibitor table.
OtherPhone	String	False		The OtherPhone of the Exhibitor table.
Website	String	False		The Website of the Exhibitor table.
Created	Datetime	False		The Created of the Exhibitor table.
CreatedBy	String	False		The CreatedBy of the Exhibitor table.
LastModified	Datetime	False		The LastModified of the Exhibitor table.
LastModifiedBy	String	False		The LastModifiedBy of the Exhibitor table.
Deleted	Boolean	False		The Deleted of the Exhibitor table.
EventSponsor	Boolean	False		The EventSponsor of the Exhibitor table.
Featured	Boolean	False		The Featured of the Exhibitor table.
EventId	String	False	Events.Id	The EventId of the Exhibitor table.
AddressAddress1	String	False		The AddressAddress1 of the Exhibitor table.
AddressAddress2	String	False		The AddressAddress2 of the Exhibitor table.
AddressCity	String	False		The AddressCity of the Exhibitor table.
AddressRegion	String	False		The AddressRegion of the Exhibitor table.
AddressPostalCode	String	False		The AddressPostalCode of the Exhibitor table.
AddressCountry	String	False		The AddressCountry of the Exhibitor table.
ContactLinksAggregate	String	False		The ContactLinksAggregate of the Exhibitor table.
SponsorshipLevelId	String	False		The SponsorshipLevelAggregate of the Exhibitor table.