A friendly REST service wrapper for OFX bank servers.
- Download latest release zip file from https://github.com/bradyholt/OpenBank/releases
- Unzip and run OpenBank.exe from command line. If using mono, run mono OpenBank.exe
- OpenBank should fire up and now be listening on port 1234, by default.
- In a browser, navigate to http://localhost:1234/ to ensure OpenBank is running and to get more info.
To get a list of transactions for a bank account, you'll want to use the statement (POST) resource. The required parameters for this resource are:
| Parameter Name | Notes |
|---|---|
| ofx_url | (obtain from OFX Home) |
| fid | (obtain from OFX Home) |
| org | (obtain from OFX Home) |
| user_id | Your login username |
| password | Your login password |
| bank_id | Routing number (leave blank for CREDITCARD accounts) |
| account_id | Your account number |
| account_type | CHECKING, SAVING, MONEYMRKT, CREDITCARD, OTHER |
| date_start | YYYYMMDD format |
| date_end | YYYYMMDD format |
For example - If you have a checking account at Chase, you would use the directory at OFX Home to get Chase's OFX information (direct link) including the ofx_url, fid, and org. The rest of the paramters should be known by you already. Using wget, you could download transactions for your Chase account, for date range 9/1/2013 to 9/15/2013, and save as JSON file with the following command:
wget --header="Accept: application/json" --post-data="ofx_url=https://ofx.chase.com
&fid=10898&org=B1&user_id=YOUR_USERNAME_HERE&password=YOUR_PASSWORD_HERE&bank_id=111000614
&account_id=816555555&account_type=CHECKING&date_start=20130901
&date_end=20130915" http://localhost:1234/statement -O statement.json