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

# DealWithActivities: ActiveCampaign Deal Activities

`read only` `REST`

- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Deal Activities

Can only retrieve data.

## API Source

- Endpoint: `/deals?include=dealActivities`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 236 |
| Full scan rows per minute | 6,420 |

The result can be cached on the client.

## Table Columns

The columns of the table `DealWithActivities` 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 |
|---|---|---|:---:|---|---|
| `automation` | `int64` | Automation | [ ] | filters on the platform, writable | Automation ID. |
| `cdate` | `datetime` | Created | [ ] | filters on the platform, writable, computed |  |
| `dataAction` | `varchar2` | Data Element Action | [ ] | filters on the platform, writable |  |
| `dataId` | `int64` | Data Element ID | [x] | filters on the platform, writable | Data ID. |
| `dataOldval` | `varchar2` | Data Element Old Value | [ ] | filters on the platform, writable |  |
| `dataType` | `varchar2` | Data Element Type | [ ] | filters on the platform, writable |  |
| `deal` | `int64` | Deal | [x] | filters on the platform, writable | Deal ID. |
| `deleted` | `char` | Deleted | [x] | filters on the platform, writable |  |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed | Unique ID. |
| `isAddtask` | `char` | Is Add Task | [x] | filters on the platform, writable |  |
| `seriesid` | `int64` | Series ID | [x] | filters on the platform, writable | Series ID. |
| `sortdate` | `datetime` | Sorting Date | [ ] | filters on the platform, writable |  |
| `stage` | `int64` | Stage | [ ] | filters on the platform, writable | Deal stage ID. |
| `user` | `int64` | User | [ ] | filters on the platform, writable | User ID. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `DealWithActivities_deal_cnd` | `deal` | [Deals](ActiveCampaign.V3.Deals)`.id` | Candidate | Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read. |
| `DealWithActivities_stage_cnd` | `stage` | [Stages](ActiveCampaign.V3.Stages)`.id` | Candidate | Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

