API Data Provider - Online Help
Keap Profile
Connecting to Keap
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
AffiliateClawbacks
AffiliateModel
AffiliatePayments
AffiliateRedirects
Affiliates
AffiliateSummaries
ApplicationConfiguration
AppointmentModel
Appointments
Campaigns
CommissionPrograms
Commissions
Companies
CompanyModel
ContactCreditCards
ContactEmails
ContactModel
Contacts
ContactTags
CurrentUser
Emails
Files
LocaleDefaultOptions
Merchants
NoteModel
Notes
Opportunities
OpportunityModel
OpportunityStagePipeline
OrderItems
OrderModel
OrderPayments
Orders
OrderTransactions
Products
ProductSubscriptions
SubscriptionModel
Subscriptions
TaggedCompanies
TaggedContacts
Tags
TaskModel
Tasks
Users
ContactTags
Retrieves a list of tags applied to a given contact
Columns
Name
Type
References
ContactId [KEY]
Integer
Contacts
.Id
TagId [KEY]
Integer
Tags
.Id
TagName
String
DateApplied
Datetime
TagCategory
String