Excel Add-In for LinkedIn

Build 25.0.9434

CompanyList

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

Note: Requires the r_organization_admin OAuth scope.

Select

The add-in 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 add-in.

  • 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 References 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) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434