Lists: ActiveCampaign Lists
Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.
insert update delete REST
- Catalog:
ActiveCampaign - Schema:
V3 - Primary Keys:
id - Label: Lists
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/lists
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 224 |
| Full scan rows per minute | 12,800 |
The result can be cached on the client.
Table Columns
The columns of the table Lists 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 |
|---|---|---|---|---|---|
active_ |
int64 |
Active Subscribers | filters on the platform, writable, computed | Number of active subscribers. | |
analytics_ |
varchar2 |
Analytics Domains | filters on the platform, writable | ||
analytics_ |
varchar2 |
Analytics Source | filters on the platform, writable | ||
analytics_ |
varchar2 |
Analytics UA | filters on the platform, writable | ||
carboncopy |
varchar2 |
Carbon Copy | filters on the platform, writable | Comma-separated list of email addresses to send a copy of all mailings to upon send. | |
cdate |
datetime |
Created | filters on the platform, writable, computed | ||
channel |
varchar2 |
Channel | filters on the platform, writable | Channel of the list, such as email. | |
created_ |
int64 |
Created by | filters on the platform, writable, computed | ID of the user that created the list. | |
created_ |
datetime |
Created | filters on the platform, writable, computed | Moment of creation. | |
deletestamp |
datetime |
Deleted | filters on the platform, writable | ||
description |
varchar2 |
Description | filters on the platform, writable | Description of the list. | |
facebook_ |
varchar2 |
Facebook Session | filters on the platform, writable | ||
fulladdress |
varchar2 |
Full Address | filters on the platform, writable | ||
get_ |
int64 |
Get Unsubscribe Reason | filters on the platform, writable | ||
id |
int64 |
ID | filters on the platform, writable, computed | Unique ID. | |
name |
varchar2 |
Name | filters on the platform, writable | Name. | |
non_ |
int64 |
Non Deleted Subscribers | filters on the platform, writable, computed | Number of subscribers that have not been deleted. | |
optinmessageid |
int64 |
Opt-in Message ID | filters on the platform, writable | ||
optinoptout |
int64 |
Opt-in Opt-out | filters on the platform, writable | ||
optoutconf |
int64 |
Opt-out Confirmation | filters on the platform, writable | ||
p_ |
int64 |
Embed Image | filters on the platform, writable | ||
p_ |
int64 |
Use Analytics Link | filters on the platform, writable | ||
p_ |
int64 |
Use Analytics Read | filters on the platform, writable | ||
p_ |
int64 |
Use Captcha | filters on the platform, writable | ||
p_ |
int64 |
Use Facebook | filters on the platform, writable | ||
p_ |
int64 |
Use Tracking | filters on the platform, writable | ||
p_ |
int64 |
Use Twitter | filters on the platform, writable | ||
private |
int64 |
Private | filters on the platform, writable | ||
require_ |
int64 |
Require Name | filters on the platform, writable | ||
send_ |
int64 |
Send Last Broadcast | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender Address Line 1 | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender Address Line 2 | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender City | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender Country | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender Name | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender Phone | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender Reminder | filters on the platform, writable | A reminder for your contacts as to why they are on this list and you are messaging them. | |
sender_ |
varchar2 |
Sender State | filters on the platform, writable | ||
sender_ |
varchar2 |
Sender URL | filters on the platform, writable | Website URL this list is for. | |
sender_ |
varchar2 |
Sender ZIP Code | filters on the platform, writable | ||
stringid |
varchar2 |
String ID | filters on the platform, writable | URL-safe list name. | |
subscription_ |
varchar2 |
Subscription Notify | filters on the platform, writable | Comma-separated list of email addresses to notify when a new subscriber joins this list. | |
to_ |
varchar2 |
To Name | filters on the platform, writable | ||
twitter_ |
varchar2 |
Twitter Token | filters on the platform, writable | ||
twitter_ |
varchar2 |
Twitter Token Secret | filters on the platform, writable | ||
udate |
datetime |
Last Updated | filters on the platform, writable, computed | ||
unsubscription_ |
varchar2 |
Unsubscription Notify | filters on the platform, writable | Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list. | |
updated_ |
int64 |
Updated by | filters on the platform, writable, computed | ID of the user that last changed the list. | |
updated_ |
datetime |
Updated | filters on the platform, writable, computed | Moment of last change. | |
user |
int64 |
User | filters on the platform, writable | ||
userid |
int64 |
User ID | filters on the platform, writable |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:
Modifiche apportate a questa tabella, da 26.0 a 27.0
+active_subscribers(int64)+channel(varchar2)+created_by(int64)+created_timestamp(datetime)+description(varchar2)+non_deleted_subscribers(int64)+updated_by(int64)+updated_timestamp(datetime)