Lists: ActiveCampaign Lists
insert update delete REST
- Catalogus:
ActiveCampaign - Schema:
V3 - Primaire sleutels:
id - Label: Lists
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
API-bron
- Eindpunt:
/lists
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 224 |
| Aantal rijen per minuut bij volledige scan | 12,800 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Lists 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 |
|---|---|---|---|---|---|
active_ |
int64 |
Actieve Abonnees | filters on the platform, writable, computed | Number of active subscribers. | |
analytics_ |
varchar2 |
Analytics Domeinen | filters on the platform, writable | ||
analytics_ |
varchar2 |
Analytics Bron | filters on the platform, writable | ||
analytics_ |
varchar2 |
Analytics UA | filters on the platform, writable | ||
carboncopy |
varchar2 |
Cc'tje | 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 |
Gemaakt door | 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-sessie | filters on the platform, writable | ||
fulladdress |
varchar2 |
Volledig Adres | filters on the platform, writable | ||
get_ |
int64 |
Opvragen Uitschrijvingsreden | 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 |
Niet-verwijderde Abbonees | filters on the platform, writable, computed | Number of subscribers that have not been deleted. | |
optinmessageid |
int64 |
Opt-in Bericht ID | filters on the platform, writable | ||
optinoptout |
int64 |
Opt-in Opt-out | filters on the platform, writable | ||
optoutconf |
int64 |
Opt-outbevestiging | filters on the platform, writable | ||
p_ |
int64 |
Insluiten Afbeelding | filters on the platform, writable | ||
p_ |
int64 |
Gebruik Analytics-link | filters on the platform, writable | ||
p_ |
int64 |
Gebruik Analytics-lees | filters on the platform, writable | ||
p_ |
int64 |
Gebruik Captcha | filters on the platform, writable | ||
p_ |
int64 |
Gebruik Facebook | filters on the platform, writable | ||
p_ |
int64 |
Gebruik Tracking | filters on the platform, writable | ||
p_ |
int64 |
Gebruik Twitter | filters on the platform, writable | ||
private |
int64 |
Private | filters on the platform, writable | ||
require_ |
int64 |
Verplicht Naam | filters on the platform, writable | ||
send_ |
int64 |
Stuur Laatste Uitzending | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzender Adresregel 1 | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzender Adresregel 2 | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzender Stad | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzender Land | filters on the platform, writable | ||
sender_ |
varchar2 |
Naam Afzender | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzender Telefoon | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzenderherinnering | 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 |
Afzenderstaat | filters on the platform, writable | ||
sender_ |
varchar2 |
Afzender URL | filters on the platform, writable | Website URL this list is for. | |
sender_ |
varchar2 |
Afzender Postcode | filters on the platform, writable | ||
stringid |
varchar2 |
Tekenreeks ID | filters on the platform, writable | URL-safe list name. | |
subscription_ |
varchar2 |
Abonnement Melden | filters on the platform, writable | Comma-separated list of email addresses to notify when a new subscriber joins this list. | |
to_ |
varchar2 |
Aan Naam | 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 |
Laatst Bijgewerkt | filters on the platform, writable, computed | ||
unsubscription_ |
varchar2 |
Afmelden Melden | filters on the platform, writable | Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list. | |
updated_ |
int64 |
Bijgewerkt door | 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 |
Gebruikers-ID | filters on the platform, writable |
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
+active_subscribers(int64)+channel(varchar2)+created_by(int64)+created_timestamp(datetime)+description(varchar2)+non_deleted_subscribers(int64)+updated_by(int64)+updated_timestamp(datetime)