Freshdesk Connector Reference

10 metrics323 dimensions

Fields

The Freshdesk connector exposes 333 fields (10 metrics, 323 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Freshdesk Fields

Freshdesk agents fields

The agents report of the Freshdesk connector includes 11 fields.

ID	Type	Name	Description
agents__available	BOOLEAN	agents.available	agents.available
agents__available_since	TIMESTAMP	agents.available_since	agents.available_since
agents__contact	OBJECT	agents.contact	agents.contact
agents__created_at	TIMESTAMP	agents.created_at	agents.created_at
agents__id	TEXT	agents.id	agents.id
agents__last_active_at	TIMESTAMP	agents.last_active_at	agents.last_active_at
agents__occasional	BOOLEAN	agents.occasional	agents.occasional
agents__signature	TEXT	agents.signature	agents.signature
agents__ticket_scope	TEXT	agents.ticket_scope	agents.ticket_scope
agents__type	TEXT	agents.type	agents.type
agents__updated_at	TIMESTAMP	agents.updated_at	agents.updated_at

Freshdesk business_hours fields

The business_hours report of the Freshdesk connector includes 8 fields.

ID	Type	Name	Description
business_hours__created_at	TIMESTAMP	business_hours.created_at	business_hours.created_at
business_hours__description	TEXT	business_hours.description	business_hours.description
business_hours__id	TEXT	business_hours.id	business_hours.id
business_hours__is_default	BOOLEAN	business_hours.is_default	business_hours.is_default
business_hours__name	TEXT	business_hours.name	business_hours.name
business_hours__time_zone	TEXT	business_hours.time_zone	business_hours.time_zone
business_hours__updated_at	TIMESTAMP	business_hours.updated_at	business_hours.updated_at
business_hours__working_hours	OBJECT	business_hours.working_hours	business_hours.working_hours

Freshdesk canned_response_folders fields

The canned_response_folders report of the Freshdesk connector includes 6 fields.

ID	Type	Name	Description
canned_response_folders__created_at	TIMESTAMP	canned_response_folders.created_at	canned_response_folders.created_at
canned_response_folders__id	TEXT	canned_response_folders.id	canned_response_folders.id
canned_response_folders__name	TEXT	canned_response_folders.name	canned_response_folders.name
canned_response_folders__personal	BOOLEAN	canned_response_folders.personal	canned_response_folders.personal
canned_response_folders__responses_count	NUMERIC	canned_response_folders.responses_count	canned_response_folders.responses_count
canned_response_folders__updated_at	TIMESTAMP	canned_response_folders.updated_at	canned_response_folders.updated_at

Freshdesk canned_responses fields

The canned_responses report of the Freshdesk connector includes 8 fields.

ID	Type	Name	Description
canned_responses__attachments	OBJECT	canned_responses.attachments	canned_responses.attachments
canned_responses__content	TEXT	canned_responses.content	canned_responses.content
canned_responses__content_html	TEXT	canned_responses.content_html	canned_responses.content_html
canned_responses__created_at	TIMESTAMP	canned_responses.created_at	canned_responses.created_at
canned_responses__folder_id	TEXT	canned_responses.folder_id	canned_responses.folder_id
canned_responses__id	TEXT	canned_responses.id	canned_responses.id
canned_responses__title	TEXT	canned_responses.title	canned_responses.title
canned_responses__updated_at	TIMESTAMP	canned_responses.updated_at	canned_responses.updated_at

Freshdesk companies fields

The companies report of the Freshdesk connector includes 12 fields.

ID	Type	Name	Description
companies__account_tier	TEXT	companies.account_tier	companies.account_tier
companies__created_at	TIMESTAMP	companies.created_at	companies.created_at
companies__custom_fields	OBJECT	companies.custom_fields	companies.custom_fields
companies__description	TEXT	companies.description	companies.description
companies__domains	OBJECT	companies.domains	companies.domains
companies__health_score	TEXT	companies.health_score	companies.health_score
companies__id	TEXT	companies.id	companies.id
companies__industry	TEXT	companies.industry	companies.industry
companies__name	TEXT	companies.name	companies.name
companies__note	TEXT	companies.note	companies.note
companies__renewal_date	DATE	companies.renewal_date	companies.renewal_date
companies__updated_at	TIMESTAMP	companies.updated_at	companies.updated_at

Freshdesk contacts fields

The contacts report of the Freshdesk connector includes 20 fields.

ID	Type	Name	Description
contacts__active	BOOLEAN	contacts.active	contacts.active
contacts__address	TEXT	contacts.address	contacts.address
contacts__company_id	TEXT	contacts.company_id	contacts.company_id
contacts__created_at	TIMESTAMP	contacts.created_at	contacts.created_at
contacts__csat_rating	TEXT	contacts.csat_rating	contacts.csat_rating
contacts__custom_fields	OBJECT	contacts.custom_fields	contacts.custom_fields
contacts__description	TEXT	contacts.description	contacts.description
contacts__email	TEXT	contacts.email	contacts.email
contacts__facebook_id	TEXT	contacts.facebook_id	contacts.facebook_id
contacts__id	TEXT	contacts.id	contacts.id
contacts__job_title	TEXT	contacts.job_title	contacts.job_title
contacts__language	TEXT	contacts.language	contacts.language
contacts__mobile	TEXT	contacts.mobile	contacts.mobile
contacts__name	TEXT	contacts.name	contacts.name
contacts__phone	TEXT	contacts.phone	contacts.phone
contacts__preferred_source	TEXT	contacts.preferred_source	contacts.preferred_source
contacts__time_zone	TEXT	contacts.time_zone	contacts.time_zone
contacts__twitter_id	TEXT	contacts.twitter_id	contacts.twitter_id
contacts__unique_external_id	TEXT	contacts.unique_external_id	contacts.unique_external_id
contacts__updated_at	TIMESTAMP	contacts.updated_at	contacts.updated_at

Freshdesk conversations fields

The conversations report of the Freshdesk connector includes 18 fields.

ID	Type	Name	Description
conversations__attachments	OBJECT	conversations.attachments	conversations.attachments
conversations__bcc_emails	OBJECT	conversations.bcc_emails	conversations.bcc_emails
conversations__body	TEXT	conversations.body	conversations.body
conversations__body_text	TEXT	conversations.body_text	conversations.body_text
conversations__category	TEXT	conversations.category	conversations.category
conversations__cc_emails	OBJECT	conversations.cc_emails	conversations.cc_emails
conversations__created_at	TIMESTAMP	conversations.created_at	conversations.created_at
conversations__from_email	TEXT	conversations.from_email	conversations.from_email
conversations__id	TEXT	conversations.id	conversations.id
conversations__incoming	BOOLEAN	conversations.incoming	conversations.incoming
conversations__private	BOOLEAN	conversations.private	conversations.private
conversations__source	TEXT	conversations.source	conversations.source
conversations__source_additional_info	OBJECT	conversations.source_additional_info	conversations.source_additional_info
conversations__support_email	TEXT	conversations.support_email	conversations.support_email
conversations__ticket_id	TEXT	conversations.ticket_id	conversations.ticket_id
conversations__to_emails	OBJECT	conversations.to_emails	conversations.to_emails
conversations__updated_at	TIMESTAMP	conversations.updated_at	conversations.updated_at
conversations__user_id	TEXT	conversations.user_id	conversations.user_id

Freshdesk discussion_categories fields

The discussion_categories report of the Freshdesk connector includes 5 fields.

ID	Type	Name	Description
discussion_categories__created_at	TIMESTAMP	discussion_categories.created_at	discussion_categories.created_at
discussion_categories__description	TEXT	discussion_categories.description	discussion_categories.description
discussion_categories__id	TEXT	discussion_categories.id	discussion_categories.id
discussion_categories__name	TEXT	discussion_categories.name	discussion_categories.name
discussion_categories__updated_at	TIMESTAMP	discussion_categories.updated_at	discussion_categories.updated_at

Freshdesk discussion_comments fields

The discussion_comments report of the Freshdesk connector includes 11 fields.

ID	Type	Name	Description
discussion_comments__answer	BOOLEAN	discussion_comments.answer	discussion_comments.answer
discussion_comments__body	TEXT	discussion_comments.body	discussion_comments.body
discussion_comments__created_at	TIMESTAMP	discussion_comments.created_at	discussion_comments.created_at
discussion_comments__forum_id	TEXT	discussion_comments.forum_id	discussion_comments.forum_id
discussion_comments__id	TEXT	discussion_comments.id	discussion_comments.id
discussion_comments__published	BOOLEAN	discussion_comments.published	discussion_comments.published
discussion_comments__spam	BOOLEAN	discussion_comments.spam	discussion_comments.spam
discussion_comments__topic_id	TEXT	discussion_comments.topic_id	discussion_comments.topic_id
discussion_comments__trash	BOOLEAN	discussion_comments.trash	discussion_comments.trash
discussion_comments__updated_at	TIMESTAMP	discussion_comments.updated_at	discussion_comments.updated_at
discussion_comments__user_id	TEXT	discussion_comments.user_id	discussion_comments.user_id

Freshdesk discussion_forums fields

The discussion_forums report of the Freshdesk connector includes 10 fields.

ID	Type	Name	Description
discussion_forums__company_ids	OBJECT	discussion_forums.company_ids	discussion_forums.company_ids
discussion_forums__description	TEXT	discussion_forums.description	discussion_forums.description
discussion_forums__forum_category_id	TEXT	discussion_forums.forum_category_id	discussion_forums.forum_category_id
discussion_forums__forum_type	TEXT	discussion_forums.forum_type	discussion_forums.forum_type
discussion_forums__forum_visibility	TEXT	discussion_forums.forum_visibility	discussion_forums.forum_visibility
discussion_forums__id	TEXT	discussion_forums.id	discussion_forums.id
discussion_forums__name	TEXT	discussion_forums.name	discussion_forums.name
discussion_forums__position	TEXT	discussion_forums.position	discussion_forums.position
discussion_forums__posts_count	NUMERIC	discussion_forums.posts_count	discussion_forums.posts_count
discussion_forums__topics_count	NUMERIC	discussion_forums.topics_count	discussion_forums.topics_count

Freshdesk discussion_topics fields

The discussion_topics report of the Freshdesk connector includes 15 fields.

ID	Type	Name	Description
discussion_topics__created_at	TIMESTAMP	discussion_topics.created_at	discussion_topics.created_at
discussion_topics__forum_id	TEXT	discussion_topics.forum_id	discussion_topics.forum_id
discussion_topics__hits	NUMERIC	discussion_topics.hits	discussion_topics.hits
discussion_topics__id	TEXT	discussion_topics.id	discussion_topics.id
discussion_topics__locked	BOOLEAN	discussion_topics.locked	discussion_topics.locked
discussion_topics__merged_topic_id	TEXT	discussion_topics.merged_topic_id	discussion_topics.merged_topic_id
discussion_topics__message	TEXT	discussion_topics.message	discussion_topics.message
discussion_topics__posts_count	NUMERIC	discussion_topics.posts_count	discussion_topics.posts_count
discussion_topics__replied_by	TEXT	discussion_topics.replied_by	discussion_topics.replied_by
discussion_topics__stamp_type	TEXT	discussion_topics.stamp_type	discussion_topics.stamp_type
discussion_topics__sticky	BOOLEAN	discussion_topics.sticky	discussion_topics.sticky
discussion_topics__title	TEXT	discussion_topics.title	discussion_topics.title
discussion_topics__updated_at	TIMESTAMP	discussion_topics.updated_at	discussion_topics.updated_at
discussion_topics__user_id	TEXT	discussion_topics.user_id	discussion_topics.user_id
discussion_topics__user_votes	NUMERIC	discussion_topics.user_votes	discussion_topics.user_votes

Freshdesk email_configs fields

The email_configs report of the Freshdesk connector includes 10 fields.

ID	Type	Name	Description
email_configs__active	BOOLEAN	email_configs.active	email_configs.active
email_configs__created_at	TIMESTAMP	email_configs.created_at	email_configs.created_at
email_configs__group_id	TEXT	email_configs.group_id	email_configs.group_id
email_configs__id	TEXT	email_configs.id	email_configs.id
email_configs__name	TEXT	email_configs.name	email_configs.name
email_configs__primary_role	BOOLEAN	email_configs.primary_role	email_configs.primary_role
email_configs__product_id	TEXT	email_configs.product_id	email_configs.product_id
email_configs__reply_email	TEXT	email_configs.reply_email	email_configs.reply_email
email_configs__to_email	TEXT	email_configs.to_email	email_configs.to_email
email_configs__updated_at	TIMESTAMP	email_configs.updated_at	email_configs.updated_at

Freshdesk email_mailboxes fields

The email_mailboxes report of the Freshdesk connector includes 17 fields.

ID	Type	Name	Description
email_mailboxes__access_type	TEXT	email_mailboxes.access_type	email_mailboxes.access_type
email_mailboxes__authentication	TEXT	email_mailboxes.authentication	email_mailboxes.authentication
email_mailboxes__custom_mailbox	TEXT	email_mailboxes.custom_mailbox	email_mailboxes.custom_mailbox
email_mailboxes__default_reply_email	BOOLEAN	email_mailboxes.default_reply_email	email_mailboxes.default_reply_email
email_mailboxes__delete_from_server	BOOLEAN	email_mailboxes.delete_from_server	email_mailboxes.delete_from_server
email_mailboxes__group_id	TEXT	email_mailboxes.group_id	email_mailboxes.group_id
email_mailboxes__id	TEXT	email_mailboxes.id	email_mailboxes.id
email_mailboxes__incoming	TEXT	email_mailboxes.incoming	email_mailboxes.incoming
email_mailboxes__mail_server	TEXT	email_mailboxes.mail_server	email_mailboxes.mail_server
email_mailboxes__mailbox_type	TEXT	email_mailboxes.mailbox_type	email_mailboxes.mailbox_type
email_mailboxes__name	TEXT	email_mailboxes.name	email_mailboxes.name
email_mailboxes__password	TEXT	email_mailboxes.password	email_mailboxes.password
email_mailboxes__port	TEXT	email_mailboxes.port	email_mailboxes.port
email_mailboxes__product_id	TEXT	email_mailboxes.product_id	email_mailboxes.product_id
email_mailboxes__support_email	TEXT	email_mailboxes.support_email	email_mailboxes.support_email
email_mailboxes__use_ssl	BOOLEAN	email_mailboxes.use_ssl	email_mailboxes.use_ssl
email_mailboxes__username	TEXT	email_mailboxes.username	email_mailboxes.username

Freshdesk groups fields

The groups report of the Freshdesk connector includes 10 fields.

ID	Type	Name	Description
groups__auto_ticket_assign	BOOLEAN	groups.auto_ticket_assign	groups.auto_ticket_assign
groups__business_hour_id	TEXT	groups.business_hour_id	groups.business_hour_id
groups__created_at	TIMESTAMP	groups.created_at	groups.created_at
groups__description	TEXT	groups.description	groups.description
groups__escalate_to	TEXT	groups.escalate_to	groups.escalate_to
groups__group_type	TEXT	groups.group_type	groups.group_type
groups__id	TEXT	groups.id	groups.id
groups__name	TEXT	groups.name	groups.name
groups__unassigned_for	TEXT	groups.unassigned_for	groups.unassigned_for
groups__updated_at	TIMESTAMP	groups.updated_at	groups.updated_at

Freshdesk products fields

The products report of the Freshdesk connector includes 5 fields.

ID	Type	Name	Description
products__created_at	TIMESTAMP	products.created_at	products.created_at
products__description	TEXT	products.description	products.description
products__id	TEXT	products.id	products.id
products__name	TEXT	products.name	products.name
products__updated_at	TIMESTAMP	products.updated_at	products.updated_at

Freshdesk roles fields

The roles report of the Freshdesk connector includes 6 fields.

ID	Type	Name	Description
roles__created_at	TIMESTAMP	roles.created_at	roles.created_at
roles__default	BOOLEAN	roles.default	roles.default
roles__description	TEXT	roles.description	roles.description
roles__id	TEXT	roles.id	roles.id
roles__name	TEXT	roles.name	roles.name
roles__updated_at	TIMESTAMP	roles.updated_at	roles.updated_at

Freshdesk satisfaction_ratings fields

The satisfaction_ratings report of the Freshdesk connector includes 10 fields.

ID	Type	Name	Description
satisfaction_ratings__agent_id	TEXT	satisfaction_ratings.agent_id	satisfaction_ratings.agent_id
satisfaction_ratings__created_at	TIMESTAMP	satisfaction_ratings.created_at	satisfaction_ratings.created_at
satisfaction_ratings__feedback	TEXT	satisfaction_ratings.feedback	satisfaction_ratings.feedback
satisfaction_ratings__group_id	TEXT	satisfaction_ratings.group_id	satisfaction_ratings.group_id
satisfaction_ratings__id	TEXT	satisfaction_ratings.id	satisfaction_ratings.id
satisfaction_ratings__ratings	OBJECT	satisfaction_ratings.ratings	satisfaction_ratings.ratings
satisfaction_ratings__survey_id	TEXT	satisfaction_ratings.survey_id	satisfaction_ratings.survey_id
satisfaction_ratings__ticket_id	TEXT	satisfaction_ratings.ticket_id	satisfaction_ratings.ticket_id
satisfaction_ratings__updated_at	TIMESTAMP	satisfaction_ratings.updated_at	satisfaction_ratings.updated_at
satisfaction_ratings__user_id	TEXT	satisfaction_ratings.user_id	satisfaction_ratings.user_id

Freshdesk scenario_automations fields

The scenario_automations report of the Freshdesk connector includes 7 fields.

ID	Type	Name	Description
scenario_automations__actions	OBJECT	scenario_automations.actions	scenario_automations.actions
scenario_automations__created_at	TIMESTAMP	scenario_automations.created_at	scenario_automations.created_at
scenario_automations__description	TEXT	scenario_automations.description	scenario_automations.description
scenario_automations__id	TEXT	scenario_automations.id	scenario_automations.id
scenario_automations__name	TEXT	scenario_automations.name	scenario_automations.name
scenario_automations__private	BOOLEAN	scenario_automations.private	scenario_automations.private
scenario_automations__updated_at	TIMESTAMP	scenario_automations.updated_at	scenario_automations.updated_at

Freshdesk settings fields

The settings report of the Freshdesk connector includes 3 fields.

ID	Type	Name	Description
settings__portal_languages	OBJECT	settings.portal_languages	settings.portal_languages
settings__primary_language	TEXT	settings.primary_language	settings.primary_language
settings__supported_languages	OBJECT	settings.supported_languages	settings.supported_languages

Freshdesk skills fields

The skills report of the Freshdesk connector includes 8 fields.

ID	Type	Name	Description
skills__agents	OBJECT	skills.agents	skills.agents
skills__conditions	OBJECT	skills.conditions	skills.conditions
skills__created_at	TIMESTAMP	skills.created_at	skills.created_at
skills__id	TEXT	skills.id	skills.id
skills__match_type	TEXT	skills.match_type	skills.match_type
skills__name	TEXT	skills.name	skills.name
skills__rank	TEXT	skills.rank	skills.rank
skills__updated_at	TIMESTAMP	skills.updated_at	skills.updated_at

Freshdesk sla_policies fields

The sla_policies report of the Freshdesk connector includes 9 fields.

ID	Type	Name	Description
sla_policies__active	BOOLEAN	sla_policies.active	sla_policies.active
sla_policies__applicable_to	OBJECT	sla_policies.applicable_to	sla_policies.applicable_to
sla_policies__description	TEXT	sla_policies.description	sla_policies.description
sla_policies__escalation	OBJECT	sla_policies.escalation	sla_policies.escalation
sla_policies__id	TEXT	sla_policies.id	sla_policies.id
sla_policies__is_default	BOOLEAN	sla_policies.is_default	sla_policies.is_default
sla_policies__name	TEXT	sla_policies.name	sla_policies.name
sla_policies__position	TEXT	sla_policies.position	sla_policies.position
sla_policies__sla_target	OBJECT	sla_policies.sla_target	sla_policies.sla_target

Freshdesk solution_articles fields

The solution_articles report of the Freshdesk connector includes 15 fields.

ID	Type	Name	Description
solution_articles__agent_id	TEXT	solution_articles.agent_id	solution_articles.agent_id
solution_articles__category_id	TEXT	solution_articles.category_id	solution_articles.category_id
solution_articles__created_at	TIMESTAMP	solution_articles.created_at	solution_articles.created_at
solution_articles__description	TEXT	solution_articles.description	solution_articles.description
solution_articles__description_text	TEXT	solution_articles.description_text	solution_articles.description_text
solution_articles__folder_id	TEXT	solution_articles.folder_id	solution_articles.folder_id
solution_articles__hits	NUMERIC	solution_articles.hits	solution_articles.hits
solution_articles__id	TEXT	solution_articles.id	solution_articles.id
solution_articles__seo_data	OBJECT	solution_articles.seo_data	solution_articles.seo_data
solution_articles__status	TEXT	solution_articles.status	solution_articles.status
solution_articles__tags	OBJECT	solution_articles.tags	solution_articles.tags
solution_articles__thumbs_down	NUMERIC	solution_articles.thumbs_down	solution_articles.thumbs_down
solution_articles__thumbs_up	NUMERIC	solution_articles.thumbs_up	solution_articles.thumbs_up
solution_articles__title	TEXT	solution_articles.title	solution_articles.title
solution_articles__updated_at	TIMESTAMP	solution_articles.updated_at	solution_articles.updated_at

Freshdesk solution_categories fields

The solution_categories report of the Freshdesk connector includes 6 fields.

ID	Type	Name	Description
solution_categories__created_at	TIMESTAMP	solution_categories.created_at	solution_categories.created_at
solution_categories__description	TEXT	solution_categories.description	solution_categories.description
solution_categories__id	TEXT	solution_categories.id	solution_categories.id
solution_categories__name	TEXT	solution_categories.name	solution_categories.name
solution_categories__updated_at	TIMESTAMP	solution_categories.updated_at	solution_categories.updated_at
solution_categories__visible_in_portals	OBJECT	solution_categories.visible_in_portals	solution_categories.visible_in_portals

Freshdesk solution_folders fields

The solution_folders report of the Freshdesk connector includes 9 fields.

ID	Type	Name	Description
solution_folders__company_ids	OBJECT	solution_folders.company_ids	solution_folders.company_ids
solution_folders__company_segment_ids	OBJECT	solution_folders.company_segment_ids	solution_folders.company_segment_ids
solution_folders__contact_segment_ids	OBJECT	solution_folders.contact_segment_ids	solution_folders.contact_segment_ids
solution_folders__created_at	TIMESTAMP	solution_folders.created_at	solution_folders.created_at
solution_folders__description	TEXT	solution_folders.description	solution_folders.description
solution_folders__id	TEXT	solution_folders.id	solution_folders.id
solution_folders__name	TEXT	solution_folders.name	solution_folders.name
solution_folders__updated_at	TIMESTAMP	solution_folders.updated_at	solution_folders.updated_at
solution_folders__visibility	TEXT	solution_folders.visibility	solution_folders.visibility

Freshdesk surveys fields

The surveys report of the Freshdesk connector includes 6 fields.

ID	Type	Name	Description
surveys__active	BOOLEAN	surveys.active	surveys.active
surveys__created_at	TIMESTAMP	surveys.created_at	surveys.created_at
surveys__id	TEXT	surveys.id	surveys.id
surveys__questions	OBJECT	surveys.questions	surveys.questions
surveys__title	TEXT	surveys.title	surveys.title
surveys__updated_at	TIMESTAMP	surveys.updated_at	surveys.updated_at

Freshdesk ticket_fields fields

The ticket_fields report of the Freshdesk connector includes 21 fields.

ID	Type	Name	Description
ticket_fields__choices	OBJECT	ticket_fields.choices	ticket_fields.choices
ticket_fields__created_at	TIMESTAMP	ticket_fields.created_at	ticket_fields.created_at
ticket_fields__customers_can_edit	BOOLEAN	ticket_fields.customers_can_edit	ticket_fields.customers_can_edit
ticket_fields__default	BOOLEAN	ticket_fields.default	ticket_fields.default
ticket_fields__dependent_fields	TEXT	ticket_fields.dependent_fields	ticket_fields.dependent_fields
ticket_fields__description	TEXT	ticket_fields.description	ticket_fields.description
ticket_fields__displayed_to_customers	BOOLEAN	ticket_fields.displayed_to_customers	ticket_fields.displayed_to_customers
ticket_fields__field_update_in_progress	BOOLEAN	ticket_fields.field_update_in_progress	ticket_fields.field_update_in_progress
ticket_fields__id	TEXT	ticket_fields.id	ticket_fields.id
ticket_fields__is_fsm	BOOLEAN	ticket_fields.is_fsm	ticket_fields.is_fsm
ticket_fields__label	TEXT	ticket_fields.label	ticket_fields.label
ticket_fields__label_for_customers	TEXT	ticket_fields.label_for_customers	ticket_fields.label_for_customers
ticket_fields__name	TEXT	ticket_fields.name	ticket_fields.name
ticket_fields__portal_cc	BOOLEAN	ticket_fields.portal_cc	ticket_fields.portal_cc
ticket_fields__portal_cc_to	TEXT	ticket_fields.portal_cc_to	ticket_fields.portal_cc_to
ticket_fields__position	TEXT	ticket_fields.position	ticket_fields.position
ticket_fields__required_for_agents	BOOLEAN	ticket_fields.required_for_agents	ticket_fields.required_for_agents
ticket_fields__required_for_closure	BOOLEAN	ticket_fields.required_for_closure	ticket_fields.required_for_closure
ticket_fields__required_for_customers	BOOLEAN	ticket_fields.required_for_customers	ticket_fields.required_for_customers
ticket_fields__type	TEXT	ticket_fields.type	ticket_fields.type
ticket_fields__updated_at	TIMESTAMP	ticket_fields.updated_at	ticket_fields.updated_at

Freshdesk tickets fields

The tickets report of the Freshdesk connector includes 34 fields.

ID	Type	Name	Description
tickets__associated_tickets_count	NUMERIC	tickets.associated_tickets_count	tickets.associated_tickets_count
tickets__association_type	TEXT	tickets.association_type	tickets.association_type
tickets__cc_emails	OBJECT	tickets.cc_emails	tickets.cc_emails
tickets__company_id	TEXT	tickets.company_id	tickets.company_id
tickets__created_at	TIMESTAMP	tickets.created_at	tickets.created_at
tickets__custom_fields	OBJECT	tickets.custom_fields	tickets.custom_fields
tickets__description	TEXT	tickets.description	tickets.description
tickets__description_text	TEXT	tickets.description_text	tickets.description_text
tickets__due_by	TEXT	tickets.due_by	tickets.due_by
tickets__email_config_id	TEXT	tickets.email_config_id	tickets.email_config_id
tickets__fr_due_by	TEXT	tickets.fr_due_by	tickets.fr_due_by
tickets__fr_escalated	BOOLEAN	tickets.fr_escalated	tickets.fr_escalated
tickets__fwd_emails	OBJECT	tickets.fwd_emails	tickets.fwd_emails
tickets__group_id	TEXT	tickets.group_id	tickets.group_id
tickets__id	TEXT	tickets.id	tickets.id
tickets__is_escalated	BOOLEAN	tickets.is_escalated	tickets.is_escalated
tickets__nr_due_by	TEXT	tickets.nr_due_by	tickets.nr_due_by
tickets__nr_escalated	BOOLEAN	tickets.nr_escalated	tickets.nr_escalated
tickets__priority	TEXT	tickets.priority	tickets.priority
tickets__product_id	TEXT	tickets.product_id	tickets.product_id
tickets__reply_cc_emails	OBJECT	tickets.reply_cc_emails	tickets.reply_cc_emails
tickets__requester	OBJECT	tickets.requester	tickets.requester
tickets__requester_id	TEXT	tickets.requester_id	tickets.requester_id
tickets__responder_id	TEXT	tickets.responder_id	tickets.responder_id
tickets__source	TEXT	tickets.source	tickets.source
tickets__spam	BOOLEAN	tickets.spam	tickets.spam
tickets__stats	OBJECT	tickets.stats	tickets.stats
tickets__status	TEXT	tickets.status	tickets.status
tickets__subject	TEXT	tickets.subject	tickets.subject
tickets__tags	OBJECT	tickets.tags	tickets.tags
tickets__ticket_cc_emails	OBJECT	tickets.ticket_cc_emails	tickets.ticket_cc_emails
tickets__to_emails	OBJECT	tickets.to_emails	tickets.to_emails
tickets__type	TEXT	tickets.type	tickets.type
tickets__updated_at	TIMESTAMP	tickets.updated_at	tickets.updated_at

Freshdesk time_entries fields

The time_entries report of the Freshdesk connector includes 12 fields.

ID	Type	Name	Description
time_entries__agent_id	TEXT	time_entries.agent_id	time_entries.agent_id
time_entries__billable	BOOLEAN	time_entries.billable	time_entries.billable
time_entries__company_id	TEXT	time_entries.company_id	time_entries.company_id
time_entries__created_at	DATE	time_entries.created_at	time_entries.created_at
time_entries__executed_at	DATE	time_entries.executed_at	time_entries.executed_at
time_entries__id	TEXT	time_entries.id	time_entries.id
time_entries__note	TEXT	time_entries.note	time_entries.note
time_entries__start_time	TEXT	time_entries.start_time	time_entries.start_time
time_entries__ticket_id	TEXT	time_entries.ticket_id	time_entries.ticket_id
time_entries__time_spent	TEXT	time_entries.time_spent	time_entries.time_spent
time_entries__timer_running	BOOLEAN	time_entries.timer_running	time_entries.timer_running
time_entries__updated_at	TIMESTAMP	time_entries.updated_at	time_entries.updated_at

Freshdesk other fields

The Freshdesk connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Account ID.
account_name	TEXT	Account Name	Account name.
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Date.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors