Salesforce

Interact with the Salesforce API using SQL Server

  • Install the SQLHTTP database on your SQL Server
  • Obtain an App ID, App Secret from developer.salesforce.com
  • Obtain a User Security Token using the top navigation bar go to your name > Setup > Personal Setup > My Personal Information > Reset My Security Token
  • You might also need to adjust your Salesforce app OAuth policies by setting Permitted Users to “All users may self-authorize” and relaxing IP restrictions
  • Create the stored procedures documented below
  • Execute the following SQL statement:

Stored Procedures:

Available API Calls:

s

IMPORTANT DISCLAIMER

CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.

USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.

USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.