TDV Adapter for Microsoft Bing

Build 23.0.8839

ImageSearch

Query the Bing image search engine.

Table Specific Information

Select

When querying this table, the Bing API requires the SearchTerms parameter. For example, to search Bing Images for the term 'bing', use the following query:

SELECT * FROM ImageSearch WHERE SearchTerms = 'bing'

You can also specify a search safety level:

SELECT * FROM ImageSearch WHERE SearchTerms = 'bing' AND SafeSearch = 'Moderate'

Columns

Name Type Description
Title String The title of the search result.
ContentUrl String The source URL of the search result.
HostPageUrl String A URL of the webpage that includes the image.
ThumbnailUrl String The thumbnail URL of the media.
Size String The file size of the media.
Width Integer The width of the image.
Height Integer The height of the image.
DatePublished Datetime The date of the search result.

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.
ImageType String The style of the image.

The allowed values are Photo, Graphics.

Color String The color richness of the image.

The allowed values are ColorOnly, Monochrome, Black, Blue.

Aspect String The size of the image.

The allowed values are Square, Wide, Tall.

ImageContent String The type of orientation of a profile picture.

The allowed values are Face, Portrait, Other.

SafeSearch String The search safety level.

The allowed values are Strict, Moderate, Off.

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.

Freshness String Filter images by when Bing discovered the image.

The allowed values are Day, Week, Month.

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