Properties Pulled from Salesforce

Below are the fields we pull for each default object. We also pull every existing custom field for each of the objects.

Account

HockeyStack Property	Salesforce Field
company_id	Id
salesforce__company_id	Id
salesforce__parent_company_id	ParentId
company_name	Name
company_domain	Website
company_industry	Industry
company_type	Type
company_number_of_employees	NumberOfEmployees
company_annual_revenue	AnnualRevenue
company_country	BillingCountryCode, BillingCountry, BillingAddress.country
company_description	Description
company_source	AccountSource
company_owner_email	Owner.Email
company_owner_id	Owner.Id
company_owner_name	Owner.Name
company_owner_title	Owner.Title
company_owner_userrole_name	Owner.UserRole.Name

Lead

HockeyStack Property	Salesforce Field
contact_id	Id
contact_name	Name
contact_email	Email
contact_title	Title
contact_created_at	CreatedDate
contact_createddate	CreatedDate
contact_updateddate	LastModifiedDate
contact_source	LeadSource
contact_status	Status
contact_industry	Industry
contact_country	Country
contact_owner_email	Owner.Email
contact_owner_id	Owner.Id
contact_owner_name	Owner.Name
contact_owner_title	Owner.Title
contact_owner_userrole_name	Owner.UserRole.Name
company_id	(Derived from email domain and internal matching logic)
salesforce__company_id	(Derived from email domain and internal matching logic)
salesforce__is_converted	IsConverted
salesforce__contact_id	Id
lead_id	Id
salesforce__lead_id	Id
lead_name	Name
lead_title	Title
lead_email	Email
lead_created_at	CreatedDate
lead_source	LeadSource
lead_status	Status
lead_industry	Industry
lead_country	Country
lead_createddate	CreatedDate
lead_updateddate	LastModifiedDate
lead_company	Company
lead_converteddate	ConvertedDate
salesforce__lead_record_type_id	RecordType.Id
salesforce__lead_record_type_name	RecordType.Name
lead_owner_email	Owner.Email
lead_owner_id	Owner.Id
lead_owner_name	Owner.Name
lead_owner_title	Owner.Title
lead_owner_userrole_name	Owner.UserRole.Name

Opportunity

HockeyStack Property	Salesforce Field
deal_id	Id
deal_name	Name
deal_amount	Amount
deal_converted_amount	Deal converted according to a custom converted amount field
deal_close_date	CloseDate
deal_expected_revenue	ExpectedRevenue
deal_source	LeadSource
deal_probability	Probability
deal_stage	StageName
deal_type	Type
deal_createddate	CreatedDate
deal_updateddate	LastModifiedDate
deal_forecast_category	ForecastCategory
deal_forecast_category_name	ForecastCategoryName
currency	CurrencyIsoCode
deal_owner_email	Owner.Email
deal_owner_id	Owner.Id
deal_owner_name	Owner.Name
deal_owner_title	Owner.Title
deal_owner_userrole_name	Owner.UserRole.Name
deal_creator_email	CreatedBy.Email
deal_creator_id	CreatedBy.Id
deal_creator_name	CreatedBy.Name
deal_creator_title	CreatedBy.Title
deal_creator_userrole_name	CreatedBy.UserRole.Name
salesforce__opportunity_record_type_id	RecordType.Id
salesforce__opportunity_record_type_name	RecordType.Name

Opportunity Line Item

HockeyStack Property	Salesforce Field
deal_line_item_id	Id
deal_line_item_name	Name
deal_line_item_quantity	Quantity
deal_line_item_unit_price	UnitPrice
deal_line_item_total_price	TotalPrice
deal_line_item_discount	Discount
deal_product_id	Product2.Id
deal_product_name	Product2.Name
deal_id	Opportunity.Id
deal_name	Opportunity.Name
deal_amount	Opportunity.Amount
currency	CurrencyIsoCode
opportunitylineitem_createddate	CreatedDate
opportunitylineitem_updateddate	LastModifiedDate
opportunity_createddate	Opportunity.CreatedDate
opportunity_updateddate	Opportunity.LastModifiedDate
opportunity_closedate	Opportunity.CloseDate
opportunity_owner_email	Opportunity.Owner.Email
opportunity_owner_id	Opportunity.Owner.Id
opportunity_owner_name	Opportunity.Owner.Name
opportunity_owner_title	Opportunity.Owner.Title
opportunity_owner_userrole_name	Opportunity.Owner.UserRole.Name
record_type_email	RecordType.Email
record_type_id	RecordType.Id
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_type_userrole_name	RecordType.UserRole.Name
salesforce__opportunity_record_type_id	RecordType.Id
salesforce__opportunity_record_type_name	RecordType.Name

Campaign

HockeyStack Property	Salesforce Field
campaign_id	Id
campaign_name	Name
campaign_type	Type
campaign_status	Status
campaign_currency	CurrencyIsoCode
campaign_budget	BudgetedCost
campaign_actual_cost	ActualCost
campaign_expected_revenue	ExpectedRevenue
campaign_expected_response	ExpectedResponse
campaign_start_date	StartDate
campaign_end_date	EndDate
salesforce__campaign_record_type_id	RecordType.Id
salesforce__campaign_record_type_name	RecordType.Name
campaign_owner_id	Owner.Id
campaign_owner_email	Owner.Email
campaign_owner_name	Owner.Name
campaign_owner_title	Owner.Title
campaign_owner_userrole_name	Owner.UserRole.Name
record_type_id	RecordType.Id
record_type_email	RecordType.Email
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_type_userrole_name	RecordType.UserRole.Name

Campaign Member

HockeyStack Property	Salesforce Field
campaign_member_id	Id
campaign_member_responded	HasResponded
campaign_member_status	Status
campaign_member_firstrespondeddate	FirstRespondedDate
campaign_id	CampaignId
campaign_name	Campaign.Name
campaign_type	Campaign.Type
campaign_status	Campaign.Status
campaign_member_currency	CurrencyIsoCode
campaign_currency	Campaign.CurrencyIsoCode
campaign_member_createddate	CreatedDate
campaign_member_updateddate	LastModifiedDate
salesforce__campaignmember_record_type_id	RecordType.Id
salesforce__campaignmember_record_type_name	RecordType.Name
campaign_member_owner_id	LeadOrContactOwner.Id
campaign_member_owner_email	LeadOrContactOwner.Email
campaign_member_owner_name	LeadOrContactOwner.Name
campaign_member_owner_title	LeadOrContactOwner.Title
campaign_member_owner_userrole_name	LeadOrContactOwner.UserRole.Name
record_type_id	RecordType.Id
record_type_email	RecordType.Email
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_type_userrole_name	RecordType.UserRole.Name

Task

HockeyStack Property	Salesforce Field
task_id	Id
task_type	Type or TaskSubtype
task_subject	Subject
task_createddate	CreatedDate
task_activitydate	ActivityDate
task_completeddatetime	CompletedDateTime
task_status	Status
call_disposition (if type is Call)	CallDisposition
call_type (if type is Call)	CallType
call_subject (if type is Call)	Subject
email_subject (if type is Email)	Subject
email_body (if type is Email)	Description
task_owner_id	Owner.Id
task_owner_email	Owner.Email
task_owner_name	Owner.Name
task_owner_title	Owner.Title
task_owner_userrole_name	Owner.UserRole.Name
task_creator_id	CreatedBy.Id
task_creator_email	CreatedBy.Email
task_creator_name	CreatedBy.Name
task_creator_title	CreatedBy.Title
task_creator_userrole_name	CreatedBy.UserRole.Name
salesforce__task_record_type_id	RecordType.Id
salesforce__task_record_type_name	RecordType.Name
record_type_id	RecordType.Id
record_type_email	RecordType.Email
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_type_userrole_name	RecordType.UserRole.Name

Contact

HockeyStack Property	Salesforce Field
contact_id	Id
salesforce__contact_id	Id
contact_name	Name
contact_email	Email
contact_title	Title
contact_created_at	CreatedDate
contact_source	LeadSource
contact_country	MailingCountry
contact_createddate	CreatedDate
contact_updateddate	LastModifiedDate
contact_owner_email	Owner.Email
contact_owner_id	Owner.Id
contact_owner_name	Owner.Name
contact_owner_title	Owner.Title
contact_owner_userrole_name	Owner.UserRole.Name
company_id	AccountId
salesforce__contact_record_type_id	RecordType.Id
salesforce__contact_record_type_name	RecordType.Name
record_type_email	RecordType.Email
record_type_id	RecordType.Id
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_userrole_name	RecordType.UserRole.Name

Event

HockeyStack Property	Salesforce Field
event_id	Id
event_description	Description
event_duration	DurationInMinutes
event_type	Type
event_subtype	EventSubtype
event_location	Location
event_subject	Subject
event_createddate	CreatedDate
event_updateddate	LastModifiedDate
event_activitydate	ActivityDateTime
event_owner_id	Owner.Id
event_owner_email	Owner.Email
event_owner_name	Owner.Name
event_owner_title	Owner.Title
event_owner_userrole_name	Owner.UserRole.Name
event_creator_id	CreatedBy.Id
event_creator_email	CreatedBy.Email
event_creator_name	CreatedBy.Name
event_creator_title	CreatedBy.Title
event_creator_userrole_name	CreatedBy.UserRole.Name
record_type_id	RecordType.Id
record_type_email	RecordType.Email
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_type_userrole_name	RecordType.UserRole.Name
salesforce__event_record_type_id	RecordType.Id
salesforce__event_record_type_name	RecordType.Name

User

HockeyStack Property	Salesforce Field
owner_id	Id
owner_email	Email
owner_name	Name
owner_title	Title
owner_username	Username
owner_is_active	IsActive
salesforce__user_record_type_id	RecordType.Id
salesforce__user_record_type_name	RecordType.Name
record_type_id	RecordType.Id
record_type_email	RecordType.Email
record_type_name	RecordType.Name
record_type_title	RecordType.Title
record_type_userrole_name	RecordType.UserRole.Name