invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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'.

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/freshservice

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • I dati possono essere sia letti che scritti.
  • 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/.

Figure

Figure Count
Tables 73
Columns 928

Poster sul modello di dati

Questo modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivano dai nomi delle colonne.

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Freshservice Modello di dati, Foglio 1 di 1Freshservice Modello di datida utilizzare con Invantive UniversalSQLComunicato 24.0.491-PROD+5130 · 11-12-2024Freshservice · Departments · Freshservice · WorkspacesFoglio 1 di 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 RequestsNATIVEPLATFORMSCALARREQUESTSVisualizzazioniFreshservice.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 URLNoteQuesto modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivanodai nomi delle colonne.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiFreshservice · Departments1Freshservice · Workspaces1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleGenerato dai metadati di Invantive UniversalSQL 24.0.491-PROD+5130 il 11-12-2024. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/freshservice
Il poster come testo: tabelle per argomento e le loro relazioni

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 (senza relazioni)

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 (senza relazioni)

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

Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Visualizzazioni (senza relazioni)

RequesterGroupMembers

Relazioni

Tabelle

Freshservice.CodeValues

Freshservice.Freshservice

Freshservice.Native

Freshservice.Views

Attributi

The attributes of this platform are on the page Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: