API Data Provider - Online Help
Drift Profile
Connecting to Drift
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
Accounts
Contacts
ContactTags
ConversationMessages
Conversations
ConversationStatus
CustomAttributes
Users
ContactTags
Retrieving details of Contact via contactId
Columns
Name
Type
References
Color
String
Name
String
Contacts
.Name
ContactId
Integer
Contacts
.Id