invantive documentation
Forum di supporto InvantiveAccedi / Registrati

eComOrders: ActiveCampaign eCommerce Orders

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

insert update delete REST

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

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

API Source

  • Endpoint: /ecomOrders

Performance Characteristics

Characteristic Value
Average access latency (ms) 264
Full scan rows per minute 3,770

The result can be cached on the client.

Table Columns

The columns of the table eComOrders 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
connection int64 Connection filters on the platform, writable
connectionid int64 Connection ID filters on the platform, writable
createdDate datetime Created filters on the platform, writable, computed
currency varchar2 Currency filters on the platform, writable
customer int64 Customer filters on the platform, writable
customerid int64 Customer ID filters on the platform, writable
discountAmount int64 Discount Amount filters on the platform, writable
email varchar2 Email Address filters on the platform, writable
externalCreatedDate datetime External Created Date filters on the platform, writable
externalcheckoutid varchar2 External Checkout ID filters on the platform, writable
externalid varchar2 External ID filters on the platform, writable
id int64 ID filters on the platform, writable, computed
orderDate datetime Order Date filters on the platform, writable
orderProducts int64 Order Products filters on the platform, writable
orderUrl varchar2 Order URL filters on the platform, writable
shippingAmount int64 Shipping Amount filters on the platform, writable
shippingMethod int64 Shipping Method filters on the platform, writable
source int64 Source filters on the platform, writable
state int64 State filters on the platform, writable
taxAmount int64 Tax Amount filters on the platform, writable
totalPrice int64 Total Price filters on the platform, writable Total sales amount including VAT in smallest unit, typically cents.
totalProducts int64 Total Products filters on the platform, writable
tstamp datetime Tstamp filters on the platform, writable
updatedDate datetime Last Updated filters on the platform, writable, computed

Keys

Key Column Refers to Kind Description
eComOrders_connectionid_cnd connectionid Connections.id Candidate Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
eComOrders_customerid_cnd customerid eComCustomers.id Candidate Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.

Referenced By

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: