Using Bing API to perform searches

We are wanting someone to loop over 10,000 rows and run 3 searches via Bing API for each row.

Bing API:

[login to view URL]

A Bing API token will be provided.

I've attached the document. that contains the 10,000 rows.

For each row, 3 API calls will be made to complete 3 searches.

Search 1:

site:[login to view URL] {CompanyName}

Replace {CompanyName} with the Company Name in Column B - for example: if the company name was ABC Limited then the search term would be:

site:[login to view URL] ABC Limited

Place the 1st URL from the search response in Column D

Place the full response from the search (JSON Object) in Column E

Search 2:

site:[login to view URL] {WebsiteURL}

Replace {WebsiteURL} with the URL in Column C - for example: if the website was [login to view URL] then the search term would be:

site:[login to view URL] [login to view URL]

Place the 1st URL from the search response in Column F

Place the full response from the search (JSON Object) in Column G

Search 3:

site:[login to view URL] {CompanyName} {WebsiteURL}

Replace {CompanyName} with the Company Name in Column B and replace {WebsiteURL} with the URL in Column C - for example: if the company name was ABC Limited and the website was [login to view URL] then the search term would be:

site:[login to view URL] ABC Limited [login to view URL]

Place the 1st URL from the search response in Column H

Place the full response from the search (JSON Object) in Column I

Software Development

Project ID: #27964503

About the project