Videos
Read the metadata of the video assets created in the organizations you administer.
Table Specific Information
Note: Requires the 'r_organization_social' OAuth scope.Select
The URN column is required and must be specified in the criteria to query data from this table.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')
The rest of the query is processed client-side.
Columns
| Name | Type | References | Description |
| URN [KEY] | String | The URN of the video. | |
| OwnerURN | String | The URN of the entity who owns the video. | |
| DownloadURL | String | The URL for downloading the video. | |
| DownloadURLExpiresAt | Datetime | The time when the URL for downloading the video expires. | |
| Status | String | The status of the video.
The allowed values are PROCESSING, PROCESSING_FAILED, AVAILABLE, WAITING_UPLOAD. | |
| AspectRatioHeight | Decimal | The aspect ratio height of the video. | |
| AspectRatioWidth | Decimal | The aspect ratio width of the video. | |
| Duration | Long | The duration of the video. | |
| ThumbnailDownloadURL | String | The URL for downloading the video's thumbnail. | |
| CaptionsDownloadURL | String | The URL for downloading the video's captions. |