Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 username=myusername&password=mypass&login=Log+Me+In&login_submit= 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.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.