RecurringPayments: ActiveCampaign Recurring Payments
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_ |
datetime |
Anchor Date | filters on the platform, writable, fields[? |
Anchor Date | |
billing_ |
varchar2 |
Billing Address Address 1 | filters on the platform, writable, fields[? |
Billing Address Line 1 | |
billing_ |
varchar2 |
Billing Address Address 2 | filters on the platform, writable, fields[? |
Billing Address Line 2 | |
billing_ |
varchar2 |
Billing Address Address 3 | filters on the platform, writable, fields[? |
Billing Address Line 3 | |
billing_ |
varchar2 |
Billing Address City | filters on the platform, writable, fields[? |
Billing Address City | |
billing_ |
varchar2 |
Billing Address Company | filters on the platform, writable, fields[? |
Billing Address Company | |
billing_ |
varchar2 |
Billing Address Country | filters on the platform, writable, fields[? |
Billing Address Country | |
billing_ |
varchar2 |
Billing Address Email | filters on the platform, writable, fields[? |
Billing Address Email | |
billing_ |
varchar2 |
Billing Address First Name | filters on the platform, writable, fields[? |
Billing Address First Name | |
billing_ |
varchar2 |
Billing Address Last Name | filters on the platform, writable, fields[? |
Billing Address Last Name | |
billing_ |
varchar2 |
Billing Address Phone | filters on the platform, writable, fields[? |
Billing Address Phone | |
billing_ |
varchar2 |
Billing Address Postal | filters on the platform, writable, fields[? |
Billing Address Postal Codes | |
billing_ |
varchar2 |
Billing Address Province | filters on the platform, writable, fields[? |
Billing Address Province | |
billing_ |
varchar2 |
Billing Interval | filters on the platform, writable, fields[? |
Billing Interval | |
billing_ |
int64 |
Billing Interval Count | filters on the platform, writable, fields[? |
Billing Interval Count | |
cancel_ |
varchar2 |
Cancel at Period End | filters on the platform, writable, fields[? |
Cancel at Period End | |
cancelled_ |
datetime |
Cancelled Date | filters on the platform, writable, fields[? |
Cancelled Date | |
created |
datetime |
Created | filters on the platform, writable, computed | Moment of creation. | |
currency |
varchar2 |
Currency | filters on the platform, writable, fields[? |
Currency | |
discount_ |
decimal |
Discount Amount | filters on the platform, writable, fields[? |
Discount Amount | |
discount_ |
varchar2 |
Discount Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column discount_amount. | |
email |
varchar2 |
Email Address | 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 Trial | filters on the platform, writable, fields[? |
Is Trial | |
last_ |
datetime |
Last Payment Date | filters on the platform, writable, fields[? |
Last Payment Date | |
last_ |
varchar2 |
Last Payment Status | filters on the platform, writable, fields[? |
Last Payment Status | |
legacy_ |
int64 |
Legacy Connection ID | filters on the platform, writable, fields[? |
Legacy Connection ID | |
line_ |
varchar2 |
Line Item Brands | filters on the platform, writable, fields[? |
Line Item Brand | |
line_ |
varchar2 |
Line Item Categories | filters on the platform, writable, fields[? |
Line Item Category | |
line_ |
varchar2 |
Line Item Names | filters on the platform, writable, fields[? |
Line Item Name | |
line_ |
varchar2 |
Line Item SKUs | filters on the platform, writable, fields[? |
Line Item Sku | |
line_ |
varchar2 |
Line Item Store Primary IDs | filters on the platform, writable, fields[? |
Line Item Store Primary ID | |
line_ |
varchar2 |
Line Item Tags | filters on the platform, writable, fields[? |
Line Item Tag | |
name |
varchar2 |
Name | filters on the platform, writable, fields[? |
Recurring Payment Name | |
next_ |
datetime |
Next Payment Date | filters on the platform, writable, fields[? |
Next Payment Date | |
normalized_ |
varchar2 |
Normalized Status | filters on the platform, writable, fields[? |
Recurring Payment Status | |
notes |
varchar2 |
Notes | filters on the platform, writable, fields[? |
Note | |
origin_ |
varchar2 |
Origin Order ID | filters on the platform, writable, fields[? |
Origin Order ID | |
payment_ |
decimal |
Payment Amount | filters on the platform, writable, fields[? |
Payment Amount | |
payment_ |
varchar2 |
Payment Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column payment_amount. | |
payment_ |
datetime |
Payment Method Expiration | filters on the platform, writable, fields[? |
Payment Method Expiration | |
primary_ |
varchar2 |
Primary Contact | filters on the platform, writable, relationships. |
Contact for Recurring Payment | |
renewal_ |
datetime |
Renewal Date | filters on the platform, writable, fields[? |
Renewal Date | |
schema |
varchar2 |
Schema ID | filters on the platform, writable, computed | Unique ID of the custom object the record belongs to. | |
shipping_ |
varchar2 |
Shipping Address Address 1 | filters on the platform, writable, fields[? |
Shipping Address Line 1 | |
shipping_ |
varchar2 |
Shipping Address Address 2 | filters on the platform, writable, fields[? |
Shipping Address Line 2 | |
shipping_ |
varchar2 |
Shipping Address Address 3 | filters on the platform, writable, fields[? |
Shipping Address Line 3 | |
shipping_ |
varchar2 |
Shipping Address City | filters on the platform, writable, fields[? |
Shipping Address City | |
shipping_ |
varchar2 |
Shipping Address Company | filters on the platform, writable, fields[? |
Shipping Address Company | |
shipping_ |
varchar2 |
Shipping Address Country | filters on the platform, writable, fields[? |
Shipping Address Country | |
shipping_ |
varchar2 |
Shipping Address Email | filters on the platform, writable, fields[? |
Shipping Address Email | |
shipping_ |
varchar2 |
Shipping Address First Name | filters on the platform, writable, fields[? |
Shipping Address First Name | |
shipping_ |
varchar2 |
Shipping Address Last Name | filters on the platform, writable, fields[? |
Shipping Address Last Name | |
shipping_ |
varchar2 |
Shipping Address Phone | filters on the platform, writable, fields[? |
Shipping Address Phone | |
shipping_ |
varchar2 |
Shipping Address Postal | filters on the platform, writable, fields[? |
Shipping Address Postal Codes | |
shipping_ |
varchar2 |
Shipping Address Province | filters on the platform, writable, fields[? |
Shipping Address Province | |
shipping_ |
decimal |
Shipping Amount | filters on the platform, writable, fields[? |
Shipping Amount | |
shipping_ |
varchar2 |
Shipping Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column shipping_amount. | |
start_ |
datetime |
Start Date | filters on the platform, writable, fields[? |
Start Date | |
store_ |
datetime |
Store Created Date | filters on the platform, writable, fields[? |
Store Created Date | |
store_ |
varchar2 |
Store Customer ID | filters on the platform, writable, fields[? |
Store's Customer ID | |
store_ |
varchar2 |
Store External ID | filters on the platform, writable, fields[? |
Store External ID | |
store_ |
datetime |
Store Modified Date | filters on the platform, writable, fields[? |
Store Modified Date | |
store_ |
varchar2 |
Store Recurring Payment ID | filters on the platform, writable, fields[? |
Store Recurring Payment ID | |
store_ |
varchar2 |
Store Status | filters on the platform, writable, fields[? |
Store's Recurring Payment Status | |
suppress_ |
varchar2 |
Suppress Automations | filters on the platform, writable, fields[? |
Suppress Automation | |
tax_ |
decimal |
Tax Amount | filters on the platform, writable, fields[? |
Tax Amount | |
tax_ |
varchar2 |
Tax Amount Currency | filters on the platform, writable, fields[? |
Currency of the amount in column tax_amount. | |
total_ |
int64 |
Total Cycles | filters on the platform, writable, fields[? |
Total Cycles | |
updated |
datetime |
Last Modified | filters on the platform, writable, computed | Moment of last change. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Table ActiveCampaign.CustomObjects.RecurringPayments is added
The table has 70 columns and can select, insert.
- importance 3