API Data Provider - Online Help
Dotmailer Profile
Connecting to Dotmailer
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Account
AddressBookCampaigns
AddressBookContacts
AddressBookContactsScoring
AddressBooks
CampaignActivity
CampaignAddressBooks
CampaignAttachments
CampaignClicks
CampaignClicksGroups
CampaignContactClicksLinkGroups
CampaignDetails
CampaignHardBouncer
CampaignOpens
Campaigns
CampaignSocialBookmarkViews
CampaignSummary
ContactAddressBooks
ContactCampaignActivity
ContactCampaignClicks
ContactCampaignOpens
ContactCampaignPageViews
ContactCampaignReplies
ContactCampaignROIActivity
ContactCampaignSocialBookmarkViews
ContactPreferences
Contacts
ContactScoring
DataFields
DocumentFolders
FolderDocuments
ImageFolders
Preferences
PrivateAddressBooks
Programs
PublicAddressBooks
Segments
SurveyFields
SurveyResponses
Surveys
Templates
Programs
Retrieves all programs
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
Status
String
DateCreated
Datetime