{"info":{"_postman_id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","name":"student connections","description":"<html><head></head><body><p>A collection with requests for <code>/student-connections</code> endpoint.</p>\n</body></html>","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"13348269","collectionId":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","publishedId":"UUy7bjZY","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2021-10-08T18:34:12.000Z"},"item":[{"name":"Get All Friend Connections","id":"76121422-b42b-4de9-bada-534ffdcd3998","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{admin_token}}"}]},"isInherited":false},"method":"GET","header":[],"url":"{{base_url}}/student-connections?erp=15030","description":"<h1 id=\"get-all-friend-connection\">Get all friend connection</h1>\n<h2 id=\"response\">Response</h2>\n<hr />\n<p>List of student connections details where each list item contains:</p>\n<ul>\n<li><code>sender_erp</code></li>\n<li><code>receiver_erp</code></li>\n<li><code>connection_status</code> = <strong>friends</strong></li>\n<li><code>sent_at</code></li>\n<li><code>accepted_at</code></li>\n</ul>\n","urlObject":{"path":["student-connections"],"host":["{{base_url}}"],"query":[{"key":"erp","value":"15030"}],"variable":[]}},"response":[{"id":"38f7c1d3-bc82-473c-a014-fa6456c3d05d","name":"Mock Get All Friend Connections","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{base_url}}/student-connections?erp=15030","host":["{{base_url}}"],"path":["student-connections"],"query":[{"key":"erp","value":"15030"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"222"},{"key":"ETag","value":"W/\"de-oXEXwYRywWDfLokcDD8mWxHN/6Y\""},{"key":"Date","value":"Sun, 10 Oct 2021 17:36:49 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n    \"headers\": {\n        \"error\": 0,\n        \"message\": \"Success\"\n    },\n    \"body\": [\n        {\n            \"student_connection_id\": 6,\n            \"connection_status\": \"friends\",\n            \"sent_at\": \"2021-10-10 18:38:15\",\n            \"accepted_at\": \"2021-10-10 18:38:15\",\n            \"sender\": {\n                \"erp\": \"15030\",\n                \"first_name\": \"Mohammad Rafay\",\n                \"last_name\": \"Siddiqui\",\n                \"profile_picture_url\": \"https://i.pinimg.com/564x/8d/e3/89/8de389c84e919d3577f47118e2627d95.jpg\",\n                \"program_id\": 1,\n                \"graduation_year\": 2022\n            },\n            \"receiver\": {\n                \"erp\": \"17619\",\n                \"first_name\": \"Test\",\n                \"last_name\": \"User\",\n                \"profile_picture_url\": \"https://i.pinimg.com/564x/8d/e3/89/8de389c84e919d3577f47118e2627d95.jpg\",\n                \"program_id\": 1,\n                \"graduation_year\": 2022\n            }\n        }\n    ]\n}"}],"_postman_id":"76121422-b42b-4de9-bada-534ffdcd3998"},{"name":"Get All Connection Requests","id":"c41737be-2406-4dd3-a25d-b010870ee470","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{base_url}}/student-connections/requests?sender_erp=17855","description":"<h1 id=\"get-all-connection-requests\">Get all connection requests</h1>\n<h2 id=\"response\">Response</h2>\n<hr />\n<p>List of friend request details where each list item contains:</p>\n<ul>\n<li><code>sender_erp</code></li>\n<li><code>receiver_erp</code></li>\n<li><code>connection_status</code></li>\n<li><code>sent_at</code></li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{token}}"}]},"isInherited":true,"source":{"_postman_id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","name":"student connections","type":"collection"}},"urlObject":{"path":["student-connections","requests"],"host":["{{base_url}}"],"query":[{"key":"sender_erp","value":"17855"}],"variable":[]}},"response":[{"id":"2a491b3c-9217-4d48-b809-071578f1920d","name":"Mock Get All Connection Requests (Sent)","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{base_url}}/student-connections/requests?sender_erp=17855","host":["{{base_url}}"],"path":["student-connections","requests"],"query":[{"key":"sender_erp","value":"17855"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"230"},{"key":"ETag","value":"W/\"e6-55wczoE2vuOSLI6WtVL2lnheZl0\""},{"key":"Date","value":"Mon, 04 Oct 2021 18:13:10 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n    \"headers\": {\n        \"error\": 0,\n        \"message\": \"Success\"\n    },\n    \"body\": [\n        {\n            \"student_connection_id\": 5,\n            \"connection_status\": \"request_pending\",\n            \"sent_at\": \"2021-10-04 17:24:40\",\n            \"sender\": {\n                \"erp\": \"17855\",\n                \"first_name\": \"Abdur Rafay\",\n                \"last_name\": \"Saleem\",\n                \"profile_picture_url\": \"https://i.pinimg.com/564x/8d/e3/89/8de389c84e919d3577f47118e2627d95.jpg\",\n                \"program_id\": 1,\n                \"graduation_year\": 2022\n            },\n            \"receiver\": {\n                \"erp\": \"15030\",\n                \"first_name\": \"Mohammad Rafay\",\n                \"last_name\": \"Siddiqui\",\n                \"profile_picture_url\": \"https://i.pinimg.com/564x/8d/e3/89/8de389c84e919d3577f47118e2627d95.jpg\",\n                \"program_id\": 1,\n                \"graduation_year\": 2022\n            }\n        }\n    ]\n}"},{"id":"349ba575-e9c6-414d-b1b0-e864d4464af3","name":"Mock Get All Connection Requests (Received)","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{base_url}}/student-connections/requests?receiver_erp=17855","host":["{{base_url}}"],"path":["student-connections","requests"],"query":[{"key":"receiver_erp","value":"17855"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"230"},{"key":"ETag","value":"W/\"e6-55wczoE2vuOSLI6WtVL2lnheZl0\""},{"key":"Date","value":"Mon, 04 Oct 2021 18:13:10 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n    \"headers\": {\n        \"error\": 0,\n        \"message\": \"Success\"\n    },\n    \"body\": [\n        {\n            \"student_connection_id\": 9,\n            \"connection_status\": \"request_pending\",\n            \"sent_at\": \"2022-05-10 19:40:00\",\n            \"sender\": {\n                \"erp\": \"17847\",\n                \"first_name\": \"Bakhtawar\",\n                \"last_name\": \"Sharif\",\n                \"profile_picture_url\": \"https://i.pinimg.com/564x/8d/e3/89/8de389c84e919d3577f47118e2627d95.jpg\",\n                \"program_id\": 4,\n                \"graduation_year\": 2022\n            },\n            \"receiver\": {\n                \"erp\": \"17855\",\n                \"first_name\": \"Abdur Rafay\",\n                \"last_name\": \"Saleem\",\n                \"profile_picture_url\": \"https://i.pinimg.com/564x/8d/e3/89/8de389c84e919d3577f47118e2627d95.jpg\",\n                \"program_id\": 1,\n                \"graduation_year\": 2022\n            }\n        }\n    ]\n}"}],"_postman_id":"c41737be-2406-4dd3-a25d-b010870ee470"},{"name":"Add A Connection Request","id":"72c13019-a09f-4581-a40a-e640c7bedfc9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"sender_erp\":\"17855\",\r\n    \"receiver_erp\":\"15030\",\r\n    \"sent_at\":\"2021-10-04 17:24:40\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/student-connections","description":"<h1 id=\"add-a-new-connection-request\">Add a new connection request</h1>\n<h2 id=\"response\">Response</h2>\n<hr />\n<ul>\n<li><code>student_connection_id</code> New friend request's id.</li>\n<li><code>affected_rows</code> Should be 1.</li>\n</ul>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{token}}"}]},"isInherited":true,"source":{"_postman_id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","name":"student connections","type":"collection"}},"urlObject":{"path":["student-connections"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"88453efc-907b-4450-abac-7167206ad158","name":"Mock Add A Connection Request","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n    \"sender_erp\":\"17855\",\r\n    \"receiver_erp\":\"15030\",\r\n    \"sent_at\":\"2021-10-04 17:24:40\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/student-connections"},"status":"Created","code":201,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"116"},{"key":"ETag","value":"W/\"74-IN9FIzN0/OQ++H6qKUXRFUheZjw\""},{"key":"Date","value":"Mon, 04 Oct 2021 18:03:26 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n    \"headers\": {\n        \"error\": 0,\n        \"message\": \"Friend request was created!\"\n    },\n    \"body\": {\n        \"student_connection_id\": 4,\n        \"affected_rows\": 1\n    }\n}"}],"_postman_id":"72c13019-a09f-4581-a40a-e640c7bedfc9"},{"name":"Update A Connection Request","id":"91ca06fb-2ea7-40e9-bd78-c3e000c6c7f4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{admin_token}}"}]},"isInherited":false},"method":"PATCH","header":[],"body":{"mode":"raw","raw":"{\r\n    \"connection_status\": \"friends\",\r\n    \"accepted_at\": \"2021-10-04 17:24:40\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/student-connections/4","description":"<h1 id=\"update-details-of-a-connection-request\">Update details of a connection request</h1>\n<h2 id=\"response\">Response</h2>\n<hr />\n<ul>\n<li>rows_matched</li>\n<li>rows_changed</li>\n<li>info</li>\n</ul>\n<p><em><strong>Note</strong></em> : <code>message</code> header indicates result.</p>\n","urlObject":{"path":["student-connections","4"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"f5079fe1-fc8d-43a9-93ae-1bd32f2f42b6","name":"Mock Update A Connection Request","originalRequest":{"method":"PATCH","header":[],"body":{"mode":"raw","raw":"{\r\n    \"connection_status\": \"friends\",\r\n    \"accepted_at\": \"2021-10-04 17:24:40\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{base_url}}/student-connections/4"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"164"},{"key":"ETag","value":"W/\"a4-gQbfnumuMHW8Op5DFP0wtWqalHA\""},{"key":"Date","value":"Mon, 04 Oct 2021 18:09:21 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n    \"headers\": {\n        \"error\": 0,\n        \"message\": \"Friend request updated successfully\"\n    },\n    \"body\": {\n        \"rows_matched\": 1,\n        \"rows_changed\": 1,\n        \"info\": \"Rows matched: 1  Changed: 1  Warnings: 0\"\n    }\n}"}],"_postman_id":"91ca06fb-2ea7-40e9-bd78-c3e000c6c7f4"},{"name":"Delete A Connection Request","id":"bcc22328-9120-4ff3-8153-0b8468933dc9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"{{base_url}}/student-connections/4","description":"<h1 id=\"delete-a-student-connection\">Delete a student connection</h1>\n<h2 id=\"response\">Response</h2>\n<hr />\n<ul>\n<li>rows_removed</li></ul>\n\n<p><em><strong>Note</strong></em> : <code>message</code> header indicates result.</p>\n","auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{token}}"}]},"isInherited":true,"source":{"_postman_id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","id":"e8717c98-79ec-45a1-bfb0-378a8d3a0faf","name":"student connections","type":"collection"}},"urlObject":{"path":["student-connections","4"],"host":["{{base_url}}"],"query":[],"variable":[]}},"response":[{"id":"14dc6c3c-a9ac-4b4e-a9c0-36a667f281c2","name":"Mock Delete A Connection Request","originalRequest":{"method":"DELETE","header":[],"url":"{{base_url}}/student-connections/4"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-Powered-By","value":"Express"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"93"},{"key":"ETag","value":"W/\"5d-sSYPtKqhj1T3mgTDxiJqdOsty+A\""},{"key":"Date","value":"Mon, 04 Oct 2021 18:20:59 GMT"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=5"}],"cookie":[],"responseTime":null,"body":"{\n    \"headers\": {\n        \"error\": 0,\n        \"message\": \"Friend request has been deleted\"\n    },\n    \"body\": {\n        \"rows_removed\": 1\n    }\n}"}],"_postman_id":"bcc22328-9120-4ff3-8153-0b8468933dc9"}],"auth":{"type":"bearer","bearer":{"basicConfig":[{"key":"token","value":"{{token}}"}]}},"event":[{"listen":"prerequest","script":{"id":"babc434b-35bf-40f9-b567-c47a902835e0","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"0006f96f-80b7-4611-8466-2d9d86f36828","type":"text/javascript","exec":[""]}}]}