Skip to content

Instantly share code, notes, and snippets.

@tariqhamid
Forked from mogsdad/NSLookup.gs
Created June 21, 2016 18:12
Show Gist options
  • Save tariqhamid/deb8362cbfefe12423d3837bb220847b to your computer and use it in GitHub Desktop.
Save tariqhamid/deb8362cbfefe12423d3837bb220847b to your computer and use it in GitHub Desktop.
NSLookup - Google Sheets custom function to Perform a Network Service Lookup, using StatDNS API. From "Nslookup or dig in Google App Script" (http://stackoverflow.com/a/30610580/1677912).
/**
* Perform a Network Service Lookup, using StatDNS API.
*
* @param {"google.com"} dn A well-formed domain name to resolve.
* @return {String} Resolved IP address
* @customfunction
*/
function NSLookup(dn) {
// From gist.github.com/mogsdad/ece531531e0ef5dc355d
var url = "http://api.statdns.com/%FQDN%/a".replace("%FQDN%",dn);
var result = UrlFetchApp.fetch(url,{muteHttpExceptions:true});
var rc = result.getResponseCode();
var response = JSON.parse(result.getContentText());
if (rc !== 200) {
throw new Error( response.message );
}
var ip = response.answer[0].rdata;
return ip;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment