Google Sheets/MySQL Connector

DB CRUD Routes

Routes to simulate client operations with DB

POST/api/db/create | Add Data to DB

https://sarthakskumar-2.dunker-great.ts.net/api/db/create

Bodyraw (json)

json

{
    "item_id": "ID-56789",
    "item_name": "BOWBOW Wet Food",
    "category": "Dog Food",
    "quantity": 38,
    "price": 1699
}

PUT/api/db/update | Update Data in DB

https://sarthakskumar-2.dunker-great.ts.net/api/db/update

Bodyraw (json)

json

{
    "item_id": "ID-56789",
    "item_name": "MEWMEW Wet Food"
}

DELETE/api/db/delete | Delete Data in DB

https://sarthakskumar-2.dunker-great.ts.net/api/db/delete?item_id=ID-56789

PARAMS

item_id

ID-56789

Bodyraw (json)

json

{
    "item_id": "ID-56789"   
}

POST/api/sheet | Update DB from Sheet

https://sarthakskumar-2.dunker-great.ts.net/api/sheet

Bodyraw (json)

json

{
    "789017": [
        { "cell": "Item ID", "value": 789017 },
        { "cell": "Item Name", "value": "Royal Canin 3KG Dog Food Packet" },
        { "cell": "Category", "value": "" },
        { "cell": "Quantity", "value": 1000 },
        { "cell": "Price", "value": 45 }
      ]
}