Freshservice Connector Reference

13 metrics314 dimensions

Fields

The Freshservice connector exposes 327 fields (13 metrics, 314 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Freshservice Fields

Freshservice agents fields

The agents report of the Freshservice connector includes 49 fields.

Freshservice agents fields (agentsactive to agentsticket_scope)

ID	Type	Name	Description
agents__active	BOOLEAN	agents.active	agents.active
agents__address	TEXT	agents.address	agents.address
agents__auto_assign_status_changed_at	TIMESTAMP	agents.auto_assign_status_changed_at	agents.auto_assign_status_changed_at
agents__auto_assign_tickets	BOOLEAN	agents.auto_assign_tickets	agents.auto_assign_tickets
agents__background_information	TEXT	agents.background_information	agents.background_information
agents__can_see_all_tickets_from_associated_departments	BOOLEAN	agents.can_see_all_tickets_from_associated_departments	agents.can_see_all_tickets_from_associated_departments
agents__change_scope	TEXT	agents.change_scope	agents.change_scope
agents__created_at	TIMESTAMP	agents.created_at	agents.created_at
agents__custom_fields	OBJECT	agents.custom_fields	agents.custom_fields
agents__department_ids	OBJECT	agents.department_ids	agents.department_ids
agents__department_names	OBJECT	agents.department_names	agents.department_names
agents__email	TEXT	agents.email	agents.email
agents__external_id	TEXT	agents.external_id	agents.external_id
agents__first_name	TEXT	agents.first_name	agents.first_name
agents__group_ids	OBJECT	agents.group_ids	agents.group_ids
agents__has_logged_in	BOOLEAN	agents.has_logged_in	agents.has_logged_in
agents__id	TEXT	agents.id	agents.id
agents__job_title	TEXT	agents.job_title	agents.job_title
agents__language	TEXT	agents.language	agents.language
agents__last_active_at	TIMESTAMP	agents.last_active_at	agents.last_active_at
agents__last_login_at	TIMESTAMP	agents.last_login_at	agents.last_login_at
agents__last_name	TEXT	agents.last_name	agents.last_name
agents__location_id	TEXT	agents.location_id	agents.location_id
agents__location_name	TEXT	agents.location_name	agents.location_name
agents__member_of	OBJECT	agents.member_of	agents.member_of
agents__member_of_pending_approval	OBJECT	agents.member_of_pending_approval	agents.member_of_pending_approval
agents__mobile_phone_number	TEXT	agents.mobile_phone_number	agents.mobile_phone_number
agents__observer_of	OBJECT	agents.observer_of	agents.observer_of
agents__observer_of_pending_approval	OBJECT	agents.observer_of_pending_approval	agents.observer_of_pending_approval
agents__occasional	BOOLEAN	agents.occasional	agents.occasional
agents__problem_scope	TEXT	agents.problem_scope	agents.problem_scope
agents__release_scope	TEXT	agents.release_scope	agents.release_scope
agents__reporting_manager_id	TEXT	agents.reporting_manager_id	agents.reporting_manager_id
agents__role_ids	OBJECT	agents.role_ids	agents.role_ids
agents__roles	OBJECT	agents.roles	agents.roles
agents__scopes	OBJECT	agents.scopes	agents.scopes
agents__scoreboard_level_id	TEXT	agents.scoreboard_level_id	agents.scoreboard_level_id
agents__scoreboard_points	NUMERIC	agents.scoreboard_points	agents.scoreboard_points
agents__signature	TEXT	agents.signature	agents.signature
agents__ticket_scope	TEXT	agents.ticket_scope	agents.ticket_scope

Freshservice agents fields (agents__time_format to agents__workspace_info)

ID	Type	Name	Description
agents__time_format	TEXT	agents.time_format	agents.time_format
agents__time_zone	TEXT	agents.time_zone	agents.time_zone
agents__updated_at	TIMESTAMP	agents.updated_at	agents.updated_at
agents__vip_user	BOOLEAN	agents.vip_user	agents.vip_user
agents__work_phone_number	TEXT	agents.work_phone_number	agents.work_phone_number
agents__work_schedule_id	TEXT	agents.work_schedule_id	agents.work_schedule_id
agents__workspace_id	TEXT	agents.workspace_id	agents.workspace_id
agents__workspace_ids	OBJECT	agents.workspace_ids	agents.workspace_ids
agents__workspace_info	OBJECT	agents.workspace_info	agents.workspace_info

Freshservice assets fields

The assets report of the Freshservice connector includes 19 fields.

ID	Type	Name	Description
assets__agent_id	TEXT	assets.agent_id	assets.agent_id
assets__asset_tag	TEXT	assets.asset_tag	assets.asset_tag
assets__asset_type_id	TEXT	assets.asset_type_id	assets.asset_type_id
assets__assigned_on	TEXT	assets.assigned_on	assets.assigned_on
assets__author_type	TEXT	assets.author_type	assets.author_type
assets__created_at	TIMESTAMP	assets.created_at	assets.created_at
assets__department_id	TEXT	assets.department_id	assets.department_id
assets__description	TEXT	assets.description	assets.description
assets__discovery_enabled	BOOLEAN	assets.discovery_enabled	assets.discovery_enabled
assets__display_id	TEXT	assets.display_id	assets.display_id
assets__end_of_life	TEXT	assets.end_of_life	assets.end_of_life
assets__group_id	TEXT	assets.group_id	assets.group_id
assets__id	TEXT	assets.id	assets.id
assets__impact	TEXT	assets.impact	assets.impact
assets__location_id	TEXT	assets.location_id	assets.location_id
assets__name	TEXT	assets.name	assets.name
assets__updated_at	TIMESTAMP	assets.updated_at	assets.updated_at
assets__usage_type	TEXT	assets.usage_type	assets.usage_type
assets__user_id	TEXT	assets.user_id	assets.user_id

Freshservice changes fields

The changes report of the Freshservice connector includes 30 fields.

ID	Type	Name	Description
changes__agent_id	TEXT	changes.agent_id	changes.agent_id
changes__approval_status	TEXT	changes.approval_status	changes.approval_status
changes__assets	OBJECT	changes.assets	changes.assets
changes__attachments	OBJECT	changes.attachments	changes.attachments
changes__blackout_window	OBJECT	changes.blackout_window	changes.blackout_window
changes__category	TEXT	changes.category	changes.category
changes__change_type	TEXT	changes.change_type	changes.change_type
changes__change_window_id	TEXT	changes.change_window_id	changes.change_window_id
changes__created_at	TIMESTAMP	changes.created_at	changes.created_at
changes__custom_fields	OBJECT	changes.custom_fields	changes.custom_fields
changes__department_id	TEXT	changes.department_id	changes.department_id
changes__description	TEXT	changes.description	changes.description
changes__description_text	TEXT	changes.description_text	changes.description_text
changes__group_id	TEXT	changes.group_id	changes.group_id
changes__id	TEXT	changes.id	changes.id
changes__impact	TEXT	changes.impact	changes.impact
changes__impacted_services	OBJECT	changes.impacted_services	changes.impacted_services
changes__item_category	TEXT	changes.item_category	changes.item_category
changes__maintenance_window	OBJECT	changes.maintenance_window	changes.maintenance_window
changes__planned_effort	TEXT	changes.planned_effort	changes.planned_effort
changes__planned_end_date	DATE	changes.planned_end_date	changes.planned_end_date
changes__planned_start_date	DATE	changes.planned_start_date	changes.planned_start_date
changes__priority	TEXT	changes.priority	changes.priority
changes__requester_id	TEXT	changes.requester_id	changes.requester_id
changes__risk	TEXT	changes.risk	changes.risk
changes__status	TEXT	changes.status	changes.status
changes__sub_category	TEXT	changes.sub_category	changes.sub_category
changes__subject	TEXT	changes.subject	changes.subject
changes__updated_at	TIMESTAMP	changes.updated_at	changes.updated_at
changes__workspace_id	TEXT	changes.workspace_id	changes.workspace_id

Freshservice locations fields

The locations report of the Freshservice connector includes 10 fields.

ID	Type	Name	Description
locations__address	OBJECT	locations.address	locations.address
locations__contact_name	TEXT	locations.contact_name	locations.contact_name
locations__created_at	TIMESTAMP	locations.created_at	locations.created_at
locations__email	TEXT	locations.email	locations.email
locations__id	TEXT	locations.id	locations.id
locations__name	TEXT	locations.name	locations.name
locations__parent_location_id	TEXT	locations.parent_location_id	locations.parent_location_id
locations__phone	TEXT	locations.phone	locations.phone
locations__primary_contact_id	TEXT	locations.primary_contact_id	locations.primary_contact_id
locations__updated_at	TIMESTAMP	locations.updated_at	locations.updated_at

Freshservice problems fields

The problems report of the Freshservice connector includes 27 fields.

ID	Type	Name	Description
problems__agent_id	TEXT	problems.agent_id	problems.agent_id
problems__analysis_fields	OBJECT	problems.analysis_fields	problems.analysis_fields
problems__assets	OBJECT	problems.assets	problems.assets
problems__associated_change	TEXT	problems.associated_change	problems.associated_change
problems__attachments	OBJECT	problems.attachments	problems.attachments
problems__category	TEXT	problems.category	problems.category
problems__created_at	TIMESTAMP	problems.created_at	problems.created_at
problems__custom_fields	OBJECT	problems.custom_fields	problems.custom_fields
problems__department_id	TEXT	problems.department_id	problems.department_id
problems__description	TEXT	problems.description	problems.description
problems__description_text	TEXT	problems.description_text	problems.description_text
problems__due_by	TEXT	problems.due_by	problems.due_by
problems__group_id	TEXT	problems.group_id	problems.group_id
problems__id	TEXT	problems.id	problems.id
problems__impact	TEXT	problems.impact	problems.impact
problems__item_category	TEXT	problems.item_category	problems.item_category
problems__known_error	BOOLEAN	problems.known_error	problems.known_error
problems__planned_effort	TEXT	problems.planned_effort	problems.planned_effort
problems__planned_end_date	DATE	problems.planned_end_date	problems.planned_end_date
problems__planned_start_date	DATE	problems.planned_start_date	problems.planned_start_date
problems__priority	TEXT	problems.priority	problems.priority
problems__requester_id	TEXT	problems.requester_id	problems.requester_id
problems__status	TEXT	problems.status	problems.status
problems__sub_category	TEXT	problems.sub_category	problems.sub_category
problems__subject	TEXT	problems.subject	problems.subject
problems__updated_at	TIMESTAMP	problems.updated_at	problems.updated_at
problems__workspace_id	TEXT	problems.workspace_id	problems.workspace_id

Freshservice products fields

The products report of the Freshservice connector includes 11 fields.

ID	Type	Name	Description
products__asset_type_id	TEXT	products.asset_type_id	products.asset_type_id
products__created_at	TIMESTAMP	products.created_at	products.created_at
products__depreciation_type_id	TEXT	products.depreciation_type_id	products.depreciation_type_id
products__description	TEXT	products.description	products.description
products__description_text	TEXT	products.description_text	products.description_text
products__id	TEXT	products.id	products.id
products__manufacturer	TEXT	products.manufacturer	products.manufacturer
products__mode_of_procurement	TEXT	products.mode_of_procurement	products.mode_of_procurement
products__name	TEXT	products.name	products.name
products__status	TEXT	products.status	products.status
products__updated_at	TIMESTAMP	products.updated_at	products.updated_at

Freshservice purchase_orders fields

The purchase_orders report of the Freshservice connector includes 23 fields.

ID	Type	Name	Description
purchase_orders__billing_address	TEXT	purchase_orders.billing_address	purchase_orders.billing_address
purchase_orders__billing_same_as_shipping	BOOLEAN	purchase_orders.billing_same_as_shipping	purchase_orders.billing_same_as_shipping
purchase_orders__conversion_rate	NUMERIC	purchase_orders.conversion_rate	purchase_orders.conversion_rate
purchase_orders__created_at	TIMESTAMP	purchase_orders.created_at	purchase_orders.created_at
purchase_orders__created_by	NUMERIC	purchase_orders.created_by	purchase_orders.created_by
purchase_orders__currency_code	TEXT	purchase_orders.currency_code	purchase_orders.currency_code
purchase_orders__custom_fields	OBJECT	purchase_orders.custom_fields	purchase_orders.custom_fields
purchase_orders__department_id	TEXT	purchase_orders.department_id	purchase_orders.department_id
purchase_orders__discount_percentage	PERCENT	purchase_orders.discount_percentage	purchase_orders.discount_percentage
purchase_orders__expected_delivery_date	DATE	purchase_orders.expected_delivery_date	purchase_orders.expected_delivery_date
purchase_orders__id	TEXT	purchase_orders.id	purchase_orders.id
purchase_orders__name	TEXT	purchase_orders.name	purchase_orders.name
purchase_orders__po_number	TEXT	purchase_orders.po_number	purchase_orders.po_number
purchase_orders__purchase_items	OBJECT	purchase_orders.purchase_items	purchase_orders.purchase_items
purchase_orders__shipping_address	TEXT	purchase_orders.shipping_address	purchase_orders.shipping_address
purchase_orders__shipping_cost	NUMERIC	purchase_orders.shipping_cost	purchase_orders.shipping_cost
purchase_orders__status	TEXT	purchase_orders.status	purchase_orders.status
purchase_orders__tax_percentage	PERCENT	purchase_orders.tax_percentage	purchase_orders.tax_percentage
purchase_orders__total_cost	NUMERIC	purchase_orders.total_cost	purchase_orders.total_cost
purchase_orders__updated_at	TIMESTAMP	purchase_orders.updated_at	purchase_orders.updated_at
purchase_orders__vendor_details	TEXT	purchase_orders.vendor_details	purchase_orders.vendor_details
purchase_orders__vendor_id	TEXT	purchase_orders.vendor_id	purchase_orders.vendor_id
purchase_orders__workspace_id	TEXT	purchase_orders.workspace_id	purchase_orders.workspace_id

Freshservice releases fields

The releases report of the Freshservice connector includes 22 fields.

ID	Type	Name	Description
releases__agent_id	TEXT	releases.agent_id	releases.agent_id
releases__associated_assets	OBJECT	releases.associated_assets	releases.associated_assets
releases__associated_changes	OBJECT	releases.associated_changes	releases.associated_changes
releases__category	TEXT	releases.category	releases.category
releases__created_at	TIMESTAMP	releases.created_at	releases.created_at
releases__custom_fields	OBJECT	releases.custom_fields	releases.custom_fields
releases__department_id	TEXT	releases.department_id	releases.department_id
releases__description	TEXT	releases.description	releases.description
releases__group_id	TEXT	releases.group_id	releases.group_id
releases__id	TEXT	releases.id	releases.id
releases__item_category	TEXT	releases.item_category	releases.item_category
releases__planned_end_date	DATE	releases.planned_end_date	releases.planned_end_date
releases__planned_start_date	DATE	releases.planned_start_date	releases.planned_start_date
releases__planning_fields	OBJECT	releases.planning_fields	releases.planning_fields
releases__priority	TEXT	releases.priority	releases.priority
releases__release_type	TEXT	releases.release_type	releases.release_type
releases__status	TEXT	releases.status	releases.status
releases__sub_category	TEXT	releases.sub_category	releases.sub_category
releases__subject	TEXT	releases.subject	releases.subject
releases__updated_at	TIMESTAMP	releases.updated_at	releases.updated_at
releases__work_end_date	DATE	releases.work_end_date	releases.work_end_date
releases__work_start_date	DATE	releases.work_start_date	releases.work_start_date

Freshservice requested_items fields

The requested_items report of the Freshservice connector includes 13 fields.

ID	Type	Name	Description
requested_items__cost_per_request	NUMERIC	requested_items.cost_per_request	requested_items.cost_per_request
requested_items__created_at	TIMESTAMP	requested_items.created_at	requested_items.created_at
requested_items__custom_fields	OBJECT	requested_items.custom_fields	requested_items.custom_fields
requested_items__delivery_time	NUMERIC	requested_items.delivery_time	requested_items.delivery_time
requested_items__id	TEXT	requested_items.id	requested_items.id
requested_items__is_parent	BOOLEAN	requested_items.is_parent	requested_items.is_parent
requested_items__loaned	BOOLEAN	requested_items.loaned	requested_items.loaned
requested_items__quantity	NUMERIC	requested_items.quantity	requested_items.quantity
requested_items__remarks	TEXT	requested_items.remarks	requested_items.remarks
requested_items__service_item_id	TEXT	requested_items.service_item_id	requested_items.service_item_id
requested_items__service_item_name	TEXT	requested_items.service_item_name	requested_items.service_item_name
requested_items__stage	TEXT	requested_items.stage	requested_items.stage
requested_items__updated_at	TIMESTAMP	requested_items.updated_at	requested_items.updated_at

Freshservice requesters fields

The requesters report of the Freshservice connector includes 29 fields.

ID	Type	Name	Description
requesters__active	BOOLEAN	requesters.active	requesters.active
requesters__address	TEXT	requesters.address	requesters.address
requesters__background_information	TEXT	requesters.background_information	requesters.background_information
requesters__can_see_all_changes_from_associated_departments	BOOLEAN	requesters.can_see_all_changes_from_associated_departments	requesters.can_see_all_changes_from_associated_departments
requesters__can_see_all_tickets_from_associated_departments	BOOLEAN	requesters.can_see_all_tickets_from_associated_departments	requesters.can_see_all_tickets_from_associated_departments
requesters__created_at	TIMESTAMP	requesters.created_at	requesters.created_at
requesters__custom_fields	OBJECT	requesters.custom_fields	requesters.custom_fields
requesters__department_ids	OBJECT	requesters.department_ids	requesters.department_ids
requesters__department_names	OBJECT	requesters.department_names	requesters.department_names
requesters__external_id	TEXT	requesters.external_id	requesters.external_id
requesters__first_name	TEXT	requesters.first_name	requesters.first_name
requesters__has_logged_in	BOOLEAN	requesters.has_logged_in	requesters.has_logged_in
requesters__id	TEXT	requesters.id	requesters.id
requesters__is_agent	BOOLEAN	requesters.is_agent	requesters.is_agent
requesters__job_title	TEXT	requesters.job_title	requesters.job_title
requesters__language	TEXT	requesters.language	requesters.language
requesters__last_name	TEXT	requesters.last_name	requesters.last_name
requesters__location_id	TEXT	requesters.location_id	requesters.location_id
requesters__location_name	TEXT	requesters.location_name	requesters.location_name
requesters__mobile_phone_number	TEXT	requesters.mobile_phone_number	requesters.mobile_phone_number
requesters__primary_email	TEXT	requesters.primary_email	requesters.primary_email
requesters__reporting_manager_id	TEXT	requesters.reporting_manager_id	requesters.reporting_manager_id
requesters__secondary_emails	OBJECT	requesters.secondary_emails	requesters.secondary_emails
requesters__time_format	TEXT	requesters.time_format	requesters.time_format
requesters__time_zone	TEXT	requesters.time_zone	requesters.time_zone
requesters__updated_at	TIMESTAMP	requesters.updated_at	requesters.updated_at
requesters__vip_user	BOOLEAN	requesters.vip_user	requesters.vip_user
requesters__work_phone_number	TEXT	requesters.work_phone_number	requesters.work_phone_number
requesters__work_schedule_id	TEXT	requesters.work_schedule_id	requesters.work_schedule_id

Freshservice satisfaction_survey_responses fields

The satisfaction_survey_responses report of the Freshservice connector includes 7 fields.

ID	Type	Name	Description
satisfaction_survey_responses__created_at	TIMESTAMP	satisfaction_survey_responses.created_at	satisfaction_survey_responses.created_at
satisfaction_survey_responses__id	TEXT	satisfaction_survey_responses.id	satisfaction_survey_responses.id
satisfaction_survey_responses__overall_rating	NUMERIC	satisfaction_survey_responses.overall_rating	satisfaction_survey_responses.overall_rating
satisfaction_survey_responses__overall_rating_text	TEXT	satisfaction_survey_responses.overall_rating_text	satisfaction_survey_responses.overall_rating_text
satisfaction_survey_responses__primary_question	TEXT	satisfaction_survey_responses.primary_question	satisfaction_survey_responses.primary_question
satisfaction_survey_responses__questionnaire_responses	OBJECT	satisfaction_survey_responses.questionnaire_responses	satisfaction_survey_responses.questionnaire_responses
satisfaction_survey_responses__updated_at	TIMESTAMP	satisfaction_survey_responses.updated_at	satisfaction_survey_responses.updated_at

Freshservice software fields

The software report of the Freshservice connector includes 16 fields.

ID	Type	Name	Description
software__additional_data	OBJECT	software.additional_data	software.additional_data
software__application_type	TEXT	software.application_type	software.application_type
software__category	TEXT	software.category	software.category
software__created_at	TIMESTAMP	software.created_at	software.created_at
software__description	TEXT	software.description	software.description
software__id	TEXT	software.id	software.id
software__installation_count	NUMERIC	software.installation_count	software.installation_count
software__managed_by_id	TEXT	software.managed_by_id	software.managed_by_id
software__name	TEXT	software.name	software.name
software__notes	TEXT	software.notes	software.notes
software__publisher_id	TEXT	software.publisher_id	software.publisher_id
software__sources	OBJECT	software.sources	software.sources
software__status	TEXT	software.status	software.status
software__updated_at	TIMESTAMP	software.updated_at	software.updated_at
software__user_count	NUMERIC	software.user_count	software.user_count
software__workspace_id	TEXT	software.workspace_id	software.workspace_id

Freshservice tickets fields

The tickets report of the Freshservice connector includes 38 fields.

ID	Type	Name	Description
tickets__attachments	OBJECT	tickets.attachments	tickets.attachments
tickets__category	TEXT	tickets.category	tickets.category
tickets__cc_emails	OBJECT	tickets.cc_emails	tickets.cc_emails
tickets__created_at	TIMESTAMP	tickets.created_at	tickets.created_at
tickets__custom_fields	OBJECT	tickets.custom_fields	tickets.custom_fields
tickets__deleted	BOOLEAN	tickets.deleted	tickets.deleted
tickets__department_id	TEXT	tickets.department_id	tickets.department_id
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	TEXT	tickets.email	tickets.email
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__impact	TEXT	tickets.impact	tickets.impact
tickets__is_escalated	BOOLEAN	tickets.is_escalated	tickets.is_escalated
tickets__item_category	TEXT	tickets.item_category	tickets.item_category
tickets__name	TEXT	tickets.name	tickets.name
tickets__phone	TEXT	tickets.phone	tickets.phone
tickets__priority	TEXT	tickets.priority	tickets.priority
tickets__reply_cc_emails	OBJECT	tickets.reply_cc_emails	tickets.reply_cc_emails
tickets__requested_for_id	TEXT	tickets.requested_for_id	tickets.requested_for_id
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__status	TEXT	tickets.status	tickets.status
tickets__sub_category	TEXT	tickets.sub_category	tickets.sub_category
tickets__subject	TEXT	tickets.subject	tickets.subject
tickets__tags	OBJECT	tickets.tags	tickets.tags
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
tickets__urgency	TEXT	tickets.urgency	tickets.urgency
tickets__workspace_id	TEXT	tickets.workspace_id	tickets.workspace_id

Freshservice vendors fields

The vendors report of the Freshservice connector includes 12 fields.

ID	Type	Name	Description
vendors__address	OBJECT	vendors.address	vendors.address
vendors__contact_name	TEXT	vendors.contact_name	vendors.contact_name
vendors__created_at	TIMESTAMP	vendors.created_at	vendors.created_at
vendors__custom_fields	OBJECT	vendors.custom_fields	vendors.custom_fields
vendors__description	TEXT	vendors.description	vendors.description
vendors__email	TEXT	vendors.email	vendors.email
vendors__id	TEXT	vendors.id	vendors.id
vendors__mobile	TEXT	vendors.mobile	vendors.mobile
vendors__name	TEXT	vendors.name	vendors.name
vendors__phone	TEXT	vendors.phone	vendors.phone
vendors__primary_contact_id	TEXT	vendors.primary_contact_id	vendors.primary_contact_id
vendors__updated_at	TIMESTAMP	vendors.updated_at	vendors.updated_at

Freshservice other fields

The Freshservice 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