API Data Provider - Online Help

Drip Tables

The provider models the data in API into a list of tables that can be queried using standard SQL statements.

Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

Drip Tables

Name Description
Accounts Gets the latest chart of accounts for a company
Broadcasts List all broadcasts of your account
Campaigns List all campaigns of your account
Conversions List all conversions of your account
Forms List all forms of your account
Subscribers List all Subscribers of your account
User Fetch the authenticated user
Webhooks List all Webhooks
Workflows List all workflows
WorkflowTriggers List all workflow triggers

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