Orders: ActiveCampaign Orders
Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.
insert REST
- Catalog:
ActiveCampaign - Schema:
CustomObjects - Primary Keys:
id - Label: Orders
Can retrieve data and change data using insert.
Summary
Orders imported into ActiveCampaign
API Source
- Endpoint:
/customObjects/records/42376388-ff77-49e2-a175-fd92566d749c
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 264 |
| Full scan rows per minute | 13,400 |
The result can be cached on the client.
Table Columns
The columns of the table Orders 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 |
|---|---|---|---|---|---|
accepts_ |
varchar2 |
Accepts Marketing | filters on the platform, writable, fields[? |
Accepts Marketing | |
cart_ |
varchar2 |
Cart ID | filters on the platform, writable, fields[? |
Cart ID | |
connection_ |
varchar2 |
Connection ID | filters on the platform, writable, fields[? |
Connection ID | |
created |
datetime |
Created | filters on the platform, writable, computed | Moment of creation. | |
created_ |
varchar2 |
Created by Recurring Payment | filters on the platform, writable, fields[? |
Created By Recurring Payment | |
creation_ |
varchar2 |
Creation Source | filters on the platform, writable, fields[? |
Creation Source | |
customer_ |
varchar2 |
Customer Locale | filters on the platform, writable, fields[? |
Customer Locale | |
customer_ |
varchar2 |
itgen_acn_customer_phone | filters on the platform, writable, fields[? |
Customer Phone | |
discounts |
varchar2 |
Discounts | filters on the platform, writable, fields[? |
Order Discount | |
discounts_ |
decimal |
Discounts Amount | filters on the platform, writable, fields[? |
Discounts Amount | |
discounts_ |
varchar2 |
Discounts Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column discounts_amount. | |
email |
varchar2 |
Email Address | filters on the platform, writable, fields[? |
||
field_ |
varchar2 |
Field Billing Address Address 1 | filters on the platform, writable, fields[? |
Billing Address Address Line 1 | |
field_ |
varchar2 |
Field Billing Address Address 2 | filters on the platform, writable, fields[? |
Billing Address Address Line 2 | |
field_ |
varchar2 |
Field Billing Address Address 3 | filters on the platform, writable, fields[? |
Billing Address Address Line 3 | |
field_ |
varchar2 |
Field Billing Address City | filters on the platform, writable, fields[? |
Billing Address City | |
field_ |
varchar2 |
Field Billing Address Company | filters on the platform, writable, fields[? |
Billing Address Company | |
field_ |
varchar2 |
Field Billing Address Country | filters on the platform, writable, fields[? |
Billing Address Country | |
field_ |
varchar2 |
Field Billing Address Email | filters on the platform, writable, fields[? |
Billing Address Email | |
field_ |
varchar2 |
Field Billing Address First Name | filters on the platform, writable, fields[? |
Billing Address First Name | |
field_ |
varchar2 |
Field Billing Address Last Name | filters on the platform, writable, fields[? |
Billing Address Last Name | |
field_ |
varchar2 |
Field Billing Address Phone | filters on the platform, writable, fields[? |
Billing Address Phone Number | |
field_ |
varchar2 |
Field Billing Address Postal | filters on the platform, writable, fields[? |
Billing Address Postal Code | |
field_ |
varchar2 |
Field Billing Address Province | filters on the platform, writable, fields[? |
Billing Address Province | |
field_ |
varchar2 |
Field Shipping Address Address 1 | filters on the platform, writable, fields[? |
Shipping Address Address Line 1 | |
field_ |
varchar2 |
Field Shipping Address Address 2 | filters on the platform, writable, fields[? |
Shipping Address Address Line 2 | |
field_ |
varchar2 |
Field Shipping Address Address 3 | filters on the platform, writable, fields[? |
Shipping Address Address Line 3 | |
field_ |
varchar2 |
Field Shipping Address City | filters on the platform, writable, fields[? |
Shipping Address City | |
field_ |
varchar2 |
Field Shipping Address Company | filters on the platform, writable, fields[? |
Shipping Address Company | |
field_ |
varchar2 |
Field Shipping Address Country | filters on the platform, writable, fields[? |
Shipping Address Country | |
field_ |
varchar2 |
Field Shipping Address Email | filters on the platform, writable, fields[? |
Shipping Address Email | |
field_ |
varchar2 |
Field Shipping Address First Name | filters on the platform, writable, fields[? |
Shipping Address First Name | |
field_ |
varchar2 |
Field Shipping Address Last Name | filters on the platform, writable, fields[? |
Shipping Address Last Name | |
field_ |
varchar2 |
Field Shipping Address Phone | filters on the platform, writable, fields[? |
Shipping Address Phone | |
field_ |
varchar2 |
Field Shipping Address Postal | filters on the platform, writable, fields[? |
Shipping Address Postal | |
field_ |
varchar2 |
Field Shipping Address Province | filters on the platform, writable, fields[? |
Shipping Address Province | |
final_ |
decimal |
Final Amount | filters on the platform, writable, fields[? |
Final Amount | |
final_ |
varchar2 |
Final Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column final_amount. | |
id |
varchar2 |
ID | filters on the platform, writable, computed | Unique ID of the record, in the form of a GUID. | |
is_ |
varchar2 |
Is Test Order | filters on the platform, writable, fields[? |
Is Test Order | |
legacy_ |
int64 |
Legacy Connection ID | filters on the platform, writable, fields[? |
Legacy Connection ID | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, fields[? |
Location ID | |
normalized_ |
varchar2 |
Normalized Status | filters on the platform, writable, fields[? |
Order Status | |
notes |
varchar2 |
Notes | filters on the platform, writable, fields[? |
Notes | |
order_ |
varchar2 |
Order Number | filters on the platform, writable, fields[? |
Order Number | |
order_ |
varchar2 |
Order URL | filters on the platform, writable, fields[? |
Order URL | |
payment_ |
varchar2 |
Payment Method | filters on the platform, writable, fields[? |
Payment Method | |
primary_ |
varchar2 |
Primary Contact | filters on the platform, writable, relationships. |
Contact for Order | |
sales_ |
varchar2 |
Sales Channel | filters on the platform, writable, fields[? |
Channel | |
schema |
varchar2 |
Schema ID | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. | |
shipping_ |
decimal |
Shipping Amount | filters on the platform, writable, fields[? |
Shipping Amount | |
shipping_ |
varchar2 |
Shipping Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column shipping_amount. | |
shipping_ |
varchar2 |
Shipping Method | filters on the platform, writable, fields[? |
Shipping Method | |
store_ |
datetime |
Store Created Date | filters on the platform, writable, fields[? |
Store Created Date | |
store_ |
varchar2 |
Store Customer ID | filters on the platform, writable, fields[? |
Store's Customer ID | |
store_ |
varchar2 |
Store External Order ID | filters on the platform, writable, fields[? |
Store's External Order ID | |
store_ |
datetime |
Store Modified Date | filters on the platform, writable, fields[? |
Store Modified Date | |
store_ |
varchar2 |
Store Order ID | filters on the platform, writable, fields[? |
Store's Order ID | |
store_ |
varchar2 |
Store Status | filters on the platform, writable, fields[? |
Store's Order Status | |
updated |
datetime |
Last Modified | filters on the platform, writable, computed | Moment of last change. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:
Änderungen an dieser Tabelle, 26.0 bis 27.0
Die Tabelle ActiveCampaign.CustomObjects.Orders wurde hinzugefügt
Die Tabelle verfügt über 60 Spalten und unterstützt die Befehle „select“ und „insert“.
- Bedeutung 3