Freshservice Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
Freshservice Tables
| Name | Description |
| AgentGroups | List all agent groups. |
| AgentRoles | List all agent roles. |
| Agents | List all agents. |
| Approvals | List all approvals in your account. The request must filter on both the Parent and one of the following: ApproverId, StatusName, ParentId, or DelegateeId. For instance, Select * from Approvals where Parent='ticket' and ParentId=11. |
| AssetComponents | List all asset components in your account. |
| Assets | List all assets in your account. |
| AssetTypes | List all the asset types in your account. |
| ChangeDetails | Retrieve the change with the given ID from Freshservice. |
| ChangeNotes | Retrieve a list of all notes on a Change request with the given ID from Freshservice. |
| Changes | List changes in your account.By default only changes that have been created within the past 30 days will be returned. For older changes, use the UpdatedSince filter. |
| ChangeTasks | Retrieve the tasks on a Change request with the given ID from Freshservice. |
| ChangeTimeEntries | Retrieve the time entries on a Change request with the given ID from Freshservice. |
| Contracts | List all contracts in your account. |
| Conversations | List all conversations of a ticket. |
| Departments | List all departments in your account. |
| EmployeeOffboardingFormFields | List all the fields in the Initiator’s Offboarding form. |
| EmployeeOffboardingRequests | List all employee offboarding requests. |
| EmployeeOffboardingTickets | List all the Offboarding Tickets associated with an Offboarding Request. |
| EmployeeOnboardingFormFields | List all the fields in the Initiator’s Onboarding form. |
| EmployeeOnboardingRequests | List all employee onboarding requests. |
| EmployeeOnboardingTickets | List all the Onboarding Tickets associated with an Onboarding Request. |
| Locations | List all locations in your account. |
| ProblemDetails | Retrieve the problem with the given ID from Freshservice. |
| ProblemNotes | Retrieve a list of all notes on a Problem request with the given ID from Freshservice. |
| Problems | List all problems in your account. |
| ProblemTasks | Retrieve the tasks on a Problem request with the given ID from Freshservice. |
| ProblemTimeEntries | Retrieve the time entries on a Problem request with the given ID from Freshservice. |
| Products | List all products in your account. |
| PurchaseOrders | List all purchase orders in your account. |
| RequesterFields | List all requester fields. |
| RequesterGroupMembers | List all members for a give requester group in your account. |
| RequesterGroups | List all requester groups in your account. |
| Requesters | List all requesters in the account, including agents. |
| ServiceCatalogItems | List all service items in your account, or a single service item if the DisplayId is specified. |
| TicketFields | List all ticket fields. |
| Tickets | List tickets. |
| Vendors | List all vendors in your account. |
| Workspaces | List all workspaces in your account. |