---
title: "Freshdesk Data Model"
description: "Freshdesk is a cloud solution for customer management. Freshdesk includes CRM as well as tickets. Existing functionality of Freshdesk can be extended by custom fields."
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/freshdesk
original: https://documentation.invantive.eu/en/datamodels/freshdesk
updated: 2026-11-16T21:06:37Z
license: https://documentation.invantive.eu/de/
---

# Freshdesk Data Model

Freshdesk is a cloud solution for customer management. Freshdesk includes CRM as well as tickets. Existing functionality of Freshdesk can be extended by custom fields.

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 Freshdesk 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 '.freshdesk.com' in the URL used to log on to Freshdesk in a browser. The API key can be found in the 'Edit Profile' page in Freshdesk, as described on https://support.freshdesk.com/support/solutions/articles/225435-where-can-i-find-my-api-key.

API Version The V2 API of Freshdesk 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 Freshdesk 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/freshdesk

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.freshdesk.com/](https://updates.freshdesk.com/).

## Angaben

| Figure | Count |
|---|---:|
| Tables | 100 |
| Columns | 1,610 |

## Tabellen

### Freshdesk.CodeValues

- [AutoTicketAssignTypes](Freshdesk.CodeValues.AutoTicketAssignTypes): Domain AutoTicketAssignTypes
- [ConversationSourceTypes](Freshdesk.CodeValues.ConversationSourceTypes): Domain ConversationSourceTypes
- [ConversationSources](Freshdesk.CodeValues.ConversationSources): Domain ConversationSources
- [ForumTypes](Freshdesk.CodeValues.ForumTypes): Domain ForumTypes
- [ForumVisibilities](Freshdesk.CodeValues.ForumVisibilities): Domain ForumVisibilities
- [SolutionArticleStatuses](Freshdesk.CodeValues.SolutionArticleStatuses): Domain SolutionArticleStatuses
- [SolutionArticleTypes](Freshdesk.CodeValues.SolutionArticleTypes): Domain SolutionArticleTypes
- [SolutionFolderVisibilities](Freshdesk.CodeValues.SolutionFolderVisibilities): Domain SolutionFolderVisibilities
- [SurveyRatingTypes](Freshdesk.CodeValues.SurveyRatingTypes): Domain SurveyRatingTypes
- [TicketAssociationTypes](Freshdesk.CodeValues.TicketAssociationTypes): Domain TicketAssociationTypes
- [TicketPermissions](Freshdesk.CodeValues.TicketPermissions): Domain TicketPermissions
- [TicketPriorityCodes](Freshdesk.CodeValues.TicketPriorityCodes): Domain TicketPriorityCodes
- [TicketSourceCodes](Freshdesk.CodeValues.TicketSourceCodes): Domain TicketSourceCodes
- [TicketStatusCodes](Freshdesk.CodeValues.TicketStatusCodes): Domain TicketStatusCodes
- [TopicStamps](Freshdesk.CodeValues.TopicStamps): Domain TopicStamps

### Freshdesk.Freshdesk

- [account](Freshdesk.Freshdesk.account): Account
- [agent_by_id](Freshdesk.Freshdesk.agent_by_id): Freshdesk Agent
- [agent_group_ids_by_id](Freshdesk.Freshdesk.agent_group_ids_by_id): Agent Group IDs
- [agent_role_ids_by_id](Freshdesk.Freshdesk.agent_role_ids_by_id): Agent Role IDs
- [agent_skill_ids_by_id](Freshdesk.Freshdesk.agent_skill_ids_by_id): Agent Skill IDs by ID
- [agents](Freshdesk.Freshdesk.agents): Agents
- [associated_tickets_by_ticket_id](Freshdesk.Freshdesk.associated_tickets_by_ticket_id): Associated Tickets by Ticket ID
- [business_hour_by_id](Freshdesk.Freshdesk.business_hour_by_id): Business Hour
- [business_hours](Freshdesk.Freshdesk.business_hours): Business Hours
- [canned_response_folders](Freshdesk.Freshdesk.canned_response_folders): Canned Response Folders
- [canned_responses_by_folder_id](Freshdesk.Freshdesk.canned_responses_by_folder_id): Canned Responses by Folder ID
- [companies](Freshdesk.Freshdesk.companies): Companies
- [company_custom_fields](Freshdesk.Freshdesk.company_custom_fields): Company Custom Fields
- [company_domains_by_id](Freshdesk.Freshdesk.company_domains_by_id): Company Domains
- [contact_by_id](Freshdesk.Freshdesk.contact_by_id): Contact
- [contact_custom_fields](Freshdesk.Freshdesk.contact_custom_fields): Contact Custom Fields
- [contact_other_companies_by_id](Freshdesk.Freshdesk.contact_other_companies_by_id): Contact Other Companies
- [contact_other_emails_by_id](Freshdesk.Freshdesk.contact_other_emails_by_id): Contact Other Emails
- [contact_tags_by_id](Freshdesk.Freshdesk.contact_tags_by_id): Contact Tags
- [contacts](Freshdesk.Freshdesk.contacts): Contacts
- [custom_object_fields](Freshdesk.Freshdesk.custom_object_fields): Custom Object Fields
- [custom_objects](Freshdesk.Freshdesk.custom_objects): Custom Objects
- [discussion_categories](Freshdesk.Freshdesk.discussion_categories): Discussion Categories
- [discussion_category_forums_by_id](Freshdesk.Freshdesk.discussion_category_forums_by_id): Discussion Category Forums
- [discussion_forum_topics_by_id](Freshdesk.Freshdesk.discussion_forum_topics_by_id): Discussion Forum Topics
- [discussion_forums_by_id](Freshdesk.Freshdesk.discussion_forums_by_id): Discussion Category Forums
- [discussion_topic_comments_by_id](Freshdesk.Freshdesk.discussion_topic_comments_by_id): Discussion Topic Comments
- [email_configs](Freshdesk.Freshdesk.email_configs): Email Configurations
- [email_mailboxes](Freshdesk.Freshdesk.email_mailboxes): Email Mail Boxes
- [group_agent_ids_by_id](Freshdesk.Freshdesk.group_agent_ids_by_id): Group Agent IDs
- [groups](Freshdesk.Freshdesk.groups): Groups
- [prime_ticket_association_by_id](Freshdesk.Freshdesk.prime_ticket_association_by_id): Prime Ticket Association by ID
- [products](Freshdesk.Freshdesk.products): Products
- [recent_tickets](Freshdesk.Freshdesk.recent_tickets): Tickets (Recent)
- [roles](Freshdesk.Freshdesk.roles): Roles
- [scenario_automations](Freshdesk.Freshdesk.scenario_automations): Scenario Automations
- [search_tickets](Freshdesk.Freshdesk.search_tickets): Search Tickets
- [skills](Freshdesk.Freshdesk.skills): Skills
- [sla_policies](Freshdesk.Freshdesk.sla_policies): SLA Policies
- [solution_article_attachments_by_id](Freshdesk.Freshdesk.solution_article_attachments_by_id): Solution Article Attachments
- [solution_article_by_id](Freshdesk.Freshdesk.solution_article_by_id): Solution Article
- [solution_article_tags_by_id](Freshdesk.Freshdesk.solution_article_tags_by_id): Solution Article Tags
- [solution_categories](Freshdesk.Freshdesk.solution_categories): Solution Categories
- [solution_category_folders_by_id](Freshdesk.Freshdesk.solution_category_folders_by_id): Solution Category Folders
- [solution_folder_articles_by_id](Freshdesk.Freshdesk.solution_folder_articles_by_id): Solution Folder Articles
- [solution_folder_by_id](Freshdesk.Freshdesk.solution_folder_by_id): Solution Folder
- [statistics_incremental](Freshdesk.Freshdesk.statistics_incremental): Statistics on Incremental Tables
- [survey_question_accepted_ratings](Freshdesk.Freshdesk.survey_question_accepted_ratings): Survey Questions
- [survey_questions](Freshdesk.Freshdesk.survey_questions): Survey Questions
- [survey_satisfaction_ratings](Freshdesk.Freshdesk.survey_satisfaction_ratings): Survey Satisfaction Ratings
- [surveys](Freshdesk.Freshdesk.surveys): Survey
- [ticket_attachments_by_id](Freshdesk.Freshdesk.ticket_attachments_by_id): Ticket Attachments
- [ticket_by_id](Freshdesk.Freshdesk.ticket_by_id): Ticket
- [ticket_cc_emails_by_id](Freshdesk.Freshdesk.ticket_cc_emails_by_id): Ticket CC Emails
- [ticket_conversations_attachments_by_id](Freshdesk.Freshdesk.ticket_conversations_attachments_by_id): Ticket Conversion Attachments
- [ticket_conversations_bcc_emails_by_id](Freshdesk.Freshdesk.ticket_conversations_bcc_emails_by_id): Ticket Conversation BCC Emails
- [ticket_conversations_by_id](Freshdesk.Freshdesk.ticket_conversations_by_id): Ticket Conversations
- [ticket_conversations_cc_emails_by_id](Freshdesk.Freshdesk.ticket_conversations_cc_emails_by_id): Ticket Conversation CC Emails
- [ticket_conversations_to_emails_by_id](Freshdesk.Freshdesk.ticket_conversations_to_emails_by_id): Ticket Conversation To Emails
- [ticket_custom_fields](Freshdesk.Freshdesk.ticket_custom_fields): Ticket Custom Fields
- [ticket_forms](Freshdesk.Freshdesk.ticket_forms): Ticket Forms
- [ticket_fwd_emails_by_id](Freshdesk.Freshdesk.ticket_fwd_emails_by_id): Ticket Forwarded Emails
- [ticket_reply_cc_emails_by_id](Freshdesk.Freshdesk.ticket_reply_cc_emails_by_id): Ticket Reply CC Emails
- [ticket_summary_by_id](Freshdesk.Freshdesk.ticket_summary_by_id): Ticket Summary by ID
- [ticket_tags](Freshdesk.Freshdesk.ticket_tags): Ticket Tags
- [ticket_tags_by_id](Freshdesk.Freshdesk.ticket_tags_by_id): Ticket Tags
- [ticket_to_emails_by_id](Freshdesk.Freshdesk.ticket_to_emails_by_id): Ticket To Emails
- [tickets](Freshdesk.Freshdesk.tickets): Tickets
- [tickets_incremental](Freshdesk.Freshdesk.tickets_incremental): Tickets (Incremental)
- [time_entries](Freshdesk.Freshdesk.time_entries): Time Entries

### Freshdesk.Native

- [NATIVEPLATFORMSCALARREQUESTS](Freshdesk.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Freshdesk.Views

- [AgentGroups](Freshdesk.Views.AgentGroups)
- [AgentRoles](Freshdesk.Views.AgentRoles)
- [AgentSkills](Freshdesk.Views.AgentSkills)
- [CannedResponses](Freshdesk.Views.CannedResponses)
- [CompanyDomains](Freshdesk.Views.CompanyDomains)
- [ContactTags](Freshdesk.Views.ContactTags)
- [DiscussionForumTopics](Freshdesk.Views.DiscussionForumTopics)
- [DiscussionForums](Freshdesk.Views.DiscussionForums)
- [SolutionCategoryFolders](Freshdesk.Views.SolutionCategoryFolders)
- [SolutionFolderArticleAttachments](Freshdesk.Views.SolutionFolderArticleAttachments)
- [SolutionFolderArticleTags](Freshdesk.Views.SolutionFolderArticleTags)
- [SolutionFolderArticles](Freshdesk.Views.SolutionFolderArticles)
- [TicketAttachments](Freshdesk.Views.TicketAttachments)
- [TicketConversations](Freshdesk.Views.TicketConversations)

## Attribute

The attributes of this platform are on the page [Attributes](attributes).


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Freshdesk](/de/release-notes/drivers?driver=freshdesk)
