RecurringPayments: ActiveCampaign Recurring Payments
insert REST
- Catalogus:
ActiveCampaign - Schema:
CustomObjects - Primaire sleutels:
id - Label: Recurring Payments
Met insert kun je gegevens ophalen en wijzigen.
Samenvatting
Recurring payments imported into ActiveCampaign
API-bron
- Eindpunt:
/customObjects/records/bac74488-5002-4e55-9aa5-28a676199c67
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 RecurringPayments 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 |
|---|---|---|---|---|---|
anchor_ |
datetime |
Ankerdatum | filters on the platform, writable, fields[? |
Ankerdatum | |
billing_ |
varchar2 |
Factuuradres Adres 1 | filters on the platform, writable, fields[? |
Factuuradresregel 1 | |
billing_ |
varchar2 |
Factuuradres Adres 2 | filters on the platform, writable, fields[? |
Factuuradresregel 2 | |
billing_ |
varchar2 |
Factuuradres Adres 3 | filters on the platform, writable, fields[? |
Factuuradresregel 3 | |
billing_ |
varchar2 |
Factuuradres Stad | filters on the platform, writable, fields[? |
Factuuradres Stad | |
billing_ |
varchar2 |
Factuuradres Bedrijf | filters on the platform, writable, fields[? |
Factuuradres Bedrijf | |
billing_ |
varchar2 |
Factuuradres Land | filters on the platform, writable, fields[? |
Factuuradres Land | |
billing_ |
varchar2 |
Factuuradres E-mail | filters on the platform, writable, fields[? |
Factuuradres E-mail | |
billing_ |
varchar2 |
Factuuradres Voornaam | filters on the platform, writable, fields[? |
Factuuradres Voornaam | |
billing_ |
varchar2 |
Factuuradres Achternaam | filters on the platform, writable, fields[? |
Factuuradres Achternaam | |
billing_ |
varchar2 |
Factuuradres Telefoon | filters on the platform, writable, fields[? |
Factuuradres Telefoon | |
billing_ |
varchar2 |
Factuuradres Postcode | filters on the platform, writable, fields[? |
Billing Address Postal Codes | |
billing_ |
varchar2 |
Factuuradres Provincie | filters on the platform, writable, fields[? |
Factuuradres Provincie | |
billing_ |
varchar2 |
Facturatie Interval | filters on the platform, writable, fields[? |
Facturatie Interval | |
billing_ |
int64 |
Facturatie Interval Aantal | filters on the platform, writable, fields[? |
Facturatie Interval Aantal | |
cancel_ |
varchar2 |
Annuleer op Periode Einde | filters on the platform, writable, fields[? |
Annuleer op Periode Einde | |
cancelled_ |
datetime |
Annuleringsdatum | filters on the platform, writable, fields[? |
Annuleringsdatum | |
created |
datetime |
Created | filters on the platform, writable, computed | Moment of creation. | |
currency |
varchar2 |
Currency | filters on the platform, writable, fields[? |
Currency | |
discount_ |
decimal |
Kortingsbedrag | filters on the platform, writable, fields[? |
Kortingsbedrag | |
discount_ |
varchar2 |
Kortingsbedrag Valuta | filters on the platform, writable, fields[? |
Currency of the amount in column discount_amount. | |
email |
varchar2 |
E-mailadres | filters on the platform, writable, fields[? |
||
id |
varchar2 |
ID | filters on the platform, writable, computed | Unique ID of the record, in the form of a GUID. | |
is_ |
varchar2 |
Is Proef | filters on the platform, writable, fields[? |
Is Proef | |
last_ |
datetime |
Laatste Betalingsdatum | filters on the platform, writable, fields[? |
Laatste Betalingsdatum | |
last_ |
varchar2 |
Laatste Betaling Status | filters on the platform, writable, fields[? |
Laatste Betaling Status | |
legacy_ |
int64 |
Oude Verbindings-ID | filters on the platform, writable, fields[? |
Oude Verbindings-ID | |
line_ |
varchar2 |
Artikelregel Merken | filters on the platform, writable, fields[? |
Line Item Brand | |
line_ |
varchar2 |
Artikelregel Categorieën | filters on the platform, writable, fields[? |
Line Item Category | |
line_ |
varchar2 |
Artikelregel Namen | filters on the platform, writable, fields[? |
Line Item Name | |
line_ |
varchar2 |
Artikelregel SKU's | filters on the platform, writable, fields[? |
Line Item Sku | |
line_ |
varchar2 |
Artikelregel Winkel Primaire ID's | filters on the platform, writable, fields[? |
Line Item Store Primary ID | |
line_ |
varchar2 |
Artikelregel Labels | filters on the platform, writable, fields[? |
Line Item Tag | |
name |
varchar2 |
Name | filters on the platform, writable, fields[? |
Recurring Payment Name | |
next_ |
datetime |
Volgende Betalingsdatum | filters on the platform, writable, fields[? |
Volgende Betalingsdatum | |
normalized_ |
varchar2 |
Genormaliseerde Status | filters on the platform, writable, fields[? |
Recurring Payment Status | |
notes |
varchar2 |
Notes | filters on the platform, writable, fields[? |
Note | |
origin_ |
varchar2 |
Oorsprong Ordernummer | filters on the platform, writable, fields[? |
Oorsprong Ordernummer | |
payment_ |
decimal |
Te Betalen Bedrag | filters on the platform, writable, fields[? |
Te Betalen Bedrag | |
payment_ |
varchar2 |
Betalingsbedrag Valuta | filters on the platform, writable, fields[? |
Currency of the amount in column payment_amount. | |
payment_ |
datetime |
Betaalmethode Vervaldatum | filters on the platform, writable, fields[? |
Betaalmethode Vervaldatum | |
primary_ |
varchar2 |
Primaire Contactpersoon | filters on the platform, writable, relationships. |
Contact for Recurring Payment | |
renewal_ |
datetime |
Verlengingsdatum | filters on the platform, writable, fields[? |
Verlengingsdatum | |
schema |
varchar2 |
Schema-ID | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. | |
shipping_ |
varchar2 |
Verzendadres Adres 1 | filters on the platform, writable, fields[? |
Verzendadresregel 1 | |
shipping_ |
varchar2 |
Verzendadres Adres 2 | filters on the platform, writable, fields[? |
Verzendadresregel 2 | |
shipping_ |
varchar2 |
Verzendadres Adres 3 | filters on the platform, writable, fields[? |
Verzendadresregel 3 | |
shipping_ |
varchar2 |
Verzendadres Stad | filters on the platform, writable, fields[? |
Verzendadres Stad | |
shipping_ |
varchar2 |
Verzendadres Bedrijf | filters on the platform, writable, fields[? |
Verzendadres Bedrijf | |
shipping_ |
varchar2 |
Verzendadres Land | filters on the platform, writable, fields[? |
Verzendadres Land | |
shipping_ |
varchar2 |
Verzendadres E-mail | filters on the platform, writable, fields[? |
Verzendadres E-mail | |
shipping_ |
varchar2 |
Verzendadres Voornaam | filters on the platform, writable, fields[? |
Verzendadres Voornaam | |
shipping_ |
varchar2 |
Verzendadres Achternaam | filters on the platform, writable, fields[? |
Verzendadres Achternaam | |
shipping_ |
varchar2 |
Verzendadres Telefoon | filters on the platform, writable, fields[? |
Verzendadres Telefoon | |
shipping_ |
varchar2 |
Verzendadres Postcode | filters on the platform, writable, fields[? |
Shipping Address Postal Codes | |
shipping_ |
varchar2 |
Verzendadres Provincie | filters on the platform, writable, fields[? |
Verzendadres Provincie | |
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. | |
start_ |
datetime |
Startdatum | filters on the platform, writable, fields[? |
Startdatum | |
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-ID | filters on the platform, writable, fields[? |
Winkel Externe-ID | |
store_ |
datetime |
Winkel Wijzigingsdatum | filters on the platform, writable, fields[? |
Winkel Wijzigingsdatum | |
store_ |
varchar2 |
Winkel Herhalende Betaling-ID | filters on the platform, writable, fields[? |
Winkel Herhalende Betaling-ID | |
store_ |
varchar2 |
Winkelstatus | filters on the platform, writable, fields[? |
Store's Recurring Payment Status | |
suppress_ |
varchar2 |
Onderdrukken Automatiseringen | filters on the platform, writable, fields[? |
Suppress Automation | |
tax_ |
decimal |
Belastingbedrag | filters on the platform, writable, fields[? |
Belastingbedrag | |
tax_ |
varchar2 |
Belastingbedrag Valuta | filters on the platform, writable, fields[? |
Currency of the amount in column tax_amount. | |
total_ |
int64 |
Totaal Aantal Cycli | filters on the platform, writable, fields[? |
Totaal Aantal Cycli | |
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.RecurringPayments is toegevoegd
De tabel heeft 70 kolommen en ondersteunt de bewerkingen select en insert.
- belang 3