invantive documentation
Invantive Support ForumsLog In / Sign Up

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 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: