invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Freshservice Data Model

Authentication Authentication can be done using one of the following two alternatives:

  1. Using the user log on code, password and company also used on the Freshservice website.
  2. 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'.

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/freshservice

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • 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/.

Cijfers

Figure Count
Tables 73
Columns 928

Poster met datamodel

In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Freshservice Datamodel, Pagina 1 van 1Freshservice Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 24.0.491-PROD+5130 · 11-12-2024Freshservice · Departments · Freshservice · WorkspacesPagina 1 van 1 · documentation.invantive.euFreshservice · DepartmentsFreshservice.Freshservice.AgentRoles: Agent RolesAgentRolesFreshservice.Freshservice.AgentWorkspaces: Agent WorkspacesAgentWorkspacesFreshservice.Freshservice.Agents: AgentsAgentsFreshservice.Freshservice.AssetSources: Asset SourcesAssetSourcesFreshservice.Freshservice.Assets: AssetsAssetsFreshservice.Freshservice.Changes: ChangesChangesFreshservice.Freshservice.Contracts: ContractsContractsFreshservice.Freshservice.Departments: DepartmentsDepartmentsFreshservice.Freshservice.Locations: LocationsLocationsFreshservice.Freshservice.Problems: ProblemsProblemsFreshservice.Freshservice.PurchaseOrders: Purchase OrdersPurchaseOrdersFreshservice.Freshservice.RecentTickets: Tickets (Recent)RecentTicketsFreshservice.Freshservice.Releases: ReleasesReleasesFreshservice.Freshservice.Requesters: RequestersRequestersFreshservice.Freshservice.TicketsIncremental: Tickets (Incremental)TicketsIncrementalFreshservice.Freshservice.Vendors: VendorsVendorsFreshservice.Freshservice.Workspaces: WorkspacesWorkspacesFreshservice · WorkspacesFreshservice · WorkspacesFreshservice.Freshservice.AgentGroups: Agent GroupsAgentGroupsFreshservice.Freshservice.Announcements: AnnouncementsAnnouncementsFreshservice.Freshservice.Applications: ApplicationsApplicationsFreshservice.Freshservice.BusinessHours: Business HoursBusinessHoursFreshservice.Freshservice.CannedResponses: Canned ResponsesCannedResponsesFreshservice.Freshservice.ProblemFormFields: Problem Form FieldsProblemFormFieldsFreshservice.Freshservice.Products: ProductsProductsFreshservice.Freshservice.ServiceCategories: Service CategoriesServiceCategoriesFreshservice.Freshservice.ServiceItems: Service ItemsServiceItemsFreshservice.Freshservice.SlaPolicies: SLA PoliciesSlaPoliciesFreshservice.Freshservice.SolutionCategories: Solution CategoriesSolutionCategoriesFreshservice.Freshservice.Workspaces: WorkspacesWorkspacesCodeValuesFreshservice.CodeValues.ApplicationStatuses: Domain ApplicationStatusesApplicationStatusesFreshservice.CodeValues.ApplicationTypes: Domain ApplicationTypesApplicationTypesFreshservice.CodeValues.ApprovalStatuses: Domain ApprovalStatusesApprovalStatusesFreshservice.CodeValues.ApprovalTypes: Domain ApprovalTypesApprovalTypesFreshservice.CodeValues.AssetImpacts: Domain AssetImpactsAssetImpactsFreshservice.CodeValues.AssetUsageTypes: Domain AssetUsageTypesAssetUsageTypesFreshservice.CodeValues.BackgroundJobStatuses: Domain BackgroundJobStatusesBackgroundJobStatusesFreshservice.CodeValues.ChangeImpacts: Domain ChangeImpactsChangeImpactsFreshservice.CodeValues.ChangePriorities: Domain ChangePrioritiesChangePrioritiesFreshservice.CodeValues.ChangeRisks: Domain ChangeRisksChangeRisksFreshservice.CodeValues.ChangeStatuses: Domain ChangeStatusesChangeStatusesFreshservice.CodeValues.ChangeTypes: Domain ChangeTypesChangeTypesFreshservice.CodeValues.ConversationSourceTypes: Domain ConversationSourceTypesConversationSourceTypesFreshservice.CodeValues.CustomFieldTypes: Domain CustomFieldTypesCustomFieldTypesFreshservice.CodeValues.LookupDatasources: Domain LookupDatasourcesLookupDatasourcesFreshservice.CodeValues.OffboardingRequestStatuses: Domain OffboardingRequestStatusesOffboardingRequestStatusesFreshservice.CodeValues.OnboardingRequestStatuses: Domain OnboardingRequestStatusesOnboardingRequestStatusesFreshservice.CodeValues.ProductProcurementModes: Domain ProductProcurementModesProductProcurementModesFreshservice.CodeValues.ProductStatuses: Domain ProductStatusesProductStatusesFreshservice.CodeValues.ProjectPriorities: Domain ProjectPrioritiesProjectPrioritiesFreshservice.CodeValues.ProjectStatuses: Domain ProjectStatusesProjectStatusesFreshservice.CodeValues.ProjectTypes: Domain ProjectTypesProjectTypesFreshservice.CodeValues.ProjectVisibilities: Domain ProjectVisibilitiesProjectVisibilitiesFreshservice.CodeValues.ServiceRequestStages: Domain ServiceRequestStagesServiceRequestStagesFreshservice.CodeValues.SolutionFolderVisibilities: Domain SolutionFolderVisibilitiesSolutionFolderVisibilitiesFreshservice.CodeValues.TicketPriorities: Domain TicketPrioritiesTicketPrioritiesFreshservice.CodeValues.TicketSourceTypes: Domain TicketSourceTypesTicketSourceTypesFreshservice.CodeValues.TicketStatuses: Domain TicketStatusesTicketStatusesFreshserviceFreshservice.Freshservice.AgentGroupMembers: Agent Group MembersAgentGroupMembersFreshservice.Freshservice.AssetTypes: Asset TypesAssetTypesFreshservice.Freshservice.BusinessHourHolidays: Business Hour HolidaysBusinessHourHolidaysFreshservice.Freshservice.CABs: CABsCABsFreshservice.Freshservice.ContractTypes: Contract TypesContractTypesFreshservice.Freshservice.ProblemFormFieldChoices: Problem Form Field ChoicesProblemFormFieldChoicesFreshservice.Freshservice.ProjectTemplates: Project TemplatesProjectTemplatesFreshservice.Freshservice.ProjectsNewGen: Projects (New Gen)ProjectsNewGenFreshservice.Freshservice.RelationshipTypes: Relationship TypesRelationshipTypesFreshservice.Freshservice.Relationships: RelationshipsRelationshipsFreshservice.Freshservice.RequesterGroups: Requester GroupsRequesterGroupsFreshservice.Freshservice.StatisticsIncremental: Statistics on Incremental TablesStatisticsIncrementalNativeFreshservice.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSViewsFreshservice.Views.RequesterGroupMembersRequesterGroupMembersFreshserviceAuthentication Authentication can be done using one of thefollowing two alternatives: 1. Using the user log on code,password and company also used on the Freshservice website.2. Using an API key and company. Authentication using userlog on code and password is recommended for general use.The company is the name before '.freshservice.com' in the URLNotitiesIn dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties wordenafgeleid uit de namen van de kolommen.Data DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenFreshservice · Departments1Freshservice · Workspaces1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenGegenereerd op basis van de metagegevens van Invantive UniversalSQL 24.0.491-PROD+5130 op 11-12-2024.Elke tabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/freshservice
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

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 (zonder relaties)

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 (zonder relaties)

AgentGroupMembers, AssetTypes, BusinessHourHolidays, CABs, ContractTypes, ProblemFormFieldChoices, ProjectTemplates, ProjectsNewGen, RelationshipTypes, Relationships, RequesterGroups, StatisticsIncremental

Native (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Views (zonder relaties)

RequesterGroupMembers

Relaties

Tabellen

Freshservice.CodeValues

Freshservice.Freshservice

Freshservice.Native

Freshservice.Views

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: