Excel Add-In for Microsoft Bing

Build 22.0.8389

NewsSearch

Query the Bing news search engine.

Table Specific Information

Select

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

SELECT * FROM NewsSearch WHERE SearchTerms = 'bing'

You can also specify a search safety level:

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

Columns

Name Type Description
Title String The title of the search result.
Description String The HTML title of the search result.
URL String The URL of the search result.
Thumbnail String The source of the search result. This often is the company name.
DatePublished Datetime The date of the search result.
Category String The news category.
ProviderName String The news provider.

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 type of the source that triggered the event.

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.

SafeSearch String The search safety level.

The allowed values are Strict, Moderate, Off.

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) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389