CompanyList
Lists all companies and the privileges that the user has within the organization.
Note: Requires the r_organization_admin OAuth scope.
Select
The connector 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 connector.
- 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. |