Read data on your ad-account users.

Table Specific Information

Select

For the AccountURN column, the = operator is fully supported server-side. The IN operator is partially supported server-side and partially client-side. Refer to the query examples below:

SELECT * FROM AccountUsers WHERE AccountURN = 'urn:li:sponsoredAccount:515215939'
SELECT * FROM AccountUsers WHERE AccountURN IN ('urn:li:sponsoredAccount:515215939', 'urn:li:sponsoredAccount:515221250')

The rest of the query is processed client-side.

Insert

To create a new account user, use an INSERT statement.

The following columns are required for this operation:

• AccountURN
• UserURN
• Role

INSERT INTO AccountUsers (AccountURN, UserURN, Role) VALUES ('urn:li:sponsoredAccount:515215939', 'urn:li:person:XXXXXXXXXX', 'CAMPAIGN_MANAGER')

Update

To modify an existing account user, use an UPDATE statement. Note that the AccountURN and UserURN columns are required in the WHERE clause.

The following columns are the ones that are mutable after creation:

• Role

UPDATE AccountUsers SET Role = 'VIEWER' WHERE AccountURN = 'urn:li:sponsoredAccount:515215939' AND UserURN = 'urn:li:person:XXXXXXXXXX'

Delete

To remove an account user, use a DELETE statement. Note that the AccountURN and UserURN columns are required in the WHERE clause.

DELETE FROM AccountUsers WHERE AccountURN = 'urn:li:sponsoredAccount:515215939' AND UserURN = 'urn:li:person:XXXXXXXXXX'

Columns

Name	Type	ReadOnly	References	Description
AccountURN [KEY]	String	False		The unique identifier of the account in which the user belongs.
UserURN [KEY]	String	False		The unique identifier of the user's LinkedIn profile.
Role	String	False		The user's role. The allowed values are VIEWER, CREATIVE_MANAGER, CAMPAIGN_MANAGER, ACCOUNT_MANAGER, ACCOUNT_BILLING_ADMIN.
CreatedAt	Datetime	True		The time when the user was created.
UpdatedAt	Datetime	True		The time when the user was last modified.