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 | ||
created |
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 | ||
discount |
int64 |
Discount Amount | filters on the platform, writable | ||
email |
varchar2 |
Email Address | filters on the platform, writable | ||
external |
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 | ||
order |
datetime |
Order Date | filters on the platform, writable | ||
order |
int64 |
Order Products | filters on the platform, writable | ||
order |
varchar2 |
Order URL | filters on the platform, writable | ||
shipping |
int64 |
Shipping Amount | filters on the platform, writable | ||
shipping |
int64 |
Shipping Method | filters on the platform, writable | ||
source |
int64 |
Source | filters on the platform, writable | ||
state |
int64 |
State | filters on the platform, writable | ||
tax |
int64 |
Tax Amount | filters on the platform, writable | ||
total |
int64 |
Total Price | filters on the platform, writable | Total sales amount including VAT in smallest unit, typically cents. | |
total |
int64 |
Total Products | filters on the platform, writable | ||
tstamp |
datetime |
Tstamp | filters on the platform, writable | ||
updated |
datetime |
Last Updated | filters on the platform, writable, computed |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
e |
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. |
e |
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
- eComOrderProducts
orderid(Candidate)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: