- Each member connects their own Salesforce login. There is no shared service account.
- Kepler queries Salesforce as that member. A member sees only the records that their Salesforce permissions allow.
- For Kepler admins: create the Salesforce app and save its credentials. You do this once.
- For members: connect your own Salesforce login.
Before you start
- A Kepler organization admin. Only admins can manage organization connectors.
- A Salesforce admin who can create an External Client App in Salesforce Setup.
- A production or Developer Edition Salesforce org. Kepler does not support Salesforce sandboxes.
- API access for each member. Each member’s Salesforce user needs the API Enabled permission.
Set up Salesforce for your organization
Open organization connectors
Open the Salesforce row
Create the Salesforce app
Kepler, and a contact email.Under API (Enable OAuth Settings), select Enable OAuth. Then do these steps:- Paste the callback URL from Kepler into Callback URL.
- Add the OAuth scope Manage user data via APIs (api).
- Add the OAuth scope Perform requests at any time (refresh_token, offline_access).
Save the app's credentials
Tell your members to connect
Connect your Salesforce login
Do these steps after a Kepler admin completes the setup for your organization.Open My connectors
Connect Salesforce
Ask a question in a chat
- “How many open opportunities do we have, by stage?”
- “Show the accounts that I own with no activity in the last 90 days.”
- “What are the notes from our last meeting with Acme Corp?”
What Kepler reads
Kepler reads the objects and fields that your Salesforce login can open. These include standard objects, such as accounts, contacts, and opportunities, and your organization’s custom objects. Kepler first reads the list of objects and their fields. Then it writes a read-only query for your question and runs it in Salesforce. Kepler cites the query result for the Salesforce values in an answer. Select a citation to see the query’s result. Kepler marks the cited value. Select Open in Salesforce to open the cited record. When the citation covers a count or more than one record, the object’s list opens. Each row also has a link to its record. A chat uses the Salesforce login of the member who started the chat. A shared link shows the answer text, and this text includes the Salesforce values that Kepler wrote in it. By default, viewers cannot open the Salesforce citations or the query results. To let viewers open them, select Allow viewers to open private documents in the link settings. See Share and export.Permissions
The Salesforce app asks for these OAuth scopes.api scope also permits changes in Salesforce. Kepler does not use that part of the scope. Kepler sends only read requests. These requests find the address of your org, describe objects, and run read-only queries.
Limits
- Rows. One query returns a maximum of 200 records, and fewer when the records are large. When more records match, Kepler reports the total count and can narrow the query.
- Long text. Kepler reads the first 4,000 characters of a long text value, such as a meeting note. A citation shows the first 2,000 characters.
- Daily API calls. Your Salesforce org has a daily limit of API calls, which all of its integrations share. Kepler stops its queries when all integrations together have used half of that limit. The other half stays free for your other integrations.
Change or remove the connection
- To disconnect your own login, open My connectors. Disconnect Salesforce.
- To use a different Salesforce app, open the Salesforce row on the Org connectors page. Select Change. Copy the callback URL. In Salesforce, create the new app with this callback URL and the same scopes. In Kepler, save the consumer key and the consumer secret of the new app. It is possible that members must connect Salesforce again after this change.
- To stop all access, block or delete the app in Salesforce. You must be a Salesforce admin.
Troubleshooting
The Salesforce row does not show a callback URL
The Salesforce row does not show a callback URL
My connectors or Salesforce is not shown in Settings
My connectors or Salesforce is not shown in Settings
Salesforce shows an error when a member signs in
Salesforce shows an error when a member signs in
Kepler says that Salesforce is not connected
Kepler says that Salesforce is not connected
Kepler says that the API is not enabled
Kepler says that the API is not enabled
Kepler cannot find an object or a field
Kepler cannot find an object or a field
Kepler says that the Salesforce API limit is reached
Kepler says that the Salesforce API limit is reached