Freshsales Connector Reference

108 metrics275 dimensions

Fields

The Freshsales connector exposes 383 fields (108 metrics, 275 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Freshsales Fields

Freshsales accounts fields

The accounts report of the Freshsales connector includes 60 fields.

Freshsales accounts fields (accounts__active_sales_sequences to accounts__parent_sales_account_id)

ID	Type	Name	Description
accounts__active_sales_sequences	TEXT	accounts.active_sales_sequences	accounts.active_sales_sequences
accounts__address	TEXT	accounts.address	accounts.address
accounts__annual_revenue	NUMERIC	accounts.annual_revenue	accounts.annual_revenue
accounts__avatar	TEXT	accounts.avatar	accounts.avatar
accounts__business_type_id	NUMERIC	accounts.business_type_id	accounts.business_type_id
accounts__city	CITY	accounts.city	accounts.city
accounts__completed_sales_sequences	TEXT	accounts.completed_sales_sequences	accounts.completed_sales_sequences
accounts__country	COUNTRY	accounts.country	accounts.country
accounts__created_at	DATE	accounts.created_at	accounts.created_at
accounts__custom_field	OBJECT	accounts.custom_field	accounts.custom_field
accounts__customer_fit	TEXT	accounts.customer_fit	accounts.customer_fit
accounts__display_name	TEXT	accounts.display_name	accounts.display_name
accounts__email	TEXT	accounts.email	accounts.email
accounts__emails	OBJECT	accounts.emails	accounts.emails
accounts__external_id	TEXT	accounts.external_id	accounts.external_id
accounts__facebook	TEXT	accounts.facebook	accounts.facebook
accounts__first_name	TEXT	accounts.first_name	accounts.first_name
accounts__id	TEXT	accounts.id	accounts.id
accounts__industry_type_id	NUMERIC	accounts.industry_type_id	accounts.industry_type_id
accounts__is_deleted	BOOLEAN	accounts.is_deleted	accounts.is_deleted
accounts__job_title	TEXT	accounts.job_title	accounts.job_title
accounts__keyword	TEXT	accounts.keyword	accounts.keyword
accounts__last_assigned_at	DATE	accounts.last_assigned_at	accounts.last_assigned_at
accounts__last_contacted	DATE	accounts.last_contacted	accounts.last_contacted
accounts__last_contacted_mode	TEXT	accounts.last_contacted_mode	accounts.last_contacted_mode
accounts__last_contacted_sales_activity_mode	TEXT	accounts.last_contacted_sales_activity_mode	accounts.last_contacted_sales_activity_mode
accounts__last_contacted_via_sales_activity	TEXT	accounts.last_contacted_via_sales_activity	accounts.last_contacted_via_sales_activity
accounts__last_name	TEXT	accounts.last_name	accounts.last_name
accounts__last_seen	DATE	accounts.last_seen	accounts.last_seen
accounts__lead_score	NUMERIC	accounts.lead_score	accounts.lead_score
accounts__linkedin	TEXT	accounts.linkedin	accounts.linkedin
accounts__links	OBJECT	accounts.links	accounts.links
accounts__medium	TEXT	accounts.medium	accounts.medium
accounts__mobile_number	TEXT	accounts.mobile_number	accounts.mobile_number
accounts__name	TEXT	accounts.name	accounts.name
accounts__number_of_employees	NUMERIC	accounts.number_of_employees	accounts.number_of_employees
accounts__open_deals_amount	TEXT	accounts.open_deals_amount	accounts.open_deals_amount
accounts__open_deals_count	NUMERIC	accounts.open_deals_count	accounts.open_deals_count
accounts__owner_id	NUMERIC	accounts.owner_id	accounts.owner_id
accounts__parent_sales_account_id	NUMERIC	accounts.parent_sales_account_id	accounts.parent_sales_account_id

Freshsales accounts fields (accountsphone to accountszipcode)

ID	Type	Name	Description
accounts__phone	TEXT	accounts.phone	accounts.phone
accounts__phone_numbers	OBJECT	accounts.phone_numbers	accounts.phone_numbers
accounts__recent_note	TEXT	accounts.recent_note	accounts.recent_note
accounts__state	TEXT	accounts.state	accounts.state
accounts__subscription_status	NUMERIC	accounts.subscription_status	accounts.subscription_status
accounts__subscription_types	TEXT	accounts.subscription_types	accounts.subscription_types
accounts__tags	OBJECT	accounts.tags	accounts.tags
accounts__team_user_ids	OBJECT	accounts.team_user_ids	accounts.team_user_ids
accounts__territory_id	NUMERIC	accounts.territory_id	accounts.territory_id
accounts__time_zone	TEXT	accounts.time_zone	accounts.time_zone
accounts__twitter	TEXT	accounts.twitter	accounts.twitter
accounts__updated_at	DATE	accounts.updated_at	accounts.updated_at
accounts__web_form_ids	OBJECT	accounts.web_form_ids	accounts.web_form_ids
accounts__website	TEXT	accounts.website	accounts.website
accounts__whatsapp_subscription_status	TEXT	accounts.whatsapp_subscription_status	accounts.whatsapp_subscription_status
accounts__won_deals_amount	TEXT	accounts.won_deals_amount	accounts.won_deals_amount
accounts__won_deals_count	NUMERIC	accounts.won_deals_count	accounts.won_deals_count
accounts__work_email	TEXT	accounts.work_email	accounts.work_email
accounts__work_number	TEXT	accounts.work_number	accounts.work_number
accounts__zipcode	TEXT	accounts.zipcode	accounts.zipcode

Freshsales completed_tasks fields

The completed_tasks report of the Freshsales connector includes 17 fields.

ID	Type	Name	Description
completed_tasks__completed_date	DATE	completed_tasks.completed_date	completed_tasks.completed_date
completed_tasks__created_at	DATE	completed_tasks.created_at	completed_tasks.created_at
completed_tasks__creater_id	NUMERIC	completed_tasks.creater_id	completed_tasks.creater_id
completed_tasks__description	TEXT	completed_tasks.description	completed_tasks.description
completed_tasks__due_date	DATE	completed_tasks.due_date	completed_tasks.due_date
completed_tasks__id	NUMERIC	completed_tasks.id	completed_tasks.id
completed_tasks__outcome_id	NUMERIC	completed_tasks.outcome_id	completed_tasks.outcome_id
completed_tasks__owner_id	NUMERIC	completed_tasks.owner_id	completed_tasks.owner_id
completed_tasks__Possible	TEXT	completed_tasks.Possible	completed_tasks.Possible
completed_tasks__status	NUMERIC	completed_tasks.status	completed_tasks.status
completed_tasks__targetable_id	NUMERIC	completed_tasks.targetable_id	completed_tasks.targetable_id
completed_tasks__targetable_type	TEXT	completed_tasks.targetable_type	completed_tasks.targetable_type
completed_tasks__targetables	OBJECT	completed_tasks.targetables	completed_tasks.targetables
completed_tasks__task_type_id	NUMERIC	completed_tasks.task_type_id	completed_tasks.task_type_id
completed_tasks__title	TEXT	completed_tasks.title	completed_tasks.title
completed_tasks__updated_at	DATE	completed_tasks.updated_at	completed_tasks.updated_at
completed_tasks__updater_id	NUMERIC	completed_tasks.updater_id	completed_tasks.updater_id

Freshsales contacts fields

The contacts report of the Freshsales connector includes 76 fields.

Freshsales contacts fields (contacts__active_sales_sequences to contacts__lead_score)

ID	Type	Name	Description
contacts__active_sales_sequences	TEXT	contacts.active_sales_sequences	contacts.active_sales_sequences
contacts__address	TEXT	contacts.address	contacts.address
contacts__avatar	TEXT	contacts.avatar	contacts.avatar
contacts__campaign_id	NUMERIC	contacts.campaign_id	contacts.campaign_id
contacts__city	CITY	contacts.city	contacts.city
contacts__completed_sales_sequences	TEXT	contacts.completed_sales_sequences	contacts.completed_sales_sequences
contacts__contact_status_id	NUMERIC	contacts.contact_status_id	contacts.contact_status_id
contacts__country	COUNTRY	contacts.country	contacts.country
contacts__created_at	DATE	contacts.created_at	contacts.created_at
contacts__custom_field	OBJECT	contacts.custom_field	contacts.custom_field
contacts__customer_fit	NUMERIC	contacts.customer_fit	contacts.customer_fit
contacts__display_name	TEXT	contacts.display_name	contacts.display_name
contacts__email	TEXT	contacts.email	contacts.email
contacts__emails	OBJECT	contacts.emails	contacts.emails
contacts__external_id	TEXT	contacts.external_id	contacts.external_id
contacts__facebook	TEXT	contacts.facebook	contacts.facebook
contacts__first_campaign	TEXT	contacts.first_campaign	contacts.first_campaign
contacts__first_medium	TEXT	contacts.first_medium	contacts.first_medium
contacts__first_name	TEXT	contacts.first_name	contacts.first_name
contacts__first_seen_chat	DATE	contacts.first_seen_chat	contacts.first_seen_chat
contacts__first_source	TEXT	contacts.first_source	contacts.first_source
contacts__id	NUMERIC	contacts.id	contacts.id
contacts__is_deleted	BOOLEAN	contacts.is_deleted	contacts.is_deleted
contacts__job_title	TEXT	contacts.job_title	contacts.job_title
contacts__keyword	TEXT	contacts.keyword	contacts.keyword
contacts__last_assigned_at	DATE	contacts.last_assigned_at	contacts.last_assigned_at
contacts__last_campaign	TEXT	contacts.last_campaign	contacts.last_campaign
contacts__last_contacted	DATE	contacts.last_contacted	contacts.last_contacted
contacts__last_contacted_mode	TEXT	contacts.last_contacted_mode	contacts.last_contacted_mode
contacts__last_contacted_sales_activity_mode	TEXT	contacts.last_contacted_sales_activity_mode	contacts.last_contacted_sales_activity_mode
contacts__last_contacted_via_sales_activity	TEXT	contacts.last_contacted_via_sales_activity	contacts.last_contacted_via_sales_activity
contacts__last_medium	TEXT	contacts.last_medium	contacts.last_medium
contacts__last_name	TEXT	contacts.last_name	contacts.last_name
contacts__last_seen	DATE	contacts.last_seen	contacts.last_seen
contacts__last_seen_chat	DATE	contacts.last_seen_chat	contacts.last_seen_chat
contacts__last_source	TEXT	contacts.last_source	contacts.last_source
contacts__latest_campaign	TEXT	contacts.latest_campaign	contacts.latest_campaign
contacts__latest_medium	TEXT	contacts.latest_medium	contacts.latest_medium
contacts__latest_source	TEXT	contacts.latest_source	contacts.latest_source
contacts__lead_score	NUMERIC	contacts.lead_score	contacts.lead_score

Freshsales contacts fields (contacts__lead_source_id to contacts__zipcode)

ID	Type	Name	Description
contacts__lead_source_id	NUMERIC	contacts.lead_source_id	contacts.lead_source_id
contacts__lifecycle_stage_id	NUMERIC	contacts.lifecycle_stage_id	contacts.lifecycle_stage_id
contacts__linkedin	TEXT	contacts.linkedin	contacts.linkedin
contacts__links	OBJECT	contacts.links	contacts.links
contacts__locale	TEXT	contacts.locale	contacts.locale
contacts__mcr_id	NUMERIC	contacts.mcr_id	contacts.mcr_id
contacts__medium	TEXT	contacts.medium	contacts.medium
contacts__mobile_number	TEXT	contacts.mobile_number	contacts.mobile_number
contacts__open_deals_amount	TEXT	contacts.open_deals_amount	contacts.open_deals_amount
contacts__open_deals_count	NUMERIC	contacts.open_deals_count	contacts.open_deals_count
contacts__other_unsubscription_reason	TEXT	contacts.other_unsubscription_reason	contacts.other_unsubscription_reason
contacts__owner_id	NUMERIC	contacts.owner_id	contacts.owner_id
contacts__phone_numbers	OBJECT	contacts.phone_numbers	contacts.phone_numbers
contacts__recent_note	TEXT	contacts.recent_note	contacts.recent_note
contacts__sales_account_id	NUMERIC	contacts.sales_account_id	contacts.sales_account_id
contacts__sales_accounts	OBJECT	contacts.sales_accounts	contacts.sales_accounts
contacts__sms_subscription_status	NUMERIC	contacts.sms_subscription_status	contacts.sms_subscription_status
contacts__state	TEXT	contacts.state	contacts.state
contacts__subscription_status	NUMERIC	contacts.subscription_status	contacts.subscription_status
contacts__subscription_types	TEXT	contacts.subscription_types	contacts.subscription_types
contacts__system_tags	OBJECT	contacts.system_tags	contacts.system_tags
contacts__tags	OBJECT	contacts.tags	contacts.tags
contacts__team_user_ids	TEXT	contacts.team_user_ids	contacts.team_user_ids
contacts__territory_id	NUMERIC	contacts.territory_id	contacts.territory_id
contacts__time_zone	TEXT	contacts.time_zone	contacts.time_zone
contacts__total_sessions	TEXT	contacts.total_sessions	contacts.total_sessions
contacts__twitter	TEXT	contacts.twitter	contacts.twitter
contacts__unsubscription_reason	TEXT	contacts.unsubscription_reason	contacts.unsubscription_reason
contacts__updated_at	DATE	contacts.updated_at	contacts.updated_at
contacts__web_form_ids	TEXT	contacts.web_form_ids	contacts.web_form_ids
contacts__whatsapp_subscription_status	NUMERIC	contacts.whatsapp_subscription_status	contacts.whatsapp_subscription_status
contacts__won_deals_amount	TEXT	contacts.won_deals_amount	contacts.won_deals_amount
contacts__won_deals_count	NUMERIC	contacts.won_deals_count	contacts.won_deals_count
contacts__work_email	TEXT	contacts.work_email	contacts.work_email
contacts__work_number	TEXT	contacts.work_number	contacts.work_number
contacts__zipcode	TEXT	contacts.zipcode	contacts.zipcode

Freshsales lost_deals fields

The lost_deals report of the Freshsales connector includes 48 fields.

Freshsales lost_deals fields (lost_deals__active_sales_sequences to lost_deals__rotten_days)

ID	Type	Name	Description
lost_deals__active_sales_sequences	TEXT	lost_deals.active_sales_sequences	lost_deals.active_sales_sequences
lost_deals__age	NUMERIC	lost_deals.age	lost_deals.age
lost_deals__amount	TEXT	lost_deals.amount	lost_deals.amount
lost_deals__avatar	TEXT	lost_deals.avatar	lost_deals.avatar
lost_deals__base_currency_amount	TEXT	lost_deals.base_currency_amount	lost_deals.base_currency_amount
lost_deals__campaign_id	NUMERIC	lost_deals.campaign_id	lost_deals.campaign_id
lost_deals__closed_date	DATE	lost_deals.closed_date	lost_deals.closed_date
lost_deals__collaboration	OBJECT	lost_deals.collaboration	lost_deals.collaboration
lost_deals__completed_sales_sequences	TEXT	lost_deals.completed_sales_sequences	lost_deals.completed_sales_sequences
lost_deals__created_at	DATE	lost_deals.created_at	lost_deals.created_at
lost_deals__currency_id	NUMERIC	lost_deals.currency_id	lost_deals.currency_id
lost_deals__custom_field	OBJECT	lost_deals.custom_field	lost_deals.custom_field
lost_deals__deal_payment_status_id	NUMERIC	lost_deals.deal_payment_status_id	lost_deals.deal_payment_status_id
lost_deals__deal_pipeline_id	NUMERIC	lost_deals.deal_pipeline_id	lost_deals.deal_pipeline_id
lost_deals__deal_prediction	NUMERIC	lost_deals.deal_prediction	lost_deals.deal_prediction
lost_deals__deal_prediction_last_updated_at	DATE	lost_deals.deal_prediction_last_updated_at	lost_deals.deal_prediction_last_updated_at
lost_deals__deal_product_id	NUMERIC	lost_deals.deal_product_id	lost_deals.deal_product_id
lost_deals__deal_reason_id	NUMERIC	lost_deals.deal_reason_id	lost_deals.deal_reason_id
lost_deals__deal_stage_id	NUMERIC	lost_deals.deal_stage_id	lost_deals.deal_stage_id
lost_deals__deal_type_id	NUMERIC	lost_deals.deal_type_id	lost_deals.deal_type_id
lost_deals__expected_close	TEXT	lost_deals.expected_close	lost_deals.expected_close
lost_deals__expected_deal_value	TEXT	lost_deals.expected_deal_value	lost_deals.expected_deal_value
lost_deals__fc_widget_collaboration	OBJECT	lost_deals.fc_widget_collaboration	lost_deals.fc_widget_collaboration
lost_deals__forecast_category	NUMERIC	lost_deals.forecast_category	lost_deals.forecast_category
lost_deals__freddy_forecast_metrics	TEXT	lost_deals.freddy_forecast_metrics	lost_deals.freddy_forecast_metrics
lost_deals__has_products	BOOLEAN	lost_deals.has_products	lost_deals.has_products
lost_deals__id	NUMERIC	lost_deals.id	lost_deals.id
lost_deals__is_deleted	BOOLEAN	lost_deals.is_deleted	lost_deals.is_deleted
lost_deals__last_assigned_at	DATE	lost_deals.last_assigned_at	lost_deals.last_assigned_at
lost_deals__last_contacted_sales_activity_mode	TEXT	lost_deals.last_contacted_sales_activity_mode	lost_deals.last_contacted_sales_activity_mode
lost_deals__last_contacted_via_sales_activity	TEXT	lost_deals.last_contacted_via_sales_activity	lost_deals.last_contacted_via_sales_activity
lost_deals__last_deal_prediction	TEXT	lost_deals.last_deal_prediction	lost_deals.last_deal_prediction
lost_deals__lead_source_id	NUMERIC	lost_deals.lead_source_id	lost_deals.lead_source_id
lost_deals__links	OBJECT	lost_deals.links	lost_deals.links
lost_deals__name	TEXT	lost_deals.name	lost_deals.name
lost_deals__owner_id	NUMERIC	lost_deals.owner_id	lost_deals.owner_id
lost_deals__probability	NUMERIC	lost_deals.probability	lost_deals.probability
lost_deals__products	TEXT	lost_deals.products	lost_deals.products
lost_deals__recent_note	TEXT	lost_deals.recent_note	lost_deals.recent_note
lost_deals__rotten_days	NUMERIC	lost_deals.rotten_days	lost_deals.rotten_days

Freshsales lost_deals fields (lost_deals__sales_account_id to lost_deals__web_form_id)

ID	Type	Name	Description
lost_deals__sales_account_id	NUMERIC	lost_deals.sales_account_id	lost_deals.sales_account_id
lost_deals__stage_updated_time	DATE	lost_deals.stage_updated_time	lost_deals.stage_updated_time
lost_deals__tags	OBJECT	lost_deals.tags	lost_deals.tags
lost_deals__team_user_ids	TEXT	lost_deals.team_user_ids	lost_deals.team_user_ids
lost_deals__territory_id	NUMERIC	lost_deals.territory_id	lost_deals.territory_id
lost_deals__upcoming_activities_time	TIMESTAMP	lost_deals.upcoming_activities_time	lost_deals.upcoming_activities_time
lost_deals__updated_at	DATE	lost_deals.updated_at	lost_deals.updated_at
lost_deals__web_form_id	NUMERIC	lost_deals.web_form_id	lost_deals.web_form_id

Freshsales open_deals fields

The open_deals report of the Freshsales connector includes 48 fields.

Freshsales open_deals fields (open_deals__active_sales_sequences to open_deals__rotten_days)

ID	Type	Name	Description
open_deals__active_sales_sequences	TEXT	open_deals.active_sales_sequences	open_deals.active_sales_sequences
open_deals__age	NUMERIC	open_deals.age	open_deals.age
open_deals__amount	TEXT	open_deals.amount	open_deals.amount
open_deals__avatar	TEXT	open_deals.avatar	open_deals.avatar
open_deals__base_currency_amount	TEXT	open_deals.base_currency_amount	open_deals.base_currency_amount
open_deals__campaign_id	NUMERIC	open_deals.campaign_id	open_deals.campaign_id
open_deals__closed_date	DATE	open_deals.closed_date	open_deals.closed_date
open_deals__collaboration	OBJECT	open_deals.collaboration	open_deals.collaboration
open_deals__completed_sales_sequences	TEXT	open_deals.completed_sales_sequences	open_deals.completed_sales_sequences
open_deals__created_at	DATE	open_deals.created_at	open_deals.created_at
open_deals__currency_id	NUMERIC	open_deals.currency_id	open_deals.currency_id
open_deals__custom_field	OBJECT	open_deals.custom_field	open_deals.custom_field
open_deals__deal_payment_status_id	NUMERIC	open_deals.deal_payment_status_id	open_deals.deal_payment_status_id
open_deals__deal_pipeline_id	NUMERIC	open_deals.deal_pipeline_id	open_deals.deal_pipeline_id
open_deals__deal_prediction	NUMERIC	open_deals.deal_prediction	open_deals.deal_prediction
open_deals__deal_prediction_last_updated_at	DATE	open_deals.deal_prediction_last_updated_at	open_deals.deal_prediction_last_updated_at
open_deals__deal_product_id	NUMERIC	open_deals.deal_product_id	open_deals.deal_product_id
open_deals__deal_reason_id	NUMERIC	open_deals.deal_reason_id	open_deals.deal_reason_id
open_deals__deal_stage_id	NUMERIC	open_deals.deal_stage_id	open_deals.deal_stage_id
open_deals__deal_type_id	NUMERIC	open_deals.deal_type_id	open_deals.deal_type_id
open_deals__expected_close	TEXT	open_deals.expected_close	open_deals.expected_close
open_deals__expected_deal_value	TEXT	open_deals.expected_deal_value	open_deals.expected_deal_value
open_deals__fc_widget_collaboration	OBJECT	open_deals.fc_widget_collaboration	open_deals.fc_widget_collaboration
open_deals__forecast_category	NUMERIC	open_deals.forecast_category	open_deals.forecast_category
open_deals__freddy_forecast_metrics	TEXT	open_deals.freddy_forecast_metrics	open_deals.freddy_forecast_metrics
open_deals__has_products	BOOLEAN	open_deals.has_products	open_deals.has_products
open_deals__id	NUMERIC	open_deals.id	open_deals.id
open_deals__is_deleted	BOOLEAN	open_deals.is_deleted	open_deals.is_deleted
open_deals__last_assigned_at	DATE	open_deals.last_assigned_at	open_deals.last_assigned_at
open_deals__last_contacted_sales_activity_mode	TEXT	open_deals.last_contacted_sales_activity_mode	open_deals.last_contacted_sales_activity_mode
open_deals__last_contacted_via_sales_activity	TEXT	open_deals.last_contacted_via_sales_activity	open_deals.last_contacted_via_sales_activity
open_deals__last_deal_prediction	TEXT	open_deals.last_deal_prediction	open_deals.last_deal_prediction
open_deals__lead_source_id	NUMERIC	open_deals.lead_source_id	open_deals.lead_source_id
open_deals__links	OBJECT	open_deals.links	open_deals.links
open_deals__name	TEXT	open_deals.name	open_deals.name
open_deals__owner_id	NUMERIC	open_deals.owner_id	open_deals.owner_id
open_deals__probability	NUMERIC	open_deals.probability	open_deals.probability
open_deals__products	TEXT	open_deals.products	open_deals.products
open_deals__recent_note	TEXT	open_deals.recent_note	open_deals.recent_note
open_deals__rotten_days	NUMERIC	open_deals.rotten_days	open_deals.rotten_days

Freshsales open_deals fields (open_deals__sales_account_id to open_deals__web_form_id)

ID	Type	Name	Description
open_deals__sales_account_id	NUMERIC	open_deals.sales_account_id	open_deals.sales_account_id
open_deals__stage_updated_time	DATE	open_deals.stage_updated_time	open_deals.stage_updated_time
open_deals__tags	OBJECT	open_deals.tags	open_deals.tags
open_deals__team_user_ids	TEXT	open_deals.team_user_ids	open_deals.team_user_ids
open_deals__territory_id	NUMERIC	open_deals.territory_id	open_deals.territory_id
open_deals__upcoming_activities_time	TIMESTAMP	open_deals.upcoming_activities_time	open_deals.upcoming_activities_time
open_deals__updated_at	DATE	open_deals.updated_at	open_deals.updated_at
open_deals__web_form_id	NUMERIC	open_deals.web_form_id	open_deals.web_form_id

Freshsales open_tasks fields

The open_tasks report of the Freshsales connector includes 17 fields.

ID	Type	Name	Description
open_tasks__completed_date	DATE	open_tasks.completed_date	open_tasks.completed_date
open_tasks__created_at	DATE	open_tasks.created_at	open_tasks.created_at
open_tasks__creater_id	NUMERIC	open_tasks.creater_id	open_tasks.creater_id
open_tasks__description	TEXT	open_tasks.description	open_tasks.description
open_tasks__due_date	DATE	open_tasks.due_date	open_tasks.due_date
open_tasks__id	NUMERIC	open_tasks.id	open_tasks.id
open_tasks__outcome_id	NUMERIC	open_tasks.outcome_id	open_tasks.outcome_id
open_tasks__owner_id	NUMERIC	open_tasks.owner_id	open_tasks.owner_id
open_tasks__Possible	TEXT	open_tasks.Possible	open_tasks.Possible
open_tasks__status	NUMERIC	open_tasks.status	open_tasks.status
open_tasks__targetable_id	NUMERIC	open_tasks.targetable_id	open_tasks.targetable_id
open_tasks__targetable_type	TEXT	open_tasks.targetable_type	open_tasks.targetable_type
open_tasks__targetables	OBJECT	open_tasks.targetables	open_tasks.targetables
open_tasks__task_type_id	NUMERIC	open_tasks.task_type_id	open_tasks.task_type_id
open_tasks__title	TEXT	open_tasks.title	open_tasks.title
open_tasks__updated_at	DATE	open_tasks.updated_at	open_tasks.updated_at
open_tasks__updater_id	NUMERIC	open_tasks.updater_id	open_tasks.updater_id

Freshsales past_appointments fields

The past_appointments report of the Freshsales connector includes 32 fields.

ID	Type	Name	Description
past_appointments__appointment_attendees_attributes	OBJECT	past_appointments.appointment_attendees_attributes	past_appointments.appointment_attendees_attributes
past_appointments__can_checkin	BOOLEAN	past_appointments.can_checkin	past_appointments.can_checkin
past_appointments__can_checkin_checkout	BOOLEAN	past_appointments.can_checkin_checkout	past_appointments.can_checkin_checkout
past_appointments__checkedin_at	DATE	past_appointments.checkedin_at	past_appointments.checkedin_at
past_appointments__checkedin_duration	TEXT	past_appointments.checkedin_duration	past_appointments.checkedin_duration
past_appointments__checkedout_at	DATE	past_appointments.checkedout_at	past_appointments.checkedout_at
past_appointments__checkedout_latitude	TEXT	past_appointments.checkedout_latitude	past_appointments.checkedout_latitude
past_appointments__checkedout_location	TEXT	past_appointments.checkedout_location	past_appointments.checkedout_location
past_appointments__checkedout_longitude	TEXT	past_appointments.checkedout_longitude	past_appointments.checkedout_longitude
past_appointments__conference_id	TEXT	past_appointments.conference_id	past_appointments.conference_id
past_appointments__created_at	DATE	past_appointments.created_at	past_appointments.created_at
past_appointments__creater_id	NUMERIC	past_appointments.creater_id	past_appointments.creater_id
past_appointments__date	DATE	past_appointments.date	past_appointments.date
past_appointments__description	TEXT	past_appointments.description	past_appointments.description
past_appointments__End	TEXT	past_appointments.End	past_appointments.End
past_appointments__end_date	DATE	past_appointments.end_date	past_appointments.end_date
past_appointments__from_date	DATE	past_appointments.from_date	past_appointments.from_date
past_appointments__id	NUMERIC	past_appointments.id	past_appointments.id
past_appointments__is_allday	BOOLEAN	past_appointments.is_allday	past_appointments.is_allday
past_appointments__latitude	TEXT	past_appointments.latitude	past_appointments.latitude
past_appointments__location	TEXT	past_appointments.location	past_appointments.location
past_appointments__longitude	TEXT	past_appointments.longitude	past_appointments.longitude
past_appointments__outcome_id	NUMERIC	past_appointments.outcome_id	past_appointments.outcome_id
past_appointments__Possible	TEXT	past_appointments.Possible	past_appointments.Possible
past_appointments__provider	TEXT	past_appointments.provider	past_appointments.provider
past_appointments__Start	TEXT	past_appointments.Start	past_appointments.Start
past_appointments__targetable_id	NUMERIC	past_appointments.targetable_id	past_appointments.targetable_id
past_appointments__targetable_type	TEXT	past_appointments.targetable_type	past_appointments.targetable_type
past_appointments__targetables	OBJECT	past_appointments.targetables	past_appointments.targetables
past_appointments__time_zone	TEXT	past_appointments.time_zone	past_appointments.time_zone
past_appointments__title	TEXT	past_appointments.title	past_appointments.title
past_appointments__updated_at	DATE	past_appointments.updated_at	past_appointments.updated_at

Freshsales upcoming_appointments fields

The upcoming_appointments report of the Freshsales connector includes 32 fields.

Freshsales won_deals fields

The won_deals report of the Freshsales connector includes 48 fields.

Freshsales won_deals fields (won_deals__active_sales_sequences to won_deals__rotten_days)

ID	Type	Name	Description
won_deals__active_sales_sequences	TEXT	won_deals.active_sales_sequences	won_deals.active_sales_sequences
won_deals__age	NUMERIC	won_deals.age	won_deals.age
won_deals__amount	TEXT	won_deals.amount	won_deals.amount
won_deals__avatar	TEXT	won_deals.avatar	won_deals.avatar
won_deals__base_currency_amount	TEXT	won_deals.base_currency_amount	won_deals.base_currency_amount
won_deals__campaign_id	NUMERIC	won_deals.campaign_id	won_deals.campaign_id
won_deals__closed_date	DATE	won_deals.closed_date	won_deals.closed_date
won_deals__collaboration	OBJECT	won_deals.collaboration	won_deals.collaboration
won_deals__completed_sales_sequences	TEXT	won_deals.completed_sales_sequences	won_deals.completed_sales_sequences
won_deals__created_at	DATE	won_deals.created_at	won_deals.created_at
won_deals__currency_id	NUMERIC	won_deals.currency_id	won_deals.currency_id
won_deals__custom_field	OBJECT	won_deals.custom_field	won_deals.custom_field
won_deals__deal_payment_status_id	NUMERIC	won_deals.deal_payment_status_id	won_deals.deal_payment_status_id
won_deals__deal_pipeline_id	NUMERIC	won_deals.deal_pipeline_id	won_deals.deal_pipeline_id
won_deals__deal_prediction	NUMERIC	won_deals.deal_prediction	won_deals.deal_prediction
won_deals__deal_prediction_last_updated_at	DATE	won_deals.deal_prediction_last_updated_at	won_deals.deal_prediction_last_updated_at
won_deals__deal_product_id	NUMERIC	won_deals.deal_product_id	won_deals.deal_product_id
won_deals__deal_reason_id	NUMERIC	won_deals.deal_reason_id	won_deals.deal_reason_id
won_deals__deal_stage_id	NUMERIC	won_deals.deal_stage_id	won_deals.deal_stage_id
won_deals__deal_type_id	NUMERIC	won_deals.deal_type_id	won_deals.deal_type_id
won_deals__expected_close	TEXT	won_deals.expected_close	won_deals.expected_close
won_deals__expected_deal_value	TEXT	won_deals.expected_deal_value	won_deals.expected_deal_value
won_deals__fc_widget_collaboration	OBJECT	won_deals.fc_widget_collaboration	won_deals.fc_widget_collaboration
won_deals__forecast_category	NUMERIC	won_deals.forecast_category	won_deals.forecast_category
won_deals__freddy_forecast_metrics	TEXT	won_deals.freddy_forecast_metrics	won_deals.freddy_forecast_metrics
won_deals__has_products	BOOLEAN	won_deals.has_products	won_deals.has_products
won_deals__id	NUMERIC	won_deals.id	won_deals.id
won_deals__is_deleted	BOOLEAN	won_deals.is_deleted	won_deals.is_deleted
won_deals__last_assigned_at	DATE	won_deals.last_assigned_at	won_deals.last_assigned_at
won_deals__last_contacted_sales_activity_mode	TEXT	won_deals.last_contacted_sales_activity_mode	won_deals.last_contacted_sales_activity_mode
won_deals__last_contacted_via_sales_activity	TEXT	won_deals.last_contacted_via_sales_activity	won_deals.last_contacted_via_sales_activity
won_deals__last_deal_prediction	TEXT	won_deals.last_deal_prediction	won_deals.last_deal_prediction
won_deals__lead_source_id	NUMERIC	won_deals.lead_source_id	won_deals.lead_source_id
won_deals__links	OBJECT	won_deals.links	won_deals.links
won_deals__name	TEXT	won_deals.name	won_deals.name
won_deals__owner_id	NUMERIC	won_deals.owner_id	won_deals.owner_id
won_deals__probability	NUMERIC	won_deals.probability	won_deals.probability
won_deals__products	TEXT	won_deals.products	won_deals.products
won_deals__recent_note	TEXT	won_deals.recent_note	won_deals.recent_note
won_deals__rotten_days	NUMERIC	won_deals.rotten_days	won_deals.rotten_days

Freshsales won_deals fields (won_deals__sales_account_id to won_deals__web_form_id)

ID	Type	Name	Description
won_deals__sales_account_id	NUMERIC	won_deals.sales_account_id	won_deals.sales_account_id
won_deals__stage_updated_time	DATE	won_deals.stage_updated_time	won_deals.stage_updated_time
won_deals__tags	OBJECT	won_deals.tags	won_deals.tags
won_deals__team_user_ids	TEXT	won_deals.team_user_ids	won_deals.team_user_ids
won_deals__territory_id	NUMERIC	won_deals.territory_id	won_deals.territory_id
won_deals__upcoming_activities_time	TIMESTAMP	won_deals.upcoming_activities_time	won_deals.upcoming_activities_time
won_deals__updated_at	DATE	won_deals.updated_at	won_deals.updated_at
won_deals__web_form_id	NUMERIC	won_deals.web_form_id	won_deals.web_form_id

Freshsales other fields

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

ID	Type	Name	Description
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
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date

ID	Type	Name	Description
upcoming_appointments__appointment_attendees_attributes	OBJECT	upcoming_appointments.appointment_attendees_attributes	upcoming_appointments.appointment_attendees_attributes
upcoming_appointments__can_checkin	BOOLEAN	upcoming_appointments.can_checkin	upcoming_appointments.can_checkin
upcoming_appointments__can_checkin_checkout	BOOLEAN	upcoming_appointments.can_checkin_checkout	upcoming_appointments.can_checkin_checkout
upcoming_appointments__checkedin_at	DATE	upcoming_appointments.checkedin_at	upcoming_appointments.checkedin_at
upcoming_appointments__checkedin_duration	TEXT	upcoming_appointments.checkedin_duration	upcoming_appointments.checkedin_duration
upcoming_appointments__checkedout_at	DATE	upcoming_appointments.checkedout_at	upcoming_appointments.checkedout_at
upcoming_appointments__checkedout_latitude	TEXT	upcoming_appointments.checkedout_latitude	upcoming_appointments.checkedout_latitude
upcoming_appointments__checkedout_location	TEXT	upcoming_appointments.checkedout_location	upcoming_appointments.checkedout_location
upcoming_appointments__checkedout_longitude	TEXT	upcoming_appointments.checkedout_longitude	upcoming_appointments.checkedout_longitude
upcoming_appointments__conference_id	TEXT	upcoming_appointments.conference_id	upcoming_appointments.conference_id
upcoming_appointments__created_at	DATE	upcoming_appointments.created_at	upcoming_appointments.created_at
upcoming_appointments__creater_id	NUMERIC	upcoming_appointments.creater_id	upcoming_appointments.creater_id
upcoming_appointments__date	DATE	upcoming_appointments.date	upcoming_appointments.date
upcoming_appointments__description	TEXT	upcoming_appointments.description	upcoming_appointments.description
upcoming_appointments__End	TEXT	upcoming_appointments.End	upcoming_appointments.End
upcoming_appointments__end_date	DATE	upcoming_appointments.end_date	upcoming_appointments.end_date
upcoming_appointments__from_date	DATE	upcoming_appointments.from_date	upcoming_appointments.from_date
upcoming_appointments__id	NUMERIC	upcoming_appointments.id	upcoming_appointments.id
upcoming_appointments__is_allday	BOOLEAN	upcoming_appointments.is_allday	upcoming_appointments.is_allday
upcoming_appointments__latitude	TEXT	upcoming_appointments.latitude	upcoming_appointments.latitude
upcoming_appointments__location	TEXT	upcoming_appointments.location	upcoming_appointments.location
upcoming_appointments__longitude	TEXT	upcoming_appointments.longitude	upcoming_appointments.longitude
upcoming_appointments__outcome_id	NUMERIC	upcoming_appointments.outcome_id	upcoming_appointments.outcome_id
upcoming_appointments__Possible	TEXT	upcoming_appointments.Possible	upcoming_appointments.Possible
upcoming_appointments__provider	TEXT	upcoming_appointments.provider	upcoming_appointments.provider
upcoming_appointments__Start	TEXT	upcoming_appointments.Start	upcoming_appointments.Start
upcoming_appointments__targetable_id	NUMERIC	upcoming_appointments.targetable_id	upcoming_appointments.targetable_id
upcoming_appointments__targetable_type	TEXT	upcoming_appointments.targetable_type	upcoming_appointments.targetable_type
upcoming_appointments__targetables	OBJECT	upcoming_appointments.targetables	upcoming_appointments.targetables
upcoming_appointments__time_zone	TEXT	upcoming_appointments.time_zone	upcoming_appointments.time_zone
upcoming_appointments__title	TEXT	upcoming_appointments.title	upcoming_appointments.title
upcoming_appointments__updated_at	DATE	upcoming_appointments.updated_at	upcoming_appointments.updated_at

API Connectors