invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

eComOrders: ActiveCampaign eCommerce Orders

insert update delete REST

  • Catalogus: ActiveCampaign
  • Schema: V3
  • Primaire sleutels: id
  • Label: eCommerce Orders

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

API-bron

  • Eindpunt: /ecomOrders

Prestatiekenmerken

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

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

Tabelkolommen

De kolommen van de tabel eComOrders 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
connection int64 Connection filters on the platform, writable
connectionid int64 Verbinding ID filters on the platform, writable
createdDate 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 Klant ID filters on the platform, writable
discountAmount int64 Kortingsbedrag filters on the platform, writable
email varchar2 E-mailadres filters on the platform, writable
externalCreatedDate datetime Extern Datum Aangemaakt filters on the platform, writable
externalcheckoutid varchar2 Externe Afreken-ID filters on the platform, writable
externalid varchar2 Externe ID filters on the platform, writable
id int64 ID filters on the platform, writable, computed
orderDate datetime Besteldatum filters on the platform, writable
orderProducts int64 Bestelling Producten filters on the platform, writable
orderUrl varchar2 Bestelling URL filters on the platform, writable
shippingAmount int64 Verzendbedrag filters on the platform, writable
shippingMethod int64 Verzendwijze filters on the platform, writable
source int64 Source filters on the platform, writable
state int64 State filters on the platform, writable
taxAmount int64 Belastingbedrag filters on the platform, writable
totalPrice int64 Totale Prijs filters on the platform, writable Total sales amount including VAT in smallest unit, typically cents.
totalProducts int64 Totaal Producten filters on the platform, writable
tstamp datetime Tstamp filters on the platform, writable
updatedDate datetime Laatst Bijgewerkt filters on the platform, writable, computed

Toetsen

Key Column Verwijst naar Kind Description
eComOrders_connectionid_cnd 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.
eComOrders_customerid_cnd 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.

Geciteerd door

Release Notes

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