JSON APIs + SeoTools = True

by William Dahlstrom

JSON, short for JavaScript Object Notation is a syntax for fetching, exchanging and storing data. It's considered an easier alternative to XML and its use is widespread on the web. There's an implementation or library in just about any language to deal with JSON style data, and it sees prevalent use in APIs all over the internet. SeoTools interacts with structured JSON data through the JsonPathOnUrl function. It allows you to both GET and POST data to a JSON compatible...

Find the country where a site is hosted in Excel

by Niels Bosma

Using the ip-api.com JSON API and ResolveIp we can get the country where a site is hosted: The following API request http://ip-api.com/json/91.189.43.102 returns this JSON response: So we use ResolveIp to get the ip of the site and JsonPathOnUrl on to parse the result: =JsonPathOnUrl("http://ip-api.com/json/"&ResolveIp("http://nielsbosma.se");"$.country";HttpSettings(TRUE;;;"240|240|Host")) Note the usage limits from their documentation: Our system will automatically ban...