invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

RecurringPayments: ActiveCampaign Recurring Payments

Esta página aún no está disponible en tu idioma; se muestra la versión original.

insert REST

  • Catalog: ActiveCampaign
  • Schema: CustomObjects
  • Primary Keys: id
  • Label: Recurring Payments

Can retrieve data and change data using insert.

Summary

Recurring payments imported into ActiveCampaign

API Source

  • Endpoint: /customObjects/records/bac74488-5002-4e55-9aa5-28a676199c67

Performance Characteristics

Characteristic Value
Average access latency (ms) 264
Full scan rows per minute 13,400

The result can be cached on the client.

Table Columns

The columns of the table RecurringPayments are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
anchor_date datetime Anchor Date filters on the platform, writable, fields[?(@.id=='anchor-date')].value Anchor Date
billing_address_address_1 varchar2 Billing Address Address 1 filters on the platform, writable, fields[?(@.id=='billing-address-address-1')].value Billing Address Line 1
billing_address_address_2 varchar2 Billing Address Address 2 filters on the platform, writable, fields[?(@.id=='billing-address-address-2')].value Billing Address Line 2
billing_address_address_3 varchar2 Billing Address Address 3 filters on the platform, writable, fields[?(@.id=='billing-address-address-3')].value Billing Address Line 3
billing_address_city varchar2 Billing Address City filters on the platform, writable, fields[?(@.id=='billing-address-city')].value Billing Address City
billing_address_company varchar2 Billing Address Company filters on the platform, writable, fields[?(@.id=='billing-address-company')].value Billing Address Company
billing_address_country varchar2 Billing Address Country filters on the platform, writable, fields[?(@.id=='billing-address-country')].value Billing Address Country
billing_address_email varchar2 Billing Address Email filters on the platform, writable, fields[?(@.id=='billing-address-email')].value Billing Address Email
billing_address_first_name varchar2 Billing Address First Name filters on the platform, writable, fields[?(@.id=='billing-address-first-name')].value Billing Address First Name
billing_address_last_name varchar2 Billing Address Last Name filters on the platform, writable, fields[?(@.id=='billing-address-last-name')].value Billing Address Last Name
billing_address_phone varchar2 Billing Address Phone filters on the platform, writable, fields[?(@.id=='billing-address-phone')].value Billing Address Phone
billing_address_postal varchar2 Billing Address Postal filters on the platform, writable, fields[?(@.id=='billing-address-postal')].value Billing Address Postal Codes
billing_address_province varchar2 Billing Address Province filters on the platform, writable, fields[?(@.id=='billing-address-province')].value Billing Address Province
billing_interval varchar2 Billing Interval filters on the platform, writable, fields[?(@.id=='billing-interval')].value Billing Interval
billing_interval_count int64 Billing Interval Count filters on the platform, writable, fields[?(@.id=='billing-interval-count')].value Billing Interval Count
cancel_at_period_end varchar2 Cancel at Period End filters on the platform, writable, fields[?(@.id=='cancel-at-period-end')].value Cancel at Period End
cancelled_date datetime Cancelled Date filters on the platform, writable, fields[?(@.id=='cancelled-date')].value Cancelled Date
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 Discount Amount filters on the platform, writable, fields[?(@.id=='discount-amount')].value Discount Amount
discount_amount_currency varchar2 Discount Amount Currency filters on the platform, writable, fields[?(@.id=='discount-amount')].currency Currency of the amount in column discount_amount.
email varchar2 Email Address 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 Trial filters on the platform, writable, fields[?(@.id=='is-trial')].value Is Trial
last_payment_date datetime Last Payment Date filters on the platform, writable, fields[?(@.id=='last-payment-date')].value Last Payment Date
last_payment_status varchar2 Last Payment Status filters on the platform, writable, fields[?(@.id=='last-payment-status')].value Last Payment Status
legacy_connection_id int64 Legacy Connection ID filters on the platform, writable, fields[?(@.id=='legacy-connection-id')].value Legacy Connection ID
line_item_brands varchar2 Line Item Brands filters on the platform, writable, fields[?(@.id=='line-item-brands')].value Line Item Brand
line_item_categories varchar2 Line Item Categories filters on the platform, writable, fields[?(@.id=='line-item-categories')].value Line Item Category
line_item_names varchar2 Line Item Names filters on the platform, writable, fields[?(@.id=='line-item-names')].value Line Item Name
line_item_skus varchar2 Line Item SKUs filters on the platform, writable, fields[?(@.id=='line-item-skus')].value Line Item Sku
line_item_store_primary_ids varchar2 Line Item Store Primary IDs filters on the platform, writable, fields[?(@.id=='line-item-store-primary-ids')].value Line Item Store Primary ID
line_item_tags varchar2 Line Item Tags 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 Next Payment Date filters on the platform, writable, fields[?(@.id=='next-payment-date')].value Next Payment Date
normalized_status varchar2 Normalized 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 Origin Order ID filters on the platform, writable, fields[?(@.id=='origin-order-id')].value Origin Order ID
payment_amount decimal Payment Amount filters on the platform, writable, fields[?(@.id=='payment-amount')].value Payment Amount
payment_amount_currency varchar2 Payment Amount Currency filters on the platform, writable, fields[?(@.id=='payment-amount')].currency Currency of the amount in column payment_amount.
payment_method_expiration datetime Payment Method Expiration filters on the platform, writable, fields[?(@.id=='payment-method-expiration')].value Payment Method Expiration
primary_contact varchar2 Primary Contact filters on the platform, writable, relationships.primary-contact Contact for Recurring Payment
renewal_date datetime Renewal Date filters on the platform, writable, fields[?(@.id=='renewal-date')].value Renewal Date
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 Shipping Address Address 1 filters on the platform, writable, fields[?(@.id=='shipping-address-address-1')].value Shipping Address Line 1
shipping_address_address_2 varchar2 Shipping Address Address 2 filters on the platform, writable, fields[?(@.id=='shipping-address-address-2')].value Shipping Address Line 2
shipping_address_address_3 varchar2 Shipping Address Address 3 filters on the platform, writable, fields[?(@.id=='shipping-address-address-3')].value Shipping Address Line 3
shipping_address_city varchar2 Shipping Address City filters on the platform, writable, fields[?(@.id=='shipping-address-city')].value Shipping Address City
shipping_address_company varchar2 Shipping Address Company filters on the platform, writable, fields[?(@.id=='shipping-address-company')].value Shipping Address Company
shipping_address_country varchar2 Shipping Address Country filters on the platform, writable, fields[?(@.id=='shipping-address-country')].value Shipping Address Country
shipping_address_email varchar2 Shipping Address Email filters on the platform, writable, fields[?(@.id=='shipping-address-email')].value Shipping Address Email
shipping_address_first_name varchar2 Shipping Address First Name filters on the platform, writable, fields[?(@.id=='shipping-address-first-name')].value Shipping Address First Name
shipping_address_last_name varchar2 Shipping Address Last Name filters on the platform, writable, fields[?(@.id=='shipping-address-last-name')].value Shipping Address Last Name
shipping_address_phone varchar2 Shipping Address Phone filters on the platform, writable, fields[?(@.id=='shipping-address-phone')].value Shipping Address Phone
shipping_address_postal varchar2 Shipping Address Postal filters on the platform, writable, fields[?(@.id=='shipping-address-postal')].value Shipping Address Postal Codes
shipping_address_province varchar2 Shipping Address Province filters on the platform, writable, fields[?(@.id=='shipping-address-province')].value Shipping Address Province
shipping_amount decimal Shipping Amount filters on the platform, writable, fields[?(@.id=='shipping-amount')].value Shipping Amount
shipping_amount_currency varchar2 Shipping Amount Currency filters on the platform, writable, fields[?(@.id=='shipping-amount')].currency Currency of the amount in column shipping_amount.
start_date datetime Start Date filters on the platform, writable, fields[?(@.id=='start-date')].value Start Date
store_created_date datetime Store Created Date filters on the platform, writable, fields[?(@.id=='store-created-date')].value Store Created Date
store_customer_id varchar2 Store Customer ID filters on the platform, writable, fields[?(@.id=='store-customer-id')].value Store's Customer ID
store_external_id varchar2 Store External ID filters on the platform, writable, fields[?(@.id=='store-external-id')].value Store External ID
store_modified_date datetime Store Modified Date filters on the platform, writable, fields[?(@.id=='store-modified-date')].value Store Modified Date
store_recurring_payment_id varchar2 Store Recurring Payment ID filters on the platform, writable, fields[?(@.id=='store-recurring-payment-id')].value Store Recurring Payment ID
store_status varchar2 Store Status filters on the platform, writable, fields[?(@.id=='store-status')].value Store's Recurring Payment Status
suppress_automations varchar2 Suppress Automations filters on the platform, writable, fields[?(@.id=='suppress-automations')].value Suppress Automation
tax_amount decimal Tax Amount filters on the platform, writable, fields[?(@.id=='tax-amount')].value Tax Amount
tax_amount_currency varchar2 Tax Amount Currency filters on the platform, writable, fields[?(@.id=='tax-amount')].currency Currency of the amount in column tax_amount.
total_cycles int64 Total Cycles filters on the platform, writable, fields[?(@.id=='total-cycles')].value Total Cycles
updatedTimestamp datetime Last Modified filters on the platform, writable, computed Moment of last change.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

Modificaciones de esta tabla, De 26.0 a 27.0

Se añaden las tablas ActiveCampaign, CustomObjects y RecurringPayments.

La tabla tiene 70 columnas y admite las operaciones «select» e «insert».

  • importancia 3

Todos los cambios del conductor, De 26.0 a 27.0