invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Orders: ActiveCampaign Orders

insert REST

  • Catalogus: ActiveCampaign
  • Schema: CustomObjects
  • Primaire sleutels: id
  • Label: Orders

Met insert kun je gegevens ophalen en wijzigen.

Samenvatting

Orders imported into ActiveCampaign

API-bron

  • Eindpunt: /customObjects/records/42376388-ff77-49e2-a175-fd92566d749c

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 264
Aantal rijen per minuut bij volledige scan 13,400

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel Orders worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
accepts_marketing varchar2 Accepteert Marketing filters on the platform, writable, fields[?(@.id=='accepts-marketing')].value Accepteert Marketing
cart_id varchar2 Winkelwagen-ID filters on the platform, writable, fields[?(@.id=='cart-id')].value Winkelwagen-ID
connection_id varchar2 Verbinding ID filters on the platform, writable, fields[?(@.id=='connection-id')].value Verbinding ID
createdTimestamp datetime Created filters on the platform, writable, computed Moment of creation.
created_by_recurring_payment varchar2 Gemaakt door Terugkerende Betaling filters on the platform, writable, fields[?(@.id=='created-by-recurring-payment')].value Created By Recurring Payment
creation_source varchar2 Scheppingsbron filters on the platform, writable, fields[?(@.id=='creation-source')].value Scheppingsbron
customer_locale varchar2 Klantlocale filters on the platform, writable, fields[?(@.id=='customer-locale')].value Klantlocale
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 Kortingen Bedrag filters on the platform, writable, fields[?(@.id=='discounts-amount')].value Kortingen Bedrag
discounts_amount_currency varchar2 Kortingen Bedrag Valuta filters on the platform, writable, fields[?(@.id=='discounts-amount')].currency Currency of the amount in column discounts_amount.
email varchar2 E-mailadres filters on the platform, writable, fields[?(@.id=='email')].value Email
field_billing_address_address_1 varchar2 Veld Factuuradres Adres 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 Veld Factuuradres Adres 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 Veld Factuuradres Adres 3 filters on the platform, writable, fields[?(@.id=='field-billing-address-address-3')].value Billing Address Address Line 3
field_billing_address_city varchar2 Veld Factuuradres Stad filters on the platform, writable, fields[?(@.id=='field-billing-address-city')].value Factuuradres Stad
field_billing_address_company varchar2 Veld Factuuradres Bedrijf filters on the platform, writable, fields[?(@.id=='field-billing-address-company')].value Factuuradres Bedrijf
field_billing_address_country varchar2 Veld Factuuradres Land filters on the platform, writable, fields[?(@.id=='field-billing-address-country')].value Factuuradres Land
field_billing_address_email varchar2 Veld Factuuradres E-mail filters on the platform, writable, fields[?(@.id=='field-billing-address-email')].value Factuuradres E-mail
field_billing_address_first_name varchar2 Veld Factuuradres Voornaam filters on the platform, writable, fields[?(@.id=='field-billing-address-first-name')].value Factuuradres Voornaam
field_billing_address_last_name varchar2 Veld Factuuradres Achternaam filters on the platform, writable, fields[?(@.id=='field-billing-address-last-name')].value Factuuradres Achternaam
field_billing_address_phone varchar2 Veld Factuuradres Telefoon filters on the platform, writable, fields[?(@.id=='field-billing-address-phone')].value Billing Address Phone Number
field_billing_address_postal varchar2 Veld Factuuradres Postcode filters on the platform, writable, fields[?(@.id=='field-billing-address-postal')].value Factuuradres Postcode
field_billing_address_province varchar2 Veld Factuuradres Provincie filters on the platform, writable, fields[?(@.id=='field-billing-address-province')].value Factuuradres Provincie
field_shipping_address_address_1 varchar2 Verzendadres Adres 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 Verzendadres Adres 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 Verzendadres Adres 3 filters on the platform, writable, fields[?(@.id=='field-shipping-address-address-3')].value Shipping Address Address Line 3
field_shipping_address_city varchar2 Verzendadres Stad filters on the platform, writable, fields[?(@.id=='field-shipping-address-city')].value Verzendadres Stad
field_shipping_address_company varchar2 Verzendadres Bedrijf filters on the platform, writable, fields[?(@.id=='field-shipping-address-company')].value Verzendadres Bedrijf
field_shipping_address_country varchar2 Veld Verzendadres Land filters on the platform, writable, fields[?(@.id=='field-shipping-address-country')].value Verzendadres Land
field_shipping_address_email varchar2 Veld Verzendadres E-mail filters on the platform, writable, fields[?(@.id=='field-shipping-address-email')].value Verzendadres E-mail
field_shipping_address_first_name varchar2 Veld Verzendadres Voornaam filters on the platform, writable, fields[?(@.id=='field-shipping-address-first-name')].value Verzendadres Voornaam
field_shipping_address_last_name varchar2 Veld Verzendadres Achternaam filters on the platform, writable, fields[?(@.id=='field-shipping-address-last-name')].value Verzendadres Achternaam
field_shipping_address_phone varchar2 Veld Verzendadres Telefoonnummer filters on the platform, writable, fields[?(@.id=='field-shipping-address-phone')].value Verzendadres Telefoon
field_shipping_address_postal varchar2 Veld Verzendadres Postcode filters on the platform, writable, fields[?(@.id=='field-shipping-address-postal')].value Verzendadres Postcode
field_shipping_address_province varchar2 Veld Verzendadres Provincie filters on the platform, writable, fields[?(@.id=='field-shipping-address-province')].value Verzendadres Provincie
final_amount decimal Eindbedrag filters on the platform, writable, fields[?(@.id=='final-amount')].value Eindbedrag
final_amount_currency varchar2 Eindbedrag Valuta 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 Testorder filters on the platform, writable, fields[?(@.id=='is-test-order')].value Is Testorder
legacy_connection_id int64 Oude Verbindings-ID filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value Oude Verbindings-ID
location_id varchar2 Locatie ID filters on the platform, writable, fields[?(@.id=='location-id')].value Locatie ID
normalized_status varchar2 Genormaliseerde Status filters on the platform, writable, fields[?(@.id=='normalized-status')].value Orderstatus
notes varchar2 Notes filters on the platform, writable, fields[?(@.id=='notes')].value Notes
order_number varchar2 Ordernummer filters on the platform, writable, fields[?(@.id=='order-number')].value Ordernummer
order_url varchar2 Bestelling URL filters on the platform, writable, fields[?(@.id=='order-url')].value Bestelling URL
payment_method varchar2 Betalingsmethode filters on the platform, writable, fields[?(@.id=='payment-method')].value Betalingsmethode
primary_contact varchar2 Primaire Contactpersoon filters on the platform, writable, relationships.primary-contact Contact for Order
sales_channel varchar2 Verkoopkanaal 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 Verzendbedrag filters on the platform, writable, fields[?(@.id=='shipping-amount')].value Verzendbedrag
shipping_amount_currency varchar2 Verzendkosten Valuta filters on the platform, writable, fields[?(@.id=='shipping-amount')].currency Currency of the amount in column shipping_amount.
shipping_method varchar2 Verzendwijze filters on the platform, writable, fields[?(@.id=='shipping-method')].value Verzendwijze
store_created_date datetime Winkel Aanmaakdatum filters on the platform, writable, fields[?(@.id=='store-created-date')].value Winkel Aanmaakdatum
store_customer_id varchar2 Winkel Klant-ID filters on the platform, writable, fields[?(@.id=='store-customer-id')].value Store's Customer ID
store_external_order_id varchar2 Winkel Externe Order-ID filters on the platform, writable, fields[?(@.id=='store-external-order-id')].value Store's External Order ID
store_modified_date datetime Winkel Wijzigingsdatum filters on the platform, writable, fields[?(@.id=='store-modified-date')].value Winkel Wijzigingsdatum
store_order_id varchar2 Winkel Order-ID filters on the platform, writable, fields[?(@.id=='store-order-id')].value Store's Order ID
store_status varchar2 Winkelstatus filters on the platform, writable, fields[?(@.id=='store-status')].value Store's Order Status
updatedTimestamp datetime Laatst Gewijzigd filters on the platform, writable, computed Moment of last change.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

Wijzigingen in deze tabel, 26.0 tot 27.0

Tabel ActiveCampaign.CustomObjects.Orders is toegevoegd

De tabel heeft 60 kolommen en ondersteunt de bewerkingen select en insert.

  • belang 3

Alle wisselingen van de Driver, 26.0 tot 27.0