Get Total Commission FN

Development

• cp .env.example .env

• edit .env

GOOGLE_SERVICE_ACCOUNT_EMAIL=
GOOGLE_PRIVATE_KEY=
GOOGLE_SPREADSHEET_ID_FROM_URL=

Set Up Google Services If Not Yet Set Up

Create New Google Project

Enable Google Spreadsheet API

Select Your New Created Project

• Create New Google Service Account

• Fill Up Service Account Details

• Add Role Owner

Create New Secret KEY

• Select JSON

• This will Download A JSON , Open that File which Will Contain GOOGLE_PRIVATE_KEY and GOOGLE_SERVICE_ACCOUNT_EMAIL

{
  "private_key": "GOOGLE_PRIVATE_KEY", // COPY THIS AND PASTE TO YOU .env file
  "client_email": "GOOGLE_SERVICE_ACCOUNT_EMAIL", // COPY AND PASTE THIS TO YOUR .env file
}

Get Google Spreadsheet ID

1. Go to this link: https://docs.google.com/spreadsheets/u/0/

2. Create A New Spreadsheet

3. Check The URL and Copy URL Segment and Paste to GOOGLE_SPREADSHEET_ID_FROM_URL

https://docs.google.com/spreadsheets/d/COPY-THIS-URL-SEGMENT/edit#gid=0

Grant Permission to GOOGLE_SERVICE_ACCOUNT_EMAIL

• Inside Your SpreadSheet ,Click Share Button , paste your GOOGLE_SERVICE_ACCOUNT_EMAIL

run netlify dev command

• test http://localhost:8888/api in postman

Raw JSON PAYLOAD

{
    "referral_code": "masterpowers"
}

**Response **

{
    "commission": 1000,
    "withdrawable": 900
}

• note: payable commission are referral commission that can be withdrawable to paymongo.

Deploy

Set Your Domain In Netlify

• Go to Settings

• Click Change Site Name ${username}-tss-fn-get-total-commission.${domain}.com

Production

• make post request with Needed payload to ${username}-tss-fn-get-total-commission.${domain}.com/api