Salesforce

The RevOS Salesforce Connector enables seamless data integration between Salesforce and RevOS. It supports both standard and custom Salesforce objects, allowing flexible synchronization through API-based extraction.

Prerequisites

Before setting up the connector, ensure you have:

  • A Salesforce account with API access (Enterprise edition or higher).
  • A dedicated Salesforce user with appropriate permissions (recommended but optional).
  • Admin privileges to authorize RevOS to connect with Salesforce.

Create a Dedicated Salesforce User (Optional, Recommended)

To ensure secure and controlled access to Salesforce data, it is recommended to create a separate user with a customized permission set. Follow these steps to configure a user with the necessary write access.

1. Creating a New User

  1. Log in to Salesforce as an administrator.
  1. Click the gear icon in the top-right corner and go to Setup.
  1. In the left navigation panel, navigate to Users > Users.
  1. Click New User and enter the required details, including first name, last name, alias, and email.
  1. The username and nickname will be auto-filled based on the provided email.
  1. Leave the Role field unspecified.
  1. Under User License, select Salesforce Platform.
  1. Choose Standard Platform User as the Profile.
  1. Decide whether to generate a password automatically and notify the user.
  1. Click Save to create the user.

2. Setting Up a Permission Set

  1. In the Setup menu, go to Users > Permission Sets.
  1. Click New to create a new permission set.
  1. Assign a descriptive name to the permission set (e.g., "RevOS Data Integration"). The API name will be auto-filled.
  1. Leave the License field set to –None–, then click Save.
  1. Once the permission set is created, navigate to Object Settings to define user permissions.
  1. Click on Object Settings.
  1. Select each object that should have write access (e.g., Accounts, Contacts, Opportunities).
  1. Click Edit, then enable all necessary permissions under Object Permissions.
  1. Click Save.
  1. Repeat the process for any other Salesforce objects that need access.

3. Assigning the Permission Set to the User

  1. Navigate back to the Permission Sets page.
  1. Locate the newly created permission set and click Manage Assignments.
  1. Click Add Assignments.
  1. Find and select the user created in Step 1.
  1. Click Assign to finalize the setup.
  1. The user will receive an email confirmation—log into the email account, verify the user, and set a password. Store the password securely.

Configuring the Salesforce Connector in RevOS

Once your Salesforce user is set up, follow these steps to configure the Salesforce Connector in RevOS:

Notion image
  1. In RevOS, go to the Integrations section.
  1. Select Salesforce as the data source.
  1. Enter a descriptive name for the connection.
  1. Click Authorize to grant RevOS access to Salesforce.
  1. Follow the authentication process to connect RevOS with your Salesforce account.

Configure Optional Settings

Notion image
  • Sandbox Mode: Enable this option if connecting to a Salesforce sandbox environment.
  • Start Date: Specify the earliest date for data synchronization in YYYY-MM-DD or YYYY-MM-DDTHH:mm:ssZ format. If left blank, RevOS will sync data from the past two years.
  • Use BULK API: Enable this option to force the use of Salesforce's Bulk API for improved performance when handling large datasets.
  • Stream Slice Step: Set the time window (ISO 8601 format) for slicing incremental sync requests (default: P30D for 30-day slices).

Filtering Salesforce Objects

To filter specific objects for synchronization:

Notion image
  1. Scroll to Filter Salesforce Objects and click Add.
  1. In the filter configuration popup:
      • Search Criteria: Choose a filter type (e.g., contains, equals).
      • Search Value: Enter the value to filter relevant Salesforce objects.
  1. Click Done to save the filter.
  1. Repeat the process to add multiple filters if needed.
Did this answer your question?
😞
😐
🤩

Last updated on March 17, 2025