TDV Adapter for Microsoft Bing

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839