JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

Contacts

Retrieve all contacts in Salesforce Marketing Cloud.

Table Specific Information

Select

Retrieve all contacts:

SELECT * FROM Contacts
Note: Most columns for this table are dynamic so they may not be the same as the columns specified below because you can have a different Contact schema in your Salesforce marketing cloud account.
Contacts that are in a deleted, deleting, or restricted state are not retrieved.

Columns

Name Type References Description
GroupConnect LINE Demographics.Address ID String This is an autogenerated description
GroupConnect LINE Demographics.Contact ID Long This is an autogenerated description
GroupConnect LINE Demographics.Contact Key String This is an autogenerated description
Contact.Contact ID [KEY] Int The system defined identifier of the contact.
Contact.Contact Key String The user defined identifier of the contact.
Email Demographics.Contacts ID Long This is an autogenerated description
Email Demographics.NewAttrTest String Test new attr
Email Demographics.NewAttrTest1 String New Attr test
Email Demographics.NewAttrTest 2 String NewAttrTest 2
Email Demographics.tet String test
Email Addresses.Email Address String This is an autogenerated description
Email Addresses.HTML Enabled Bool This is an autogenerated description
MobileConnect Demographics.Contact ID Long This is an autogenerated description
MobileConnect Demographics.Locale String This is an autogenerated description
MobileConnect Demographics.Mobile Number String This is an autogenerated description
MobilePush Demographics.Application String This is an autogenerated description
MobilePush Demographics.Contact ID Long This is an autogenerated description
MobilePush Demographics.Device ID String This is an autogenerated description
Contact.Business Unit ID Int This is an autogenerated description
Email Addresses.Member ID Int This is an autogenerated description
Email Addresses.List ID Int This is an autogenerated description

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462