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

# DealsByContactId: ActiveCampaign Deals by Contact ID

`read only` `REST`

- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Deals by Contact ID

Can only retrieve data.

## API Source

- Endpoint: `/contacts/{id}/deals`

## Performance Characteristics

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

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  | ID of the record. |

## Table Columns

The columns of the table `DealsByContactId` 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 |
|---|---|---|:---:|---|---|
| `account` | `int64` | Account | [x] | filters on the platform, writable |  |
| `activitycount` | `int64` | Activity Count | [ ] | filters on the platform, writable |  |
| `cdate` | `datetime` | Created | [x] | filters on the platform, writable, computed |  |
| `contact` | `int64` | Contact | [x] | filters on the platform, writable |  |
| `currency` | `varchar2` | Currency | [x] | filters on the platform, writable |  |
| `customerAccount` | `int64` | Customer Account | [ ] | filters on the platform, writable |  |
| `description` | `varchar2(4000)` | Description | [ ] | filters on the platform, writable |  |
| `edate` | `datetime` | itgen_acn_edate | [ ] | filters on the platform, writable |  |
| `group` | `int64` | Group | [ ] | filters on the platform, writable |  |
| `hash` | `varchar2` | Hash | [ ] | filters on the platform, writable |  |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed |  |
| `isDisabled` | `char` | Disabled | [x] | filters on the platform, writable |  |
| `mdate` | `datetime` | Last Modified | [x] | filters on the platform, writable, computed |  |
| `nextTask` | `int64` | Next Task | [ ] | filters on the platform, writable |  |
| `nextdate` | `datetime` | Next Date | [ ] | filters on the platform, writable |  |
| `nextdealid` | `int64` | Next Deal ID | [ ] | filters on the platform, writable |  |
| `nexttaskid` | `int64` | Next Task ID | [ ] | filters on the platform, writable |  |
| `organization` | `int64` | Account | [ ] | filters on the platform, writable | Deprecated. Do not use. |
| `owner` | `int64` | Owner | [ ] | filters on the platform, writable |  |
| `percent` | `int64` | Percentage | [ ] | filters on the platform, writable |  |
| `stage` | `int64` | Stage | [ ] | filters on the platform, writable |  |
| `status` | `int64` | Status | [x] | filters on the platform, writable |  |
| `title` | `varchar2` | Title | [ ] | filters on the platform, writable |  |
| `value` | `int64` | Value | [ ] | filters on the platform, writable |  |
| `winProbability` | `int64` | Win Probability | [ ] | filters on the platform, writable |  |
| `winProbabilityMdate` | `datetime` | Win Probability Last Updated | [ ] | filters on the platform, writable |  |



## Release Notes

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

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

### Changes of This Table, 26.0 to 27.0

<div class="rn-item" id="ACN-27.0-C031">

##### ActiveCampaign.V3.DealsByContactId can no longer delete

The driver no longer supports delete on ActiveCampaign.V3.DealsByContactId. The capability never worked in 26.0, so no working statement is affected.

<div class="rn-chips">

- `true` &rarr; `false`
- importance 2

</div>

</div>

<div class="rn-item" id="ACN-27.0-C032">

##### ActiveCampaign.V3.DealsByContactId can no longer insert

The driver no longer supports insert on ActiveCampaign.V3.DealsByContactId. The capability never worked in 26.0, so no working statement is affected.

<div class="rn-chips">

- `true` &rarr; `false`
- importance 2

</div>

</div>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)

