invantive documentation
Invantive Support ForumsLog In / Sign Up

eComCustomers: ActiveCampaign eCommerce Customers

insert update delete REST

  • Catalog: ActiveCampaign
  • Schema: V3
  • Primary Keys: id
  • Label: eCommerce Customers

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /ecomCustomers

Performance Characteristics

Characteristic Value
Average access latency (ms) 211
Full scan rows per minute 8,320

The result can be cached on the client.

Table Columns

The columns of the table eComCustomers are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
acceptsMarketing int64 Accepts Marketing filters on the platform, writable
avgProductCategory varchar2 Average Product Category filters on the platform, writable
avgRevenuePerOrder int64 Average Revenue per Order filters on the platform, writable
connection int64 Connection filters on the platform, writable
connectionid int64 Connection ID filters on the platform, writable
email varchar2 Email Address filters on the platform, writable
externalid varchar2 External ID filters on the platform, writable
id int64 ID filters on the platform, writable, computed
totalOrders int64 Total Orders filters on the platform, writable
totalProducts int64 Total Products filters on the platform, writable
totalRevenue int64 Total Revenue filters on the platform, writable
tstamp datetime Tstamp filters on the platform, writable

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: