{"info":{"_postman_id":"fd5e422e-1282-46a4-bf92-2119058e8ee0","name":"Google Sheets/MySQL Connector","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"","owner":"22931938","collectionId":"fd5e422e-1282-46a4-bf92-2119058e8ee0","publishedId":"2sAXxJhun3","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2024-10-01T13:36:00.000Z"},"item":[{"name":"DB CRUD Routes","item":[{"name":"/api/db/create | Add Data to DB","id":"dc830473-27e4-4664-9146-8049a2b014a1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"item_id\": \"ID-56789\",\r\n \"item_name\": \"BOWBOW Wet Food\",\r\n \"category\": \"Dog Food\",\r\n \"quantity\": 38,\r\n \"price\": 1699\r\n}","options":{"raw":{"language":"json"}}},"url":"https://sarthakskumar-2.dunker-great.ts.net/api/db/create","urlObject":{"path":["api","db","create"],"host":["https://sarthakskumar-2.dunker-great.ts.net"],"query":[],"variable":[]}},"response":[],"_postman_id":"dc830473-27e4-4664-9146-8049a2b014a1"},{"name":"/api/db/update | Update Data in DB","id":"e4e340c1-41ee-4c0e-94ed-0fd87460d173","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\r\n \"item_id\": \"ID-56789\",\r\n \"item_name\": \"MEWMEW Wet Food\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://sarthakskumar-2.dunker-great.ts.net/api/db/update","urlObject":{"path":["api","db","update"],"host":["https://sarthakskumar-2.dunker-great.ts.net"],"query":[],"variable":[]}},"response":[],"_postman_id":"e4e340c1-41ee-4c0e-94ed-0fd87460d173"},{"name":"/api/db/delete | Delete Data in DB","id":"250575ad-011b-43af-9ba7-a0627b1e6db7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"body":{"mode":"raw","raw":"{\r\n \"item_id\": \"ID-56789\" \r\n}","options":{"raw":{"language":"json"}}},"url":"https://sarthakskumar-2.dunker-great.ts.net/api/db/delete?item_id=ID-56789","urlObject":{"path":["api","db","delete"],"host":["https://sarthakskumar-2.dunker-great.ts.net"],"query":[{"key":"item_id","value":"ID-56789"}],"variable":[]}},"response":[],"_postman_id":"250575ad-011b-43af-9ba7-a0627b1e6db7"}],"id":"a72989e1-9089-4977-9677-c6a71c552548","description":"

Routes to simulate client operations with DB

\n","_postman_id":"a72989e1-9089-4977-9677-c6a71c552548"},{"name":"/api/sheet | Update DB from Sheet","id":"ad7ab589-7aa9-46d3-9765-0a0ff709a85f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"789017\": [\r\n { \"cell\": \"Item ID\", \"value\": 789017 },\r\n { \"cell\": \"Item Name\", \"value\": \"Royal Canin 3KG Dog Food Packet\" },\r\n { \"cell\": \"Category\", \"value\": \"\" },\r\n { \"cell\": \"Quantity\", \"value\": 1000 },\r\n { \"cell\": \"Price\", \"value\": 45 }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"https://sarthakskumar-2.dunker-great.ts.net/api/sheet","urlObject":{"path":["api","sheet"],"host":["https://sarthakskumar-2.dunker-great.ts.net"],"query":[],"variable":[]}},"response":[],"_postman_id":"ad7ab589-7aa9-46d3-9765-0a0ff709a85f"},{"name":"AppScript API | Insert Row","id":"f1a5f8e1-93be-42a4-9334-de01e799eee8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"item_id\": \"ID-34844\",\r\n \"item_name\": \"PurePet Wet Food\",\r\n \"category\": \"Cat Food\",\r\n \"quantity\": 38,\r\n \"price\": 499\r\n}","options":{"raw":{"language":"json"}}},"url":"https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec","urlObject":{"host":["https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec"],"query":[],"variable":[]}},"response":[],"_postman_id":"f1a5f8e1-93be-42a4-9334-de01e799eee8"},{"name":"AppScript API | Update Row","id":"bdf64916-36bf-4f21-9186-84f54ae7a62d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"item_id\": \"ID-34833\",\r\n \"item_name\": \"PurePet Wet Food\",\r\n}","options":{"raw":{"language":"json"}}},"url":"https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec?username=jsmith&age=21","urlObject":{"host":["https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec"],"query":[{"key":"username","value":"jsmith"},{"key":"age","value":"21"}],"variable":[]}},"response":[],"_postman_id":"bdf64916-36bf-4f21-9186-84f54ae7a62d"},{"name":"AppScript API | Delete Row","id":"029fc37e-a68b-4854-b28c-fbe248e73a4a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"item_id\": \"ID-34833\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec","urlObject":{"host":["https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec"],"query":[],"variable":[]}},"response":[],"_postman_id":"029fc37e-a68b-4854-b28c-fbe248e73a4a"}],"event":[{"listen":"prerequest","script":{"id":"053d7e0f-f166-4e24-b5fb-a01230f4fd1d","type":"text/javascript","packages":{},"exec":[""]}},{"listen":"test","script":{"id":"8d641b6c-ebc8-4fff-b380-ae843efd9336","type":"text/javascript","packages":{},"exec":[""]}}],"variable":[{"key":"ws_url","value":"https://sarthakskumar-2.dunker-great.ts.net","type":"string"},{"key":"ap_url","value":"https://script.google.com/macros/s/AKfycbwbNrZPjr_RurVs_iVUsa6QDXm-Lx8WQ3p5GNMSWcrTU-tdX_FVMleyV3wpA2wt3WZUWg/exec","type":"string"}]}