Videos
Get the metadata for a specified VideoPress video.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- VideoGUID supports the '=' comparison.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM Videos where VideoGUID='guid_string'
Columns
| Name | Type | References | Description |
| GUID [KEY] | String | The globally unique identifier (GUID) assigned to the video. | |
| Title | String | The title of the video as displayed in the media library or post editor. | |
| Description | String | A short summary or description of the video's content. | |
| width | Integer | The width of the video frame in pixels. | |
| Height | Integer | The height of the video frame in pixels. | |
| Duration | Integer | The total playback length of the video, measured in milliseconds. | |
| HasDisplayEmbed | Boolean | Indicates whether the video embed menu is visible to viewers. | |
| HasAllowDownload | Boolean | Specifies whether viewers can download the video from the player interface. | |
| Rating | String | The video's content rating, if applicable. | |
| Poster | String | The URL of the image displayed as the video's poster or preview thumbnail. | |
| Original | String | The URL of the original, uncompressed video file. | |
| Watermark | String | The URL of a watermark or logo overlay applied to the video. | |
| BgColor | String | The custom background color used in the video player. | |
| BlogId | String | The unique identifier of the WordPress site where the video was uploaded. | |
| PostId | Integer | The post ID of the video attachment or associated post. | |
| IsPrivate | Boolean | Indicates whether the video is private and restricted to authorized viewers. | |
| PrivacySetting | Integer | The numeric value representing the video's privacy level or access control setting. | |
| HasPrivateEnabledForSite | Boolean | Indicates whether private video mode is enabled for the site. | |
| UploadDate | Datetime | The date and time the video was uploaded, in ISO 8601 format. | |
| HasVideoTranscodingFinished | Boolean | Indicates whether the video transcoding process has completed. | |
| Subtitles | String | A list of available subtitle or caption files, including languages and formats. | |
| TracksAggregate | String | A collection of auxiliary media tracks, such as subtitles or metadata tracks, linked to the video. | |
| AdaptiveStreaming | String | The HLS (HTTP Live Streaming) URL used for adaptive bitrate playback. | |
| IsThumbnailGenerating | Boolean | Indicates whether thumbnail grid generation is currently in progress. | |
| FilesAggregate | String | A list of available video file formats and their corresponding file names. | |
| FileUrlBaseHttp | String | The base HTTP URL structure used to generate video file links. | |
| FileUrlBaseHttps | String | The base HTTPS URL structure used to generate video file links. | |
| PrivacyDetailsAggregate | String | Additional metadata describing the video's privacy configuration. | |
| FilesStatusAggregate | String | Status information for each video file format during or after transcoding. | |
| FormatMetaAggregate | String | Technical metadata describing each encoded video format. | |
| ThumbnailsGridAggregate | String | Detailed information about the generated video thumbnail grid. |