Contacts

Returns data from the Contacts 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 =,!=
FirstName supports =,!=
LastName supports =,!=,like
MiddleName supports =,!=,like
Nickname supports =,!=
Email supports =,!=,like
Company supports =,!=
Designation supports =,!=
Title supports =,!=
HomePhone supports =,!=
HomeFax supports =,!=
WorkPhone supports =,!=
WorkFax supports =,!=
SourceId supports =,!=
MobilePhone supports =,!=
Pager supports =,!=
Deleted supports =,!=
Created supports =,!=,>,<,>=,<=
CreatedBy supports =,!=
LastModified supports =,!=,>,<,>=,<=
LastModifiedBy supports =,!=

All other filters are handled client-side.

The following is an example of a SELECT statement:

SELECT * FROM Contacts WHERE LastName='lastNameValue' OR Created <= '06/11/2020'

INSERT

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

UPDATE

The following is an example of an UPDATE statement:

UPDATE Contacts SET firstName= 'updatedFirstName' WHERE id = '80B7A193-A807-4B7E-BFEA-787E86DFB40D'

DELETE

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