Please enable JavaScript to view this site.

Navigation: Schema: Freshdesk > Tables

time_entries: Freshdesk Time Entries

Catalog: Freshdesk

Schema: Freshdesk

Primary Keys: id

Label: Time Entries

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

Select Freshdesk API URL: /time_entries

Insert Freshdesk API URL: /time_entries

Update Freshdesk API URL: /time_entries

Delete Freshdesk API URL: /time_entries

Field Selection Method: NotRequired

Table Columns

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

Name

Data Type

Label

Required

Documentation

agent_email

string

 

The agent email in the response related to user_id.

agent_id

int64

Agent ID

 

agent_name

string

 

System fills the agent name in the response from the user_id.

billable

boolean

Billable

Whether the entry is billable.

company_id

int64

Company ID

 

contact_email

string

Contact Email Address

The requester email of the ticket.

created_at

datetime

Created at

Date/time at which the record was created.

customer_name

string

 

The customer name.

executed_at

datetime

Executed at

Time at which this time-entry id added/created.

hhmm

string

 

The number of hours (in hh:mm format). Used to set the total time_spent. If this property is set via update call the timer_running will be stopped and reset to the passed value.

id

int64

ID

ID of the time entry.

note

string

Note

Description on this time entry.

start_time

datetime

Start Time

The time at which the time entry is added or the time of the last invoked 'start-timer' action using a toggle.

ticket_id

int64

Ticket ID

The ID of the ticket to which this time entry is associated. Id is passed as part of the handle URL.

time_spent

datetime

Time Spent

 

timer_running

boolean

Timer Running

Whether the start timer is invoked and is currently running.

updated_at

datetime

Updated at

Date/time at which the record was last updated.

user_id

int64

User ID

The user/agent to whom this time entry is associated.

 

27-12-2021 10:23 Version 20.2.169-PROD+3633