This API will connect to the MySQL instance that is running on the Google Cloud Server instance. You can use it to add and remove businesses, as well as reviews for those businesses.
\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Overview","slug":"overview"}],"owner":"14673689","collectionId":"157109df-4020-4af3-a56c-cbb34c88289f","publishedId":"TWDdiYic","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2021-02-28T15:23:15.000Z"},"item":[{"name":"POST Business","id":"5c5e3e99-71f4-4adf-9f5b-cbf2f206bfdc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"url":"{{url}}/business?name=Study Hall&county=Pickens&state=SC","description":"This request can be used to add a business to the table. When succesfully executed, it will return the business ID of the new business.
\n","urlObject":{"path":["business"],"host":["{{url}}"],"query":[{"description":{"content":"The name of the business.
\n","type":"text/plain"},"key":"name","value":"Study Hall"},{"description":{"content":"The name of the county.
\n","type":"text/plain"},"key":"county","value":"Pickens"},{"description":{"content":"The state the business is in.
\n","type":"text/plain"},"key":"state","value":"SC"}],"variable":[]}},"response":[],"_postman_id":"5c5e3e99-71f4-4adf-9f5b-cbf2f206bfdc"},{"name":"GET All Businesses","id":"23571056-3ac1-41b8-b19c-911b1d02ece9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{url}}/business","description":"This request can be used to get an array of all the businesses in our database.
\n","urlObject":{"path":["business"],"host":["{{url}}"],"query":[],"variable":[]}},"response":[],"_postman_id":"23571056-3ac1-41b8-b19c-911b1d02ece9"},{"name":"GET Business Reviews","id":"9441c21a-8a1b-42e3-a156-3737d346cc01","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{url}}/businessReview","description":"This request can be used to get an array of all the business reviews in our database.
\n","urlObject":{"path":["businessReview"],"host":["{{url}}"],"query":[],"variable":[]}},"response":[],"_postman_id":"9441c21a-8a1b-42e3-a156-3737d346cc01"},{"name":"Post Business Review","id":"20494d73-9fa6-40c9-a1b4-2a70956084ac","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"url":"{{url}}/businessReview?businessId=1&socialDistance=1&busy=1&pickupOptions=1&reviewText=They are constantly busy.","description":"This request can be used to add a business review to our database.
\n","urlObject":{"path":["businessReview"],"host":["{{url}}"],"query":[{"description":{"content":"The business ID
\n","type":"text/plain"},"key":"businessId","value":"1"},{"description":{"content":"Binary indicator of whether they social distance customers.
\n","type":"text/plain"},"key":"socialDistance","value":"1"},{"description":{"content":"Binary indicator of whether they are typically crowded/busy.
\n","type":"text/plain"},"key":"busy","value":"1"},{"description":{"content":"Binary indicator of whether they offer pickup options.
\n","type":"text/plain"},"key":"pickupOptions","value":"1"},{"description":{"content":"String that includes a more detailed review of the business.
\n","type":"text/plain"},"key":"reviewText","value":"They are constantly busy."}],"variable":[]}},"response":[],"_postman_id":"20494d73-9fa6-40c9-a1b4-2a70956084ac"},{"name":"Get Specific Business","id":"721be1a8-d934-46cf-9c77-ad11adf54210","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{url}}/business/:business_id","description":"This will return all of the information associated with a specific business.
\n","urlObject":{"path":["business",":business_id"],"host":["{{url}}"],"query":[],"variable":[{"description":{"content":"The id of the business you want to receive information for.
\n","type":"text/plain"},"type":"any","value":"","key":"business_id"}]}},"response":[],"_postman_id":"721be1a8-d934-46cf-9c77-ad11adf54210"},{"name":"Get Reviews for Specific Business","id":"ffc98963-70c3-4a9d-936e-8a29ec7a6f25","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{url}}/businessReview/:business_id","description":"This will return all of the reviews associated with a specific business.
\n","urlObject":{"path":["businessReview",":business_id"],"host":["{{url}}"],"query":[],"variable":[{"type":"any","value":"","key":"business_id"}]}},"response":[],"_postman_id":"ffc98963-70c3-4a9d-936e-8a29ec7a6f25"}]}