WebSearch
Query the Bing Web search engine.
Table Specific Information
Select
When querying this table, the Bing API requires the SearchTerms parameter. For example, to search Bing Web for the term 'bing' use the following query:
SELECT * FROM WebSearch WHERE SearchTerms = 'bing'
You can also specify a search safety level:
SELECT * FROM WebSearch WHERE SearchTerms = 'bing' AND SafeSearch = 'Moderate'
Columns
| Name | Type | Description |
| Id | String | An ID that uniquely identifies the web answer. |
| Title | String | The title of the search result. |
| URL | String | The URL of the search result. |
| DisplayUrl | String | The displayed link 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. |
| 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. |