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

# DealWithTasks: ActiveCampaign Deal Tasks

`read only` `REST`

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

Can only retrieve data.

## API Source

- Endpoint: `/deals?include=tasks`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 264 |
| Full scan rows per minute | 3,390 |

The result can be cached on the client.

## Table Columns

The columns of the table `DealWithTasks` 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 |
|---|---|---|:---:|---|---|
| `assigned_date` | `datetime` | Assigned Date | [ ] | filters on the platform, writable |  |
| `assignee` | `int64` | Assignee | [ ] | filters on the platform, writable |  |
| `automation` | `int64` | Automation | [ ] | filters on the platform, writable | Automation ID. |
| `cdate` | `datetime` | Created | [ ] | filters on the platform, writable, computed |  |
| `created_utc_timestamp` | `datetime` | Created UTC Timestamp | [ ] | filters on the platform, writable, computed |  |
| `createdseriesid` | `int64` | Created Series ID | [ ] | filters on the platform, writable |  |
| `dealTasktype` | `int64` | Task Type | [x] | filters on the platform, writable |  |
| `doneAutomation` | `int64` | Done Automation | [ ] | filters on the platform, writable |  |
| `done_by` | `varchar2` | Done by | [ ] | filters on the platform, writable |  |
| `done_utc_timestamp` | `datetime` | Done UTC Timestamp | [ ] | filters on the platform, writable |  |
| `donedate` | `datetime` | Done Date | [ ] | filters on the platform, writable |  |
| `duedate` | `datetime` | Due Date | [x] | filters on the platform, writable |  |
| `duration` | `int64` | Duration | [x] | filters on the platform, writable |  |
| `edate` | `datetime` | itgen_acn_edate | [ ] | filters on the platform, writable |  |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed | Unique ID. |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable |  |
| `outcome_id` | `int64` | Outcome ID | [ ] | filters on the platform, writable |  |
| `outcome_info` | `varchar2` | Outcome Info | [ ] | filters on the platform, writable |  |
| `relid` | `int64` | Relationship ID | [x] | filters on the platform, writable |  |
| `reltype` | `varchar2` | Relationship Type | [x] | filters on the platform, writable |  |
| `status` | `int64` | Status | [x] | filters on the platform, writable |  |
| `title` | `varchar2` | Title | [ ] | filters on the platform, writable |  |
| `udate` | `datetime` | Last Updated | [ ] | filters on the platform, writable, computed |  |
| `updated_by` | `varchar2` | Updated by | [ ] | filters on the platform, writable |  |
| `updated_utc_timestamp` | `datetime` | Updated UTC Timestamp | [ ] | filters on the platform, writable, computed |  |
| `user` | `int64` | User | [x] | filters on the platform, writable |  |



## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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