billfold-server is a REST Server which directly updates expense sheet (existing with predefined structure) in Google Spreadsheets. No database required.
yarn
npm start
Create a .env
file in the project root directory, provide following info in that.
GOOGLE_API_CLIENT_ID = 'xxxxxxxxxxxx'
GOOGLE_API_CLIENT_SECRET = 'xxxxx'
GOOGLE_API_REDIRECT_URL = 'http://xxxxxxxx/xxxx'
GOOGLE_API_ACCESS_TOKEN = 'xxxxxxxxxxxx'
GOOGLE_API_REFRESH_TOKEN = 'xxxxxxxxxxxx'
GOOGLE_API_EXPIRY_DATE = new Date(xxxxxxx)'
GOOGLE_SPREADSHEET_ID_2017 = 'xxxxxxxxxxxx'
-
List all expenses (from start of year till date):
GET /api/v1/expenses
-
View expense item:
GET /api/expenses/:datestr
-
Update expense item:
PUT /api/expenses/:datestr
Date | Total | Food | Travel | Supermarket | Recharge | e-shopping | Rent/wifi/hosting | Transfers | Others | Remarks |
---|---|---|---|---|---|---|---|---|---|---|
<Date> |
<Number> |
<Number> |
<Number> |
<Number> |
<Number> |
<Number> |
<Number> |
<Number> |
<Number> |
<String> |