Excel Add-In for Microsoft Bing

Build 22.0.8389

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389