SSIS Components for Cvent

Build 24.0.9060

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.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060