invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectsNewGen: Freshservice Projects (New Gen)

read only REST

  • Catalog: Freshservice
  • Schema: Freshservice
  • Primary Keys: id
  • Label: Projects (New Gen)

Can only retrieve data.

API Source

  • Endpoint: /pm/projects

Table Columns

The columns of the table ProjectsNewGen 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
archived char itgen_freshservice_archived
created_at datetime itgen_freshservice_created_at Date/time at which the record was created.
description varchar2 Description
description_custom_field varchar2 Description Custom field #0 of type custom_text.
end_date datetime itgen_freshservice_end_date
end_date_custom_field varchar2 End Date Custom field #0 of type custom_text.
id int64 ID ID of an agent.
key varchar2 itgen_freshservice_key
key_custom_field varchar2 Project Key Custom field #0 of type custom_text.
manager_id int64 itgen_freshservice_manager_id
manager_id_custom_field varchar2 Project Manager Custom field #0 of type custom_text.
name varchar2 Name
name_custom_field varchar2 Name Custom field #0 of type custom_text.
priority_id int64 itgen_freshservice_priority_id
priority_id_custom_field varchar2 Priority Custom field #0 of type custom_text.
project_type int16 itgen_freshservice_project_type
project_type_custom_field varchar2 Project Type Custom field #0 of type custom_text.
sprint_duration int16 itgen_freshservice_sprint_duration
sprint_duration_custom_field varchar2 Sprint Duration (in days) Custom field #0 of type custom_text.
start_date datetime itgen_freshservice_start_date
start_date_custom_field varchar2 Start Date Custom field #0 of type custom_text.
status_id int64 itgen_freshservice_status_id
status_id_custom_field varchar2 Status Custom field #0 of type custom_text.
updated_at datetime itgen_freshservice_updated_at Date/time at which the record was last updated.
visibility int16 Visibility
visibility_custom_field varchar2 Privacy Custom field #0 of type custom_text.

Release Notes

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