Contents
hide
Introduction
In this section, we will discuss how to register OAuth App to call Salesforce API using Client ID / Secret rather than using your User Id / Password.
Once you follow these steps below to register your Salesforce App (OAuth App), at the end you will get a Client ID (sometimes referred to as App Id) and Client Secret (or App Secret). These two pieces can be used later on to call Salesforce API using OAuth.
So let's get started.
Get Client Id, Client Secret - For New External Client App[/caption]
Enable Salesforce Client Credentials Grant (Run As)[/caption]
Register Salesforce App (OAuth)
- Login into your account and go to Setup as shown below (click on gear icon at the top right corner):

- Then in the search bar input "app" and open App Manager:

- Then click New Connected App to create a new OAuth App:
NOTE: In some version, it may say New External Client App
Look for one of the following buttons:
-
New Connected App (Classic name)
-
New External Client App (Lightning name)

-
- Give your App a name and:
- Enable OAuth Settings
- Set callback URL to following two URLs (one in each line)
https://login.salesforce.com/services/oauth2/success
https://zappysys.com/oauth
- Add an OAuth scope you want or simply add "Full access".
- Add "Perform requests on your behalf at any time (offline_token)" scope to get a refresh token so that you don't have to re-authenticate each time requesting an access token:

- Click "Save".
Get Client Id and Client Secret for Salesforce Connected App
Once App is created we need to find out App Id / Secret so we can use it for API calls.- Go to App Manager
- Find out recently created App and click View (click on the small arrow to the right)

- Once App page is loaded you can Copy Consumer Key and Consumer Secret (click on reveal to see). Also copy anyone Call back URL (We will need this for OAuth Connection > Advanced Tab > Call Back URL or Redirect URL property depending on which ZappySys Product / Driver you are using)

- That's it, you can now use these 3 pieces to ZappySys OAuth connection UI or on Salesforce Connection UI (new version with OAuth support). The above screenshot is showing where to enter these 3 pieces on New Salesforce Connection. For OAuth Connection redirect URL goes to Advanced Tab > Callback URL textbox.
Get Client Id and Secret for Salesforce External Client App
If you created a new App by clicking on the New External Client App button, then your App may not be visible in the App Manager Screen. In that case, find it below way. [caption id="attachment_11637" align="alignnone" width="1222"]
Get Client Id, Client Secret - For New External Client App[/caption]
Enable Client Credentials Grant (Non-Interactive Run-As)
If you like to enable Non-Interactive mode just like UserId / Password Authentication but without actually passing real UserId or Password on Connection UI then you can enable Client Credentials Flow as below. NOTE: Only the New version of ZappySys Salesforce Connection supports Client Credentials Grant. Version released after Nov 1, 2025 supports this grant type. [caption id="attachment_11639" align="alignnone" width="419"]
Enable Salesforce Client Credentials Grant (Run As)[/caption]
(OPTIONAL) Configure Salesforce OAuth refresh token validity
By default, Salesforce Refresh Token doesn't expire once you generate. If you like to change default behavior you can follow these steps.Using Salesforce Connection with OAuth App in SSIS / ODBC
Once you have Client ID / Secret you can use in the Salesforce Connection in SSIS Connector / ODBC Driver for salesforce like below (Only new version will have OAuth option)
Troubleshooting Known Issues
Let’s look at some common issues with Salesforce Connection and how to fix them.
OAuth Error: Missing Required Code Challange
When you click Generate Token button, you may get an error like the one below.
Solution
Here is how to fix it.
For Salesforce Connection UI: Go to Advanced Tab => Check Enable PKCE Code Verifier option
–OR–
For OAuth Connection UI: Go to OAuth2 Grant Options Tab => Check Enable Code Verifier Option









