'Excel Formula to get the result of a web query

I have the following Excel 2016 sheet:

**First Name                 Calc                           Result**
Richard     https://api.genderize.io/?name=richard
Arvin       https://api.genderize.io/?name=arvin

If I paste https://api.genderize.io/?name=richard in a browser I get:

  {"name":"richard","gender":"male","probability":0.99,"count":101928}

For https://api.genderize.io/?name=arvin, I get:

  {"name":"arvin","gender":"male","probability":0.98,"count":1602}

How can I automate these calculations with an Excel formula?

Desired result would be:

result picture

excel excel-formula

Solution 1:^[1]

You can use the WEBSERVICE() function, with the value from your CALC column as the argument.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Spectral Instance

'Excel Formula to get the result of a web query

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]