Parent Previous Next

LinkedIn Source

The "LinkedIn Source" is used to extract data such as name, status updates, connections, and headlines within an SSIS package. See the Social OAuth Connection Manager page to learn more about setting up this component's connection manager.

Important Note

LinkedIn is available for SQL versions 2012 and higher.

 Connection Manager - In this field, users can create a new connection manager or select a pre-existing one.

 Api End Points - In this field, users select the Api they wish to connect to (Get My Profile and Get Member Profile.) Selecting an endpoint will auto-populate that field's parameters and commonly used Output Columns

 API Query - This field defines the query to be used in the API. Although several end points have been pre-configured, users can type in or paste custom calls that are not included with the component. (Unfortunately, LinkedIn does not provide a comprehensive list of API calls so users will have to search the internet if they wish to customize this field.)

 Root Json Path - Because LinkedIn returns the raw data in Json format, users will need to define the root path when creating custom queries.

 Query Parameters - User-defined parameters (such as id) based on the API query. Parameters can be set dynamically by entering the variable name (example: <@User::ScreenName>.)  

 Output Columns - In this window, users can add and remove columns and define their name, token path (defined within the raw data), data type, length, precision, scale, and code page.  


 Preview Data - Pressing this button will return the results and raw data based on the user-defined settings.

 Results - In this window, users can see a preview of the first few rows of data based on their configuration.

 Raw Data - This window displays the Json data in raw form. Developers can use this to help determine a root and token path.