Read the metadata of the video assets in your accounts.

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 mutable 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		The URN of the video.
AccountURN	String	True		The URN of the ad-account to which this video belongs.
MediaLibraryName	String	False		The name of the video asset in the media library.
MediaLibraryStatus	String	False		The status of the video asset in the media library. 使用できる値は次のとおりです。ACTIVE, ARCHIVED
OwnerURN	String	True		The URN of the entity who owns the video.
DownloadURL	String	True		The URL for downloading the video.
DownloadURLExpiresAt	Datetime	True		The time when the URL for downloading the video expires.
Status	String	True		The status of the video. 使用できる値は次のとおりです。PROCESSING, PROCESSING_FAILED, AVAILABLE, WAITING_UPLOAD
AspectRatioHeight	Decimal	True		The aspect ratio height of the video.
AspectRatioWidth	Decimal	True		The aspect ratio width of the video.
Duration	Long	True		The duration of the video.
ThumbnailDownloadURL	String	True		The URL for downloading the video's thumbnail.
CaptionsDownloadURL	String	True		The URL for downloading the video's captions.