VideoSearch
Query the Bing video search engine.
Table Specific Information
Select
When querying this table, the Bing API requires the SearchTerms parameter. For example, to search Bing Videos for the term 'bing' use the following query:
SELECT * FROM VideoSearch WHERE SearchTerms = 'bing'
You can also specify a search safety level:
SELECT * FROM VideoSearch WHERE SearchTerms = 'bing' AND SafeSearch = 'Moderate'
Columns
| Name | Type | Description |
| Title | String | The title of the search result. |
| ContentUrl | String | A URL to the on the host site. |
| HostPageUrl | String | A URL to the webpage that hosts the video. |
| HostPageDisplayUrl | String | The display URL of the webpage that hosts the video. |
| Thumbnail | String | The thumbnail URL of the media. |
| RunTime | String | The duration of the video. |
| DatePublished | Datetime | Publication date. |
| Publisher | String | The name of the creator of the video. |
| Description | String | A short description of the video. |
| ViewCount | Integer | The number of times that the video has been watched at the source site. |
| Width | Integer | The width of the video. |
| Height | Integer | The height of the video. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SearchTerms | String | The search expression. |
| Aspect | String | The aspect of the video.
The allowed values are Widescreen, Standard. |
| Resolution | String | The quality of the video.
The allowed values are Low, Medium, High. |
| Length | String | The duration of the video.
The allowed values are Short, Medium, Long. |
| Market | String | The market where the results come from.
The allowed values are ar-XA, bg-BG, cs-CZ, da-DK, de-AT, de-CH, de-DE, el-GR, en-AU, en-CA, en-G, en-ID, en-IE, en-IN, en-MY, en-NZ, en-PH, en-SG, en-US, en-XA, en-ZA, es-AR, es-CL, es-MX, es-US, es-XL, et-EE, fi-FI, fr-BE, fr-CA, fr-CH, fr-FR, he-IL, hr-HR, hu-HU, it-IT, ja-JP, ko-KR, lt-LT, lv-LV, nb-NO, nl-BE, nl-NL, pl-PL, pt-BR, pt-PT, ro-RO, ru-RU, sk-SK, sl-SI, sv-SE, th-TH, tr-TR, uk-UA, zh-CN, zh-HK, zh-TW. |
| Country | String | A 2-character country code of the country where the results come from.
The allowed values are AR, AU, AT, BE, BR, CA, CL, DK, FI, FR, DE, HK, IN, ID, IE, IT, JP, KR, MY, MX, NL, NZ, NO, CN, PL, PT, PH, RU, SA, ZA, ES, SE, CH, TW, TR, GB, US. |
| SafeSearch | String | The search safety level.
The allowed values are Strict, Moderate, Off. |