invantive documentation
Invantive SupportforenAnmelden / Eintragen

contacts: Freshdesk Contacts

insert update delete REST

  • Katalog: Freshdesk
  • Schema: Freshdesk
  • Primärschlüssel: id
  • Rubrik: Kontakte

Mit insert, update und delete können Daten abgerufen und geändert werden.

API-Quelle

  • Endpunkt: /contacts

Parameter

Name Datentyp 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'.

Tabellenspalten

Die Spalten der Tabelle contacts sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
active char Active Whether the user has been verified.
address varchar2 Address Address of the user.
company_id int64 Firmen ID
created_at datetime Erstellt bei Date/time at which the record was created.
customer_id int64 Kunden-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 Externe ID Internal usage.
helpdesk_agent char Helpdesk-Mitarbeiter Whether the user is an agent.
id int64 ID ID of the user.
job_title varchar2 Funktionstitel Berufsbezeichnung des Benutzers.
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 des Benutzers.
phone varchar2 Phone Phone number of the user.
time_zone varchar2 Zeitzone Time zone of the user.
twitter_id varchar2 Twitter ID Twitter ID of the user.
unique_external_id varchar2 Eindeutige externe ID External ID of the user.
updated_at datetime Aktualisiert am Date/time at which the record was last updated.
view_all_tickets char Alle Tickets anzeigen Whether the contact can see all tickets that are associated with the company to which the contact belongs.

Anmerkungen zu dieser Version

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