Lists: ActiveCampaign Lists
insert update delete REST
- Catalogue :
ActiveCampaign - Schéma :
V3 - Clés primaires :
id - Label: Lists
Permet de récupérer et de modifier des données à l'aide de insert, update et delete.
Source de l'API
- Point de terminaison :
/lists
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 224 |
| Nombre de lignes par minute en mode de balayage complet | 12,800 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table Lists sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active_ |
int64 |
Abonnés actifs | filters on the platform, writable, computed | Number of active subscribers. | |
analytics_ |
varchar2 |
Domaines d'analyse | filters on the platform, writable | ||
analytics_ |
varchar2 |
Source d'analyse | filters on the platform, writable | ||
analytics_ |
varchar2 |
Analytics UA | filters on the platform, writable | ||
carboncopy |
varchar2 |
Copie conforme | 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 |
Crée par | 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 |
Session Facebook | filters on the platform, writable | ||
fulladdress |
varchar2 |
Adresse complète | filters on the platform, writable | ||
get_ |
int64 |
Afficher le motif de désabonnement | 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 |
Abonnés non supprimés | filters on the platform, writable, computed | Number of subscribers that have not been deleted. | |
optinmessageid |
int64 |
Identifiant du message d'inscription | filters on the platform, writable | ||
optinoptout |
int64 |
Opt-in Opt-out | filters on the platform, writable | ||
optoutconf |
int64 |
Confirmation de désinscription | filters on the platform, writable | ||
p_ |
int64 |
Insérer une image | filters on the platform, writable | ||
p_ |
int64 |
Utiliser le lien Analytics | filters on the platform, writable | ||
p_ |
int64 |
Utiliser Analytics Lire | filters on the platform, writable | ||
p_ |
int64 |
Utiliser le Captcha | filters on the platform, writable | ||
p_ |
int64 |
Utiliser Facebook | filters on the platform, writable | ||
p_ |
int64 |
Utilisation du suivi | filters on the platform, writable | ||
p_ |
int64 |
Utiliser Twitter | filters on the platform, writable | ||
private |
int64 |
Private | filters on the platform, writable | ||
require_ |
int64 |
Nom obligatoire | filters on the platform, writable | ||
send_ |
int64 |
Envoyer la dernière diffusion | filters on the platform, writable | ||
sender_ |
varchar2 |
Adresse de l'expéditeur, ligne 1 | filters on the platform, writable | ||
sender_ |
varchar2 |
Adresse de l'expéditeur, ligne 2 | filters on the platform, writable | ||
sender_ |
varchar2 |
Ville de l'expéditeur | filters on the platform, writable | ||
sender_ |
varchar2 |
Pays de l'expéditeur | filters on the platform, writable | ||
sender_ |
varchar2 |
Nom de l'expéditeur | filters on the platform, writable | ||
sender_ |
varchar2 |
Téléphone de l'expéditeur | filters on the platform, writable | ||
sender_ |
varchar2 |
Rappel de l'expéditeur | 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 |
État de l'expéditeur | filters on the platform, writable | ||
sender_ |
varchar2 |
URL de l'expéditeur | filters on the platform, writable | Website URL this list is for. | |
sender_ |
varchar2 |
Code postal de l'expéditeur | filters on the platform, writable | ||
stringid |
varchar2 |
ID de chaîne | filters on the platform, writable | URL-safe list name. | |
subscription_ |
varchar2 |
Notification d'abonnement | filters on the platform, writable | Comma-separated list of email addresses to notify when a new subscriber joins this list. | |
to_ |
varchar2 |
Nom de destination | filters on the platform, writable | ||
twitter_ |
varchar2 |
Jeton Twitter | filters on the platform, writable | ||
twitter_ |
varchar2 |
Secret du jeton Twitter | filters on the platform, writable | ||
udate |
datetime |
Dernière mise à jour | filters on the platform, writable, computed | ||
unsubscription_ |
varchar2 |
Notification de désabonnement | filters on the platform, writable | Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list. | |
updated_ |
int64 |
Mise à jour par | 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 |
ID utilisateur | filters on the platform, writable |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :
Modifications apportées à cette table, 26.0 à 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)
Toutes les modifications apportées au chauffeur, 26.0 à 27.0