Read data on publisher restriction files used for restricting the sites which serve your ads off-network.

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		The unique identifier of the restriction file.
URN	String	True		The URN of the restriction file.
Name	String	False		The name of the restriction file.
RestrictionType	String	False		The restriction type of the file. The allowed values are BLOCKLIST, ALLOWLIST.
MediaURN	String	False		The media URN with details on the uploaded file's location.
Status	String	True		The status of the restriction file.
AccountURN	String	False		The unique identifier of the ad-account in which the restriction file exists.
CreatedAt	Datetime	True		The time when the restriction file was created.
UpdatedAt	Datetime	True		The time when the restriction file was last modified.