Freshservice Data Model
Authentication Authentication can be done using one of the following two alternatives:
- Using the user log on code, password and company also used on the Freshservice website.
- Using an API key and company. Authentication using user log on code and password is recommended for general use. The company is the name before '.freshservice.com' in the URL used to log on to Freshservice in a browser. The API key can be found in the 'Edit Profile' page in Freshservice, as described on https://support.freshservice.com/support/solutions/articles/225435-where-can-i-find-my-api-key.
API Version The V2 API of Freshservice is used. V1 APIs can be accessed using NativePlatformScalarRequests.
Usage Limits Invantive SQL executes API calls to retrieve and upload data. The number of API calls allowed per hour depends on your Freshservice plan, API version and whether you have chosen for rate limits per minute (most recent) or hour (older). The V1 API default usage limit is 1.000 calls per hour. On V2 the limit is 3.000 (blossom, garden) or 5.000 (estate, forest) calls per hour. The new V2 limits are 100 (blossom), 200 (garden), 400 (estate) or 700 (forest) calls per minute. Increased limits can be purchased. Invantive SQL ensures that within your session the number of calls allowed per hour is not exceeded. To get an impression of how Invantive SQL translates into API calls, please query the data dictionary view 'sessionios', such as with 'select * from sessionios@datadictionary'.
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/freshservice
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Daten können sowohl geschrieben als auch gelesen werden.
- Invantive Cloud plans: Free for Exact Online, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://updates.freshservice.com/.
Angaben
| Figure | Count |
|---|---|
| Tables | 73 |
| Columns | 928 |
Poster zum Daten Muster
In diesem Daten Muster sind noch keine Schlüssel definiert; die durch Punkte getrennten Relationen werden aus den Namen der Spalten abgeleitet.
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
Freshservice · Departments
AgentRoles, AgentWorkspaces, Agents, AssetSources, Assets, Changes, Contracts, Departments, Locations, Problems, PurchaseOrders, RecentTickets, Releases, Requesters, TicketsIncremental, Vendors
Freshservice · Workspaces
AgentGroups, Announcements, Applications, BusinessHours, CannedResponses, ProblemFormFields, Products, ServiceCategories, ServiceItems, SlaPolicies, SolutionCategories, Workspaces
CodeValues (ohne Beziehungen)
ApplicationStatuses, ApplicationTypes, ApprovalStatuses, ApprovalTypes, AssetImpacts, AssetUsageTypes, BackgroundJobStatuses, ChangeImpacts, ChangePriorities, ChangeRisks, ChangeStatuses, ChangeTypes, ConversationSourceTypes, CustomFieldTypes, LookupDatasources, OffboardingRequestStatuses, OnboardingRequestStatuses, ProductProcurementModes, ProductStatuses, ProjectPriorities, ProjectStatuses, ProjectTypes, ProjectVisibilities, ServiceRequestStages, SolutionFolderVisibilities, TicketPriorities, TicketSourceTypes, TicketStatuses
Freshservice (ohne Beziehungen)
AgentGroupMembers, AssetTypes, BusinessHourHolidays, CABs, ContractTypes, ProblemFormFieldChoices, ProjectTemplates, ProjectsNewGen, RelationshipTypes, Relationships, RequesterGroups, StatisticsIncremental
Native (ohne Beziehungen)
Views (ohne Beziehungen)
Beziehungen
- AgentGroups → Workspaces (Kandidat): Derived from the column workspace_id.
- AgentRoles → Agents (Kandidat): Derived from the column agent_id.
- AgentWorkspaces → Agents (Kandidat): Derived from the column agent_id.
- Agents → Locations (Kandidat): Derived from the column location_id.
- Announcements → Workspaces (Kandidat): Derived from the column workspace_id.
- Applications → Workspaces (Kandidat): Derived from the column workspace_id.
- AssetSources → Assets (Kandidat): Derived from the column asset_id.
- Assets → Agents (Kandidat): Derived from the column agent_id.
- Assets → Departments (Kandidat): Derived from the column department_id.
- Assets → Locations (Kandidat): Derived from the column location_id.
- BusinessHours → Workspaces (Kandidat): Derived from the column workspace_id.
- CannedResponses → Workspaces (Kandidat): Derived from the column workspace_id.
- Changes → Agents (Kandidat): Derived from the column agent_id.
- Changes → Departments (Kandidat): Derived from the column department_id.
- Changes → Requesters (Kandidat): Derived from the column requester_id.
- Changes → Workspaces (Kandidat): Derived from the column workspace_id.
- Contracts → Requesters (Kandidat): Derived from the column requester_id.
- Contracts → Vendors (Kandidat): Derived from the column vendor_id.
- Contracts → Workspaces (Kandidat): Derived from the column workspace_id.
- ProblemFormFields → Workspaces (Kandidat): Derived from the column workspace_id.
- Problems → Agents (Kandidat): Derived from the column agent_id.
- Problems → Departments (Kandidat): Derived from the column department_id.
- Problems → Requesters (Kandidat): Derived from the column requester_id.
- PurchaseOrders → Departments (Kandidat): Derived from the column department_id.
- PurchaseOrders → Vendors (Kandidat): Derived from the column vendor_id.
- PurchaseOrders → Workspaces (Kandidat): Derived from the column workspace_id.
- RecentTickets → Departments (Kandidat): Derived from the column department_id.
- RecentTickets → Requesters (Kandidat): Derived from the column requester_id.
- RecentTickets → Workspaces (Kandidat): Derived from the column workspace_id.
- Releases → Agents (Kandidat): Derived from the column agent_id.
- Releases → Departments (Kandidat): Derived from the column department_id.
- Releases → Workspaces (Kandidat): Derived from the column workspace_id.
- Requesters → Locations (Kandidat): Derived from the column location_id.
- ServiceCategories → Workspaces (Kandidat): Derived from the column workspace_id.
- ServiceItems → Products (Kandidat): Derived from the column product_id.
- ServiceItems → Workspaces (Kandidat): Derived from the column workspace_id.
- SlaPolicies → Workspaces (Kandidat): Derived from the column workspace_id.
- SolutionCategories → Workspaces (Kandidat): Derived from the column workspace_id.
- TicketsIncremental → Departments (Kandidat): Derived from the column department_id.
- TicketsIncremental → Requesters (Kandidat): Derived from the column requester_id.
- TicketsIncremental → Workspaces (Kandidat): Derived from the column workspace_id.
Tabellen
Freshservice.CodeValues
- ApplicationStatuses: Domain ApplicationStatuses
- ApplicationTypes: Domain ApplicationTypes
- ApprovalStatuses: Domain ApprovalStatuses
- ApprovalTypes: Domain ApprovalTypes
- AssetImpacts: Domain AssetImpacts
- AssetUsageTypes: Domain AssetUsageTypes
- BackgroundJobStatuses: Domain BackgroundJobStatuses
- ChangeImpacts: Domain ChangeImpacts
- ChangePriorities: Domain ChangePriorities
- ChangeRisks: Domain ChangeRisks
- ChangeStatuses: Domain ChangeStatuses
- ChangeTypes: Domain ChangeTypes
- ConversationSourceTypes: Domain ConversationSourceTypes
- CustomFieldTypes: Domain CustomFieldTypes
- LookupDatasources: Domain LookupDatasources
- OffboardingRequestStatuses: Domain OffboardingRequestStatuses
- OnboardingRequestStatuses: Domain OnboardingRequestStatuses
- ProductProcurementModes: Domain ProductProcurementModes
- ProductStatuses: Domain ProductStatuses
- ProjectPriorities: Domain ProjectPriorities
- ProjectStatuses: Domain ProjectStatuses
- ProjectTypes: Domain ProjectTypes
- ProjectVisibilities: Domain ProjectVisibilities
- ServiceRequestStages: Domain ServiceRequestStages
- SolutionFolderVisibilities: Domain SolutionFolderVisibilities
- TicketPriorities: Domain TicketPriorities
- TicketSourceTypes: Domain TicketSourceTypes
- TicketStatuses: Domain TicketStatuses
Freshservice.Freshservice
- AgentGroupMembers: Agent Group Members
- AgentGroups: Agent Groups
- AgentRoles: Agent Roles
- AgentWorkspaces: Agent Workspaces
- Agents: Agents
- Announcements: Announcements
- Applications: Applications
- AssetSources: Asset Sources
- AssetTypes: Asset Types
- Assets: Assets
- BusinessHourHolidays: Business Hour Holidays
- BusinessHours: Business Hours
- CABs: CABs
- CannedResponses: Canned Responses
- Changes: Changes
- ContractTypes: Contract Types
- Contracts: Contracts
- Departments: Departments
- Locations: Locations
- ProblemFormFieldChoices: Problem Form Field Choices
- ProblemFormFields: Problem Form Fields
- Problems: Problems
- Products: Products
- ProjectTemplates: Project Templates
- ProjectsNewGen: Projects (New Gen)
- PurchaseOrders: Purchase Orders
- RecentTickets: Tickets (Recent)
- RelationshipTypes: Relationship Types
- Relationships: Relationships
- Releases: Releases
- RequesterGroupMembersById: Requester Group Members by Id
- RequesterGroups: Requester Groups
- Requesters: Requesters
- SearchTickets: Search Tickets
- ServiceCategories: Service Categories
- ServiceItems: Service Items
- SlaPolicies: SLA Policies
- SolutionCategories: Solution Categories
- StatisticsIncremental: Statistics on Incremental Tables
- Tickets: Tickets
- TicketsIncremental: Tickets (Incremental)
- Vendors: Vendors
- Workspaces: Workspaces
Freshservice.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Freshservice.Views
Attribute
The attributes of this platform are on the page Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: