Retrieves data about publisher restriction files that define which off-network sites are allowed or blocked for ad serving.

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 PublisherRestrictionFiles WHERE AccountURN = 'urn:li:sponsoredAccount:512859024';
SELECT * FROM PublisherRestrictionFiles WHERE AccountURN IN ('urn:li:sponsoredAccount:512859024', 'urn:li:sponsoredAccount:513009855')

For the Id 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 PublisherRestrictionFiles WHERE Id = '1323992';
SELECT * FROM PublisherRestrictionFiles WHERE Id IN ('1323992', '1324991');

When no criteria is specified as shown below:

SELECT * FROM PublisherRestrictionFiles;

, we internally post-process the query to the following before executing:

SELECT * FROM PublisherRestrictionFiles WHERE AccountURN IN (SELECT URN FROM Accounts);

The rest of the query is processed client-side.

Insert

To create a new publisher restriction file, use an INSERT statement.

The following columns are required for this operation:

• Name
• RestrictionType
• MediaURN
• AccountURN

INSERT INTO PublisherRestrictionFiles (Name, RestrictionType, MediaURN, AccountURN) VALUES ('Test Blocklist 1', 'BLOCKLIST', 'urn:li:media:/AAYAAgDxAAQAAQAAAAAAAP1BmZKAq-knSwOe7fuAwqPpug.csv', 'urn:li:sponsoredAccount:512859024')

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique identifier assigned to the publisher restriction file.
URN	String	True		Uniform Resource Name (URN) that uniquely identifies the publisher restriction file within LinkedIn.
Name	String	False		Name of the publisher restriction file, used for identification and reference.
RestrictionType	String	False		Specifies the type of restriction defined in the file. The allowed values are BLOCKLIST, ALLOWLIST.
MediaURN	String	False		URN that identifies the media asset containing the uploaded restriction file and its storage location.
Status	String	True		Indicates the current status of the restriction file, such as active, processing, or archived.
AccountURN	String	False		URN that identifies the advertising account in which the restriction file resides.
CreatedAt	Datetime	True		Date and time when the restriction file was created.
UpdatedAt	Datetime	True		Date and time when the restriction file was last updated.