invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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_date datetime Ankerdatum filters on the platform, writable, fields[?(@.id=='anchor-date')].value Ankerdatum
billing_address_address_1 varchar2 Factuuradres Adres 1 filters on the platform, writable, fields[?(@.id=='billing-address-address-1')].value Factuuradresregel 1
billing_address_address_2 varchar2 Factuuradres Adres 2 filters on the platform, writable, fields[?(@.id=='billing-address-address-2')].value Factuuradresregel 2
billing_address_address_3 varchar2 Factuuradres Adres 3 filters on the platform, writable, fields[?(@.id=='billing-address-address-3')].value Factuuradresregel 3
billing_address_city varchar2 Factuuradres Stad filters on the platform, writable, fields[?(@.id=='billing-address-city')].value Factuuradres Stad
billing_address_company varchar2 Factuuradres Bedrijf filters on the platform, writable, fields[?(@.id=='billing-address-company')].value Factuuradres Bedrijf
billing_address_country varchar2 Factuuradres Land filters on the platform, writable, fields[?(@.id=='billing-address-country')].value Factuuradres Land
billing_address_email varchar2 Factuuradres E-mail filters on the platform, writable, fields[?(@.id=='billing-address-email')].value Factuuradres E-mail
billing_address_first_name varchar2 Factuuradres Voornaam filters on the platform, writable, fields[?(@.id=='billing-address-first-name')].value Factuuradres Voornaam
billing_address_last_name varchar2 Factuuradres Achternaam filters on the platform, writable, fields[?(@.id=='billing-address-last-name')].value Factuuradres Achternaam
billing_address_phone varchar2 Factuuradres Telefoon filters on the platform, writable, fields[?(@.id=='billing-address-phone')].value Factuuradres Telefoon
billing_address_postal varchar2 Factuuradres Postcode filters on the platform, writable, fields[?(@.id=='billing-address-postal')].value Billing Address Postal Codes
billing_address_province varchar2 Factuuradres Provincie filters on the platform, writable, fields[?(@.id=='billing-address-province')].value Factuuradres Provincie
billing_interval varchar2 Facturatie Interval filters on the platform, writable, fields[?(@.id=='billing-interval')].value Facturatie Interval
billing_interval_count int64 Facturatie Interval Aantal filters on the platform, writable, fields[?(@.id=='billing-interval-count')].value Facturatie Interval Aantal
cancel_at_period_end varchar2 Annuleer op Periode Einde filters on the platform, writable, fields[?(@.id=='cancel-at-period-end')].value Annuleer op Periode Einde
cancelled_date datetime Annuleringsdatum filters on the platform, writable, fields[?(@.id=='cancelled-date')].value Annuleringsdatum
createdTimestamp datetime Created filters on the platform, writable, computed Moment of creation.
currency varchar2 Currency filters on the platform, writable, fields[?(@.id=='currency')].value Currency
discount_amount decimal Kortingsbedrag filters on the platform, writable, fields[?(@.id=='discount-amount')].value Kortingsbedrag
discount_amount_currency varchar2 Kortingsbedrag Valuta filters on the platform, writable, fields[?(@.id=='discount-amount')].currency Currency of the amount in column discount_amount.
email varchar2 E-mailadres filters on the platform, writable, fields[?(@.id=='email')].value Email
id varchar2 ID filters on the platform, writable, computed Unique ID of the record, in the form of a GUID.
is_trial varchar2 Is Proef filters on the platform, writable, fields[?(@.id=='is-trial')].value Is Proef
last_payment_date datetime Laatste Betalingsdatum filters on the platform, writable, fields[?(@.id=='last-payment-date')].value Laatste Betalingsdatum
last_payment_status varchar2 Laatste Betaling Status filters on the platform, writable, fields[?(@.id=='last-payment-status')].value Laatste Betaling Status
legacy_connection_id int64 Oude Verbindings-ID filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value Oude Verbindings-ID
line_item_brands varchar2 Artikelregel Merken filters on the platform, writable, fields[?(@.id=='line-item-brands')].value Line Item Brand
line_item_categories varchar2 Artikelregel Categorieën filters on the platform, writable, fields[?(@.id=='line-item-categories')].value Line Item Category
line_item_names varchar2 Artikelregel Namen filters on the platform, writable, fields[?(@.id=='line-item-names')].value Line Item Name
line_item_skus varchar2 Artikelregel SKU's filters on the platform, writable, fields[?(@.id=='line-item-skus')].value Line Item Sku
line_item_store_primary_ids varchar2 Artikelregel Winkel Primaire ID's filters on the platform, writable, fields[?(@.id=='line-item-store-primary-ids')].value Line Item Store Primary ID
line_item_tags varchar2 Artikelregel Labels filters on the platform, writable, fields[?(@.id=='line-item-tags')].value Line Item Tag
name varchar2 Name filters on the platform, writable, fields[?(@.id=='name')].value Recurring Payment Name
next_payment_date datetime Volgende Betalingsdatum filters on the platform, writable, fields[?(@.id=='next-payment-date')].value Volgende Betalingsdatum
normalized_status varchar2 Genormaliseerde Status filters on the platform, writable, fields[?(@.id=='normalized-status')].value Recurring Payment Status
notes varchar2 Notes filters on the platform, writable, fields[?(@.id=='notes')].value Note
origin_order_id varchar2 Oorsprong Ordernummer filters on the platform, writable, fields[?(@.id=='origin-order-id')].value Oorsprong Ordernummer
payment_amount decimal Te Betalen Bedrag filters on the platform, writable, fields[?(@.id=='payment-amount')].value Te Betalen Bedrag
payment_amount_currency varchar2 Betalingsbedrag Valuta filters on the platform, writable, fields[?(@.id=='payment-amount')].currency Currency of the amount in column payment_amount.
payment_method_expiration datetime Betaalmethode Vervaldatum filters on the platform, writable, fields[?(@.id=='payment-method-expiration')].value Betaalmethode Vervaldatum
primary_contact varchar2 Primaire Contactpersoon filters on the platform, writable, relationships.primary-contact Contact for Recurring Payment
renewal_date datetime Verlengingsdatum filters on the platform, writable, fields[?(@.id=='renewal-date')].value Verlengingsdatum
schemaId varchar2 Schema-ID filters on the platform, writable, computed Unique ID of the custom object the record belongs to.
shipping_address_address_1 varchar2 Verzendadres Adres 1 filters on the platform, writable, fields[?(@.id=='shipping-address-address-1')].value Verzendadresregel 1
shipping_address_address_2 varchar2 Verzendadres Adres 2 filters on the platform, writable, fields[?(@.id=='shipping-address-address-2')].value Verzendadresregel 2
shipping_address_address_3 varchar2 Verzendadres Adres 3 filters on the platform, writable, fields[?(@.id=='shipping-address-address-3')].value Verzendadresregel 3
shipping_address_city varchar2 Verzendadres Stad filters on the platform, writable, fields[?(@.id=='shipping-address-city')].value Verzendadres Stad
shipping_address_company varchar2 Verzendadres Bedrijf filters on the platform, writable, fields[?(@.id=='shipping-address-company')].value Verzendadres Bedrijf
shipping_address_country varchar2 Verzendadres Land filters on the platform, writable, fields[?(@.id=='shipping-address-country')].value Verzendadres Land
shipping_address_email varchar2 Verzendadres E-mail filters on the platform, writable, fields[?(@.id=='shipping-address-email')].value Verzendadres E-mail
shipping_address_first_name varchar2 Verzendadres Voornaam filters on the platform, writable, fields[?(@.id=='shipping-address-first-name')].value Verzendadres Voornaam
shipping_address_last_name varchar2 Verzendadres Achternaam filters on the platform, writable, fields[?(@.id=='shipping-address-last-name')].value Verzendadres Achternaam
shipping_address_phone varchar2 Verzendadres Telefoon filters on the platform, writable, fields[?(@.id=='shipping-address-phone')].value Verzendadres Telefoon
shipping_address_postal varchar2 Verzendadres Postcode filters on the platform, writable, fields[?(@.id=='shipping-address-postal')].value Shipping Address Postal Codes
shipping_address_province varchar2 Verzendadres Provincie filters on the platform, writable, fields[?(@.id=='shipping-address-province')].value Verzendadres Provincie
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.
start_date datetime Startdatum filters on the platform, writable, fields[?(@.id=='start-date')].value Startdatum
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_id varchar2 Winkel Externe-ID filters on the platform, writable, fields[?(@.id=='store-external-id')].value Winkel Externe-ID
store_modified_date datetime Winkel Wijzigingsdatum filters on the platform, writable, fields[?(@.id=='store-modified-date')].value Winkel Wijzigingsdatum
store_recurring_payment_id varchar2 Winkel Herhalende Betaling-ID filters on the platform, writable, fields[?(@.id=='store-recurring-payment-id')].value Winkel Herhalende Betaling-ID
store_status varchar2 Winkelstatus filters on the platform, writable, fields[?(@.id=='store-status')].value Store's Recurring Payment Status
suppress_automations varchar2 Onderdrukken Automatiseringen filters on the platform, writable, fields[?(@.id=='suppress-automations')].value Suppress Automation
tax_amount decimal Belastingbedrag filters on the platform, writable, fields[?(@.id=='tax-amount')].value Belastingbedrag
tax_amount_currency varchar2 Belastingbedrag Valuta filters on the platform, writable, fields[?(@.id=='tax-amount')].currency Currency of the amount in column tax_amount.
total_cycles int64 Totaal Aantal Cycli filters on the platform, writable, fields[?(@.id=='total-cycles')].value Totaal Aantal Cycli
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.RecurringPayments is toegevoegd

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

  • belang 3

Alle wisselingen van de Driver, 26.0 tot 27.0