Retrieves metadata for video assets in your LinkedIn Ads account, including identifiers, upload details, and ownership information.

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

For the URN 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 Videos WHERE URN = 'urn:li:video:D4D10AQGLvWblHowYUw';
SELECT * FROM Videos WHERE URN IN ('urn:li:video:D4D10AQGLvWblHowYUw', 'urn:li:video:D4D10AQFLAKXbRnqwLQ')

For the two queries above, the values for the AccountURN, MediaLibraryName, and MediaLibraryStatus columns are not returned (always null).

When no criteria is specified as shown below:

SELECT * FROM Videos;

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

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

The rest of the query is processed client-side.

Update

To modify an existing image, use an UPDATE statement. Note that the URN column and the AccountURN column are required in the WHERE clause.

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

• MediaLibraryName
• MediaLibraryStatus

UPDATE Videos SET MediaLibraryName = 'My Test Video', MediaLibraryStatus = 'ARCHIVED' WHERE AccountURN = 'urn:li:sponsoredAccount:515278483' AND URN = 'urn:li:video:D4D10AQGLvWblHowYUw'

Columns

Name	Type	ReadOnly	References	Description
URN [KEY]	String	True		Uniform Resource Name (URN) that uniquely identifies the video asset within LinkedIn.
AccountURN	String	True		URN that identifies the advertising account associated with the video asset.
MediaLibraryName	String	False		Display name of the video asset as it appears in the media library.
MediaLibraryStatus	String	False		Indicates the current status of the video asset in the media library, such as active, processing, or archived. The allowed values are ACTIVE, ARCHIVED.
OwnerURN	String	True		URN that identifies the entity or organization that owns the video asset.
DownloadURL	String	True		URL used to download the video file from LinkedIn's media library.
DownloadURLExpiresAt	Datetime	True		Date and time when the download URL for the video asset expires and is no longer valid.
Status	String	True		Represents the current processing or availability status of the video asset. The allowed values are PROCESSING, PROCESSING_FAILED, AVAILABLE, WAITING_UPLOAD.
AspectRatioHeight	Decimal	True		Specifies the height component of the video's aspect ratio, used to maintain proper display proportions.
AspectRatioWidth	Decimal	True		Specifies the width component of the video's aspect ratio, used to maintain proper display proportions.
Duration	Long	True		Total duration of the video in milliseconds.
ThumbnailDownloadURL	String	True		URL used to download the thumbnail image associated with the video asset.
CaptionsDownloadURL	String	True		URL used to download caption files associated with the video asset.