So i have a spreadsheet with multiple API query's in it H1 http://www.useragentstring.com/?uas=mozilla/5.0 (windows nt 6.1; win64; x64; trident/7.0; rv:11.0) like gecko&getJSON=all H2 http://www.useragentstring.com/?uas=mozilla/5.0 (windows nt 6.1; wow64) applewebkit/537.36 (khtml, like gecko) chrome/53.0.2785.116 safari/537.36&getJSON=all etc each of these will pull data back like this {"agent_type":"Browser","agent_name":"Internet Explorer","agent_version":"11.0","os_type":"Windows","os_name":"Windows NT","os_versionName":"","os_versionNumber":"","os_producer":"","os_producerURL":"","linux_distibution":"Null","agent_language":"","agent_languageTag":""} What is the best way for me to do this and get the query answer data back into the spreadsheet?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

API Query in Excel Spreadsheet help

Thread starter AlwaysNeedHelp
Start date Dec 15, 2016

AlwaysNeedHelp

New Member

Dec 15, 2016

So i have a spreadsheet with multiple API query's in it

H1 http://www.useragentstring.com/?uas=mozilla/5.0 (windows nt 6.1; win64; x64; trident/7.0; rv:11.0) like gecko&getJSON=all
H2 http://www.useragentstring.com/?uas=mozilla/5.0 (windows nt 6.1; wow64) applewebkit/537.36 (khtml, like gecko) chrome/53.0.2785.116 safari/537.36&getJSON=all

etc

each of these will pull data back like this

Code:

{"agent_type":"Browser","agent_name":"Internet Explorer","agent_version":"11.0","os_type":"Windows","os_name":"Windows NT","os_versionName":"","os_versionNumber":"","os_producer":"","os_producerURL":"","linux_distibution":"Null","agent_language":"","agent_languageTag":""}

What is the best way for me to do this and get the query answer data back into the spreadsheet?