invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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 esta plataforma en Invantive Cloud: https://cloud.invantive.com/freshservice

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Los datos se pueden leer y escribir.
  • 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/.

Cifras

Figure Count
Tables 73
Columns 928

Póster del Modelo de Datos

Este modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de los nombres de las columnas.

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Freshservice Modelo de Datos, Hoja 1 de 1Freshservice Modelo de Datospara su uso con Invantive UniversalSQLComunicado 24.0.491-PROD+5130 · 11-12-2024Freshservice · Departments · Freshservice · WorkspacesHoja 1 de 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 RequestsNATIVEPLATFORMSCALARREQUESTSVistasFreshservice.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 URLNotasEste modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de losnombres de las columnas.Diccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasFreshservice · Departments1Freshservice · Workspaces1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasGenerado a partir de los metadatos de Invantive UniversalSQL 24.0.491-PROD+5130 el 11-12-2024. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/freshservice
El póster en forma de texto: tablas por tema y sus relaciones

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 (sin relaciones)

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 (sin relaciones)

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

Native (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Vistas (sin relaciones)

RequesterGroupMembers

Relaciones

Tablas

Freshservice.CodeValues

Freshservice.Freshservice

Freshservice.Native

Freshservice.Views

Atributos

The attributes of this platform are on the page Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: