3,915 questions
how do I use webservice to obtain the domain name for a company?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 27%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Steve Jennings
0
Reputation points
I would like to use the webservice formula to search for the domain name based on the company name. A list of company names would be provided in column A with the webservice formula in column B.
Once the domain name is returned in column B, a list of employee names in column C would be used to search for each employee's business email address by concatenating the employee name with the domain name responses from column B.
Microsoft 365 and Office | Excel | For business | Windows
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua 18,065 Reputation points Moderator2024-10-09T06:45:22.28+00:00 Hi @Steve Jennings
Could you please share us more details.
Where and how do you use webservice formula to get the data via company name? If you are using some tool or website, you may share it with us.
If you use WEBSERVICE formula, which type of data will you get, XML, Json or others?
-
Steve Jennings 0 Reputation points
2024-10-09T15:36:42.5366667+00:00 I am using the WEBSERVICE formula in Excel to execute the “Bing Search” function provided in the Azure Cognitive library.
The function allows you to use Python, Java, etc. to execute the search. I’m not interested in reinventing the wheel as Copilot will already accept up to 5 Company Names and return the domain name, address, phone number, etc.
However, that’s in an online environment, I.e., executing Copilot from within Bing. I need to execute the same Copilot function within Excel (in a batch environment).
Does MS offer that same Copilot functionality in a batch environment?
-
Steve Jennings 0 Reputation points
2024-10-09T17:22:57.06+00:00 I am able to execute copilot in a web environment and extract up to five domain names by giving copilot the company name. I would like to be able to do the same thing in a batch environment and I'm wondering if Microsoft azure provides a means to do this using Bing search or some other function.
I would prefer not to pay for something that is already available in Azure. Please let me know if you are aware of the location for the copilot Search function I am Trying to find.
-
Jiajing Hua 18,065 Reputation points Moderator
2024-10-11T08:45:47.94+00:00 Hi @Steve Jennings
Thanks for your back and explanation.
Because I don't have an environment with the Azure Cognitive library, I don't know what kind of URL you can use and add the company name in column A as the website directory, what results you will get using the WEBSERVICE formula.
Here is a thread showing how to query price information using this formula. https://answers.microsoft.com/en-us/msoffice/forum/all/problem-referencing-the-returned-value-from-the/7cb31698-2a9e-45f8-88a2-3b6c4d6a6d29
In addition, if you need Excel batch processing operations, you need to use VBA macros and Office scripts.
Sign in to comment
Sign in to answer