I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously clunky and slow admin interface of my registrar (who also has a habit of defaulting them back to their original settings or pointing my domains to their holding page.(*))
Fortunately the URLS are in the easy form of /email?domain=mydomain.co.uk&submit=Submit+Query&r=y /manage-dns/?domain=mydomain.co.uk
and so on. And I have the necessary wherewithal to extract data like this from a normal webpage.
A Google Employee has helpfully posted some code which will pass a username and password in the case of HTTP basic or digest auth via the UrlFetchApp paremeters (docs). And I've tried to apply the method in this StackOverflow posting relating to doing the same with Java and Python.
When I look at the traffic via the most excellent Fiddler2 I get the following:
# Result Protocol Host URL Body Caching Content-Type Process Comments Custom 3 302 HTTPS www.123-reg.co.uk /public/login 311 post-check=0, pre-check=0; Expires: Tue, 01 Jan 2013 00:00:00 GMT text/html; charset=utf-8 chrome:7036 4 200 HTTPS www.123-reg.co.uk /secure 71,061 text/html; charset=UTF-8 chrome:7036
and I see that this passes
and I get some cookies back.
Is this beyond the realms of Google Apps Scripting? I have a feeling it could probably be done with CURL but I was learning G-A-S and wondered what it could do.
If there's a better suggestion for doing this, be it browser plugin or other, please let me know cos I'm done in after 2 days of Googling.
(*)1: Yes, I should get a better registrar. 2: No, no-one is hacking in and changing it.