invantive documentation
Invantive SupportforenAnmelden / Eintragen

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_marketing varchar2 Accepts Marketing filters on the platform, writable, fields[?(@.id=='accepts-marketing')].value Accepts Marketing
cart_id varchar2 Cart ID filters on the platform, writable, fields[?(@.id=='cart-id')].value Cart ID
connection_id varchar2 Connection ID filters on the platform, writable, fields[?(@.id=='connection-id')].value Connection ID
createdTimestamp datetime Created filters on the platform, writable, computed Moment of creation.
created_by_recurring_payment varchar2 Created by Recurring Payment filters on the platform, writable, fields[?(@.id=='created-by-recurring-payment')].value Created By Recurring Payment
creation_source varchar2 Creation Source filters on the platform, writable, fields[?(@.id=='creation-source')].value Creation Source
customer_locale varchar2 Customer Locale filters on the platform, writable, fields[?(@.id=='customer-locale')].value Customer Locale
customer_phone varchar2 itgen_acn_customer_phone filters on the platform, writable, fields[?(@.id=='customer-phone')].value Customer Phone
discounts varchar2 Discounts filters on the platform, writable, fields[?(@.id=='discounts')].value Order Discount
discounts_amount decimal Discounts Amount filters on the platform, writable, fields[?(@.id=='discounts-amount')].value Discounts Amount
discounts_amount_currency varchar2 Discounts Amount Currency filters on the platform, writable, fields[?(@.id=='discounts-amount')].currency Currency of the amount in column discounts_amount.
email varchar2 Email Address filters on the platform, writable, fields[?(@.id=='email')].value Email
field_billing_address_address_1 varchar2 Field Billing Address Address 1 filters on the platform, writable, fields[?(@.id=='field-billing-address-address-1')].value Billing Address Address Line 1
field_billing_address_address_2 varchar2 Field Billing Address Address 2 filters on the platform, writable, fields[?(@.id=='field-billing-address-address-2')].value Billing Address Address Line 2
field_billing_address_address_3 varchar2 Field Billing Address Address 3 filters on the platform, writable, fields[?(@.id=='field-billing-address-address-3')].value Billing Address Address Line 3
field_billing_address_city varchar2 Field Billing Address City filters on the platform, writable, fields[?(@.id=='field-billing-address-city')].value Billing Address City
field_billing_address_company varchar2 Field Billing Address Company filters on the platform, writable, fields[?(@.id=='field-billing-address-company')].value Billing Address Company
field_billing_address_country varchar2 Field Billing Address Country filters on the platform, writable, fields[?(@.id=='field-billing-address-country')].value Billing Address Country
field_billing_address_email varchar2 Field Billing Address Email filters on the platform, writable, fields[?(@.id=='field-billing-address-email')].value Billing Address Email
field_billing_address_first_name varchar2 Field Billing Address First Name filters on the platform, writable, fields[?(@.id=='field-billing-address-first-name')].value Billing Address First Name
field_billing_address_last_name varchar2 Field Billing Address Last Name filters on the platform, writable, fields[?(@.id=='field-billing-address-last-name')].value Billing Address Last Name
field_billing_address_phone varchar2 Field Billing Address Phone filters on the platform, writable, fields[?(@.id=='field-billing-address-phone')].value Billing Address Phone Number
field_billing_address_postal varchar2 Field Billing Address Postal filters on the platform, writable, fields[?(@.id=='field-billing-address-postal')].value Billing Address Postal Code
field_billing_address_province varchar2 Field Billing Address Province filters on the platform, writable, fields[?(@.id=='field-billing-address-province')].value Billing Address Province
field_shipping_address_address_1 varchar2 Field Shipping Address Address 1 filters on the platform, writable, fields[?(@.id=='field-shipping-address-address-1')].value Shipping Address Address Line 1
field_shipping_address_address_2 varchar2 Field Shipping Address Address 2 filters on the platform, writable, fields[?(@.id=='field-shipping-address-address-2')].value Shipping Address Address Line 2
field_shipping_address_address_3 varchar2 Field Shipping Address Address 3 filters on the platform, writable, fields[?(@.id=='field-shipping-address-address-3')].value Shipping Address Address Line 3
field_shipping_address_city varchar2 Field Shipping Address City filters on the platform, writable, fields[?(@.id=='field-shipping-address-city')].value Shipping Address City
field_shipping_address_company varchar2 Field Shipping Address Company filters on the platform, writable, fields[?(@.id=='field-shipping-address-company')].value Shipping Address Company
field_shipping_address_country varchar2 Field Shipping Address Country filters on the platform, writable, fields[?(@.id=='field-shipping-address-country')].value Shipping Address Country
field_shipping_address_email varchar2 Field Shipping Address Email filters on the platform, writable, fields[?(@.id=='field-shipping-address-email')].value Shipping Address Email
field_shipping_address_first_name varchar2 Field Shipping Address First Name filters on the platform, writable, fields[?(@.id=='field-shipping-address-first-name')].value Shipping Address First Name
field_shipping_address_last_name varchar2 Field Shipping Address Last Name filters on the platform, writable, fields[?(@.id=='field-shipping-address-last-name')].value Shipping Address Last Name
field_shipping_address_phone varchar2 Field Shipping Address Phone filters on the platform, writable, fields[?(@.id=='field-shipping-address-phone')].value Shipping Address Phone
field_shipping_address_postal varchar2 Field Shipping Address Postal filters on the platform, writable, fields[?(@.id=='field-shipping-address-postal')].value Shipping Address Postal
field_shipping_address_province varchar2 Field Shipping Address Province filters on the platform, writable, fields[?(@.id=='field-shipping-address-province')].value Shipping Address Province
final_amount decimal Final Amount filters on the platform, writable, fields[?(@.id=='final-amount')].value Final Amount
final_amount_currency varchar2 Final Amount Currency filters on the platform, writable, fields[?(@.id=='final-amount')].currency 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_test_order varchar2 Is Test Order filters on the platform, writable, fields[?(@.id=='is-test-order')].value Is Test Order
legacy_connection_id int64 Legacy Connection ID filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value Legacy Connection ID
location_id varchar2 Location ID filters on the platform, writable, fields[?(@.id=='location-id')].value Location ID
normalized_status varchar2 Normalized Status filters on the platform, writable, fields[?(@.id=='normalized-status')].value Order Status
notes varchar2 Notes filters on the platform, writable, fields[?(@.id=='notes')].value Notes
order_number varchar2 Order Number filters on the platform, writable, fields[?(@.id=='order-number')].value Order Number
order_url varchar2 Order URL filters on the platform, writable, fields[?(@.id=='order-url')].value Order URL
payment_method varchar2 Payment Method filters on the platform, writable, fields[?(@.id=='payment-method')].value Payment Method
primary_contact varchar2 Primary Contact filters on the platform, writable, relationships.primary-contact Contact for Order
sales_channel varchar2 Sales Channel filters on the platform, writable, fields[?(@.id=='sales-channel')].value Channel
schemaId varchar2 Schema ID filters on the platform, writable, computed Unique ID of the custom object the record belongs to.
shipping_amount decimal Shipping Amount filters on the platform, writable, fields[?(@.id=='shipping-amount')].value Shipping Amount
shipping_amount_currency varchar2 Shipping Amount Currency filters on the platform, writable, fields[?(@.id=='shipping-amount')].currency Currency of the amount in column shipping_amount.
shipping_method varchar2 Shipping Method filters on the platform, writable, fields[?(@.id=='shipping-method')].value Shipping Method
store_created_date datetime Store Created Date filters on the platform, writable, fields[?(@.id=='store-created-date')].value Store Created Date
store_customer_id varchar2 Store Customer ID filters on the platform, writable, fields[?(@.id=='store-customer-id')].value Store's Customer ID
store_external_order_id varchar2 Store External Order ID filters on the platform, writable, fields[?(@.id=='store-external-order-id')].value Store's External Order ID
store_modified_date datetime Store Modified Date filters on the platform, writable, fields[?(@.id=='store-modified-date')].value Store Modified Date
store_order_id varchar2 Store Order ID filters on the platform, writable, fields[?(@.id=='store-order-id')].value Store's Order ID
store_status varchar2 Store Status filters on the platform, writable, fields[?(@.id=='store-status')].value Store's Order Status
updatedTimestamp 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

Alle Treiberwechsel, 26.0 bis 27.0