API Data Provider - Online Help
Ontraport Profile
Connecting to Ontraport
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
Campaigns
Contacts
CreditCards
Forms
Groups
LandingPages
Messages
Offers
Order
Products
Rules
Tasks
Transactions
Webhooks
Offers
Returns the list of offers.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
IsPublic
Boolean
Data
String