---
title: "Lists (ActiveCampaign)"
description: "Lists"
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/activecampaign/ActiveCampaign.V3.Lists
original: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.V3.Lists
updated: 2026-11-01T17:44:09Z
license: https://documentation.invantive.eu/it/
---

# Lists: ActiveCampaign Lists

`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_subscribers` | `int64` | Active Subscribers | [ ] | filters on the platform, writable, computed | Number of active subscribers. |
| `analytics_domains` | `varchar2` | Analytics Domains | [ ] | filters on the platform, writable |  |
| `analytics_source` | `varchar2` | Analytics Source | [ ] | filters on the platform, writable |  |
| `analytics_ua` | `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 | [x] | filters on the platform, writable, computed |  |
| `channel` | `varchar2` | Channel | [ ] | filters on the platform, writable | Channel of the list, such as email. |
| `created_by` | `int64` | Created by | [ ] | filters on the platform, writable, computed | ID of the user that created the list. |
| `created_timestamp` | `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_session` | `varchar2` | Facebook Session | [ ] | filters on the platform, writable |  |
| `fulladdress` | `varchar2` | Full Address | [ ] | filters on the platform, writable |  |
| `get_unsubscribe_reason` | `int64` | Get Unsubscribe Reason | [x] | filters on the platform, writable |  |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed | Unique ID. |
| `name` | `varchar2` | Name | [x] | filters on the platform, writable | Name. |
| `non_deleted_subscribers` | `int64` | Non Deleted Subscribers | [ ] | filters on the platform, writable, computed | Number of subscribers that have not been deleted. |
| `optinmessageid` | `int64` | Opt-in Message ID | [x] | filters on the platform, writable |  |
| `optinoptout` | `int64` | Opt-in Opt-out | [x] | filters on the platform, writable |  |
| `optoutconf` | `int64` | Opt-out Confirmation | [x] | filters on the platform, writable |  |
| `p_embed_image` | `int64` | Embed Image | [x] | filters on the platform, writable |  |
| `p_use_analytics_link` | `int64` | Use Analytics Link | [x] | filters on the platform, writable |  |
| `p_use_analytics_read` | `int64` | Use Analytics Read | [x] | filters on the platform, writable |  |
| `p_use_captcha` | `int64` | Use Captcha | [x] | filters on the platform, writable |  |
| `p_use_facebook` | `int64` | Use Facebook | [x] | filters on the platform, writable |  |
| `p_use_tracking` | `int64` | Use Tracking | [x] | filters on the platform, writable |  |
| `p_use_twitter` | `int64` | Use Twitter | [x] | filters on the platform, writable |  |
| `private` | `int64` | Private | [x] | filters on the platform, writable |  |
| `require_name` | `int64` | Require Name | [x] | filters on the platform, writable |  |
| `send_last_broadcast` | `int64` | Send Last Broadcast | [x] | filters on the platform, writable |  |
| `sender_addr1` | `varchar2` | Sender Address Line 1 | [ ] | filters on the platform, writable |  |
| `sender_addr2` | `varchar2` | Sender Address Line 2 | [ ] | filters on the platform, writable |  |
| `sender_city` | `varchar2` | Sender City | [ ] | filters on the platform, writable |  |
| `sender_country` | `varchar2` | Sender Country | [ ] | filters on the platform, writable |  |
| `sender_name` | `varchar2` | Sender Name | [ ] | filters on the platform, writable |  |
| `sender_phone` | `varchar2` | Sender Phone | [ ] | filters on the platform, writable |  |
| `sender_reminder` | `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_state` | `varchar2` | Sender State | [ ] | filters on the platform, writable |  |
| `sender_url` | `varchar2` | Sender URL | [ ] | filters on the platform, writable | Website URL this list is for. |
| `sender_zip` | `varchar2` | Sender ZIP Code | [ ] | filters on the platform, writable |  |
| `stringid` | `varchar2` | String ID | [x] | filters on the platform, writable | URL-safe list name. |
| `subscription_notify` | `varchar2` | Subscription Notify | [ ] | filters on the platform, writable | Comma-separated list of email addresses to notify when a new subscriber joins this list. |
| `to_name` | `varchar2` | To Name | [x] | filters on the platform, writable |  |
| `twitter_token` | `varchar2` | Twitter Token | [ ] | filters on the platform, writable |  |
| `twitter_token_secret` | `varchar2` | Twitter Token Secret | [ ] | filters on the platform, writable |  |
| `udate` | `datetime` | Last Updated | [ ] | filters on the platform, writable, computed |  |
| `unsubscription_notify` | `varchar2` | Unsubscription Notify | [ ] | filters on the platform, writable | Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list. |
| `updated_by` | `int64` | Updated by | [ ] | filters on the platform, writable, computed | ID of the user that last changed the list. |
| `updated_timestamp` | `datetime` | Updated | [ ] | filters on the platform, writable, computed | Moment of last change. |
| `user` | `int64` | User | [ ] | filters on the platform, writable |  |
| `userid` | `int64` | User ID | [x] | filters on the platform, writable |  |



## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

- [ActiveCampaign](/it/release-notes/drivers?driver=activecampaign)

### Modifiche apportate a questa tabella, da 26.0 a 27.0

<a id="ACN-27.0-D062"></a><a id="ACN-27.0-D063"></a><a id="ACN-27.0-D064"></a><a id="ACN-27.0-D065"></a><a id="ACN-27.0-D066"></a><a id="ACN-27.0-D067"></a><a id="ACN-27.0-D068"></a><a id="ACN-27.0-D069"></a>

- `+` `active_subscribers` (`int64`)
- `+` `channel` (`varchar2`)
- `+` `created_by` (`int64`)
- `+` `created_timestamp` (`datetime`)
- `+` `description` (`varchar2`)
- `+` `non_deleted_subscribers` (`int64`)
- `+` `updated_by` (`int64`)
- `+` `updated_timestamp` (`datetime`)

[Tutte le sostituzioni del conducente, da 26.0 a 27.0](/it/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)
