---
title: "contacts (Freshdesk)"
description: "Contacts"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Freshdesk.contacts
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Freshdesk.contacts
updated: 2026-06-04T07:55:59Z
license: https://documentation.invantive.eu/en/
---

# contacts: Freshdesk Contacts

`insert` `update` `delete` `REST`

- Catalog: `Freshdesk`
- Schema: `Freshdesk`
- Primary Keys: `id`
- Label: Contacts

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/contacts`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `_updated_since` | `datetime` | [ ] | 01/01/1900 00:00:00 | Limit to contacts updated since. |
| `company_id` | `int64` | [ ] |  | Company ID of contact. |
| `email` | `varchar2` | [ ] |  | Email address of the contact. |
| `mobile` | `varchar2` | [ ] |  | Mobile number of the contact. |
| `phone` | `varchar2` | [ ] |  | Phone of the contact. |
| `query` | `varchar2` | [ ] |  | Custom query matching Freshdesk specifications, such as 'active:true'. |
| `state` | `varchar2` | [ ] |  | Pre-defined filter: 'blocked', 'deleted', 'unverified' and 'verified'. |

## Table Columns

The columns of the table `contacts` 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` | `char` | Active | [ ] |  | Whether the user has been verified. |
| `address` | `varchar2` | Address | [ ] |  | Address of the user. |
| `company_id` | `int64` | Company ID | [ ] |  |  |
| `created_at` | `datetime` | Created at | [ ] |  | Date/time at which the record was created. |
| `customer_id` | `int64` | Customer ID | [ ] |  | ID of the company to which this user belongs. |
| `deleted` | `char` | Deleted | [ ] |  | Whether the contact has been deleted. |
| `description` | `varchar2` | Description | [ ] |  | A short description about the user. |
| `email` | `varchar2` | Email | [ ] |  | Primary email for the user. |
| `external_id` | `int64` | External ID | [ ] |  | Internal usage. |
| `helpdesk_agent` | `char` | Helpdesk Agent | [ ] |  | Whether the user is an agent. |
| `id` | `int64` | ID | [x] |  | ID of the user. |
| `job_title` | `varchar2` | Job Title | [ ] |  | Job title of the user. |
| `language` | `varchar2` | Language | [ ] |  | Language of the user. Default language is 'en' for English. |
| `mobile` | `varchar2` | Mobile | [ ] |  | Mobile number of the user. |
| `name` | `varchar2` | Name | [ ] |  | Name of the user. |
| `phone` | `varchar2` | Phone | [ ] |  | Phone number of the user. |
| `time_zone` | `varchar2` | Time Zone | [ ] |  | Time zone of the user. |
| `twitter_id` | `varchar2` | Twitter ID | [ ] |  | Twitter ID of the user. |
| `unique_external_id` | `varchar2` | Unique External ID | [ ] |  | External ID of the user. |
| `updated_at` | `datetime` | Updated at | [ ] |  | Date/time at which the record was last updated. |
| `view_all_tickets` | `char` | View All Tickets | [ ] |  | Whether the contact can see all tickets that are associated with the company to which the contact belongs. |



## Release Notes

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

- [Freshdesk](/en/release-notes/drivers?driver=freshdesk)

