{"id":3671,"date":"2018-05-28T10:54:49","date_gmt":"2018-05-28T10:54:49","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=3671"},"modified":"2025-04-08T15:36:34","modified_gmt":"2025-04-08T15:36:34","slug":"read-linkedin-data-in-ssis-load-sql-server-call-rest-api","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-linkedin-data-in-ssis-load-sql-server-call-rest-api\/","title":{"rendered":"How to read LinkedIn data in SSIS – Call REST API \/ Load to SQL Server"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In this blog, we will learn\u00a0How to read LinkedIn data in SSIS and load into SQL Server Table<\/strong>, along with few other topics such as how to register an OAuth App for LinkedIn REST API Call<\/strong>, how to retrieve basic profile data from LinkedIn, how to share a post on LinkedIn with SSIS.<\/p>\n

We will go through the steps to read data from LinkedIn and Load into SQL Server using\u00a0\u00a0SSIS REST API Task<\/a> and\u00a0SSIS JSON Source.<\/a><\/p>\n

In nutshell,\u00a0this post will focus on how to call LinkedIn API using SSIS.<\/p>\n

So let’s get started.<\/p>\n

Prerequisite
\n<\/span><\/h2>\n
    \n
  1. First, you will need to have SSIS installed<\/li>\n
  2. Secondly, make sure to have SSDT<\/li>\n
  3. Finally, do not forget to install\u00a0ZappySys\u00a0SSIS PowerPack<\/a><\/li>\n<\/ol>\n

    What is LinkedIn<\/h2>\n

    LinkedIn is a social network for the business community. It provides an online platform for the professionals to connect with past and current colleagues. A user can increase their number of business connections, network within their industry, discuss business ideas, search for jobs and look for new hires.<\/p>\n

    Getting Started<\/h2>\n

    In order to start, we will show several examples. ZappySys includes an SSIS REST API Task<\/a>\u00a0and SSIS JSON Source<\/a>\u00a0that will help you to call LinkedIn API, retrieve basic profile data from LinkedIn, share a post on LinkedIn with SSIS and do many more actions using REST API. To learn more about LinkedIn API check this help file<\/a>.<\/p>\n

    Create LinkedIn App (for OAuth)<\/h3>\n

    To access LinkedIn data using REST API call you need to create a LinkedIn app.\u00a0Follow steps mentioned below to register LinkedIn OAuth App:<\/p>\n

      \n
    1. you can directly login to the LinkedIn site<\/a> with your credentials, and redirect to the LinkedIn Developer Console<\/a>\u00a0for creating an app.<\/li>\n
    2. you can open MyApps Page<\/a>.\n
    3. Click on Create Application button, the new Application form appears, Fill it up.\n
    4. Once you are done with the Creation of an App, you can see the Authentication tab.
      \nEnter Authorized Redirect URL there and you have your App’s Client ID and Client Secret.<\/p>\n
      \"LinkedIn<\/a>

      LinkedIn App: Authentication Tab<\/p><\/div>\n

      Now we are ready with an App. Let\u00b4s start with an example. In this example, we will show how to retrieve basic profile data from LinkedIn and share a post on LinkedIn with SSIS.<\/li>\n<\/ol>\n

      Load LinkedIn data to SQL Server using SSIS JSON Source<\/h3>\n

      Now once you registered OAuth app in the LinkedIn website we can move to SSIS Part.<\/p>\n

        \n
      1. Create a new SSIS Project or Open Existing Project in Visual Studio\u00a0 (File > New > Project > Business Intelligence > Integration Services)<\/li>\n
      2. Once SSIS Package is open, Goto Data Flow Section, Drag and Drop ZS JSON Source Component<\/a> from the SSIS Toolbox.\n
      3. Double click on that Component to Edit the Configurations. Select File path or web URL from the Access Mode drop-down.
        \nEnter Web URL like this:<\/p>\n
        https:\/\/api.linkedin.com\/v1\/people\/~:(id,firstName,lastName,headline,num-connections)?format=json<\/pre>\n
        \"JSON<\/a>
        JSON Source: Enter the Request URL<\/p><\/div><\/li>\n
      4. Check Use Credentials Option and select a\u00a0new ZS-OAUTH connection from the drop-down.<\/li>\n
      5. Configure new OAuth Connection for LinkedIn as below.
        \nBasically, you need to enter 3 pieces on the General tab (i.e. ClientId, ClientSecret, Scopes)\u00a0and one more info on the Advanced tab (i.e. callback URL ). If you are not sure what is Scope then check         this linkedin API documentation<\/a>. For each API page you will see which permission needed. Just include the desired scope on ZappySys OAuth Connection (see below).<\/p>\n
      6. Click on Preview button to see the response data.\n
      7. Click OK to save JSON Source settings.<\/li>\n
      8. Drag any destination (i.e. OLEDB Destination) from your SSIS toolbox. For demo purpose, we will load LinkedIn data into SQL Server Table.<\/li>\n
      9. Configure OLEDB Destination (Select Connection and Target Table). You can Create new Table for the destination by clicking NEW next to Table drop-down.<\/li>\n
      10. Click on the Columns Tab to configure Mappings. Click OK to save.<\/li>\n
      11. And that’s it. Execute your package to Load LinkedIn data to SQL Server.<\/li>\n<\/ol>\n
        Share a Post on LinkedIn (Use SSIS REST API Task)<\/h2>\n
        Now let’s look at one more example to call LinkedIn REST API. This time we will share a post on LinkedIn Page using REST API call in SSIS. For this, we will use\u00a0SSIS REST API Task<\/a><\/p>\n
          \n
        1. First\u00a0of All, Goto Control Flow Section, Drag and Drop\u00a0SSIS REST API Task<\/a>\u00a0from the SSIS Toolbox.\n
        2. Double click on that Component to Edit the Configurations. Configure the task like the below-attached screesnshot.\n
          Request URL: \r\nhttps:\/\/api.linkedin.com\/v1\/people\/~\/shares?format=json\r\n\r\nRequest Body: \r\n{\r\n  \"comment\": \"Hello, This is test message posted by Hardik from SSIS Package\",\r\n  \"visibility\": {\r\n    \"code\": \"anyone\"\r\n  }\r\n}<\/pre>\n
          \"REST<\/a>
          REST API Task: Configurations<\/p><\/div><\/li>\n
        3. now you are done with the configurations. you can do Test Request\/Response. See the below-attached request\/response screen.\n
        4. Goto your LinkedIn Profile, you can see the latest Post which is posted by us with the use of ZappySys and SSIS.\n
        5. You can Share a Post with a Specific Values too. See the Below example we have added title, description, submitted URL, submitted image URL.\n
          Request Body:\r\n\r\n{\r\n  \"comment\": \"Check out ZappySys's Latest Product ODBC PowerPack \",\r\n  \"content\": {\r\n    \"title\": \"ODBC PowerPack\",\r\n    \"description\": \"ODBC PowerPack is a collection of high-performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read\/query data from API sources or JSON \/ XML Files inside your favorite Data Engine \/ Reporting \/ ETL tools (i.e. SQL Server,  Power BI, Tableau, Qlik, SSRS, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more.\",\r\n    \"submitted-url\": \"https:\/\/zappysys.com\/products\/odbc-powerpack\/\",  \r\n    \"submitted-image-url\": \"https:\/\/zappysys.com\/wp-content\/uploads\/2017\/11\/slider-odbc-powerpack-rest-api-json-xml-drivers-1.png\"\r\n  },\r\n  \"visibility\": {\r\n    \"code\": \"anyone\"\r\n  }  \r\n}<\/pre>\n
          \"Share<\/a>
          Share a Post on LinkedIn with Specific Values<\/p><\/div><\/li>\n
        6. see the latest Post which is posted by us with the use of ZappySys and SSIS.\n
          \"Share<\/a>
          Share a Post with Specific values on LinkedIn: LinkedIn Activity Screen<\/p><\/div><\/li>\n<\/ol>\n
          <\/h2>\n
          VERY Important – About Refresh Token \/ Access Token<\/h2>\n
          As of now Linkedin allows only one active Access Token<\/strong>. Which means if you Regenerate token on OAuth connection manager then any previously generated token becomes invalid so always use just one Linked Shared Connection in your package \/ solution or parameterize Package level connection with same access token.<\/p>\n
          https:\/\/developer.linkedin.com\/docs\/Refresh-Tokens-with-OAuth-2#<\/a><\/p>\n
          Access Token you generate on OAuth Connection manager expires after 60 days<\/strong> and after 60 days unfortunately you have to re-authorize (3-Legged) to get new token. This is limitation imposed by linkedin\u00a0 which may change in future but unless you are authorized partner by LinkedIn you have to do this way. See below notes.<\/p>\n
          LinkedIn has introduced Refresh Tokens with OAuth 2.0. \u00a0This feature is currently available for a\u00a0limited set of partners<\/strong>. It will be made GA in the near future.<\/div><\/div>\n
           <\/p>\n
          Conclusion<\/span><\/h2>\n
          In this blog, we learned how to Create a LinkedIn App, retrieve basic profile data from LinkedIn and share a post on LinkedIn with SSIS using\u00a0ZS JSON Source Component<\/a>\u00a0and\u00a0SSIS REST API Task<\/a> in a very simple way. You can achieve many more functionalities with the use of both of these tools. Check our blogs\/articles on REST API Task\u00a0<\/strong>https:\/\/zappysys.com\/blog\/tag\/ssis-rest-api-task\/<\/a>\u00a0and JSON Source Component\u00a0<\/strong>https:\/\/zappysys.com\/blog\/tag\/ssis-json-source\/<\/a> to find out what\u00a0these tools<\/em>\u00a0are capable of more.<\/p>\n
          References<\/span><\/h2>\n
          Finally, you can use the following links for more information about the use of LinkedIn API with our tools:<\/p>\n