Skip to content

Praseetha-KR/billfold-server

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

59 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

billfold-server

billfold-server is a REST Server which directly updates expense sheet (existing with predefined structure) in Google Spreadsheets. No database required.

Setup

Install dependencies:
yarn
Start server:
npm start

Config

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'

Endpoints implemented:

  1. List all expenses (from start of year till date):

     GET /api/v1/expenses
    
  2. View expense item:

     GET /api/expenses/:datestr
    
  3. Update expense item:

     PUT /api/expenses/:datestr
    

Expense sheet format:

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>

About

REST Server for managing expense sheet in Google Spreadsheets

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published