> ## Documentation Index
> Fetch the complete documentation index at: https://docs.corsair.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

> ActiveCampaign local sync: searchable entities, `.search()` filters, and operators.

The ActiveCampaign plugin syncs data locally. Use `corsair.activecampaign.db.<entity>.search({ data, limit?, offset? })` with the filters listed per entity.

<Info>
  **New to Corsair?** See [database operations](/concepts/database), [data synchronization](/concepts/integrations), and [multi-tenancy](/concepts/multi-tenancy).
</Info>

## Account Contacts

Path: `activecampaign.db.accountContacts.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.accountContacts.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `contact` | `string` | equals, contains, startsWith, endsWith, in |
| `account` | `string` | equals, contains, startsWith, endsWith, in |
| `jobTitle` | `string` | equals, contains, startsWith, endsWith, in |
| `createdTimestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updatedTimestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Account Custom Field Meta

Path: `activecampaign.db.accountCustomFieldMeta.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.accountCustomFieldMeta.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldLabel` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldType` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldDefault` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldDefaultCurrency` | `string` | equals, contains, startsWith, endsWith, in |
| `personalization` | `string` | equals, contains, startsWith, endsWith, in |
| `createdTimestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updatedTimestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Accounts

Path: `activecampaign.db.accounts.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.accounts.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `accountUrl` | `string` | equals, contains, startsWith, endsWith, in |
| `owner` | `string` | equals, contains, startsWith, endsWith, in |
| `createdTimestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updatedTimestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Addresses

Path: `activecampaign.db.addresses.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.addresses.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `companyName` | `string` | equals, contains, startsWith, endsWith, in |
| `address1` | `string` | equals, contains, startsWith, endsWith, in |
| `address2` | `string` | equals, contains, startsWith, endsWith, in |
| `city` | `string` | equals, contains, startsWith, endsWith, in |
| `state` | `string` | equals, contains, startsWith, endsWith, in |
| `district` | `string` | equals, contains, startsWith, endsWith, in |
| `zip` | `string` | equals, contains, startsWith, endsWith, in |
| `country` | `string` | equals, contains, startsWith, endsWith, in |
| `allgroup` | `string` | equals, contains, startsWith, endsWith, in |
| `smsName` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Automations

Path: `activecampaign.db.automations.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.automations.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `entered` | `string` | equals, contains, startsWith, endsWith, in |
| `exited` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Brandings

Path: `activecampaign.db.brandings.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.brandings.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `siteName` | `string` | equals, contains, startsWith, endsWith, in |
| `groupid` | `string` | equals, contains, startsWith, endsWith, in |
| `siteLogo` | `string` | equals, contains, startsWith, endsWith, in |
| `siteLogoSmall` | `string` | equals, contains, startsWith, endsWith, in |
| `favicon` | `string` | equals, contains, startsWith, endsWith, in |
| `copyright` | `string` | equals, contains, startsWith, endsWith, in |
| `license` | `string` | equals, contains, startsWith, endsWith, in |
| `help` | `string` | equals, contains, startsWith, endsWith, in |
| `version` | `string` | equals, contains, startsWith, endsWith, in |
| `headerHtmlValue` | `string` | equals, contains, startsWith, endsWith, in |
| `headerTextValue` | `string` | equals, contains, startsWith, endsWith, in |
| `footerHtmlValue` | `string` | equals, contains, startsWith, endsWith, in |
| `footerTextValue` | `string` | equals, contains, startsWith, endsWith, in |
| `publicTemplateCss` | `string` | equals, contains, startsWith, endsWith, in |
| `publicTemplateHtm` | `string` | equals, contains, startsWith, endsWith, in |
| `adminTemplateCss` | `string` | equals, contains, startsWith, endsWith, in |
| `adminTemplateHtm` | `string` | equals, contains, startsWith, endsWith, in |
| `admin_template_css_backup` | `string` | equals, contains, startsWith, endsWith, in |
| `admin_template_htm_backup` | `string` | equals, contains, startsWith, endsWith, in |
| `zendeskWidgetEnabled` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Calendars

Path: `activecampaign.db.calendars.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.calendars.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `type` | `string` | equals, contains, startsWith, endsWith, in |
| `token` | `string` | equals, contains, startsWith, endsWith, in |
| `userid` | `string` | equals, contains, startsWith, endsWith, in |
| `notification` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Campaigns

Path: `activecampaign.db.campaigns.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.campaigns.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `type` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `sdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |
| `ldate` | `string` | equals, contains, startsWith, endsWith, in |
| `send_amt` | `string` | equals, contains, startsWith, endsWith, in |
| `total_amt` | `string` | equals, contains, startsWith, endsWith, in |
| `opens` | `string` | equals, contains, startsWith, endsWith, in |
| `uniqueopens` | `string` | equals, contains, startsWith, endsWith, in |
| `linkclicks` | `string` | equals, contains, startsWith, endsWith, in |
| `uniquelinkclicks` | `string` | equals, contains, startsWith, endsWith, in |
| `subscriberclicks` | `string` | equals, contains, startsWith, endsWith, in |
| `unsubscribes` | `string` | equals, contains, startsWith, endsWith, in |
| `hardbounces` | `string` | equals, contains, startsWith, endsWith, in |
| `softbounces` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Connections

Path: `activecampaign.db.connections.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.connections.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `service` | `string` | equals, contains, startsWith, endsWith, in |
| `serviceName` | `string` | equals, contains, startsWith, endsWith, in |
| `externalid` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `logoUrl` | `string` | equals, contains, startsWith, endsWith, in |
| `linkUrl` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `syncStatus` | `string` | equals, contains, startsWith, endsWith, in |
| `connectionType` | `string` | equals, contains, startsWith, endsWith, in |
| `planTier` | `string` | equals, contains, startsWith, endsWith, in |
| `lastSync` | `string` | equals, contains, startsWith, endsWith, in |
| `sync_request_time` | `string` | equals, contains, startsWith, endsWith, in |
| `sync_start_time` | `string` | equals, contains, startsWith, endsWith, in |
| `credentialExpiration` | `string` | equals, contains, startsWith, endsWith, in |
| `disconnectDate` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Contact Lists

Path: `activecampaign.db.contactLists.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.contactLists.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `contact` | `string` | equals, contains, startsWith, endsWith, in |
| `list` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `form` | `string` | equals, contains, startsWith, endsWith, in |
| `seriesid` | `string` | equals, contains, startsWith, endsWith, in |
| `sdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |
| `responder` | `string` | equals, contains, startsWith, endsWith, in |
| `sync` | `string` | equals, contains, startsWith, endsWith, in |
| `unsubreason` | `string` | equals, contains, startsWith, endsWith, in |
| `campaign` | `string` | equals, contains, startsWith, endsWith, in |
| `message` | `string` | equals, contains, startsWith, endsWith, in |
| `first_name` | `string` | equals, contains, startsWith, endsWith, in |
| `last_name` | `string` | equals, contains, startsWith, endsWith, in |
| `ip4Sub` | `string` | equals, contains, startsWith, endsWith, in |
| `ip4Unsub` | `string` | equals, contains, startsWith, endsWith, in |
| `ip4_last` | `string` | equals, contains, startsWith, endsWith, in |
| `sourceid` | `string` | equals, contains, startsWith, endsWith, in |
| `autosyncLog` | `string` | equals, contains, startsWith, endsWith, in |
| `unsubscribeAutomation` | `string` | equals, contains, startsWith, endsWith, in |
| `automation` | `string` | equals, contains, startsWith, endsWith, in |
| `channel` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Contacts

Path: `activecampaign.db.contacts.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.contacts.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `email` | `string` | equals, contains, startsWith, endsWith, in |
| `firstName` | `string` | equals, contains, startsWith, endsWith, in |
| `lastName` | `string` | equals, contains, startsWith, endsWith, in |
| `phone` | `string` | equals, contains, startsWith, endsWith, in |
| `orgid` | `string` | equals, contains, startsWith, endsWith, in |
| `orgname` | `string` | equals, contains, startsWith, endsWith, in |
| `organization` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |
| `adate` | `string` | equals, contains, startsWith, endsWith, in |
| `edate` | `string` | equals, contains, startsWith, endsWith, in |
| `hash` | `string` | equals, contains, startsWith, endsWith, in |
| `ip` | `string` | equals, contains, startsWith, endsWith, in |
| `ua` | `string` | equals, contains, startsWith, endsWith, in |
| `gravatar` | `string` | equals, contains, startsWith, endsWith, in |
| `deleted` | `string` | equals, contains, startsWith, endsWith, in |
| `deleted_at` | `string` | equals, contains, startsWith, endsWith, in |
| `anonymized` | `string` | equals, contains, startsWith, endsWith, in |
| `email_local` | `string` | equals, contains, startsWith, endsWith, in |
| `email_domain` | `string` | equals, contains, startsWith, endsWith, in |
| `segmentio_id` | `string` | equals, contains, startsWith, endsWith, in |
| `bounced_hard` | `string` | equals, contains, startsWith, endsWith, in |
| `bounced_soft` | `string` | equals, contains, startsWith, endsWith, in |
| `bounced_date` | `string` | equals, contains, startsWith, endsWith, in |
| `sentcnt` | `string` | equals, contains, startsWith, endsWith, in |
| `rating_tstamp` | `string` | equals, contains, startsWith, endsWith, in |
| `socialdata_lastcheck` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_utc_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_utc_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `mpp_tracking` | `string` | equals, contains, startsWith, endsWith, in |
| `last_click_date` | `string` | equals, contains, startsWith, endsWith, in |
| `last_open_date` | `string` | equals, contains, startsWith, endsWith, in |
| `last_mpp_open_date` | `string` | equals, contains, startsWith, endsWith, in |
| `best_send_hour` | `string` | equals, contains, startsWith, endsWith, in |
| `sms_consent` | `string` | equals, contains, startsWith, endsWith, in |
| `sms_consent_updated_at` | `string` | equals, contains, startsWith, endsWith, in |
| `whatsapp_id` | `string` | equals, contains, startsWith, endsWith, in |
| `whatsapp_username` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Contact Tags

Path: `activecampaign.db.contactTags.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.contactTags.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `contact` | `string` | equals, contains, startsWith, endsWith, in |
| `tag` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Custom Object Schemas

Path: `activecampaign.db.customObjectSchemas.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.customObjectSchemas.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `slug` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `string` | equals, contains, startsWith, endsWith, in |
| `createdTimestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updatedTimestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deal Custom Field Meta

Path: `activecampaign.db.dealCustomFieldMeta.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.dealCustomFieldMeta.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldLabel` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldType` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldDefault` | `string` | equals, contains, startsWith, endsWith, in |
| `fieldDefaultCurrency` | `string` | equals, contains, startsWith, endsWith, in |
| `personalization` | `string` | equals, contains, startsWith, endsWith, in |
| `createdTimestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updatedTimestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deal Groups

Path: `activecampaign.db.dealGroups.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.dealGroups.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `allgroups` | `string` | equals, contains, startsWith, endsWith, in |
| `allusers` | `string` | equals, contains, startsWith, endsWith, in |
| `autoassign` | `string` | equals, contains, startsWith, endsWith, in |
| `source` | `string` | equals, contains, startsWith, endsWith, in |
| `count` | `string` | equals, contains, startsWith, endsWith, in |
| `win_probability_initialize_date` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deal Roles

Path: `activecampaign.db.dealRoles.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.dealRoles.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deals

Path: `activecampaign.db.deals.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.deals.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `string` | equals, contains, startsWith, endsWith, in |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `contact` | `string` | equals, contains, startsWith, endsWith, in |
| `organization` | `string` | equals, contains, startsWith, endsWith, in |
| `group` | `string` | equals, contains, startsWith, endsWith, in |
| `stage` | `string` | equals, contains, startsWith, endsWith, in |
| `owner` | `string` | equals, contains, startsWith, endsWith, in |
| `nextdate` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |
| `edate` | `string` | equals, contains, startsWith, endsWith, in |
| `hash` | `string` | equals, contains, startsWith, endsWith, in |
| `nextdealid` | `string` | equals, contains, startsWith, endsWith, in |
| `nexttaskid` | `string` | equals, contains, startsWith, endsWith, in |
| `activitycount` | `string` | equals, contains, startsWith, endsWith, in |
| `winProbabilityMdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deal Stages

Path: `activecampaign.db.dealStages.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.dealStages.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `group` | `string` | equals, contains, startsWith, endsWith, in |
| `order` | `string` | equals, contains, startsWith, endsWith, in |
| `width` | `string` | equals, contains, startsWith, endsWith, in |
| `color` | `string` | equals, contains, startsWith, endsWith, in |
| `dealOrder` | `string` | equals, contains, startsWith, endsWith, in |
| `cardRegion1` | `string` | equals, contains, startsWith, endsWith, in |
| `cardRegion2` | `string` | equals, contains, startsWith, endsWith, in |
| `cardRegion3` | `string` | equals, contains, startsWith, endsWith, in |
| `cardRegion4` | `string` | equals, contains, startsWith, endsWith, in |
| `cardRegion5` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deal Tasks

Path: `activecampaign.db.dealTasks.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.dealTasks.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `note` | `string` | equals, contains, startsWith, endsWith, in |
| `relid` | `string` | equals, contains, startsWith, endsWith, in |
| `reltype` | `string` | equals, contains, startsWith, endsWith, in |
| `dealtasktype` | `string` | equals, contains, startsWith, endsWith, in |
| `duedate` | `string` | equals, contains, startsWith, endsWith, in |
| `done` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `owner` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `edate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Deal Task Types

Path: `activecampaign.db.dealTaskTypes.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.dealTaskTypes.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `defduration` | `string` | equals, contains, startsWith, endsWith, in |
| `display_order` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_utc_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_utc_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Ecom Customers

Path: `activecampaign.db.ecomCustomers.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.ecomCustomers.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `connectionid` | `string` | equals, contains, startsWith, endsWith, in |
| `externalid` | `string` | equals, contains, startsWith, endsWith, in |
| `email` | `string` | equals, contains, startsWith, endsWith, in |
| `totalRevenue` | `string` | equals, contains, startsWith, endsWith, in |
| `totalOrders` | `string` | equals, contains, startsWith, endsWith, in |
| `totalProducts` | `string` | equals, contains, startsWith, endsWith, in |
| `avgRevenuePerOrder` | `string` | equals, contains, startsWith, endsWith, in |
| `avgProductCategory` | `string` | equals, contains, startsWith, endsWith, in |
| `acceptsMarketing` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Event Tracking Events

Path: `activecampaign.db.eventTrackingEvents.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.eventTrackingEvents.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Field Options

Path: `activecampaign.db.fieldOptions.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.fieldOptions.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `field` | `string` | equals, contains, startsWith, endsWith, in |
| `label` | `string` | equals, contains, startsWith, endsWith, in |
| `value` | `string` | equals, contains, startsWith, endsWith, in |
| `orderid` | `string` | equals, contains, startsWith, endsWith, in |
| `isdefault` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Field Rels

Path: `activecampaign.db.fieldRels.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.fieldRels.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `field` | `string` | equals, contains, startsWith, endsWith, in |
| `relid` | `string` | equals, contains, startsWith, endsWith, in |
| `dorder` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Fields

Path: `activecampaign.db.fields.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.fields.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `descript` | `string` | equals, contains, startsWith, endsWith, in |
| `type` | `string` | equals, contains, startsWith, endsWith, in |
| `perstag` | `string` | equals, contains, startsWith, endsWith, in |
| `defval` | `string` | equals, contains, startsWith, endsWith, in |
| `isrequired` | `string` | equals, contains, startsWith, endsWith, in |
| `show_in_list` | `string` | equals, contains, startsWith, endsWith, in |
| `visible` | `string` | equals, contains, startsWith, endsWith, in |
| `service` | `string` | equals, contains, startsWith, endsWith, in |
| `ordernum` | `string` | equals, contains, startsWith, endsWith, in |
| `rows` | `string` | equals, contains, startsWith, endsWith, in |
| `cols` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Field Values

Path: `activecampaign.db.fieldValues.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.fieldValues.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `contact` | `string` | equals, contains, startsWith, endsWith, in |
| `field` | `string` | equals, contains, startsWith, endsWith, in |
| `value` | `string` | equals, contains, startsWith, endsWith, in |
| `owner` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Forms

Path: `activecampaign.db.forms.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.forms.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `action` | `string` | equals, contains, startsWith, endsWith, in |
| `layout` | `string` | equals, contains, startsWith, endsWith, in |
| `style` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Group Limits

Path: `activecampaign.db.groupLimits.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.groupLimits.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `group` | `string` | equals, contains, startsWith, endsWith, in |
| `groupid` | `string` | equals, contains, startsWith, endsWith, in |
| `limitContact` | `string` | equals, contains, startsWith, endsWith, in |
| `limitList` | `string` | equals, contains, startsWith, endsWith, in |
| `limitCampaign` | `string` | equals, contains, startsWith, endsWith, in |
| `limitCampaignType` | `string` | equals, contains, startsWith, endsWith, in |
| `limitMail` | `string` | equals, contains, startsWith, endsWith, in |
| `limitMailType` | `string` | equals, contains, startsWith, endsWith, in |
| `limitUser` | `string` | equals, contains, startsWith, endsWith, in |
| `limitAttachment` | `string` | equals, contains, startsWith, endsWith, in |
| `abuseRatio` | `string` | equals, contains, startsWith, endsWith, in |
| `forceSenderInfo` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Group Members

Path: `activecampaign.db.groupMembers.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.groupMembers.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Groups

Path: `activecampaign.db.groups.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.groups.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `descript` | `string` | equals, contains, startsWith, endsWith, in |
| `p_admin` | `string` | equals, contains, startsWith, endsWith, in |
| `sdate` | `string` | equals, contains, startsWith, endsWith, in |
| `unsubscribelink` | `string` | equals, contains, startsWith, endsWith, in |
| `optinconfirm` | `string` | equals, contains, startsWith, endsWith, in |
| `socialdata` | `string` | equals, contains, startsWith, endsWith, in |
| `reqApproval` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## List Groups

Path: `activecampaign.db.listGroups.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.listGroups.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `list` | `string` | equals, contains, startsWith, endsWith, in |
| `group` | `string` | equals, contains, startsWith, endsWith, in |
| `p_list_add` | `string` | equals, contains, startsWith, endsWith, in |
| `p_list_edit` | `string` | equals, contains, startsWith, endsWith, in |
| `p_list_delete` | `string` | equals, contains, startsWith, endsWith, in |
| `p_list_filter` | `string` | equals, contains, startsWith, endsWith, in |
| `p_list_sync` | `string` | equals, contains, startsWith, endsWith, in |
| `p_message_add` | `string` | equals, contains, startsWith, endsWith, in |
| `p_message_edit` | `string` | equals, contains, startsWith, endsWith, in |
| `p_message_delete` | `string` | equals, contains, startsWith, endsWith, in |
| `p_message_send` | `string` | equals, contains, startsWith, endsWith, in |
| `p_subscriber_add` | `string` | equals, contains, startsWith, endsWith, in |
| `p_subscriber_edit` | `string` | equals, contains, startsWith, endsWith, in |
| `p_subscriber_delete` | `string` | equals, contains, startsWith, endsWith, in |
| `p_subscriber_import` | `string` | equals, contains, startsWith, endsWith, in |
| `p_subscriber_approve` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Lists

Path: `activecampaign.db.lists.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.lists.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `stringid` | `string` | equals, contains, startsWith, endsWith, in |
| `userid` | `string` | equals, contains, startsWith, endsWith, in |
| `user` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |
| `channel` | `string` | equals, contains, startsWith, endsWith, in |
| `private` | `string` | equals, contains, startsWith, endsWith, in |
| `deletestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `active_subscribers` | `string` | equals, contains, startsWith, endsWith, in |
| `non_deleted_subscribers` | `string` | equals, contains, startsWith, endsWith, in |
| `subscription_notify` | `string` | equals, contains, startsWith, endsWith, in |
| `unsubscription_notify` | `string` | equals, contains, startsWith, endsWith, in |
| `require_name` | `string` | equals, contains, startsWith, endsWith, in |
| `get_unsubscribe_reason` | `string` | equals, contains, startsWith, endsWith, in |
| `to_name` | `string` | equals, contains, startsWith, endsWith, in |
| `optinoptout` | `string` | equals, contains, startsWith, endsWith, in |
| `optinmessageid` | `string` | equals, contains, startsWith, endsWith, in |
| `optoutconf` | `string` | equals, contains, startsWith, endsWith, in |
| `carboncopy` | `string` | equals, contains, startsWith, endsWith, in |
| `fulladdress` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_name` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_addr1` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_addr2` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_city` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_state` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_zip` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_country` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_phone` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_url` | `string` | equals, contains, startsWith, endsWith, in |
| `sender_reminder` | `string` | equals, contains, startsWith, endsWith, in |
| `send_last_broadcast` | `string` | equals, contains, startsWith, endsWith, in |
| `analytics_domains` | `string` | equals, contains, startsWith, endsWith, in |
| `analytics_source` | `string` | equals, contains, startsWith, endsWith, in |
| `analytics_ua` | `string` | equals, contains, startsWith, endsWith, in |
| `twitter_token` | `string` | equals, contains, startsWith, endsWith, in |
| `twitter_token_secret` | `string` | equals, contains, startsWith, endsWith, in |
| `facebook_session` | `string` | equals, contains, startsWith, endsWith, in |
| `p_use_tracking` | `string` | equals, contains, startsWith, endsWith, in |
| `p_use_analytics_read` | `string` | equals, contains, startsWith, endsWith, in |
| `p_use_analytics_link` | `string` | equals, contains, startsWith, endsWith, in |
| `p_use_twitter` | `string` | equals, contains, startsWith, endsWith, in |
| `p_use_facebook` | `string` | equals, contains, startsWith, endsWith, in |
| `p_embed_image` | `string` | equals, contains, startsWith, endsWith, in |
| `p_use_captcha` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Messages

Path: `activecampaign.db.messages.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.messages.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `subject` | `string` | equals, contains, startsWith, endsWith, in |
| `preheader_text` | `string` | equals, contains, startsWith, endsWith, in |
| `fromname` | `string` | equals, contains, startsWith, endsWith, in |
| `fromemail` | `string` | equals, contains, startsWith, endsWith, in |
| `reply2` | `string` | equals, contains, startsWith, endsWith, in |
| `html` | `string` | equals, contains, startsWith, endsWith, in |
| `text` | `string` | equals, contains, startsWith, endsWith, in |
| `htmlfetch` | `string` | equals, contains, startsWith, endsWith, in |
| `textfetch` | `string` | equals, contains, startsWith, endsWith, in |
| `charset` | `string` | equals, contains, startsWith, endsWith, in |
| `encoding` | `string` | equals, contains, startsWith, endsWith, in |
| `format` | `string` | equals, contains, startsWith, endsWith, in |
| `language_code` | `string` | equals, contains, startsWith, endsWith, in |
| `priority` | `string` | equals, contains, startsWith, endsWith, in |
| `source` | `string` | equals, contains, startsWith, endsWith, in |
| `hidden` | `string` | equals, contains, startsWith, endsWith, in |
| `user` | `string` | equals, contains, startsWith, endsWith, in |
| `userid` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |
| `ed_instanceid` | `string` | equals, contains, startsWith, endsWith, in |
| `ed_version` | `string` | equals, contains, startsWith, endsWith, in |
| `has_predictive_content` | `string` | equals, contains, startsWith, endsWith, in |
| `preview_mime` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Notes

Path: `activecampaign.db.notes.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.notes.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `note` | `string` | equals, contains, startsWith, endsWith, in |
| `reltype` | `string` | equals, contains, startsWith, endsWith, in |
| `relid` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |
| `userid` | `string` | equals, contains, startsWith, endsWith, in |
| `user` | `string` | equals, contains, startsWith, endsWith, in |
| `is_draft` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Personalizations

Path: `activecampaign.db.personalizations.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.personalizations.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `tag` | `string` | equals, contains, startsWith, endsWith, in |
| `content` | `string` | equals, contains, startsWith, endsWith, in |
| `format` | `string` | equals, contains, startsWith, endsWith, in |
| `locked` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `udate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Saved Responses

Path: `activecampaign.db.savedResponses.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.savedResponses.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `subject` | `string` | equals, contains, startsWith, endsWith, in |
| `body` | `string` | equals, contains, startsWith, endsWith, in |
| `userid` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Scores

Path: `activecampaign.db.scores.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.scores.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `descript` | `string` | equals, contains, startsWith, endsWith, in |
| `reltype` | `string` | equals, contains, startsWith, endsWith, in |
| `status` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Segments

Path: `activecampaign.db.segments.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.segments.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `logic` | `string` | equals, contains, startsWith, endsWith, in |
| `hidden` | `string` | equals, contains, startsWith, endsWith, in |
| `seriesid` | `string` | equals, contains, startsWith, endsWith, in |
| `segmentid_v2` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Tags

Path: `activecampaign.db.tags.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.tags.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `tag` | `string` | equals, contains, startsWith, endsWith, in |
| `tagType` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `string` | equals, contains, startsWith, endsWith, in |
| `subscriber_count` | `string` | equals, contains, startsWith, endsWith, in |
| `deleted` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Task Outcomes

Path: `activecampaign.db.taskOutcomes.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.taskOutcomes.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `sentiment` | `string` | equals, contains, startsWith, endsWith, in |
| `disabled` | `string` | equals, contains, startsWith, endsWith, in |
| `created_by` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_by` | `string` | equals, contains, startsWith, endsWith, in |
| `created_utc_timestamp` | `string` | equals, contains, startsWith, endsWith, in |
| `updated_utc_timestamp` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Templates

Path: `activecampaign.db.templates.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.templates.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `subject` | `string` | equals, contains, startsWith, endsWith, in |
| `content` | `string` | equals, contains, startsWith, endsWith, in |
| `categoryid` | `string` | equals, contains, startsWith, endsWith, in |
| `userid` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `mdate` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Users

Path: `activecampaign.db.users.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.users.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `username` | `string` | equals, contains, startsWith, endsWith, in |
| `email` | `string` | equals, contains, startsWith, endsWith, in |
| `firstName` | `string` | equals, contains, startsWith, endsWith, in |
| `lastName` | `string` | equals, contains, startsWith, endsWith, in |
| `phone` | `string` | equals, contains, startsWith, endsWith, in |
| `signature` | `string` | equals, contains, startsWith, endsWith, in |
| `lang` | `string` | equals, contains, startsWith, endsWith, in |
| `localZoneid` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Webhooks

Path: `activecampaign.db.webhooks.search`

```ts theme={null}
const rows = await corsair.activecampaign.db.webhooks.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `url` | `string` | equals, contains, startsWith, endsWith, in |
| `listid` | `string` | equals, contains, startsWith, endsWith, in |
| `cdate` | `string` | equals, contains, startsWith, endsWith, in |
| `state` | `string` | equals, contains, startsWith, endsWith, in |
| `deactivated_date` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.