Exhibitors
Returns data from the Exhibitor 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 Exhibitors where Id='cventId' or Created <= '06/11/2020'The following is an example of an INSERT statement:
INSERT INTO Exhibitors (EventId, Name)
VALUES('DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD', 'exhibitorName')
The following is an example of an UPDATE statement:
UPDATE Exhibitors EventId = 'DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD', name = 'UpdatedName', EventId='e0ce6b11-2c5c-48b2-8104-b71ace5eed13' where EventId='DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD' and ID='462af84e-be35-4082-ac38-3cda475dd1de'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. | |
| 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. |