{"id":8010,"date":"2019-09-14T08:49:27","date_gmt":"2019-09-14T08:49:27","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=8010"},"modified":"2019-10-11T17:11:32","modified_gmt":"2019-10-11T17:11:32","slug":"make-paypal-api-call-odbc-sql-server","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/make-paypal-api-call-odbc-sql-server\/","title":{"rendered":"How to Make PayPal API Call in ODBC \/ SQL Server (T-SQL)"},"content":{"rendered":"

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

\"PayPal\"<\/a>In our previous article we saw how to call PayPal API in SSIS<\/a>. Now in this article, we will see How to Make PayPal API Call in ODBC from the SQL Server.\u00a0This blog mainly focuses on ODBC approach but steps mentioned to call PayPal APIs can be useful for any developer regardless of which programming language or tool set you use. We will also see\u00a0How to send basic Authorization header along with body in OAuth2.<\/p>\n

We will go through the steps to Create PayPal Order from MS SQL Server.<\/p>\n

In nutshell,\u00a0this post will focus on how to make PayPal API Call using ODBC Driver.<\/p>\n

 <\/p>\n

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

Before we perform the steps listed in this article, you will need to make sure the following prerequisites are met:<\/p>\n

    \n
  1. A first requirement, make sure that Microsoft Access installed<\/li>\n
  2. Make sure to have\u00a0ZappySys ODBC PowerPack<\/a>\u00a0installed.<\/li>\n
  3. Credentials of PayPal API. Click\u00a0here<\/a>\u00a0to create API.<\/li>\n<\/ol>\n

    What is PayPal?<\/span><\/span><\/h2>\n

    PayPal<\/a> is an American company operating a worldwide online payments system that supports online money transfers and serves as an electronic alternative to traditional paper methods like checks and money orders. The company operates as a payment processor for online vendors, auction sites, and many other commercial users, for which it charges a fee in exchange for benefits such as one-click transactions and password memory. PayPal’s payment system, also called PayPal, is considered a type of payment rail.<\/p>\n

    Get Started with PayPal API<\/h2>\n

    If you have need to automate PayPal operations (e.g. read \/ write \/ update \/ delete ) then you can use PayPal REST API. Before you can integrate a PayPal product or solution, you must set up your development environment to get OAuth 2.0 client ID and secret credentials for the sandbox and live environments. You exchange these credentials for an access token that authorizes your REST API calls. To test your web and mobile apps, you create sandbox accounts.<\/p>\n

    Get PayPal credentials<\/h3>\n

    To generate OAuth 2.0 credentials for the sandbox and live environments:<\/p>\n

      \n
    1. Log into Dashboard<\/strong><\/a>\u00a0and type your PayPal personal or business account email and password.<\/li>\n
    2. In the\u00a0REST API apps<\/strong>\u00a0section, click\u00a0Create App<\/strong>. The purpose of this app is to generate your credentials.<\/li>\n
    3. Type a name for your app and click\u00a0Create App<\/strong>. The page shows your sandbox app information, which includes your credentials.
      \n

      Note:<\/strong>\u00a0To show your live app information, toggle to\u00a0Live<\/strong>.<\/p><\/blockquote>\n<\/li>\n

    4. Copy and save the client ID and secret for your sandbox app.\n
    5. Review your app details and save your app.<\/li>\n<\/ol>\n

      Call PayPal\u00a0<\/span><\/span><\/span>Create Order API in SQL Server (T-SQL) using Data Gateway<\/h2>\n

      Let\u2019s start with an example. We use JSON Driver to make the call to PayPal API, we will Create the PayPal Order from SQL Server.<\/p>\n

      In REST API calls, include the URL to the API service for the environment:<\/p>\n