# Salesforce (v2) Information note **Salesforce extraction is supported by Stitch** This integration is powered by [Singer's](https://www.singer.io/) Salesforce tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-salesforce). For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport). Information note **Keep up with the latest Salesforce updates** with the [Salesforce Integration Changelog](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce/changelog). ## Salesforce integration summary Stitch’s Salesforce integration replicates data from your Salesforce account. When setting up a Salesforce integration in Stitch, you can select one of the following Salesforce APIs to replicate your data: * [Salesforce Lightning Platform REST API (v61.0)](https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/intro_what_is_rest_api.htm) * [Salesforce Bulk API (v61.0)](https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_intro.htm) Each API has its own advantages and disadvantages, such as support for compound fields and specific objects. Learn more [in the setup guide](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#bulk-vs-rest-api). ## Salesforce feature snapshot A high-level look at Stitch's Salesforce (v2) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on August 17, 2023 | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Success icon

This version of the integration is available via the API.

Available | | **Singer GitHub repository** | [singer-io/tap-salesforce](https://github.com/singer-io/tap-salesforce) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Success icon

This feature is supported for this version of the integration.

Supported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported

Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | ## Connecting Salesforce ### Salesforce setup requirements To set up Salesforce in Stitch, you need: * **To verify your object access.** Stitch will only be able to access and replicate the objects that the user setting up the integration has access to. Before beginning, we recommend verifying that you have access to everything you want to replicate. * **To verify your API access.** To use Stitch’s Salesforce integration, your Salesforce account must have Web Service API access enabled. Some editions of Salesforce include Web Service API access while others don’t. Info about this feature can be found on [Salesforce’s plan details page](https://www.salesforce.com/editions-pricing/sales-cloud-b/) in the **Connect sales info to any app** section, located near the bottom of the page. Contact Salesforce support if you’re unsure about your Salesforce plan’s API access. ### Step 1: Set trusted IPs in Salesforce Depending on how your Salesforce instance is set up, you may need to whitelist Stitch’s IP addresses. In Salesforce, this is referred to as “setting trusted IPs”. Complete this step before proceeding with the rest of the setup, or you may encounter connection issues. * [Step 1.1: Verify your Stitch account’s data pipeline region](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#verify-stitch-account-region) * [Step 1.2: Set Stitch’s IP addresses as trusted IPs](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#set-trusted-ips) #### Step 1.1: Verify your Stitch account's data pipeline region The IP addresses you’ll whitelist depend on the [**Data pipeline region** your account is in](https://help.qlik.com/en-US/stitch/security/supported-data-pipeline-regions). 1. [Sign into your Stitch account](https://app.stitchdata.com/), if you haven’t already. 2. Click **User menu (your icon) > Edit User Settings** and locate the **Data pipeline region** section to verify your account’s region. 3. Locate the list of IP addresses for your region: * [North America region IP addresses](https://help.qlik.com/en-US/stitch/security/stitch-ip-addresses#north-america-ip-addresses) * [Europe region IP addresses](https://help.qlik.com/en-US/stitch/security/stitch-ip-addresses#europe-ip-addresses) Keep this list handy - you’ll need it in the next step. #### Step 1.2: Set Stitch's IP addresses as trusted IPs Next, you’ll add the IP addresses you retrieved in the [previous step](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#verify-stitch-account-region) to your Salesforce instance’s trusted IP list. [The instructions in this Salesforce article](https://help.salesforce.com/articleView?id=security_networkaccess.htm&type=0) will walk you through how to do this in Salesforce. **Note**: Because Stitch’s IPs are exact IP addresses and not ranges, the same IP address must be entered in the **Start IP Address** and **End IP Address** fields in Salesforce. ### Step 2: Add Salesforce as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **Salesforce** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch Salesforce” would create a schema called `stitch_salesforce` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. If the instance you want to connect to Stitch is a **sandbox**, check the **Connect to a Sandbox Environment** box. ### Step 3: Configure Stitch's Salesforce API Usage Usage of the Salesforce API depends on two factors: 1. The type of API used for data extraction (Bulk vs REST), and 2. The amount of standard API quota your account has. An API quota refers to the total number of API requests that can be made in a given period of time. Stitch’s Salesforce integration allows you to control both of these settings so you can replicate data as you see fit. * [Step 3.1: Select extraction API](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#bulk-vs-rest-api) * [Step 3.2: Define standard API quota usage limits](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#configure-standard-api-quota-usage) #### Step 3.1: Select extraction API If you’re not sure which API you should use, take a look at the brief comparison below. Consider how much data you need to replicate, how often you require updates, how many additional apps are connected to your Salesforce instance, and so on. Information note **Note**: The extraction API you select cannot be changed after the integration is saved. Once you’ve decided, click radio button next to the API you want to use. | | **REST API** | **Bulk API** | | --- | --- | --- | | **Good for replicating** | Small data sets, more frequently

**Note:** Due to the design of Salesforce’s REST API, tracking a large number of columns in a single object can lead to replication issues. See [this guide](https://help.qlik.com/en-US/stitch/troubleshooting/salesforce-replication-too-many-columns) for more info. | Large data sets, less frequently

While the Bulk API allows for a greater number of tracked fields, Salesforce only allows each batch to be 5MB. | | **API quota** | Total usage is calculated by your organization type, the type of licenses held, and the number of licenses.

Refer to [Salesforce’s documentation](https://developer.salesforce.com/docs/atlas.en-us.210.0.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_platform_api.htm) for more info. | **Limited to 10,000 batches per day,** regardless of the standard API quota.

Refer to [Salesforce’s documentation](https://developer.salesforce.com/docs/atlas.en-us.210.0.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_platform_bulkapi.htm) for more info. | | **Structure sync**

the Help icon

The first step in the replication process, where Stitch looks for changes to the structure of your data, such as new objects or fields. | Uses the REST API and standard API quota. | Uses the Bulk API, REST API and standard API quota. | | **Data extraction**

the Help icon

The second step in the replication process, where Stitch queries for and extracts data from a source. | Uses the REST API standard API quota. | Uses the Bulk API and Bulk API quota. Each query to an object uses one (1) batch, even if no data is replicated from the object.

If you have any other apps using the Salesforce API, you may consume your quota more quickly. | | **Compound fields**

the Help icon

A compound field is a field that is comprised of other fields. Ex: An address field made up of street, city, state, etc. | Supported | [Unsupported by the Bulk API](https://help.salesforce.com/articleView?id=000204592&type=1).

Tracking the individual fields that make up a compound field - such as `street`, `city`, `state`, for a compound `address` field - will yield the same data. | | **Unsupported objects**

the Help icon

Objects not available for replication through Stitch due to Salesforce API limitations. | The following objects require a querying strategy that Stitch doesn’t currently support. [Read more here](https://github.com/singer-io/tap-salesforce/blob/master/Blacklisting.md#query-restricted-objects).

Announcement
CollaborationGroupRecord
ContentDocumentLink
ContentFolderMember
DataStatistics
EntityParticle
FieldDefinition
FlexQueueItem
IdeaComment
OwnerChangeOptionInfo
PicklistValueInfo
PlatformAction
RelationshipDomain
RelationshipInfo
SearchLayout
SiteDetail
UserEntityAccess
UserFieldAccess
Vote

The following objects are incompatible with querying. [Read more here](https://github.com/singer-io/tap-salesforce/blob/master/Blacklisting.md#query-incompatible-objects).

Any *ChangeEvent object
ActivityHistory
AggregateResult
AttachedContentDocument
CombinedAttachment
ContentBody
EmailStatus
FeedLike
FeedTrackedChange
FeedSignal
FolderedContentDocument
ListViewChartInstance
LookedUpFromActivity
Name
NoteAndAttachment
OpenActivity
OutgoingEmail
OutgoingEmailRelation
OwnedContentDocument
ProcessInstanceHistory
UserRecordAccess

| **In addition to the objects listed in the REST API column**, the objects listed below are also unsupported by the Bulk API. [Read more here](https://github.com/singer-io/tap-salesforce/blob/master/Blacklisting.md#unsupported-objects).

AcceptedEventRelation
AssetTokenEvent
AttachedContentNote
CaseStatus
ContentFolderItem
ContractStatus
DeclinedEventRelation
EventWhoRelation
PartnerRole
QuoteTemplateRichTextData
RecentlyViewed
SolutionStatus
TaskPriority
TaskWhoRelation
TaskStatus
UndecidedEventRelation

| #### Step 3.2: Define standard API quota usage limits Next, you’ll define the percentage of your standard API quota Stitch is allowed to use. If these limits are reached, Stitch will pause replication and resume when additional quota becomes available. Information note **Note**: Even if you choose the Bulk API for extraction, Stitch still requires usage of Salesforce’s REST API to detect changes and additions to objects and fields. Before defining these limits, we recommend reviewing your overall API usage in Salesforce to ensure Stitch or other apps won’t be negatively impacted. This [Salesforce Salesforce topic](https://success.salesforce.com/answers?id=90630000000DOzAAAW) can help you locate your current API quota and usage. | | Description | Example | | --- | --- | --- | | **Max Percentage of

total standard API quota** | The percentage of your total API quota Stitch is allowed to use per 24 hour period.

**Note**: This includes API usage from other apps. | If set to **80%** and the quota is 10,000 calls 24 hour period:

10,000 x .8 = 8,000

Stitch will replicate data up until 8,000 calls are used across all your connected apps. | | **Max Percentage of

standard API quota per job** | The percentage of your total standard API quota Stitch is allowed to use per replication job. | If set to **10%** and the quota is 10,000 calls:

10,000 x .1 = 1,000

Stitch will use up to 1,000 calls per replication job. | Once you know what you want Stitch’s maximum allowed standard API percentages to be, enter them as whole numbers (ex: `80` for 80%) into their respective fields. ### Step 4: Define new field selection By default, when new fields are added to Salesforce objects, Stitch will automatically detect and begin replicating data from them. If you prefer to track new fields manually, uncheck the **Replicate new fields automatically** checkbox. **Note**: This setting cannot be changed after the integration is saved. Information note **Data for new fields in already-replicating tables** Data in new fields in already-replicating tables will only be available for records added or updated **after** the column is tracked, whether they’re tracked manually or automatically. **This is only applicable to tables using Key-based Incremental Replication.** To backfill columns - or get data for a new field into existing rows - you’ll need to queue a full re-replication of the table by resetting its Replication Key values on the **Table Settings** page. ### Step 5: Define the historical replication start date The Sync Historical Data setting defines the starting date for your Salesforce integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond Salesforce’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 6: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. Salesforce integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 7: Authorize Stitch to access Salesforce 1. Next, you’ll be prompted to sign into your Salesforce account. 2. A screen asking for authorization to Salesforce will display. **Note that Stitch will only ever read your data.** 3. Click **Allow.** 4. After the authorization process successfully completes, you’ll be redirected back to Stitch. 5. Click **All Done**. ### Step 8: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Salesforce integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. **Optional**: To define a table’s [Replication Method](https://help.qlik.com/en-US/stitch/replication/replication-methods), click **Table Settings** on the right side of the page. Whenever possible, Stitch will default to using [Key-based Incremental Replication](https://help.qlik.com/en-US/stitch/replication/replication-methods/key-based-incremental). In these cases, the table’s Replication Key will be automatically selected and cannot be changed. To change the table’s Replication Method: 1. Select the Replication Method you want the table to use. **Note**: Some tables can only be replicated using [Full Table Replication](https://help.qlik.com/en-US/stitch/replication/replication-methods/full-table). Key-based Incremental Replication will be greyed out when this is applicable. 2. Click **Update Settings**. 5. Repeat this process for all the tables and columns you want to replicate. 6. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up Salesforce, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## Salesforce table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 2** of this integration. This is the latest version of the Salesforce integration. Stitch currently supports the replication of the majority of Salesforce objects, with the exception of those listed in the [**Unsupported Objects** row of this table](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#bulk-vs-rest-api). To ensure we can provide you with up-to-date documentation, this section will only cover a few of the most popular tables Stitch’s Salesforce integration offers. See the [Salesforce Object Reference](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_list.htm) guide for info on objects not listed here, including the fields available in each object. ### Custom Salesforce object and field replication Stitch’s Salesforce integration supports the replication of custom objects and fields. Custom object and field names are appended with `__c` to make identification easier. For example: `AE_Assignment__c` or `Assignment_Group_Name__c` Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### account The `account` table contains info about the individual accounts (organizations and persons) involved with your business. This could be a customer, a competitor, a partner, and so on. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | systemModStamp | | **Useful links** | [Salesforce documentation](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_account.htm#! "Opens in new tab: Salesforce documentation")

[account schema on GitHub](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce "Opens in new tab: account schema on GitHub") | account table foreign keys | Join account with | on | | --- | --- | | [contact](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#contact) | ```
account.id = contact.accountId
```

```
account.ownerId = contact.ownerId
``` | | [lead](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#lead) | ```
account.id = lead.convertedAccountId
```

```
account.ownerId = lead.ownerId
``` | | [opportunity](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#opportunity) | ```
account.id = opportunity.accountId
```

```
account.ownerId = opportunity.ownerId
``` | | [user](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#user) | ```
account.id = user.accountId
```

```
account.ownerId = user.id
```

```
account.ownerId = user.delegatedApproverId
```

```
account.ownerId = user.managerId
``` | account table schema | **accountNumber**

STRING | | --- | | **accountSource**

STRING | | **annualRevenue**

NUMBER | | **billingAddress**

STRING | | **billingCity**

STRING | | **billingCountry**

STRING | | **billingCountryCode**

STRING | | **billingGeocodeAccuracy**

STRING | | **billingLatitude**

INTEGER | | **billingLongitude**

INTEGER | | **billingPostalCode**

STRING | | **billingState**

STRING | | **billingStateCode**

STRING | | **billingStreet**

STRING | | **cleanStatus**

STRING | | **connectionReceivedId**

STRING | | **description**

STRING | | **dunsNumber**

STRING | | **fax**

STRING | | **id**

STRING | | **industry**

STRING | | **isCustomerPortal**

BOOLEAN | | **isDeleted**

BOOLEAN | | **isPartner**

BOOLEAN | | **isPersonAccount**

BOOLEAN | | **jigsaw**

STRING | | **lastActivityDate**

DATE-TIME | | **lastReferenceDate**

DATE-TIME | | **lastViewedDate**

DATE-TIME | | **masterRecordId**

STRING | | **naicsCode**

STRING | | **naicsDescription**

STRING | | **name**

STRING | | **numberOfEmployees**

NUMBER | | **operatingHoursId**

STRING | | **ownerId**

STRING | | **ownership**

STRING | | **parentId**

STRING | | **phone**

STRING | | **photoUrl**

STRING | | **rating**

STRING | | **recordTypeId**

STRING | | **salutation**

STRING | | **shippingAddress**

STRING | | **shippingCity**

STRING | | **shippingCountry**

STRING | | **shippingCountryCode**

STRING | | **shippingGeocodeAccuracy**

STRING | | **shippingLatitude**

INTEGER | | **shippingLongitude**

INTEGER | | **shippingPostalCode**

STRING | | **shippingState**

STRING | | **shippingStateCode**

STRING | | **shippingStreet**

STRING | | **sic**

STRING | | **sicDesc**

STRING | | **site**

STRING | | **systemModStamp**

DATE-TIME | | **tickerSymbol**

STRING | | **tradeStyle**

STRING | | **type**

STRING | | **website**

STRING | | **yearStarted**

STRING | ### contact The `contact` table contains info about your contacts, who are individuals associated with accounts in your Salesforce instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | systemModStamp | | **Useful links** | [Salesforce documentation](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_contact.htm "Opens in new tab: Salesforce documentation")

[contact schema on GitHub](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce "Opens in new tab: contact schema on GitHub") | contact table foreign keys | Join contact with | on | | --- | --- | | [account](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#account) | ```
contact.accountId = account.id
```

```
contact.ownerId = account.ownerId
``` | | [lead](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#lead) | ```
contact.accountId = lead.convertedAccountId
```

```
contact.id = lead.convertedContactId
```

```
contact.ownerId = lead.ownerId
``` | | [opportunity](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#opportunity) | ```
contact.accountId = opportunity.accountId
```

```
contact.ownerId = opportunity.ownerId
``` | | [user](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#user) | ```
contact.accountId = user.accountId
```

```
contact.id = user.contactId
```

```
contact.ownerId = user.id
```

```
contact.ownerId = user.delegatedApproverId
```

```
contact.ownerId = user.managerId
``` | contact table schema | **accountId**

STRING | | --- | | **assistantName**

STRING | | **assistantPhone**

STRING | | **birthdate**

DATE | | **canAllowPortalSelfReg**

BOOLEAN | | **cleanStatus**

STRING | | **connectionReceivedId**

STRING | | **connectionSentId**

STRING | | **department**

STRING | | **description**

STRING | | **doNotCall**

BOOLEAN | | **email**

STRING | | **emailBouncedDate**

DATE-TIME | | **emailBouncedReason**

STRING | | **fax**

STRING | | **firstName**

STRING | | **hasOptedOutOfEmail**

BOOLEAN | | **hasOptedOutOfFax**

BOOLEAN | | **homePhone**

STRING | | **id**

STRING | | **isDeleted**

BOOLEAN | | **isEmailBounced**

BOOLEAN | | **isPersonAccount**

BOOLEAN | | **jigsaw**

STRING | | **lastActivityDate**

DATE-TIME | | **lastName**

STRING | | **lastReferenceDate**

DATE-TIME | | **lastViewedDate**

DATE-TIME | | **leadSource**

STRING | | **mailingAddress**

STRING | | **mailingCity**

STRING | | **mailingCountry**

STRING | | **mailingCountryCode**

STRING | | **mailingGeocodeAccuracy**

STRING | | **mailingLatitude**

INTEGER | | **mailingLongitude**

INTEGER | | **mailingPostalCode**

STRING | | **mailingState**

STRING | | **mailingStateCode**

STRING | | **mailingStreet**

STRING | | **masterRecordId**

STRING | | **middleName**

STRING | | **mobilePhone**

STRING | | **name**

STRING | | **otherAddress**

STRING | | **otherCity**

STRING | | **otherCountry**

STRING | | **otherCountryCode**

STRING | | **otherGeocodeAccuracy**

STRING | | **otherLatitude**

INTEGER | | **otherLongitude**

INTEGER | | **otherPhone**

STRING | | **otherPostalCode**

STRING | | **otherState**

STRING | | **otherStateCode**

STRING | | **otherStreet**

STRING | | **ownerId**

STRING | | **phone**

STRING | | **photoUrl**

STRING | | **recordTypeId**

STRING | | **reportsToId**

STRING | | **salutation**

STRING | | **suffix**

STRING | | **systemModStamp**

DATE-TIME | | **title**

STRING | ### lead The `lead` table contains info about your leads, who are prospects or potential Opportunities. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | systemModStamp | | **Useful links** | [Salesforce documentation](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_lead.htm "Opens in new tab: Salesforce documentation")

[lead schema on GitHub](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce "Opens in new tab: lead schema on GitHub") | lead table foreign keys | Join lead with | on | | --- | --- | | [account](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#account) | ```
lead.convertedAccountId = account.id
```

```
lead.ownerId = account.ownerId
``` | | [contact](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#contact) | ```
lead.convertedAccountId = contact.accountId
```

```
lead.convertedContactId = contact.id
```

```
lead.ownerId = contact.ownerId
``` | | [opportunity](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#opportunity) | ```
lead.convertedAccountId = opportunity.accountId
```

```
lead.convertedOpportunityId = opportunity.id
```

```
lead.ownerId = opportunity.ownerId
``` | | [user](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#user) | ```
lead.convertedAccountId = user.accountId
```

```
lead.convertedContactId = user.contactId
```

```
lead.ownerId = user.id
```

```
lead.ownerId = user.delegatedApproverId
```

```
lead.ownerId = user.managerId
``` | lead table schema | **PostalCode**

STRING | | --- | | **address**

STRING | | **annualRevenue**

NUMBER | | **city**

STRING | | **cleanStatus**

STRING | | **company**

STRING | | **companyDunsNumber**

STRING | | **connectionReceivedId**

STRING | | **convertedAccountId**

STRING | | **convertedContactId**

STRING | | **convertedDate**

DATE-TIME | | **convertedOpportunityId**

STRING | | **country**

STRING | | **countryCode**

STRING | | **currencyIsoCode**

STRING | | **description**

STRING | | **division**

STRING | | **email**

STRING | | **emailBouncedDate**

DATE-TIME | | **emailBouncedReason**

STRING | | **fax**

STRING | | **firstName**

STRING | | **geocodeAccuracy**

STRING | | **hasOptedOutOfEmail**

BOOLEAN | | **id**

STRING | | **industry**

STRING | | **isConverted**

BOOLEAN | | **isDeleted**

BOOLEAN | | **isUnreadByOwner**

BOOLEAN | | **jigsaw**

STRING | | **lastActivityDate**

DATE-TIME | | **lastName**

STRING | | **lastReferenceDate**

DATE-TIME | | **lastViewedDate**

DATE-TIME | | **latitude**

INTEGER | | **leadSource**

STRING | | **longitude**

INTEGER | | **masterRecordId**

STRING | | **middleName**

STRING | | **mobilePhone**

STRING | | **name**

STRING | | **numberOfEmployees**

INTEGER | | **ownerId**

STRING | | **partnerAccountId**

STRING | | **phone**

STRING | | **photoUrl**

STRING | | **rating**

STRING | | **recordTypeId**

STRING | | **salutation**

STRING | | **scoreIntelligenceId**

STRING | | **state**

STRING | | **stateCode**

STRING | | **status**

STRING | | **street**

STRING | | **suffix**

STRING | | **systemModStamp**

DATE-TIME | | **title**

STRING | | **website**

STRING | ### opportunity The `opportunity` table contains info about your opportunities, which are sales or pending deals. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | systemModStamp | | **Useful links** | [Salesforce documentation](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_opportunity.htm "Opens in new tab: Salesforce documentation")

[opportunity schema on GitHub](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce "Opens in new tab: opportunity schema on GitHub") | opportunity table foreign keys | Join opportunity with | on | | --- | --- | | [account](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#account) | ```
opportunity.accountId = account.id
```

```
opportunity.ownerId = account.ownerId
``` | | [contact](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#contact) | ```
opportunity.accountId = contact.accountId
```

```
opportunity.ownerId = contact.ownerId
``` | | [lead](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#lead) | ```
opportunity.accountId = lead.convertedAccountId
```

```
opportunity.id = lead.convertedOpportunityId
```

```
opportunity.ownerId = lead.ownerId
``` | | [user](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#user) | ```
opportunity.accountId = user.accountId
```

```
opportunity.ownerId = user.id
```

```
opportunity.ownerId = user.delegatedApproverId
```

```
opportunity.ownerId = user.managerId
``` | opportunity table schema | **accountId**

STRING | | --- | | **amount**

NUMBER | | **campaignId**

STRING | | **closeDate**

DATE-TIME | | **connectionReceivedId**

STRING | | **connectionSentId**

STRING | | **currencyIsoCode**

STRING | | **description**

STRING | | **expectedRevenue**

NUMBER | | **fiscal**

STRING | | **fiscalQuarter**

INTEGER | | **fiscalYear**

INTEGER | | **forecastCategory**

STRING | | **forecastCategoryName**

STRING | | **hasOpenActivity**

BOOLEAN | | **hasOpportunityLineItem**

BOOLEAN | | **hasOverdueTask**

BOOLEAN | | **id**

STRING | | **isClosed**

BOOLEAN | | **isDeleted**

BOOLEAN | | **isExcludedFromTerritory2Filter**

BOOLEAN | | **isSplit**

BOOLEAN | | **isWon**

BOOLEAN | | **lastActivityDate**

DATE-TIME | | **lastReferenceDate**

DATE-TIME | | **lastViewedDate**

DATE-TIME | | **leadSource**

STRING | | **name**

STRING | | **nextStep**

STRING | | **ownerId**

STRING | | **pricebook2Id**

STRING | | **pricebookId**

STRING | | **probability**

INTEGER | | **recordTypeId**

STRING | | **stageName**

STRING | | **syncedQuoteId**

STRING | | **systemModStamp**

DATE-TIME | | **territory2Id**

STRING | | **totalOpportunityQuantity**

NUMBER | | **type**

STRING | ### user The `user` table contains info about the users in your organization. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | systemModStamp | | **Useful links** | [Salesforce documentation](https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_user.htm "Opens in new tab: Salesforce documentation")

[user schema on GitHub](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce "Opens in new tab: user schema on GitHub") | user table foreign keys | Join user with | on | | --- | --- | | [account](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#account) | ```
user.accountId = account.id
```

```
user.id = account.ownerId
```

```
user.delegatedApproverId = account.ownerId
```

```
user.managerId = account.ownerId
``` | | [contact](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#contact) | ```
user.accountId = contact.accountId
```

```
user.contactId = contact.id
```

```
user.id = contact.ownerId
```

```
user.delegatedApproverId = contact.ownerId
```

```
user.managerId = contact.ownerId
``` | | [lead](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#lead) | ```
user.accountId = lead.convertedAccountId
```

```
user.contactId = lead.convertedContactId
```

```
user.id = lead.ownerId
```

```
user.delegatedApproverId = lead.ownerId
```

```
user.managerId = lead.ownerId
``` | | [opportunity](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce#opportunity) | ```
user.accountId = opportunity.accountId
```

```
user.id = opportunity.ownerId
```

```
user.delegatedApproverId = opportunity.ownerId
```

```
user.managerId = opportunity.ownerId
``` | user table schema | **aboutMe**

STRING | | --- | | **accountId**

STRING | | **address**

STRING | | **alias**

STRING | | **badgeText**

STRING | | **bannerPhotoUrl**

STRING | | **callCenterId**

STRING | | **city**

STRING | | **communityNickname**

STRING | | **companyName**

STRING | | **contactId**

STRING | | **country**

STRING | | **countryCode**

STRING | | **defaultCurrencyIsoCode**

STRING | | **defaultDivision**

STRING | | **defaultGroupNotificationFrequency**

STRING | | **delegatedApproverId**

STRING | | **department**

STRING | | **digestFrequency**

STRING | | **division**

STRING | | **email**

STRING | | **emailEncodingKey**

STRING | | **emailPreferencesAutoBcc**

BOOLEAN | | **employeeNumber**

STRING | | **extension**

STRING | | **fax**

STRING | | **federationIdentifier**

STRING | | **firstName**

STRING | | **forecastEnabled**

BOOLEAN | | **fullPhotoUrl**

STRING | | **id**

STRING | | **isActive**

BOOLEAN | | **isPortalEnabled**

BOOLEAN | | **isPortalSelfRegistered**

BOOLEAN | | **isPrmSuperUser**

BOOLEAN | | **isProfilePhotoActive**

BOOLEAN | | **jigsawImportLimitOverride**

INTEGER | | **languageLocaleKey**

STRING | | **lastLoginDate**

DATE-TIME | | **lastName**

STRING | | **lastReferenceDate**

DATE-TIME | | **lastViewedDate**

DATE-TIME | | **latitude**

INTEGER | | **localeSidKey**

STRING | | **longitude**

INTEGER | | **manager**

STRING | | **managerId**

STRING | | **mediumBannerPhotoUrl**

STRING | | **middleName**

STRING | | **mobilePhone**

STRING | | **name**

STRING | | **offlineTrialExpirationDate**

DATE-TIME | | **phone**

STRING | | **portalRole**

STRING | | **postalCode**

STRING | | **profileId**

STRING | | **receivesAdminInfoEmails**

BOOLEAN | | **receivesInfoEmails**

BOOLEAN | | **senderEmail**

STRING | | **senderName**

STRING | | **signature**

STRING | | **smallBannerPhotoUrl**

STRING | | **smallPhotoUrl**

STRING | | **state**

STRING | | **stateCode**

STRING | | **street**

STRING | | **suffix**

STRING | | **systemModStamp**

DATE-TIME | | **timeZoneSidKey**

STRING | | **title**

STRING | | **userPermissionsCallCenterAutoLogin**

BOOLEAN | | **userPermissionsChatterAnswersUser**

BOOLEAN | | **userPermissionsInteractionUser**

BOOLEAN | | **userPermissionsJigsawProspectingUser**

BOOLEAN | | **userPermissionsKnowledgeUser**

BOOLEAN | | **userPermissionsLiveAgentUser**

BOOLEAN | | **userPermissionsMarketingUser**

BOOLEAN | | **userPermissionsMobileUser**

BOOLEAN | | **userPermissionsOfflineUser**

BOOLEAN | | **userPermissionsSFContentUser**

BOOLEAN | | **userPermissionsSiteforceContributorUser**

BOOLEAN | | **userPermissionsSiteforcePublisherUser**

BOOLEAN | | **userPermissionsSupportUser**

BOOLEAN | | **userPermissionsWorkDotComeUserFeature**

BOOLEAN | | **userPreferencesAcitivityRemindersPopup**

BOOLEAN | | **userPreferencesApexPagesDeveloperMode**

BOOLEAN | | **userPreferencesContentEmailAsAndWhen**

BOOLEAN | | **userPreferencesContentNoEmail**

BOOLEAN | | **userPreferencesDisCommentAfterLikeEmail**

BOOLEAN | | **userPreferencesDisMentionsCommentEmail**

BOOLEAN | | **userPreferencesDisProfPostCommentEmail**

BOOLEAN | | **userPreferencesDisableAllFeedsEmail**

BOOLEAN | | **userPreferencesDisableBookmarkEmail**

BOOLEAN | | **userPreferencesDisableChangeCommentEmail**

BOOLEAN | | **userPreferencesDisableEndorsementEmail**

BOOLEAN | | **userPreferencesDisableFeedbackEmail**

BOOLEAN | | **userPreferencesDisableFileShareNotificationsForApi**

BOOLEAN | | **userPreferencesDisableFollowersEmail**

BOOLEAN | | **userPreferencesDisableLaterCommentEmail**

BOOLEAN | | **userPreferencesDisableLikeEmail**

BOOLEAN | | **userPreferencesDisableMentionsPostEmail**

BOOLEAN | | **userPreferencesDisableMessageEmail**

BOOLEAN | | **userPreferencesDisableProfilePostEmail**

BOOLEAN | | **userPreferencesDisableRewardEmail**

BOOLEAN | | **userPreferencesDisableSharePostEmail**

BOOLEAN | | **userPreferencesDisableWorkEmail**

BOOLEAN | | **userPreferencesEnableAutoSubForFeeds**

BOOLEAN | | **userPreferencesEventRemindersCheckboxDefault**

BOOLEAN | | **userPreferencesHideBiggerPhotoCallout**

BOOLEAN | | **userPreferencesHideCSNDesktopTask**

BOOLEAN | | **userPreferencesHideCSNGetChatterMobileTask**

BOOLEAN | | **userPreferencesHideChatterOnboardingSplash**

BOOLEAN | | **userPreferencesHideHideSecondChatterOnboardingSplash**

BOOLEAN | | **userPreferencesHideS1BrowserUI**

BOOLEAN | | **userPreferencesHideSfxWelcomeMat**

BOOLEAN | | **userPreferencesJigsawListUser**

BOOLEAN | | **userPreferencesLightningExperiencePreferred**

BOOLEAN | | **userPreferencesPathAssistantCollapsed**

BOOLEAN | | **userPreferencesReminderSoundOff**

BOOLEAN | | **userPreferencesShowCityToExternalUsers**

BOOLEAN | | **userPreferencesShowCityToGuestUsers**

BOOLEAN | | **userPreferencesShowCountryToExternalUsers**

BOOLEAN | | **userPreferencesShowCountryToGuestUsers**

BOOLEAN | | **userPreferencesShowEmailToExternalUsers**

BOOLEAN | | **userPreferencesShowEmailToGuestUsers**

BOOLEAN | | **userPreferencesShowFaxToExternalUsers**

BOOLEAN | | **userPreferencesShowFaxToGuestUsers**

BOOLEAN | | **userPreferencesShowManagerToExternalUsers**

BOOLEAN | | **userPreferencesShowManagerToGuestUsers**

BOOLEAN | | **userPreferencesShowMobilePhoneToExternalUsers**

BOOLEAN | | **userPreferencesShowMobilePhoneToGuestUsers**

BOOLEAN | | **userPreferencesShowPostalCodeToExternalUsers**

BOOLEAN | | **userPreferencesShowPostalCodeToGuestUsers**

BOOLEAN | | **userPreferencesShowProfilePicToExternalUsers**

BOOLEAN | | **userPreferencesShowProfilePicToGuestUsers**

BOOLEAN | | **userPreferencesShowStateToExternalUsers**

BOOLEAN | | **userPreferencesShowStateToGuestUsers**

BOOLEAN | | **userPreferencesShowStreetAddressToExternalUsers**

BOOLEAN | | **userPreferencesShowStreetAddressToGuestUsers**

BOOLEAN | | **userPreferencesShowTitleToExternalUsers**

BOOLEAN | | **userPreferencesShowTitleToGuestUsers**

BOOLEAN | | **userPreferencesShowWorkPhoneToExternalUsers**

BOOLEAN | | **userPreferencesShowWorkPhoneToGuestUsers**

BOOLEAN | | **userPreferencesSortFeedByComment**

BOOLEAN | | **userPreferencesTaskRemindersCheckboxDefault**

BOOLEAN | | **userRoleId**

STRING | | **userType**

STRING | | **username**

STRING |