{"id":7822,"date":"2019-08-24T08:36:05","date_gmt":"2019-08-24T08:36:05","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7822"},"modified":"2019-09-14T05:21:15","modified_gmt":"2019-09-14T05:21:15","slug":"read-paypal-api-data-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-paypal-api-data-ssis\/","title":{"rendered":"How to read PayPal API data in SSIS"},"content":{"rendered":"

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

\"PayPal\"<\/a>In this article, we will see how to read PayPal API data in SSIS and load into SQL Server.\u00a0This blog mainly focuses on SSIS 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 read data from PayPal Transactions and Load into MS SQL Server.<\/p>\n

In nutshell,\u00a0this post will focus on how to make PayPal API Call using SSIS.<\/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. SSIS<\/abbr>\u00a0designer installed.\u00a0Sometimes it is referred to as\u00a0BIDS<\/abbr>\u00a0or\u00a0SSDT<\/abbr>\u00a0(download it from Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\n
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a>\u00a0is installed (download it<\/a>).<\/li>\n
  4. 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

      Read PayPal API Data using SSIS JSON Source<\/span><\/span><\/h2>\n

      Let\u2019s start with an example. We use SSIS JSON Source component to make the call to PayPal API, we will read PayPal data and load into SQL Server.\u00a0First of All, Open Visual Studio and Create New SSIS Package Project.<\/p>\n

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