http://snippets.dzone.com/posts Thu, 07 Aug 2008 01:46:26 GMT DZone Snippets: wamu code http://snippets.dzone.com/posts/show/4548 I bank at Washington Mutual, and I wanted to see when I was spending too much, or get automated updates of what I was spending money on each day and what my balance was. However, it's really difficult to do and WaMu won't let you use an API or something helpful like that, so I wrote my own little screen-scraper to do it. <br /> <br />This requires WWW::Mechanize, but it works quite well. <br /> <br /><code> <br />require 'rubygems' <br />require 'mechanize' <br /> <br />agent = WWW::Mechanize.new <br /> <br /># login to the account <br />puts "Login" <br />page = agent.get('https://online.wamu.com/IdentityManagement/Logon.aspx') <br />login_form = page.forms.with.name("frmLogin").first <br />login_form.txtUserID = '<UNAME>' <br />login_form.password = '<PWD>' <br />page = agent.submit(login_form, login_form.buttons.first) <br /> <br /># click on the download button <br />puts "Download" <br />dl_link = page.links.with.text(/WAMU FREE CHECKING/) <br />page = agent.click(dl_link) <br /> <br />line_items = [] <br /> <br />trs = (page/"table#_ctl0_depositTransactionsGrid/tr") <br />trs.shift <br />trs.each do |tr| <br /> tds = (tr/:td) <br /> <br /> dtd = tds[1].inner_html <br /> js_call = dtd.match(/showDDATransactionDetails\('(.*)'\);/)[1] <br /> js_fields = js_call.split("','") <br /> <br /> item = {} <br /> item['type'] = js_fields[1] <br /> item['descr'] = js_fields[3] <br /> item['amount'] = js_fields[4] <br /> item['tranid'] = js_fields[6] <br /> # if !tranid = ovedraft charge / bank fee <br /> <br /> item['date'] = tds[0].inner_html <br /> item['debit'] = tds[3].inner_html <br /> item['credit'] = tds[4].inner_html <br /> item['balance'] = tds[5].inner_html <br /> <br /> line_items << item <br />end <br /> <br />pp line_items.first <br /></code> <br /> <br /> Sun, 16 Sep 2007 21:18:32 GMT http://snippets.dzone.com/posts/show/4548 schacon (Scott Chacon)