Contacts
Returns data from the Contacts 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 contacts where LastName='lastNameValue' or Created <= '06/11/2020'The following is an example of an INSERT statement:
INSERT INTO Contacts (firstName, lastName, email, HomeAddressAddress1, HomeAddressCity, HomeAddressCountry) VALUES('MateoMateov222', 'Villa2sds2222', '[email protected]', 'address1val', 'cityVal', 'countryVal')The following is an example of an UPDATE statement:
UPDATE contacts SET firstName= 'updatedFirstName' where id = '80B7A193-A807-4B7E-BFEA-787E86DFB40D'The following is an example of a DELETE statement:
DELETE FROM contacts where id = '80B7A193-A807-4B7E-BFEA-787E86DFB40D'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The Id of the Contacts table. | |
ParentId | String | False |
The ParentId of the Contacts table. | |
FirstName | String | False |
The FirstName of the Contacts table. | |
LastName | String | False |
The LastName of the Contacts table. | |
MiddleName | String | False |
The MiddleName of the Contacts table. | |
Nickname | String | False |
The Nickname of the Contacts table. | |
String | False |
The Email of the Contacts table. | ||
CcEmail | String | False |
The CcEmail of the Contacts table. | |
Gender | String | False |
The Gender of the Contacts table. | |
Company | String | False |
The Company of the Contacts table. | |
Designation | String | False |
The Designation of the Contacts table. | |
Title | String | False |
The Title of the Contacts table. | |
PrimaryAddressType | String | False |
The PrimaryAddressType of the Contacts table. | |
HomePhone | String | False |
The HomePhone of the Contacts table. | |
HomeFax | String | False |
The HomeFax of the Contacts table. | |
WorkPhone | String | False |
The WorkPhone of the Contacts table. | |
WorkFax | String | False |
The WorkFax of the Contacts table. | |
SourceId | String | False |
The SourceId of the Contacts table. | |
MobilePhone | String | False |
The MobilePhone of the Contacts table. | |
Prefix | String | False |
The Prefix of the Contacts table. | |
Pager | String | False |
The Pager of the Contacts table. | |
Deleted | Boolean | False |
The Deleted of the Contacts table. | |
Npi | String | False |
The Npi of the Contacts table. | |
DateOfBirth | Datetime | False |
The DateOfBirth of the Contacts table. | |
PassportNumber | String | False |
The PassportNumber of the Contacts table. | |
SocialSecurityNumber | String | False |
The SocialSecurityNumber of the Contacts table. | |
NationalIdentificationNumber | String | False |
The NationalIdentificationNumber of the Contacts table. | |
Headline | String | False |
The Headline of the Contacts table. | |
PersonalWebsite | String | False |
The PersonalWebsite of the Contacts table. | |
Biography | String | False |
The Biography of the Contacts table. | |
Pronouns | String | False |
The Pronouns of the Contacts table. | |
Created | Datetime | False |
The Created of the Contacts table. | |
CreatedBy | String | False |
The CreatedBy of the Contacts table. | |
LastModified | Datetime | False |
The LastModified of the Contacts table. | |
LastModifiedBy | String | False |
The LastModifiedBy of the Contacts table. | |
EventId | String | False |
The EventId of the Contacts table. | |
TypeId | String | False |
The TypeId of the Contacts table. | |
TypeName | String | False |
The TypeName of the Contacts table. | |
MembershipType | String | False |
The MembershipType of the Contacts table. | |
MembershipPlan | String | False |
The MembershipPlan of the Contacts table. | |
MembershipJoined | String | False |
The MembershipJoined of the Contacts table. | |
MembershipExpiration | String | False |
The MembershipExpiration of the Contacts table. | |
MembershipLastRenewal | String | False |
The MembershipLastRenewal of the Contacts table. | |
MembershipAmountDue | String | False |
The MembershipAmountDue of the Contacts table. | |
MembershipListInDirectory | String | False |
The MembershipListInDirectory of the Contacts table. | |
HomeAddressRegion | String | False |
The HomeAddressRegion of the Contacts table. | |
HomeAddressRegionCode | String | False |
The HomeAddressRegionCode of the Contacts table. | |
HomeAddressCountry | String | False |
The HomeAddressCountry of the Contacts table. | |
HomeAddressAddress1 | String | False |
The HomeAddressAddress1 of the Contacts table. | |
HomeAddressAddress2 | String | False |
The HomeAddressAddress2 of the Contacts table. | |
HomeAddressAddress3 | String | False |
The HomeAddressAddress3 of the Contacts table. | |
HomeAddressCity | String | False |
The HomeAddressCity of the Contacts table. | |
HomeAddressCountryCode | String | False |
The HomeAddressCountryCode of the Contacts table. | |
HomeAddressPostalCode | String | False |
The HomeAddressPostalCode of the Contacts table. | |
WorkAddressRegion | String | False |
The WorkAddressRegion of the Contacts table. | |
WorkAddressRegionCode | String | False |
The WorkAddressRegionCode of the Contacts table. | |
WorkAddressCountry | String | False |
The WorkAddressCountry of the Contacts table. | |
WorkAddressAddress1 | String | False |
The WorkAddressAddress1 of the Contacts table. | |
WorkAddressAddress2 | String | False |
The WorkAddressAddress2 of the Contacts table. | |
WorkAddressAddress3 | String | False |
The WorkAddressAddress3 of the Contacts table. | |
WorkAddressCity | String | False |
The WorkAddressCity of the Contacts table. | |
WorkAddressCountryCode | String | False |
The WorkAddressCountryCode of the Contacts table. | |
WorkAddressPostalCode | String | False |
The WorkAddressPostalCode of the Contacts table. | |
ComplianceAggregate | String | False |
The ComplianceAggregate of the Contacts table. | |
OptOutOptedOut | String | False |
The OptOutDate of the Contacts table. | |
OptOutDate | String | False |
The OptOut of the Contacts table. | |
OptOutBy | String | False |
The OptOut of the Contacts table. |