Windsor brings all your Freshservice data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Freshservice Field Reference

Fields

ID	Type	Name	Description	Report
agents__active	BOOLEAN	agents.active	agents.active	agents
agents__address	TEXT	agents.address	agents.address	agents
agents__auto_assign_status_changed_at	TEXT	agents.auto_assign_status_changed_at	agents.auto_assign_status_changed_at	agents
agents__auto_assign_tickets	BOOLEAN	agents.auto_assign_tickets	agents.auto_assign_tickets	agents
agents__background_information	TEXT	agents.background_information	agents.background_information	agents
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
agents__change_scope	TEXT	agents.change_scope	agents.change_scope	agents
agents__created_at	TEXT	agents.created_at	agents.created_at	agents
agents__custom_fields	OBJECT	agents.custom_fields	agents.custom_fields	agents
agents__department_ids	OBJECT	agents.department_ids	agents.department_ids	agents
agents__department_names	OBJECT	agents.department_names	agents.department_names	agents
agents__email	TEXT	agents.email	agents.email	agents
agents__external_id	TEXT	agents.external_id	agents.external_id	agents
agents__first_name	TEXT	agents.first_name	agents.first_name	agents
agents__group_ids	OBJECT	agents.group_ids	agents.group_ids	agents
agents__has_logged_in	BOOLEAN	agents.has_logged_in	agents.has_logged_in	agents
agents__id	NUMERIC	agents.id	agents.id	agents
agents__job_title	TEXT	agents.job_title	agents.job_title	agents
agents__language	TEXT	agents.language	agents.language	agents
agents__last_active_at	TEXT	agents.last_active_at	agents.last_active_at	agents
agents__last_login_at	TEXT	agents.last_login_at	agents.last_login_at	agents
agents__last_name	TEXT	agents.last_name	agents.last_name	agents
agents__location_id	NUMERIC	agents.location_id	agents.location_id	agents
agents__location_name	TEXT	agents.location_name	agents.location_name	agents
agents__member_of	OBJECT	agents.member_of	agents.member_of	agents
agents__member_of_pending_approval	OBJECT	agents.member_of_pending_approval	agents.member_of_pending_approval	agents
agents__mobile_phone_number	TEXT	agents.mobile_phone_number	agents.mobile_phone_number	agents
agents__observer_of	OBJECT	agents.observer_of	agents.observer_of	agents
agents__observer_of_pending_approval	OBJECT	agents.observer_of_pending_approval	agents.observer_of_pending_approval	agents
agents__occasional	BOOLEAN	agents.occasional	agents.occasional	agents
agents__problem_scope	TEXT	agents.problem_scope	agents.problem_scope	agents
agents__release_scope	TEXT	agents.release_scope	agents.release_scope	agents
agents__reporting_manager_id	NUMERIC	agents.reporting_manager_id	agents.reporting_manager_id	agents
agents__role_ids	OBJECT	agents.role_ids	agents.role_ids	agents
agents__roles	OBJECT	agents.roles	agents.roles	agents
agents__scopes	OBJECT	agents.scopes	agents.scopes	agents
agents__scoreboard_level_id	NUMERIC	agents.scoreboard_level_id	agents.scoreboard_level_id	agents
agents__scoreboard_points	NUMERIC	agents.scoreboard_points	agents.scoreboard_points	agents
agents__signature	TEXT	agents.signature	agents.signature	agents
agents__ticket_scope	TEXT	agents.ticket_scope	agents.ticket_scope	agents
agents__time_format	TEXT	agents.time_format	agents.time_format	agents
agents__time_zone	TEXT	agents.time_zone	agents.time_zone	agents
agents__updated_at	TEXT	agents.updated_at	agents.updated_at	agents
agents__vip_user	BOOLEAN	agents.vip_user	agents.vip_user	agents
agents__work_phone_number	TEXT	agents.work_phone_number	agents.work_phone_number	agents
agents__work_schedule_id	NUMERIC	agents.work_schedule_id	agents.work_schedule_id	agents
agents__workspace_id	NUMERIC	agents.workspace_id	agents.workspace_id	agents
agents__workspace_ids	OBJECT	agents.workspace_ids	agents.workspace_ids	agents
agents__workspace_info	OBJECT	agents.workspace_info	agents.workspace_info	agents
assets__agent_id	NUMERIC	assets.agent_id	assets.agent_id	assets
assets__asset_tag	TEXT	assets.asset_tag	assets.asset_tag	assets
assets__asset_type_id	NUMERIC	assets.asset_type_id	assets.asset_type_id	assets
assets__assigned_on	TEXT	assets.assigned_on	assets.assigned_on	assets
assets__author_type	TEXT	assets.author_type	assets.author_type	assets
assets__created_at	TEXT	assets.created_at	assets.created_at	assets
assets__department_id	NUMERIC	assets.department_id	assets.department_id	assets
assets__description	TEXT	assets.description	assets.description	assets
assets__discovery_enabled	BOOLEAN	assets.discovery_enabled	assets.discovery_enabled	assets
assets__display_id	NUMERIC	assets.display_id	assets.display_id	assets
assets__end_of_life	TEXT	assets.end_of_life	assets.end_of_life	assets
assets__group_id	NUMERIC	assets.group_id	assets.group_id	assets
assets__id	NUMERIC	assets.id	assets.id	assets
assets__impact	TEXT	assets.impact	assets.impact	assets
assets__location_id	NUMERIC	assets.location_id	assets.location_id	assets
assets__name	TEXT	assets.name	assets.name	assets
assets__updated_at	TEXT	assets.updated_at	assets.updated_at	assets
assets__usage_type	TEXT	assets.usage_type	assets.usage_type	assets
assets__user_id	NUMERIC	assets.user_id	assets.user_id	assets
changes__agent_id	NUMERIC	changes.agent_id	changes.agent_id	changes
changes__approval_status	NUMERIC	changes.approval_status	changes.approval_status	changes
changes__assets	OBJECT	changes.assets	changes.assets	changes
changes__attachments	OBJECT	changes.attachments	changes.attachments	changes
changes__blackout_window	OBJECT	changes.blackout_window	changes.blackout_window	changes
changes__category	TEXT	changes.category	changes.category	changes
changes__change_type	NUMERIC	changes.change_type	changes.change_type	changes
changes__change_window_id	NUMERIC	changes.change_window_id	changes.change_window_id	changes
changes__created_at	TEXT	changes.created_at	changes.created_at	changes
changes__custom_fields	OBJECT	changes.custom_fields	changes.custom_fields	changes
changes__department_id	NUMERIC	changes.department_id	changes.department_id	changes
changes__description	TEXT	changes.description	changes.description	changes
changes__description_text	TEXT	changes.description_text	changes.description_text	changes
changes__group_id	NUMERIC	changes.group_id	changes.group_id	changes
changes__id	NUMERIC	changes.id	changes.id	changes
changes__impact	NUMERIC	changes.impact	changes.impact	changes
changes__impacted_services	OBJECT	changes.impacted_services	changes.impacted_services	changes
changes__item_category	TEXT	changes.item_category	changes.item_category	changes
changes__maintenance_window	OBJECT	changes.maintenance_window	changes.maintenance_window	changes
changes__planned_effort	TEXT	changes.planned_effort	changes.planned_effort	changes
changes__planned_end_date	DATE	changes.planned_end_date	changes.planned_end_date	changes
changes__planned_start_date	DATE	changes.planned_start_date	changes.planned_start_date	changes
changes__priority	NUMERIC	changes.priority	changes.priority	changes
changes__requester_id	NUMERIC	changes.requester_id	changes.requester_id	changes
changes__risk	NUMERIC	changes.risk	changes.risk	changes
changes__status	NUMERIC	changes.status	changes.status	changes
changes__sub_category	TEXT	changes.sub_category	changes.sub_category	changes
changes__subject	TEXT	changes.subject	changes.subject	changes
changes__updated_at	TEXT	changes.updated_at	changes.updated_at	changes
changes__workspace_id	NUMERIC	changes.workspace_id	changes.workspace_id	changes
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
locations__address	OBJECT	locations.address	locations.address	locations
locations__contact_name	TEXT	locations.contact_name	locations.contact_name	locations
locations__created_at	TEXT	locations.created_at	locations.created_at	locations
locations__email	TEXT	locations.email	locations.email	locations
locations__id	NUMERIC	locations.id	locations.id	locations
locations__name	TEXT	locations.name	locations.name	locations
locations__parent_location_id	NUMERIC	locations.parent_location_id	locations.parent_location_id	locations
locations__phone	TEXT	locations.phone	locations.phone	locations
locations__primary_contact_id	NUMERIC	locations.primary_contact_id	locations.primary_contact_id	locations
locations__updated_at	TEXT	locations.updated_at	locations.updated_at	locations
problems__agent_id	NUMERIC	problems.agent_id	problems.agent_id	problems
problems__analysis_fields	OBJECT	problems.analysis_fields	problems.analysis_fields	problems
problems__assets	OBJECT	problems.assets	problems.assets	problems
problems__associated_change	NUMERIC	problems.associated_change	problems.associated_change	problems
problems__attachments	OBJECT	problems.attachments	problems.attachments	problems
problems__category	TEXT	problems.category	problems.category	problems
problems__created_at	TEXT	problems.created_at	problems.created_at	problems
problems__custom_fields	OBJECT	problems.custom_fields	problems.custom_fields	problems
problems__department_id	NUMERIC	problems.department_id	problems.department_id	problems
problems__description	TEXT	problems.description	problems.description	problems
problems__description_text	TEXT	problems.description_text	problems.description_text	problems
problems__due_by	TEXT	problems.due_by	problems.due_by	problems
problems__group_id	NUMERIC	problems.group_id	problems.group_id	problems
problems__id	NUMERIC	problems.id	problems.id	problems
problems__impact	NUMERIC	problems.impact	problems.impact	problems
problems__item_category	TEXT	problems.item_category	problems.item_category	problems
problems__known_error	BOOLEAN	problems.known_error	problems.known_error	problems
problems__planned_effort	TEXT	problems.planned_effort	problems.planned_effort	problems
problems__planned_end_date	DATE	problems.planned_end_date	problems.planned_end_date	problems
problems__planned_start_date	DATE	problems.planned_start_date	problems.planned_start_date	problems
problems__priority	NUMERIC	problems.priority	problems.priority	problems
problems__requester_id	NUMERIC	problems.requester_id	problems.requester_id	problems
problems__status	NUMERIC	problems.status	problems.status	problems
problems__sub_category	TEXT	problems.sub_category	problems.sub_category	problems
problems__subject	TEXT	problems.subject	problems.subject	problems
problems__updated_at	TEXT	problems.updated_at	problems.updated_at	problems
problems__workspace_id	NUMERIC	problems.workspace_id	problems.workspace_id	problems
products__asset_type_id	NUMERIC	products.asset_type_id	products.asset_type_id	products
products__created_at	TEXT	products.created_at	products.created_at	products
products__depreciation_type_id	NUMERIC	products.depreciation_type_id	products.depreciation_type_id	products
products__description	TEXT	products.description	products.description	products
products__description_text	TEXT	products.description_text	products.description_text	products
products__id	NUMERIC	products.id	products.id	products
products__manufacturer	TEXT	products.manufacturer	products.manufacturer	products
products__mode_of_procurement	TEXT	products.mode_of_procurement	products.mode_of_procurement	products
products__name	TEXT	products.name	products.name	products
products__status	TEXT	products.status	products.status	products
products__updated_at	TEXT	products.updated_at	products.updated_at	products
purchase_orders__billing_address	TEXT	purchase_orders.billing_address	purchase_orders.billing_address	purchase_orders
purchase_orders__billing_same_as_shipping	NUMERIC	purchase_orders.billing_same_as_shipping	purchase_orders.billing_same_as_shipping	purchase_orders
purchase_orders__conversion_rate	NUMERIC	purchase_orders.conversion_rate	purchase_orders.conversion_rate	purchase_orders
purchase_orders__created_at	TIMESTAMP	purchase_orders.created_at	purchase_orders.created_at	purchase_orders
purchase_orders__created_by	NUMERIC	purchase_orders.created_by	purchase_orders.created_by	purchase_orders
purchase_orders__currency_code	TEXT	purchase_orders.currency_code	purchase_orders.currency_code	purchase_orders
purchase_orders__custom_fields	OBJECT	purchase_orders.custom_fields	purchase_orders.custom_fields	purchase_orders
purchase_orders__department_id	NUMERIC	purchase_orders.department_id	purchase_orders.department_id	purchase_orders
purchase_orders__discount_percentage	NUMERIC	purchase_orders.discount_percentage	purchase_orders.discount_percentage	purchase_orders
purchase_orders__expected_delivery_date	DATE	purchase_orders.expected_delivery_date	purchase_orders.expected_delivery_date	purchase_orders
purchase_orders__id	NUMERIC	purchase_orders.id	purchase_orders.id	purchase_orders
purchase_orders__name	TEXT	purchase_orders.name	purchase_orders.name	purchase_orders
purchase_orders__po_number	TEXT	purchase_orders.po_number	purchase_orders.po_number	purchase_orders
purchase_orders__purchase_items	OBJECT	purchase_orders.purchase_items	purchase_orders.purchase_items	purchase_orders
purchase_orders__shipping_address	TEXT	purchase_orders.shipping_address	purchase_orders.shipping_address	purchase_orders
purchase_orders__shipping_cost	NUMERIC	purchase_orders.shipping_cost	purchase_orders.shipping_cost	purchase_orders
purchase_orders__status	NUMERIC	purchase_orders.status	purchase_orders.status	purchase_orders
purchase_orders__tax_percentage	NUMERIC	purchase_orders.tax_percentage	purchase_orders.tax_percentage	purchase_orders
purchase_orders__total_cost	NUMERIC	purchase_orders.total_cost	purchase_orders.total_cost	purchase_orders
purchase_orders__updated_at	TEXT	purchase_orders.updated_at	purchase_orders.updated_at	purchase_orders
purchase_orders__vendor_details	TEXT	purchase_orders.vendor_details	purchase_orders.vendor_details	purchase_orders
purchase_orders__vendor_id	NUMERIC	purchase_orders.vendor_id	purchase_orders.vendor_id	purchase_orders
purchase_orders__workspace_id	NUMERIC	purchase_orders.workspace_id	purchase_orders.workspace_id	purchase_orders
releases__agent_id	NUMERIC	releases.agent_id	releases.agent_id	releases
releases__associated_assets	OBJECT	releases.associated_assets	releases.associated_assets	releases
releases__associated_changes	OBJECT	releases.associated_changes	releases.associated_changes	releases
releases__category	TEXT	releases.category	releases.category	releases
releases__created_at	TEXT	releases.created_at	releases.created_at	releases
releases__custom_fields	OBJECT	releases.custom_fields	releases.custom_fields	releases
releases__department_id	NUMERIC	releases.department_id	releases.department_id	releases
releases__description	TEXT	releases.description	releases.description	releases
releases__group_id	NUMERIC	releases.group_id	releases.group_id	releases
releases__id	NUMERIC	releases.id	releases.id	releases
releases__item_category	TEXT	releases.item_category	releases.item_category	releases
releases__planned_end_date	DATE	releases.planned_end_date	releases.planned_end_date	releases
releases__planned_start_date	DATE	releases.planned_start_date	releases.planned_start_date	releases
releases__planning_fields	OBJECT	releases.planning_fields	releases.planning_fields	releases
releases__priority	NUMERIC	releases.priority	releases.priority	releases
releases__release_type	NUMERIC	releases.release_type	releases.release_type	releases
releases__status	NUMERIC	releases.status	releases.status	releases
releases__sub_category	TEXT	releases.sub_category	releases.sub_category	releases
releases__subject	TEXT	releases.subject	releases.subject	releases
releases__updated_at	TEXT	releases.updated_at	releases.updated_at	releases
releases__work_end_date	DATE	releases.work_end_date	releases.work_end_date	releases
releases__work_start_date	DATE	releases.work_start_date	releases.work_start_date	releases
requested_items__cost_per_request	NUMERIC	requested_items.cost_per_request	requested_items.cost_per_request	requested_items
requested_items__created_at	TEXT	requested_items.created_at	requested_items.created_at	requested_items
requested_items__custom_fields	OBJECT	requested_items.custom_fields	requested_items.custom_fields	requested_items
requested_items__delivery_time	NUMERIC	requested_items.delivery_time	requested_items.delivery_time	requested_items
requested_items__id	NUMERIC	requested_items.id	requested_items.id	requested_items
requested_items__is_parent	BOOLEAN	requested_items.is_parent	requested_items.is_parent	requested_items
requested_items__loaned	BOOLEAN	requested_items.loaned	requested_items.loaned	requested_items
requested_items__quantity	NUMERIC	requested_items.quantity	requested_items.quantity	requested_items
requested_items__remarks	TEXT	requested_items.remarks	requested_items.remarks	requested_items
requested_items__service_item_id	NUMERIC	requested_items.service_item_id	requested_items.service_item_id	requested_items
requested_items__service_item_name	TEXT	requested_items.service_item_name	requested_items.service_item_name	requested_items
requested_items__stage	NUMERIC	requested_items.stage	requested_items.stage	requested_items
requested_items__updated_at	TEXT	requested_items.updated_at	requested_items.updated_at	requested_items
requesters__active	BOOLEAN	requesters.active	requesters.active	requesters
requesters__address	TEXT	requesters.address	requesters.address	requesters
requesters__background_information	TEXT	requesters.background_information	requesters.background_information	requesters
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
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
requesters__created_at	TEXT	requesters.created_at	requesters.created_at	requesters
requesters__custom_fields	OBJECT	requesters.custom_fields	requesters.custom_fields	requesters
requesters__department_ids	OBJECT	requesters.department_ids	requesters.department_ids	requesters
requesters__department_names	OBJECT	requesters.department_names	requesters.department_names	requesters
requesters__external_id	TEXT	requesters.external_id	requesters.external_id	requesters
requesters__first_name	TEXT	requesters.first_name	requesters.first_name	requesters
requesters__has_logged_in	BOOLEAN	requesters.has_logged_in	requesters.has_logged_in	requesters
requesters__id	NUMERIC	requesters.id	requesters.id	requesters
requesters__is_agent	BOOLEAN	requesters.is_agent	requesters.is_agent	requesters
requesters__job_title	TEXT	requesters.job_title	requesters.job_title	requesters
requesters__language	TEXT	requesters.language	requesters.language	requesters
requesters__last_name	TEXT	requesters.last_name	requesters.last_name	requesters
requesters__location_id	NUMERIC	requesters.location_id	requesters.location_id	requesters
requesters__location_name	TEXT	requesters.location_name	requesters.location_name	requesters
requesters__mobile_phone_number	TEXT	requesters.mobile_phone_number	requesters.mobile_phone_number	requesters
requesters__primary_email	TEXT	requesters.primary_email	requesters.primary_email	requesters
requesters__reporting_manager_id	NUMERIC	requesters.reporting_manager_id	requesters.reporting_manager_id	requesters
requesters__secondary_emails	OBJECT	requesters.secondary_emails	requesters.secondary_emails	requesters
requesters__time_format	TEXT	requesters.time_format	requesters.time_format	requesters
requesters__time_zone	TEXT	requesters.time_zone	requesters.time_zone	requesters
requesters__updated_at	TEXT	requesters.updated_at	requesters.updated_at	requesters
requesters__vip_user	BOOLEAN	requesters.vip_user	requesters.vip_user	requesters
requesters__work_phone_number	TEXT	requesters.work_phone_number	requesters.work_phone_number	requesters
requesters__work_schedule_id	NUMERIC	requesters.work_schedule_id	requesters.work_schedule_id	requesters
satisfaction_survey_responses__created_at	TEXT	satisfaction_survey_responses.created_at	satisfaction_survey_responses.created_at	satisfaction_survey_responses
satisfaction_survey_responses__id	NUMERIC	satisfaction_survey_responses.id	satisfaction_survey_responses.id	satisfaction_survey_responses
satisfaction_survey_responses__overall_rating	NUMERIC	satisfaction_survey_responses.overall_rating	satisfaction_survey_responses.overall_rating	satisfaction_survey_responses
satisfaction_survey_responses__overall_rating_text	TEXT	satisfaction_survey_responses.overall_rating_text	satisfaction_survey_responses.overall_rating_text	satisfaction_survey_responses
satisfaction_survey_responses__primary_question	TEXT	satisfaction_survey_responses.primary_question	satisfaction_survey_responses.primary_question	satisfaction_survey_responses
satisfaction_survey_responses__questionnaire_responses	OBJECT	satisfaction_survey_responses.questionnaire_responses	satisfaction_survey_responses.questionnaire_responses	satisfaction_survey_responses
satisfaction_survey_responses__updated_at	TEXT	satisfaction_survey_responses.updated_at	satisfaction_survey_responses.updated_at	satisfaction_survey_responses
software__additional_data	OBJECT	software.additional_data	software.additional_data	software
software__application_type	TEXT	software.application_type	software.application_type	software
software__category	TEXT	software.category	software.category	software
software__created_at	TEXT	software.created_at	software.created_at	software
software__description	TEXT	software.description	software.description	software
software__id	NUMERIC	software.id	software.id	software
software__installation_count	NUMERIC	software.installation_count	software.installation_count	software
software__managed_by_id	NUMERIC	software.managed_by_id	software.managed_by_id	software
software__name	TEXT	software.name	software.name	software
software__notes	TEXT	software.notes	software.notes	software
software__publisher_id	NUMERIC	software.publisher_id	software.publisher_id	software
software__sources	OBJECT	software.sources	software.sources	software
software__status	TEXT	software.status	software.status	software
software__updated_at	TEXT	software.updated_at	software.updated_at	software
software__user_count	NUMERIC	software.user_count	software.user_count	software
software__workspace_id	NUMERIC	software.workspace_id	software.workspace_id	software
source	TEXT	Source	The name of the Windsor connector returning the row
tickets__attachments	OBJECT	tickets.attachments	tickets.attachments	tickets
tickets__category	TEXT	tickets.category	tickets.category	tickets
tickets__cc_emails	OBJECT	tickets.cc_emails	tickets.cc_emails	tickets
tickets__created_at	TEXT	tickets.created_at	tickets.created_at	tickets
tickets__custom_fields	OBJECT	tickets.custom_fields	tickets.custom_fields	tickets
tickets__deleted	BOOLEAN	tickets.deleted	tickets.deleted	tickets
tickets__department_id	NUMERIC	tickets.department_id	tickets.department_id	tickets
tickets__description	TEXT	tickets.description	tickets.description	tickets
tickets__description_text	TEXT	tickets.description_text	tickets.description_text	tickets
tickets__due_by	TEXT	tickets.due_by	tickets.due_by	tickets
tickets__email	TEXT	tickets.email	tickets.email	tickets
tickets__email_config_id	NUMERIC	tickets.email_config_id	tickets.email_config_id	tickets
tickets__fr_due_by	TEXT	tickets.fr_due_by	tickets.fr_due_by	tickets
tickets__fr_escalated	BOOLEAN	tickets.fr_escalated	tickets.fr_escalated	tickets
tickets__fwd_emails	OBJECT	tickets.fwd_emails	tickets.fwd_emails	tickets
tickets__group_id	NUMERIC	tickets.group_id	tickets.group_id	tickets
tickets__id	NUMERIC	tickets.id	tickets.id	tickets
tickets__impact	NUMERIC	tickets.impact	tickets.impact	tickets
tickets__is_escalated	BOOLEAN	tickets.is_escalated	tickets.is_escalated	tickets
tickets__item_category	TEXT	tickets.item_category	tickets.item_category	tickets
tickets__name	TEXT	tickets.name	tickets.name	tickets
tickets__phone	TEXT	tickets.phone	tickets.phone	tickets
tickets__priority	NUMERIC	tickets.priority	tickets.priority	tickets
tickets__reply_cc_emails	OBJECT	tickets.reply_cc_emails	tickets.reply_cc_emails	tickets
tickets__requested_for_id	NUMERIC	tickets.requested_for_id	tickets.requested_for_id	tickets
tickets__requester_id	NUMERIC	tickets.requester_id	tickets.requester_id	tickets
tickets__responder_id	NUMERIC	tickets.responder_id	tickets.responder_id	tickets
tickets__source	NUMERIC	tickets.source	tickets.source	tickets
tickets__spam	BOOLEAN	tickets.spam	tickets.spam	tickets
tickets__status	NUMERIC	tickets.status	tickets.status	tickets
tickets__sub_category	TEXT	tickets.sub_category	tickets.sub_category	tickets
tickets__subject	TEXT	tickets.subject	tickets.subject	tickets
tickets__tags	OBJECT	tickets.tags	tickets.tags	tickets
tickets__to_emails	OBJECT	tickets.to_emails	tickets.to_emails	tickets
tickets__type	TEXT	tickets.type	tickets.type	tickets
tickets__updated_at	TEXT	tickets.updated_at	tickets.updated_at	tickets
tickets__urgency	NUMERIC	tickets.urgency	tickets.urgency	tickets
tickets__workspace_id	NUMERIC	tickets.workspace_id	tickets.workspace_id	tickets
today	DATE	Today	Today's date
vendors__address	OBJECT	vendors.address	vendors.address	vendors
vendors__contact_name	TEXT	vendors.contact_name	vendors.contact_name	vendors
vendors__created_at	TEXT	vendors.created_at	vendors.created_at	vendors
vendors__custom_fields	OBJECT	vendors.custom_fields	vendors.custom_fields	vendors
vendors__description	TEXT	vendors.description	vendors.description	vendors
vendors__email	TEXT	vendors.email	vendors.email	vendors
vendors__id	NUMERIC	vendors.id	vendors.id	vendors
vendors__mobile	NUMERIC	vendors.mobile	vendors.mobile	vendors
vendors__name	TEXT	vendors.name	vendors.name	vendors
vendors__phone	NUMERIC	vendors.phone	vendors.phone	vendors
vendors__primary_contact_id	NUMERIC	vendors.primary_contact_id	vendors.primary_contact_id	vendors
vendors__updated_at	TEXT	vendors.updated_at	vendors.updated_at	vendors