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. |