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_ |
varchar2 |
Accepteert Marketing | filters on the platform, writable, fields[? |
Accepteert Marketing | |
cart_ |
varchar2 |
Winkelwagen-ID | filters on the platform, writable, fields[? |
Winkelwagen-ID | |
connection_ |
varchar2 |
Verbinding ID | filters on the platform, writable, fields[? |
Verbinding ID | |
created |
datetime |
Created | filters on the platform, writable, computed | Moment of creation. | |
created_ |
varchar2 |
Gemaakt door Terugkerende Betaling | filters on the platform, writable, fields[? |
Created By Recurring Payment | |
creation_ |
varchar2 |
Scheppingsbron | filters on the platform, writable, fields[? |
Scheppingsbron | |
customer_ |
varchar2 |
Klantlocale | filters on the platform, writable, fields[? |
Klantlocale | |
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 |
Kortingen Bedrag | filters on the platform, writable, fields[? |
Kortingen Bedrag | |
discounts_ |
varchar2 |
Kortingen Bedrag Valuta | filters on the platform, writable, fields[? |
Currency of the amount in column discounts_amount. | |
email |
varchar2 |
E-mailadres | filters on the platform, writable, fields[? |
||
field_ |
varchar2 |
Veld Factuuradres Adres 1 | filters on the platform, writable, fields[? |
Billing Address Address Line 1 | |
field_ |
varchar2 |
Veld Factuuradres Adres 2 | filters on the platform, writable, fields[? |
Billing Address Address Line 2 | |
field_ |
varchar2 |
Veld Factuuradres Adres 3 | filters on the platform, writable, fields[? |
Billing Address Address Line 3 | |
field_ |
varchar2 |
Veld Factuuradres Stad | filters on the platform, writable, fields[? |
Factuuradres Stad | |
field_ |
varchar2 |
Veld Factuuradres Bedrijf | filters on the platform, writable, fields[? |
Factuuradres Bedrijf | |
field_ |
varchar2 |
Veld Factuuradres Land | filters on the platform, writable, fields[? |
Factuuradres Land | |
field_ |
varchar2 |
Veld Factuuradres E-mail | filters on the platform, writable, fields[? |
Factuuradres E-mail | |
field_ |
varchar2 |
Veld Factuuradres Voornaam | filters on the platform, writable, fields[? |
Factuuradres Voornaam | |
field_ |
varchar2 |
Veld Factuuradres Achternaam | filters on the platform, writable, fields[? |
Factuuradres Achternaam | |
field_ |
varchar2 |
Veld Factuuradres Telefoon | filters on the platform, writable, fields[? |
Billing Address Phone Number | |
field_ |
varchar2 |
Veld Factuuradres Postcode | filters on the platform, writable, fields[? |
Factuuradres Postcode | |
field_ |
varchar2 |
Veld Factuuradres Provincie | filters on the platform, writable, fields[? |
Factuuradres Provincie | |
field_ |
varchar2 |
Verzendadres Adres 1 | filters on the platform, writable, fields[? |
Shipping Address Address Line 1 | |
field_ |
varchar2 |
Verzendadres Adres 2 | filters on the platform, writable, fields[? |
Shipping Address Address Line 2 | |
field_ |
varchar2 |
Verzendadres Adres 3 | filters on the platform, writable, fields[? |
Shipping Address Address Line 3 | |
field_ |
varchar2 |
Verzendadres Stad | filters on the platform, writable, fields[? |
Verzendadres Stad | |
field_ |
varchar2 |
Verzendadres Bedrijf | filters on the platform, writable, fields[? |
Verzendadres Bedrijf | |
field_ |
varchar2 |
Veld Verzendadres Land | filters on the platform, writable, fields[? |
Verzendadres Land | |
field_ |
varchar2 |
Veld Verzendadres E-mail | filters on the platform, writable, fields[? |
Verzendadres E-mail | |
field_ |
varchar2 |
Veld Verzendadres Voornaam | filters on the platform, writable, fields[? |
Verzendadres Voornaam | |
field_ |
varchar2 |
Veld Verzendadres Achternaam | filters on the platform, writable, fields[? |
Verzendadres Achternaam | |
field_ |
varchar2 |
Veld Verzendadres Telefoonnummer | filters on the platform, writable, fields[? |
Verzendadres Telefoon | |
field_ |
varchar2 |
Veld Verzendadres Postcode | filters on the platform, writable, fields[? |
Verzendadres Postcode | |
field_ |
varchar2 |
Veld Verzendadres Provincie | filters on the platform, writable, fields[? |
Verzendadres Provincie | |
final_ |
decimal |
Eindbedrag | filters on the platform, writable, fields[? |
Eindbedrag | |
final_ |
varchar2 |
Eindbedrag Valuta | 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 Testorder | filters on the platform, writable, fields[? |
Is Testorder | |
legacy_ |
int64 |
Oude Verbindings-ID | filters on the platform, writable, fields[? |
Oude Verbindings-ID | |
location_ |
varchar2 |
Locatie ID | filters on the platform, writable, fields[? |
Locatie ID | |
normalized_ |
varchar2 |
Genormaliseerde Status | filters on the platform, writable, fields[? |
Orderstatus | |
notes |
varchar2 |
Notes | filters on the platform, writable, fields[? |
Notes | |
order_ |
varchar2 |
Ordernummer | filters on the platform, writable, fields[? |
Ordernummer | |
order_ |
varchar2 |
Bestelling URL | filters on the platform, writable, fields[? |
Bestelling URL | |
payment_ |
varchar2 |
Betalingsmethode | filters on the platform, writable, fields[? |
Betalingsmethode | |
primary_ |
varchar2 |
Primaire Contactpersoon | filters on the platform, writable, relationships. |
Contact for Order | |
sales_ |
varchar2 |
Verkoopkanaal | 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 |
Verzendbedrag | filters on the platform, writable, fields[? |
Verzendbedrag | |
shipping_ |
varchar2 |
Verzendkosten Valuta | filters on the platform, writable, fields[? |
Currency of the amount in column shipping_amount. | |
shipping_ |
varchar2 |
Verzendwijze | filters on the platform, writable, fields[? |
Verzendwijze | |
store_ |
datetime |
Winkel Aanmaakdatum | filters on the platform, writable, fields[? |
Winkel Aanmaakdatum | |
store_ |
varchar2 |
Winkel Klant-ID | filters on the platform, writable, fields[? |
Store's Customer ID | |
store_ |
varchar2 |
Winkel Externe Order-ID | filters on the platform, writable, fields[? |
Store's External Order ID | |
store_ |
datetime |
Winkel Wijzigingsdatum | filters on the platform, writable, fields[? |
Winkel Wijzigingsdatum | |
store_ |
varchar2 |
Winkel Order-ID | filters on the platform, writable, fields[? |
Store's Order ID | |
store_ |
varchar2 |
Winkelstatus | filters on the platform, writable, fields[? |
Store's Order Status | |
updated |
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