# 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 |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.hockeystack.com/integrations/crms/salesforce/properties-pulled-from-salesforce.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
