Salesforce

Overview of the Salesforce integration.

The following documentation is for Salesforce v2.0.3.

Overview

Salesforce is the world's leading customer relationship management (CRM) platform for sales and marketing automation. This integration enables automated lead management, opportunity tracking, customer communication, and sales pipeline optimization. Enhance sales productivity and customer relationship management.

Setup

The following integrations need to be connected to your Kognitos workspace:

• Salesforce

Steps

Follow these steps to connect the integration in Kognitos:

1

Navigate

Using the left navigation menu, go to Integrations → Explore Integrations.

2

Find

Search for the integration and click on it.

3

Connect

Click on Connect to add a connection to the integration.

4

Configure

Add a name for the connection. You'll be prompted for authentication details if needed. Then, click on Connect.

Authentication

Use one of the following authentication methods to connect this integration in Kognitos. Each method has its own configuration requirements.

Connect using Consumer Key, Consumer Secret and Domain

Connect to Salesforce using client credentials OAuth flow.

Label	Description	Type
Consumer Key	The consumer key for authentication.	sensitive
Consumer Secret	The consumer secret for authentication.	sensitive
Domain	The domain of the Salesforce instance.	text

Connect using Username, Password, Security Token and Domain

Connects to a Salesforce instance using username, password, security token and domain.

Label	Description	Type
Username	The username for authentication.	text
Password	The password for authentication.	sensitive
Security Token	The security token for authentication.	sensitive
Domain	The domain of the Salesforce instance.	text

Connect using Username, Password and Security Token

Connects to a Salesforce instance using username, password and security token.

Label	Description	Type
Username	The username for authentication.	text
Password	The password for authentication.	sensitive
Security Token	The security token for authentication.	sensitive

Actions

The following actions are available in the Salesforce integration:

1. Create a report in salesforce

Creates a report in Salesforce.

2. Export a report as a excel

Exports a report as an Excel file.

3. Export a report as a table

Exports a report as a Pyarrow Table.

4. Retrieve some reports from salesforce

Retrieves reports from Salesforce.

5. Send an email in salesforce

Sends an email in Salesforce.

Concepts

Salesforce create report body

Information sent to Salesforce to create a report.

Field Name	Description	Type
report_metadata	The metadata of the report.	json

Salesforce report

A Salesforce report, modeled as the Salesforce Object (SObject)and defined as a set of data that meets certain criteria, displayed in an organized way. Specified here: https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_report.htm

Field Name	Description	Type
id	The ID of the report.	text
owner_id	The ID of the owner of the report.	text
name	The name of the report.	text
developer_name	The unique name of the object in the API.	text
description	The description of the report. Limit: 255 characters.	optional[text]
folder_name	The name of the folder that contains the report.	optional[text]
namespace_prefix	The namespace prefix of the report.	optional[text]
format	Indicates the format of the report. Can have one of these values: Tabular, Summary, Matrix, or Joined.	optional[text]
is_deleted	Indicates whether the report is deleted.	optional[boolean]
created_date	The date and time when the report was created.	optional[datetime]
created_by_id	The ID of the user who created the report.	optional[text]
last_modified_date	The date and time when the report was last modified.	optional[datetime]
last_modified_by_id	The ID of the user who last modified the report.	optional[text]
last_referenced_date	The date and time when the report was last referenced.	optional[datetime]
last_run_date	The date and time when the report was last run.	optional[datetime]
last_viewed_date	The date and time when the report was last viewed.	optional[datetime]