Navigation: » No topics above this level «

eComOrders: eCommerce Orders

Name: eComOrders

Catalog: ActiveCampaign

Schema: V3

Primary Keys: id

Label: eCommerce Orders

Partition-specific: false

Select: true

Insert: true

Update: true

Delete: true

Select Service URL (OData-specific): /ecomOrders

Insert Service URL (OData-specific): /ecomOrders

Update Service URL (OData-specific): /ecomOrders

Delete Service URL (OData-specific): /ecomOrders

Field Selection Method (OData-specific): NotRequired

Base Path (OData-specific): ecomOrders[*]

Table Columns

Name	Data Type	Label	Required
connection	int64	Connection	☑
connectionid	int64	Connection ID	☑
createdDate	datetime	Created	☑
currency	string	Currency	☑
customer	int64	Customer	☑
customerid	int64	Customer ID	☑
discountAmount	int64	Discount Amount	☑
email	string	Email Address	☑
externalcheckoutid	string	itgen_acn_externalcheckoutid	☐
externalCreatedDate	datetime	itgen_acn_externalcreateddate	☑
externalid	string	External ID	☑
id	int64	ID	☑
orderDate	datetime	Order Date	☑
orderProducts	int64	Order Products	☑
orderUrl	string	Order URL	☑
shippingAmount	int64	Shipping Amount	☑
shippingMethod	int64	Shipping Method	☑
source	int64	Source	☑
state	int64	State	☑
taxAmount	int64	Tax Amount	☑
totalPrice	int64	Total Price	☑
totalProducts	int64	Total Products	☑
tstamp	datetime	itgen_acn_tstamp	☑
updatedDate	datetime	Last Updated	☑

14-05-2020 17:1120.1.36-BETA+2798