{"id":4241,"date":"2018-06-29T12:59:37","date_gmt":"2018-06-29T12:59:37","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4241"},"modified":"2021-12-27T20:33:01","modified_gmt":"2021-12-27T20:33:01","slug":"how-to-call-salesforce-rest-api-via-odbc-driver","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-call-salesforce-rest-api-via-odbc-driver\/","title":{"rendered":"How to call Salesforce REST API via ODBC driver"},"content":{"rendered":"

\"\"Introduction<\/span><\/h2>\n

Salesforce<\/a>\u00a0is a popular CRM tool that lets you manage your sales, contacts, products, and other useful things. In this tutorial, you will learn how to call Salesforce REST API via ODBC driver using\u00a0ZappySys JSON Driver<\/a>. You can also use \u00a0ZappySys Salesforce Driver<\/a> for salesforce data read \/ write but this article covers more more generic API calling usecase.<\/p>\n

You will find out how to register a Connected App<\/em> in Salesforce, set OAuth authentication and use it for data retrieval. We will cover a topic of how to load leads from Salesforce and use them virtually in any application which supports ODBC. We will not stop with that and touch a possibility of calling any method of any REST API-based Salesforce API; be it insert or simple retrieval.<\/p>\n

Prerequisites<\/span><\/h2>\n

Make sure you meet these requirements:<\/p>\n

    \n
  1. ZappySys ODBC PowerPack<\/a>\u00a0installed.<\/li>\n
  2. Have a registered, working Salesforce account.<\/li>\n<\/ol>\n

    <\/h2>\n

    Register Salesforce App (for OAuth)\u00a0<\/span><\/span><\/span><\/h2>\n
    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.\r\n\r\nOnce 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.\r\n\r\nSo let's get started.\r\n

    Register Salesforce App (OAuth)<\/h3>\r\n
      \r\n \t
    1. Login into your account and go to Setup<\/em> <\/strong>as shown below (click on gear icon at the top right corner):\r\n\"Accessing<\/li>\r\n \t
    2. Then in the search bar input \"app\" and open App Manager<\/em><\/strong>:\r\n\"Searching<\/li>\r\n \t
    3. Then click New Connected App<\/em><\/strong> to create a new OAuth App:\r\nNOTE:<\/strong> In some version, it may say New External Client App\r\n<\/strong><\/strong>\r\n

      Look for one of the following buttons:<\/p>\r\n\r\n