Please enable JavaScript to view this site.

Made in EU
Freshservice Forums

Freshservice API Data Model

Navigation: Catalog: Freshservice > Schemas > Schema: Freshservice > Tables

Agents

Catalog: Freshservice

Schema: Freshservice

Primary Keys: id

This is a read-only table. The Freshservice API may not support changing the data or the Invantive UniversalSQL driver for Freshservice does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshservice API.

Table Columns

The columns of the table Agents are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

aariverside_cloud

string

AaRiverside Cloud

☐

Custom field #50000080954 of type custom_text.

active

boolean

 

☑

 

address_custom_field

string

Address

☐

Custom field #50000005748 of type custom_text.

address

string

 

☐

 

api_key_enabled

boolean

 

☑

 

auto_assign_status_changed_at

datetime

 

☐

 

auto_assign_tickets

boolean

 

☑

 

azure

string

AZURE

☐

Custom field #50000080935 of type custom_text.

background_information

string

 

☐

 

can_see_all_tickets_from_associated_departments

boolean

 

☑

 

change_department_head

string

Can see all changes from these companies

☐

Custom field #50000081273 of type custom_text.

created_at

datetime

 

☐

Date/time at which the record was created.

datum_aangemaakt

string

Datum aangemaakt

☐

Custom field #50000008838 of type custom_text.

debiteur_nummer

string

Debiteur nummer

☐

Custom field #50000009953 of type custom_text.

department_head

string

Can see all tickets from associated companies

☐

Custom field #50000005746 of type custom_text.

department_names

string

 

☐

 

department

string

Company

☐

Custom field #50000005745 of type custom_text.

description

string

Background Information

☐

Custom field #50000005752 of type custom_text.

email_custom_field

string

Email

☐

Custom field #50000005742 of type custom_text.

email

string

 

☐

 

external_id

string

 

☐

 

first_name_custom_field

string

First Name

☐

Custom field #50000005739 of type custom_text.

first_name

string

 

☐

 

geslacht

string

Geslacht

☐

Custom field #50000008734 of type custom_text.

has_logged_in

boolean

 

☑

 

id

int64

 

☑

ID of an agent.

job_title_custom_field

string

Title

☐

Custom field #50000005741 of type custom_text.

job_title

string

 

☐

 

language_custom_field

string

Language

☐

Custom field #50000005750 of type custom_text.

language

string

 

☐

 

last_active_at

datetime

 

☐

 

last_login_at

datetime

 

☐

 

last_name_custom_field

string

Last Name

☐

Custom field #50000005740 of type custom_text.

last_name

string

 

☐

 

location_id_custom_field

string

Location

☐

Custom field #50000005751 of type custom_text.

location_id

int64

 

☐

 

location_name

string

 

☐

 

mobile_phone_number

string

 

☐

 

mobile

string

Mobile Phone

☐

Custom field #50000005744 of type custom_text.

nocore_online_url

string

Nocore online URL

☐

Custom field #50000080936 of type custom_text.

occasional

boolean

 

☑

 

phone

string

Work Phone

☐

Custom field #50000005743 of type custom_text.

reporting_manager_id

int64

 

☐

 

reporting_manager

string

Reporting Manager

☐

Custom field #50000005747 of type custom_text.

scoreboard_points

string

 

☐

 

signature

string

 

☐

 

sla

string

SLA

☐

Custom field #50000010025 of type custom_text.

soort_gebruiker

string

Soort gebruiker

☐

Custom field #50000008735 of type custom_text.

soort_klant

string

Soort klant

☐

Custom field #50000008592 of type custom_text.

time_format_custom_field

string

Time Format

☐

Custom field #50000020648 of type custom_text.

time_format

string

 

☐

 

time_zone_custom_field

string

Time Zone

☐

Custom field #50000005749 of type custom_text.

time_zone

string

 

☐

 

updated_at

datetime

 

☐

Date/time at which the record was last updated.

vip_user_custom_field

string

Mark as VIP

☐

Custom field #50000080341 of type custom_text.

vip_user

boolean

 

☑

 

werktijden

string

Werktijden

☐

Custom field #50000008839 of type custom_text.

work_phone_number

string

 

☐

 

 

11-12-2024 09:11 Version 24.0.491-PROD+5130

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.
  
Disclaimer