SSIS Components for LinkedIn

Build 24.0.9060

CompanyList

Lists all companies and the privileges that the user has within the organization.

Note: Requires the r_organization_admin OAuth scope.

Select

The component uses the LinkedIn API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • Role supports only the '=' and IN operators.
  • State supports only the '=' and IN operators.

The following query returns a list of all companies that the corresponding member is an administrator of:

SELECT * FROM CompanyList

The following queries are processed server side:

SELECT * FROM CompanyList Role = 'ANALYST';
SELECT * FROM CompanyList WHERE State IN ('APPROVED', 'REQUESTED');
SELECT * FROM CompanyList WHERE State = 'APPROVED' AND Role = 'ADMINISTRATOR';

Columns

Name Type Description
Id String A unique identifier for the company in the following format urn:li:organization:{id}
RoleAssignee String Id of the assigned person.
Role String Role of the assigned person. Possible values are: ADMINISTRATOR, DIRECT_SPONSORED_CONTENT_POSTER, RECRUITING_POSTER, LEAD_CAPTURE_ADMINISTRATOR, LEAD_GEN_FORMS_MANAGER, ANALYST, CURATOR, CONTENT_ADMINISTRATOR.
State String State of the role assigned to the person. Possible values are: APPROVED, REJECTED, REQUESTED, REVOKED.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060