{"info":{"_postman_id":"1fe3ee89-06c1-4b6b-8abb-97b2308d3cbd","name":"NORTHWIND_DATAGROKR_ASSIGNMENT","description":"

Northwind Database RESTful API

\n
This API is part of a assignment task regarding internship@ DataGrokr.
\n

API to perform CURD operations on the Northwind Database.\nThis API uses Northwind MySQL database server deploed on AWS Cloud Platform.

#baseroute(/)\n\nhttp://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/\n

\n
I am available at LinkedIn. Find my work at GitHub
\n

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Northwind Database RESTful API","slug":"northwind-database-restful-api"}],"owner":"12122001","collectionId":"1fe3ee89-06c1-4b6b-8abb-97b2308d3cbd","publishedId":"T1DnidZm","public":true,"customColor":{"top-bar":"303030","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2020-07-22T16:42:24.000Z"},"item":[{"name":"Select all Products","id":"03816d73-4d89-482a-a720-21774204ec75","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/products","description":"

Lists all the product entries in the Northwind Database Products table

\n","urlObject":{"protocol":"http","port":"5000","path":["products"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"8912d3a8-47a1-4408-ac1f-259a0f7f2dcd","name":"Select all Products","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","description":"Lists all the entries in Products table","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/products"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"22141"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:05:57 GMT"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 1,\n \"ProductName\": \"Chai\",\n \"QuantityPerUnit\": \"10 boxes x 20 bags\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 1,\n \"UnitPrice\": \"18.0000\",\n \"UnitsInStock\": 39,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 2,\n \"ProductName\": \"Chang\",\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 1,\n \"UnitPrice\": \"19.0000\",\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 40\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 3,\n \"ProductName\": \"Aniseed Syrup\",\n \"QuantityPerUnit\": \"12 - 550 ml bottles\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 1,\n \"UnitPrice\": \"10.0000\",\n \"UnitsInStock\": 13,\n \"UnitsOnOrder\": 70\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 4,\n \"ProductName\": \"Chef Anton's Cajun Seasoning\",\n \"QuantityPerUnit\": \"48 - 6 oz jars\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 2,\n \"UnitPrice\": \"22.0000\",\n \"UnitsInStock\": 53,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 1,\n \"ProductID\": 5,\n \"ProductName\": \"Chef Anton's Gumbo Mix\",\n \"QuantityPerUnit\": \"36 boxes\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 2,\n \"UnitPrice\": \"21.3500\",\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 6,\n \"ProductName\": \"Grandma's Boysenberry Spread\",\n \"QuantityPerUnit\": \"12 - 8 oz jars\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 3,\n \"UnitPrice\": \"25.0000\",\n \"UnitsInStock\": 120,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 7,\n \"Discontinued\": 0,\n \"ProductID\": 7,\n \"ProductName\": \"Uncle Bob's Organic Dried Pears\",\n \"QuantityPerUnit\": \"12 - 1 lb pkgs.\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 3,\n \"UnitPrice\": \"30.0000\",\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 8,\n \"ProductName\": \"Northwoods Cranberry Sauce\",\n \"QuantityPerUnit\": \"12 - 12 oz jars\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 3,\n \"UnitPrice\": \"40.0000\",\n \"UnitsInStock\": 6,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 6,\n \"Discontinued\": 1,\n \"ProductID\": 9,\n \"ProductName\": \"Mishi Kobe Niku\",\n \"QuantityPerUnit\": \"18 - 500 g pkgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 4,\n \"UnitPrice\": \"97.0000\",\n \"UnitsInStock\": 29,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 10,\n \"ProductName\": \"Ikura\",\n \"QuantityPerUnit\": \"12 - 200 ml jars\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 4,\n \"UnitPrice\": \"31.0000\",\n \"UnitsInStock\": 31,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 11,\n \"ProductName\": \"Queso Cabrales\",\n \"QuantityPerUnit\": \"1 kg pkg.\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 5,\n \"UnitPrice\": \"21.0000\",\n \"UnitsInStock\": 22,\n \"UnitsOnOrder\": 30\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 12,\n \"ProductName\": \"Queso Manchego La Pastora\",\n \"QuantityPerUnit\": \"10 - 500 g pkgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 5,\n \"UnitPrice\": \"38.0000\",\n \"UnitsInStock\": 86,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 13,\n \"ProductName\": \"Konbu\",\n \"QuantityPerUnit\": \"2 kg box\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 6,\n \"UnitPrice\": \"6.0000\",\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 7,\n \"Discontinued\": 0,\n \"ProductID\": 14,\n \"ProductName\": \"Tofu\",\n \"QuantityPerUnit\": \"40 - 100 g pkgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 6,\n \"UnitPrice\": \"23.2500\",\n \"UnitsInStock\": 35,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 15,\n \"ProductName\": \"Genen Shouyu\",\n \"QuantityPerUnit\": \"24 - 250 ml bottles\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 6,\n \"UnitPrice\": \"15.5000\",\n \"UnitsInStock\": 39,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 16,\n \"ProductName\": \"Pavlova\",\n \"QuantityPerUnit\": \"32 - 500 g boxes\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 7,\n \"UnitPrice\": \"17.4500\",\n \"UnitsInStock\": 29,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 6,\n \"Discontinued\": 1,\n \"ProductID\": 17,\n \"ProductName\": \"Alice Mutton\",\n \"QuantityPerUnit\": \"20 - 1 kg tins\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 7,\n \"UnitPrice\": \"39.0000\",\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 18,\n \"ProductName\": \"Carnarvon Tigers\",\n \"QuantityPerUnit\": \"16 kg pkg.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 7,\n \"UnitPrice\": \"62.5000\",\n \"UnitsInStock\": 42,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 19,\n \"ProductName\": \"Teatime Chocolate Biscuits\",\n \"QuantityPerUnit\": \"10 boxes x 12 pieces\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 8,\n \"UnitPrice\": \"9.2000\",\n \"UnitsInStock\": 25,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 20,\n \"ProductName\": \"Sir Rodney's Marmalade\",\n \"QuantityPerUnit\": \"30 gift boxes\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 8,\n \"UnitPrice\": \"81.0000\",\n \"UnitsInStock\": 40,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 21,\n \"ProductName\": \"Sir Rodney's Scones\",\n \"QuantityPerUnit\": \"24 pkgs. x 4 pieces\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 8,\n \"UnitPrice\": \"10.0000\",\n \"UnitsInStock\": 3,\n \"UnitsOnOrder\": 40\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 0,\n \"ProductID\": 22,\n \"ProductName\": \"Gustaf's KnÃ¤ckebrÃ¶d\",\n \"QuantityPerUnit\": \"24 - 500 g pkgs.\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 9,\n \"UnitPrice\": \"21.0000\",\n \"UnitsInStock\": 104,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 0,\n \"ProductID\": 23,\n \"ProductName\": \"TunnbrÃ¶d\",\n \"QuantityPerUnit\": \"12 - 250 g pkgs.\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 9,\n \"UnitPrice\": \"9.0000\",\n \"UnitsInStock\": 61,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 1,\n \"ProductID\": 24,\n \"ProductName\": \"GuaranÃ¡ FantÃ¡stica\",\n \"QuantityPerUnit\": \"12 - 355 ml cans\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 10,\n \"UnitPrice\": \"4.5000\",\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 25,\n \"ProductName\": \"NuNuCa NuÃŸ-Nougat-Creme\",\n \"QuantityPerUnit\": \"20 - 450 g glasses\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 11,\n \"UnitPrice\": \"14.0000\",\n \"UnitsInStock\": 76,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 26,\n \"ProductName\": \"GumbÃ¤r GummibÃ¤rchen\",\n \"QuantityPerUnit\": \"100 - 250 g bags\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 11,\n \"UnitPrice\": \"31.2300\",\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 27,\n \"ProductName\": \"Schoggi Schokolade\",\n \"QuantityPerUnit\": \"100 - 100 g pieces\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 11,\n \"UnitPrice\": \"43.9000\",\n \"UnitsInStock\": 49,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 7,\n \"Discontinued\": 1,\n \"ProductID\": 28,\n \"ProductName\": \"RÃ¶ssle Sauerkraut\",\n \"QuantityPerUnit\": \"25 - 825 g cans\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 12,\n \"UnitPrice\": \"45.6000\",\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 6,\n \"Discontinued\": 1,\n \"ProductID\": 29,\n \"ProductName\": \"ThÃ¼ringer Rostbratwurst\",\n \"QuantityPerUnit\": \"50 bags x 30 sausgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 12,\n \"UnitPrice\": \"123.7900\",\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 30,\n \"ProductName\": \"Nord-Ost Matjeshering\",\n \"QuantityPerUnit\": \"10 - 200 g glasses\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 13,\n \"UnitPrice\": \"25.8900\",\n \"UnitsInStock\": 10,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 31,\n \"ProductName\": \"Gorgonzola Telino\",\n \"QuantityPerUnit\": \"12 - 100 g pkgs\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 14,\n \"UnitPrice\": \"12.5000\",\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 70\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 32,\n \"ProductName\": \"Mascarpone Fabioli\",\n \"QuantityPerUnit\": \"24 - 200 g pkgs.\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 14,\n \"UnitPrice\": \"32.0000\",\n \"UnitsInStock\": 9,\n \"UnitsOnOrder\": 40\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 33,\n \"ProductName\": \"Geitost\",\n \"QuantityPerUnit\": \"500 g\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 15,\n \"UnitPrice\": \"2.5000\",\n \"UnitsInStock\": 112,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 34,\n \"ProductName\": \"Sasquatch Ale\",\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 16,\n \"UnitPrice\": \"14.0000\",\n \"UnitsInStock\": 111,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 35,\n \"ProductName\": \"Steeleye Stout\",\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 16,\n \"UnitPrice\": \"18.0000\",\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 36,\n \"ProductName\": \"Inlagd Sill\",\n \"QuantityPerUnit\": \"24 - 250 g jars\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 17,\n \"UnitPrice\": \"19.0000\",\n \"UnitsInStock\": 112,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 37,\n \"ProductName\": \"Gravad lax\",\n \"QuantityPerUnit\": \"12 - 500 g pkgs.\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 17,\n \"UnitPrice\": \"26.0000\",\n \"UnitsInStock\": 11,\n \"UnitsOnOrder\": 50\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 38,\n \"ProductName\": \"CÃ´te de Blaye\",\n \"QuantityPerUnit\": \"12 - 75 cl bottles\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 18,\n \"UnitPrice\": \"263.5000\",\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 39,\n \"ProductName\": \"Chartreuse verte\",\n \"QuantityPerUnit\": \"750 cc per bottle\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 18,\n \"UnitPrice\": \"18.0000\",\n \"UnitsInStock\": 69,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 40,\n \"ProductName\": \"Boston Crab Meat\",\n \"QuantityPerUnit\": \"24 - 4 oz tins\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 19,\n \"UnitPrice\": \"18.4000\",\n \"UnitsInStock\": 123,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 41,\n \"ProductName\": \"Jack's New England Clam Chowder\",\n \"QuantityPerUnit\": \"12 - 12 oz cans\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 19,\n \"UnitPrice\": \"9.6500\",\n \"UnitsInStock\": 85,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 1,\n \"ProductID\": 42,\n \"ProductName\": \"Singaporean Hokkien Fried Mee\",\n \"QuantityPerUnit\": \"32 - 1 kg pkgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 20,\n \"UnitPrice\": \"14.0000\",\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 43,\n \"ProductName\": \"Ipoh Coffee\",\n \"QuantityPerUnit\": \"16 - 500 g tins\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 20,\n \"UnitPrice\": \"46.0000\",\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 10\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 44,\n \"ProductName\": \"Gula Malacca\",\n \"QuantityPerUnit\": \"20 - 2 kg bags\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 20,\n \"UnitPrice\": \"19.4500\",\n \"UnitsInStock\": 27,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 45,\n \"ProductName\": \"Rogede sild\",\n \"QuantityPerUnit\": \"1k pkg.\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 21,\n \"UnitPrice\": \"9.5000\",\n \"UnitsInStock\": 5,\n \"UnitsOnOrder\": 70\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 46,\n \"ProductName\": \"Spegesild\",\n \"QuantityPerUnit\": \"4 - 450 g glasses\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 21,\n \"UnitPrice\": \"12.0000\",\n \"UnitsInStock\": 95,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 47,\n \"ProductName\": \"Zaanse koeken\",\n \"QuantityPerUnit\": \"10 - 4 oz boxes\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 22,\n \"UnitPrice\": \"9.5000\",\n \"UnitsInStock\": 36,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 48,\n \"ProductName\": \"Chocolade\",\n \"QuantityPerUnit\": \"10 pkgs.\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 22,\n \"UnitPrice\": \"12.7500\",\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 70\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 49,\n \"ProductName\": \"Maxilaku\",\n \"QuantityPerUnit\": \"24 - 50 g pkgs.\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 23,\n \"UnitPrice\": \"20.0000\",\n \"UnitsInStock\": 10,\n \"UnitsOnOrder\": 60\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 50,\n \"ProductName\": \"Valkoinen suklaa\",\n \"QuantityPerUnit\": \"12 - 100 g bars\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 23,\n \"UnitPrice\": \"16.2500\",\n \"UnitsInStock\": 65,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 7,\n \"Discontinued\": 0,\n \"ProductID\": 51,\n \"ProductName\": \"Manjimup Dried Apples\",\n \"QuantityPerUnit\": \"50 - 300 g pkgs.\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 24,\n \"UnitPrice\": \"53.0000\",\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 0,\n \"ProductID\": 52,\n \"ProductName\": \"Filo Mix\",\n \"QuantityPerUnit\": \"16 - 2 kg boxes\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 24,\n \"UnitPrice\": \"7.0000\",\n \"UnitsInStock\": 38,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 6,\n \"Discontinued\": 1,\n \"ProductID\": 53,\n \"ProductName\": \"Perth Pasties\",\n \"QuantityPerUnit\": \"48 pieces\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 24,\n \"UnitPrice\": \"32.8000\",\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"ProductID\": 54,\n \"ProductName\": \"TourtiÃ¨re\",\n \"QuantityPerUnit\": \"16 pies\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 25,\n \"UnitPrice\": \"7.4500\",\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"ProductID\": 55,\n \"ProductName\": \"PÃ¢tÃ© chinois\",\n \"QuantityPerUnit\": \"24 boxes x 2 pies\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 25,\n \"UnitPrice\": \"24.0000\",\n \"UnitsInStock\": 115,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 0,\n \"ProductID\": 56,\n \"ProductName\": \"Gnocchi di nonna Alice\",\n \"QuantityPerUnit\": \"24 - 250 g pkgs.\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 26,\n \"UnitPrice\": \"38.0000\",\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 10\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 0,\n \"ProductID\": 57,\n \"ProductName\": \"Ravioli Angelo\",\n \"QuantityPerUnit\": \"24 - 250 g pkgs.\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 26,\n \"UnitPrice\": \"19.5000\",\n \"UnitsInStock\": 36,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 58,\n \"ProductName\": \"Escargots de Bourgogne\",\n \"QuantityPerUnit\": \"24 pieces\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 27,\n \"UnitPrice\": \"13.2500\",\n \"UnitsInStock\": 62,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 59,\n \"ProductName\": \"Raclette Courdavault\",\n \"QuantityPerUnit\": \"5 kg pkg.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 28,\n \"UnitPrice\": \"55.0000\",\n \"UnitsInStock\": 79,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 60,\n \"ProductName\": \"Camembert Pierrot\",\n \"QuantityPerUnit\": \"15 - 300 g rounds\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 28,\n \"UnitPrice\": \"34.0000\",\n \"UnitsInStock\": 19,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 61,\n \"ProductName\": \"Sirop d'Ã©rable\",\n \"QuantityPerUnit\": \"24 - 500 ml bottles\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 29,\n \"UnitPrice\": \"28.5000\",\n \"UnitsInStock\": 113,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 62,\n \"ProductName\": \"Tarte au sucre\",\n \"QuantityPerUnit\": \"48 pies\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 29,\n \"UnitPrice\": \"49.3000\",\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 63,\n \"ProductName\": \"Vegie-spread\",\n \"QuantityPerUnit\": \"15 - 625 g jars\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 7,\n \"UnitPrice\": \"43.9000\",\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 5,\n \"Discontinued\": 0,\n \"ProductID\": 64,\n \"ProductName\": \"Wimmers gute SemmelknÃ¶del\",\n \"QuantityPerUnit\": \"20 bags x 4 pieces\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 12,\n \"UnitPrice\": \"33.2500\",\n \"UnitsInStock\": 22,\n \"UnitsOnOrder\": 80\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 65,\n \"ProductName\": \"Louisiana Fiery Hot Pepper Sauce\",\n \"QuantityPerUnit\": \"32 - 8 oz bottles\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 2,\n \"UnitPrice\": \"21.0500\",\n \"UnitsInStock\": 76,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 66,\n \"ProductName\": \"Louisiana Hot Spiced Okra\",\n \"QuantityPerUnit\": \"24 - 8 oz jars\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 2,\n \"UnitPrice\": \"17.0000\",\n \"UnitsInStock\": 4,\n \"UnitsOnOrder\": 100\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 67,\n \"ProductName\": \"Laughing Lumberjack Lager\",\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"ReorderLevel\": 10,\n \"SupplierID\": 16,\n \"UnitPrice\": \"14.0000\",\n \"UnitsInStock\": 52,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 3,\n \"Discontinued\": 0,\n \"ProductID\": 68,\n \"ProductName\": \"Scottish Longbreads\",\n \"QuantityPerUnit\": \"10 boxes x 8 pieces\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 8,\n \"UnitPrice\": \"12.5000\",\n \"UnitsInStock\": 6,\n \"UnitsOnOrder\": 10\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 69,\n \"ProductName\": \"Gudbrandsdalsost\",\n \"QuantityPerUnit\": \"10 kg pkg.\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 15,\n \"UnitPrice\": \"36.0000\",\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 70,\n \"ProductName\": \"Outback Lager\",\n \"QuantityPerUnit\": \"24 - 355 ml bottles\",\n \"ReorderLevel\": 30,\n \"SupplierID\": 7,\n \"UnitPrice\": \"15.0000\",\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 10\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 71,\n \"ProductName\": \"Flotemysost\",\n \"QuantityPerUnit\": \"10 - 500 g pkgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 15,\n \"UnitPrice\": \"21.5000\",\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 4,\n \"Discontinued\": 0,\n \"ProductID\": 72,\n \"ProductName\": \"Mozzarella di Giovanni\",\n \"QuantityPerUnit\": \"24 - 200 g pkgs.\",\n \"ReorderLevel\": 0,\n \"SupplierID\": 14,\n \"UnitPrice\": \"34.8000\",\n \"UnitsInStock\": 14,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 8,\n \"Discontinued\": 0,\n \"ProductID\": 73,\n \"ProductName\": \"RÃ¶d Kaviar\",\n \"QuantityPerUnit\": \"24 - 150 g jars\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 17,\n \"UnitPrice\": \"15.0000\",\n \"UnitsInStock\": 101,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 7,\n \"Discontinued\": 0,\n \"ProductID\": 74,\n \"ProductName\": \"Longlife Tofu\",\n \"QuantityPerUnit\": \"5 kg pkg.\",\n \"ReorderLevel\": 5,\n \"SupplierID\": 4,\n \"UnitPrice\": \"10.0000\",\n \"UnitsInStock\": 4,\n \"UnitsOnOrder\": 20\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 75,\n \"ProductName\": \"RhÃ¶nbrÃ¤u Klosterbier\",\n \"QuantityPerUnit\": \"24 - 0.5 l bottles\",\n \"ReorderLevel\": 25,\n \"SupplierID\": 12,\n \"UnitPrice\": \"7.7500\",\n \"UnitsInStock\": 125,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 1,\n \"Discontinued\": 0,\n \"ProductID\": 76,\n \"ProductName\": \"LakkalikÃ¶Ã¶ri\",\n \"QuantityPerUnit\": \"500 ml\",\n \"ReorderLevel\": 20,\n \"SupplierID\": 23,\n \"UnitPrice\": \"18.0000\",\n \"UnitsInStock\": 57,\n \"UnitsOnOrder\": 0\n },\n {\n \"CategoryID\": 2,\n \"Discontinued\": 0,\n \"ProductID\": 77,\n \"ProductName\": \"Original Frankfurter grÃ¼ne SoÃŸe\",\n \"QuantityPerUnit\": \"12 boxes\",\n \"ReorderLevel\": 15,\n \"SupplierID\": 12,\n \"UnitPrice\": \"13.0000\",\n \"UnitsInStock\": 32,\n \"UnitsOnOrder\": 0\n }\n]"}],"_postman_id":"03816d73-4d89-482a-a720-21774204ec75"},{"name":"Create an entry into Products","id":"ff95c18c-4dad-4361-8746-b0f7d96cda11","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"ProductID\": 101,\n \"ProductName\": \"New Product\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"QuantityPerUnit\": \"19 pies\",\n \"UnitPrice\": 17.45,\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10\n}\n"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/add","description":"

Adds an entry into the Northwind Database Products table

\n
Provide all the fields as in Product table schema. Refer to the example for better understanding.
\n

\n","urlObject":{"protocol":"http","port":"5000","path":["product","add"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"08078321-a4af-4bb5-9238-1d376804a128","name":"Create an entry into Products","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json","description":"Add all the required fields as present in the Products table schema\n","type":"text"}],"body":{"mode":"raw","raw":"{\n \"ProductID\": 101,\n \"ProductName\": \"New Product\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"QuantityPerUnit\": \"19 pies\",\n \"UnitPrice\": 17.45,\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10\n}\n"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/add"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Content-Length","value":"26"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:17:24 GMT"}],"cookie":[],"responseTime":null,"body":"Successfully added product"}],"_postman_id":"ff95c18c-4dad-4361-8746-b0f7d96cda11"},{"name":"Update an entry in Products","id":"f09990d7-a12f-4b12-b152-1bb7ed58b480","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\n \"ProductID\": 101,\n \"ProductName\": \"New Product Updated\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"QuantityPerUnit\": \"19 pies\",\n \"UnitPrice\": 20.75,\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 1,\n \"ReorderLevel\": 12\n}\n"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/update/101","description":"

Update a specific entry in Products

\n
Select the Product to be update by using ProductID and then provide all the fields in schema for a successful update. Refer the example for better understanding.
\n

\n","urlObject":{"protocol":"http","port":"5000","path":["product","update","101"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"a50965c8-8f5a-4327-a727-8da088224bcf","name":"Update an entry in Products","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json","description":"Use id to list the product, then provide the details to be updated.","type":"text"}],"body":{"mode":"raw","raw":"{\n \"ProductID\": 101,\n \"ProductName\": \"New Product Updated\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"QuantityPerUnit\": \"19 pies\",\n \"UnitPrice\": 20.75,\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 1,\n \"ReorderLevel\": 12\n}\n"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/update/101"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"255"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:18:32 GMT"}],"cookie":[],"responseTime":null,"body":"{\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"ProductID\": 101,\n \"ProductName\": \"New Product Updated\",\n \"QuantityPerUnit\": \"19 pies\",\n \"ReorderLevel\": 12,\n \"SupplierID\": 25,\n \"UnitPrice\": \"20.7500\",\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 1\n}"}],"_postman_id":"f09990d7-a12f-4b12-b152-1bb7ed58b480"},{"name":"Select a specific Product entry by ProductID","id":"808720ff-e727-46b9-befa-7425736f2122","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/101","description":"

List a particular product in Products table of Northwind Database using the ProductID

\n","urlObject":{"protocol":"http","port":"5000","path":["product","101"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"b37edd9a-ef69-482e-9d8c-52029ed1d98c","name":"Select a specific Product entry by ProductID","originalRequest":{"method":"GET","header":[],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/101"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"255"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:21:56 GMT"}],"cookie":[],"responseTime":null,"body":"{\n \"CategoryID\": 6,\n \"Discontinued\": 0,\n \"ProductID\": 101,\n \"ProductName\": \"New Product Updated\",\n \"QuantityPerUnit\": \"19 pies\",\n \"ReorderLevel\": 12,\n \"SupplierID\": 25,\n \"UnitPrice\": \"20.7500\",\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 1\n}"}],"_postman_id":"808720ff-e727-46b9-befa-7425736f2122"},{"name":"Delete an entry in Products","id":"7374e628-86ee-4689-9e29-eee8133c8515","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/remove/101","description":"

Delete a product entry by referencing it with ProductID

\n","urlObject":{"protocol":"http","port":"5000","path":["product","remove","101"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"8c055fb4-0087-4e4e-b7e4-bc6387d472f2","name":"Delete an entry in Products","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json","description":"Deletes record referenced by ProductID\n","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/product/remove/101"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Content-Length","value":"28"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:30:22 GMT"}],"cookie":[],"responseTime":null,"body":"Deleted Product Successfully"}],"_postman_id":"7374e628-86ee-4689-9e29-eee8133c8515"},{"name":"Select all Customers","id":"8dbde504-e3a0-4f44-b137-1288044af963","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customers","description":"

Lists all the customer entries in the Northwind Database Customers table

\n","urlObject":{"protocol":"http","port":"5000","path":["customers"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"67094677-86a3-400e-86b8-53d846496aca","name":"Select all Customers","originalRequest":{"method":"GET","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customers"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"33009"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:34:34 GMT"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"Address\": \"Obere Str. 57\",\n \"City\": \"Berlin\",\n \"CompanyName\": \"Alfreds Futterkiste\",\n \"ContactName\": \"Maria Anders\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"ALFKI\",\n \"Fax\": \"030-0076545\",\n \"Phone\": \"030-0074321\",\n \"PostalCode\": \"12209\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Avda. de la ConstituciÃ³n 2222\",\n \"City\": \"MÃ©xico D.F.\",\n \"CompanyName\": \"Ana Trujillo Emparedados y helados\",\n \"ContactName\": \"Ana Trujillo\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Mexico\",\n \"CustomerID\": \"ANATR\",\n \"Fax\": \"(5) 555-3745\",\n \"Phone\": \"(5) 555-4729\",\n \"PostalCode\": \"05021\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Mataderos 2312\",\n \"City\": \"MÃ©xico D.F.\",\n \"CompanyName\": \"Antonio Moreno TaquerÃ\\u00ada\",\n \"ContactName\": \"Antonio Moreno\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Mexico\",\n \"CustomerID\": \"ANTON\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(5) 555-3932\",\n \"PostalCode\": \"05023\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"120 Hanover Sq.\",\n \"City\": \"London\",\n \"CompanyName\": \"Around the Horn\",\n \"ContactName\": \"Thomas Hardy\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"UK\",\n \"CustomerID\": \"AROUT\",\n \"Fax\": \"(171) 555-6750\",\n \"Phone\": \"(171) 555-7788\",\n \"PostalCode\": \"WA1 1DP\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"BerguvsvÃ¤gen 8\",\n \"City\": \"LuleÃ¥\",\n \"CompanyName\": \"Berglunds snabbkÃ¶p\",\n \"ContactName\": \"Christina Berglund\",\n \"ContactTitle\": \"Order Administrator\",\n \"Country\": \"Sweden\",\n \"CustomerID\": \"BERGS\",\n \"Fax\": \"0921-12 34 67\",\n \"Phone\": \"0921-12 34 65\",\n \"PostalCode\": \"S-958 22\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Forsterstr. 57\",\n \"City\": \"Mannheim\",\n \"CompanyName\": \"Blauer See Delikatessen\",\n \"ContactName\": \"Hanna Moos\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"BLAUS\",\n \"Fax\": \"0621-08924\",\n \"Phone\": \"0621-08460\",\n \"PostalCode\": \"68306\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"24 place KlÃ©ber\",\n \"City\": \"Strasbourg\",\n \"CompanyName\": \"Blondesddsl pÃ¨re et fils\",\n \"ContactName\": \"FrÃ©dÃ©rique Citeaux\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"France\",\n \"CustomerID\": \"BLONP\",\n \"Fax\": \"88.60.15.32\",\n \"Phone\": \"88.60.15.31\",\n \"PostalCode\": \"67000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"C/ Araquil 67\",\n \"City\": \"Madrid\",\n \"CompanyName\": \"BÃ³lido Comidas preparadas\",\n \"ContactName\": \"MartÃ\\u00adn Sommer\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Spain\",\n \"CustomerID\": \"BOLID\",\n \"Fax\": \"(91) 555 91 99\",\n \"Phone\": \"(91) 555 22 82\",\n \"PostalCode\": \"28023\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"12 rue des Bouchers\",\n \"City\": \"Marseille\",\n \"CompanyName\": \"Bon app'\",\n \"ContactName\": \"Laurence Lebihan\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"France\",\n \"CustomerID\": \"BONAP\",\n \"Fax\": \"91.24.45.41\",\n \"Phone\": \"91.24.45.40\",\n \"PostalCode\": \"13008\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"23 Tsawassen Blvd.\",\n \"City\": \"Tsawassen\",\n \"CompanyName\": \"Bottom-Dollar Markets\",\n \"ContactName\": \"Elizabeth Lincoln\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Canada\",\n \"CustomerID\": \"BOTTM\",\n \"Fax\": \"(604) 555-3745\",\n \"Phone\": \"(604) 555-4729\",\n \"PostalCode\": \"T2F 8M4\",\n \"Region\": \"BC\"\n },\n {\n \"Address\": \"Fauntleroy Circus\",\n \"City\": \"London\",\n \"CompanyName\": \"B's Beverages\",\n \"ContactName\": \"Victoria Ashworth\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"UK\",\n \"CustomerID\": \"BSBEV\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(171) 555-1212\",\n \"PostalCode\": \"EC2 5NT\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Cerrito 333\",\n \"City\": \"Buenos Aires\",\n \"CompanyName\": \"Cactus Comidas para llevar\",\n \"ContactName\": \"Patricio Simpson\",\n \"ContactTitle\": \"Sales Agent\",\n \"Country\": \"Argentina\",\n \"CustomerID\": \"CACTU\",\n \"Fax\": \"(1) 135-4892\",\n \"Phone\": \"(1) 135-5555\",\n \"PostalCode\": \"1010\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Sierras de Granada 9993\",\n \"City\": \"MÃ©xico D.F.\",\n \"CompanyName\": \"Centro comercial Moctezuma\",\n \"ContactName\": \"Francisco Chang\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"Mexico\",\n \"CustomerID\": \"CENTC\",\n \"Fax\": \"(5) 555-7293\",\n \"Phone\": \"(5) 555-3392\",\n \"PostalCode\": \"05022\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Hauptstr. 29\",\n \"City\": \"Bern\",\n \"CompanyName\": \"Chop-suey Chinese\",\n \"ContactName\": \"Yang Wang\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Switzerland\",\n \"CustomerID\": \"CHOPS\",\n \"Fax\": \"NULL\",\n \"Phone\": \"0452-076545\",\n \"PostalCode\": \"3012\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Av. dos LusÃ\\u00adadas 23\",\n \"City\": \"Sao Paulo\",\n \"CompanyName\": \"ComÃ©rcio Mineiro\",\n \"ContactName\": \"Pedro Afonso\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"COMMI\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(11) 555-7647\",\n \"PostalCode\": \"05432-043\",\n \"Region\": \"SP\"\n },\n {\n \"Address\": \"Berkeley Gardens 12 Brewery\",\n \"City\": \"London\",\n \"CompanyName\": \"Consolidated Holdings\",\n \"ContactName\": \"Elizabeth Brown\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"UK\",\n \"CustomerID\": \"CONSH\",\n \"Fax\": \"(171) 555-9199\",\n \"Phone\": \"(171) 555-2282\",\n \"PostalCode\": \"WX1 6LT\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Walserweg 21\",\n \"City\": \"Aachen\",\n \"CompanyName\": \"Drachenblut Delikatessen\",\n \"ContactName\": \"Sven Ottlieb\",\n \"ContactTitle\": \"Order Administrator\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"DRACD\",\n \"Fax\": \"0241-059428\",\n \"Phone\": \"0241-039123\",\n \"PostalCode\": \"52066\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"67 rue des Cinquante Otages\",\n \"City\": \"Nantes\",\n \"CompanyName\": \"Du monde entier\",\n \"ContactName\": \"Janine Labrune\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"France\",\n \"CustomerID\": \"DUMON\",\n \"Fax\": \"40.67.89.89\",\n \"Phone\": \"40.67.88.88\",\n \"PostalCode\": \"44000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"35 King George\",\n \"City\": \"London\",\n \"CompanyName\": \"Eastern Connection\",\n \"ContactName\": \"Ann Devon\",\n \"ContactTitle\": \"Sales Agent\",\n \"Country\": \"UK\",\n \"CustomerID\": \"EASTC\",\n \"Fax\": \"(171) 555-3373\",\n \"Phone\": \"(171) 555-0297\",\n \"PostalCode\": \"WX3 6FW\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Kirchgasse 6\",\n \"City\": \"Graz\",\n \"CompanyName\": \"Ernst Handel\",\n \"ContactName\": \"Roland Mendel\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Austria\",\n \"CustomerID\": \"ERNSH\",\n \"Fax\": \"7675-3426\",\n \"Phone\": \"7675-3425\",\n \"PostalCode\": \"8010\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Rua OrÃ³s 92\",\n \"City\": \"Sao Paulo\",\n \"CompanyName\": \"Familia Arquibaldo\",\n \"ContactName\": \"Aria Cruz\",\n \"ContactTitle\": \"Marketing Assistant\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"FAMIA\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(11) 555-9857\",\n \"PostalCode\": \"05442-030\",\n \"Region\": \"SP\"\n },\n {\n \"Address\": \"C/ Moralzarzal 86\",\n \"City\": \"Madrid\",\n \"CompanyName\": \"FISSA Fabrica Inter. Salchichas S.A.\",\n \"ContactName\": \"Diego Roel\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Spain\",\n \"CustomerID\": \"FISSA\",\n \"Fax\": \"(91) 555 55 93\",\n \"Phone\": \"(91) 555 94 44\",\n \"PostalCode\": \"28034\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"184 chaussÃ©e de Tournai\",\n \"City\": \"Lille\",\n \"CompanyName\": \"Folies gourmandes\",\n \"ContactName\": \"Martine RancÃ©\",\n \"ContactTitle\": \"Assistant Sales Agent\",\n \"Country\": \"France\",\n \"CustomerID\": \"FOLIG\",\n \"Fax\": \"20.16.10.17\",\n \"Phone\": \"20.16.10.16\",\n \"PostalCode\": \"59000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Ã…kergatan 24\",\n \"City\": \"BrÃ¤cke\",\n \"CompanyName\": \"Folk och fÃ¤ HB\",\n \"ContactName\": \"Maria Larsson\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Sweden\",\n \"CustomerID\": \"FOLKO\",\n \"Fax\": \"NULL\",\n \"Phone\": \"0695-34 67 21\",\n \"PostalCode\": \"S-844 67\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Berliner Platz 43\",\n \"City\": \"MÃ¼nchen\",\n \"CompanyName\": \"Frankenversand\",\n \"ContactName\": \"Peter Franken\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"FRANK\",\n \"Fax\": \"089-0877451\",\n \"Phone\": \"089-0877310\",\n \"PostalCode\": \"80805\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"54 rue Royale\",\n \"City\": \"Nantes\",\n \"CompanyName\": \"France restauration\",\n \"ContactName\": \"Carine Schmitt\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"France\",\n \"CustomerID\": \"FRANR\",\n \"Fax\": \"40.32.21.20\",\n \"Phone\": \"40.32.21.21\",\n \"PostalCode\": \"44000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Via Monte Bianco 34\",\n \"City\": \"Torino\",\n \"CompanyName\": \"Franchi S.p.A.\",\n \"ContactName\": \"Paolo Accorti\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Italy\",\n \"CustomerID\": \"FRANS\",\n \"Fax\": \"011-4988261\",\n \"Phone\": \"011-4988260\",\n \"PostalCode\": \"10100\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Jardim das rosas n. 32\",\n \"City\": \"Lisboa\",\n \"CompanyName\": \"Furia Bacalhau e Frutos do Mar\",\n \"ContactName\": \"Lino Rodriguez\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Portugal\",\n \"CustomerID\": \"FURIB\",\n \"Fax\": \"(1) 354-2535\",\n \"Phone\": \"(1) 354-2534\",\n \"PostalCode\": \"1675\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Rambla de CataluÃ±a 23\",\n \"City\": \"Barcelona\",\n \"CompanyName\": \"GalerÃ\\u00ada del gastrÃ³nomo\",\n \"ContactName\": \"Eduardo Saavedra\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"Spain\",\n \"CustomerID\": \"GALED\",\n \"Fax\": \"(93) 203 4561\",\n \"Phone\": \"(93) 203 4560\",\n \"PostalCode\": \"08022\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"C/ Romero 33\",\n \"City\": \"Sevilla\",\n \"CompanyName\": \"Godos Cocina TÃ\\u00adpica\",\n \"ContactName\": \"JosÃ© Pedro Freyre\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Spain\",\n \"CustomerID\": \"GODOS\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(95) 555 82 82\",\n \"PostalCode\": \"41101\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Av. Brasil 442\",\n \"City\": \"Campinas\",\n \"CompanyName\": \"Gourmet Lanchonetes\",\n \"ContactName\": \"AndrÃ© Fonseca\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"GOURL\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(11) 555-9482\",\n \"PostalCode\": \"04876-786\",\n \"Region\": \"SP\"\n },\n {\n \"Address\": \"2732 Baker Blvd.\",\n \"City\": \"Eugene\",\n \"CompanyName\": \"Great Lakes Food Market\",\n \"ContactName\": \"Howard Snyder\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"USA\",\n \"CustomerID\": \"GREAL\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(503) 555-7555\",\n \"PostalCode\": \"97403\",\n \"Region\": \"OR\"\n },\n {\n \"Address\": \"5Âª Ave. Los Palos Grandes\",\n \"City\": \"Caracas\",\n \"CompanyName\": \"GROSELLA-Restaurante\",\n \"ContactName\": \"Manuel Pereira\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Venezuela\",\n \"CustomerID\": \"GROSR\",\n \"Fax\": \"(2) 283-3397\",\n \"Phone\": \"(2) 283-2951\",\n \"PostalCode\": \"1081\",\n \"Region\": \"DF\"\n },\n {\n \"Address\": \"Rua do PaÃ§o 67\",\n \"City\": \"Rio de Janeiro\",\n \"CompanyName\": \"Hanari Carnes\",\n \"ContactName\": \"Mario Pontes\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"HANAR\",\n \"Fax\": \"(21) 555-8765\",\n \"Phone\": \"(21) 555-0091\",\n \"PostalCode\": \"05454-876\",\n \"Region\": \"RJ\"\n },\n {\n \"Address\": \"Carrera 22 con Ave. Carlos Soublette #8-35\",\n \"City\": \"San CristÃ³bal\",\n \"CompanyName\": \"HILARION-Abastos\",\n \"ContactName\": \"Carlos HernÃ¡ndez\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Venezuela\",\n \"CustomerID\": \"HILAA\",\n \"Fax\": \"(5) 555-1948\",\n \"Phone\": \"(5) 555-1340\",\n \"PostalCode\": \"5022\",\n \"Region\": \"TÃ¡chira\"\n },\n {\n \"Address\": \"City Center Plaza 516 Main St.\",\n \"City\": \"Elgin\",\n \"CompanyName\": \"Hungry Coyote Import Store\",\n \"ContactName\": \"Yoshi Latimer\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"USA\",\n \"CustomerID\": \"HUNGC\",\n \"Fax\": \"(503) 555-2376\",\n \"Phone\": \"(503) 555-6874\",\n \"PostalCode\": \"97827\",\n \"Region\": \"OR\"\n },\n {\n \"Address\": \"8 Johnstown Road\",\n \"City\": \"Cork\",\n \"CompanyName\": \"Hungry Owl All-Night Grocers\",\n \"ContactName\": \"Patricia McKenna\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"Ireland\",\n \"CustomerID\": \"HUNGO\",\n \"Fax\": \"2967 3333\",\n \"Phone\": \"2967 542\",\n \"PostalCode\": \"NULL\",\n \"Region\": \"Co. Cork\"\n },\n {\n \"Address\": \"Garden House Crowther Way\",\n \"City\": \"Cowes\",\n \"CompanyName\": \"Island Trading\",\n \"ContactName\": \"Helen Bennett\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"UK\",\n \"CustomerID\": \"ISLAT\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(198) 555-8888\",\n \"PostalCode\": \"PO31 7PJ\",\n \"Region\": \"Isle of Wight\"\n },\n {\n \"Address\": \"Maubelstr. 90\",\n \"City\": \"Brandenburg\",\n \"CompanyName\": \"KÃ¶niglich Essen\",\n \"ContactName\": \"Philip Cramer\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"KOENE\",\n \"Fax\": \"NULL\",\n \"Phone\": \"0555-09876\",\n \"PostalCode\": \"14776\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"67 avenue de l'Europe\",\n \"City\": \"Versailles\",\n \"CompanyName\": \"La corne d'abondance\",\n \"ContactName\": \"Daniel Tonini\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"France\",\n \"CustomerID\": \"LACOR\",\n \"Fax\": \"30.59.85.11\",\n \"Phone\": \"30.59.84.10\",\n \"PostalCode\": \"78000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"1 rue Alsace-Lorraine\",\n \"City\": \"Toulouse\",\n \"CompanyName\": \"La maison d'Asie\",\n \"ContactName\": \"Annette Roulet\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"France\",\n \"CustomerID\": \"LAMAI\",\n \"Fax\": \"61.77.61.11\",\n \"Phone\": \"61.77.61.10\",\n \"PostalCode\": \"31000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"1900 Oak St.\",\n \"City\": \"Vancouver\",\n \"CompanyName\": \"Laughing Bacchus Wine Cellars\",\n \"ContactName\": \"Yoshi Tannamuri\",\n \"ContactTitle\": \"Marketing Assistant\",\n \"Country\": \"Canada\",\n \"CustomerID\": \"LAUGB\",\n \"Fax\": \"(604) 555-7293\",\n \"Phone\": \"(604) 555-3392\",\n \"PostalCode\": \"V3F 2K1\",\n \"Region\": \"BC\"\n },\n {\n \"Address\": \"12 Orchestra Terrace\",\n \"City\": \"Walla Walla\",\n \"CompanyName\": \"Lazy K Kountry Store\",\n \"ContactName\": \"John Steel\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"USA\",\n \"CustomerID\": \"LAZYK\",\n \"Fax\": \"(509) 555-6221\",\n \"Phone\": \"(509) 555-7969\",\n \"PostalCode\": \"99362\",\n \"Region\": \"WA\"\n },\n {\n \"Address\": \"Magazinweg 7\",\n \"City\": \"Frankfurt a.M.\",\n \"CompanyName\": \"Lehmanns Marktstand\",\n \"ContactName\": \"Renate Messner\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"LEHMS\",\n \"Fax\": \"069-0245874\",\n \"Phone\": \"069-0245984\",\n \"PostalCode\": \"60528\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"87 Polk St. Suite 5\",\n \"City\": \"San Francisco\",\n \"CompanyName\": \"Let's Stop N Shop\",\n \"ContactName\": \"Jaime Yorres\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"USA\",\n \"CustomerID\": \"LETSS\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(415) 555-5938\",\n \"PostalCode\": \"94117\",\n \"Region\": \"CA\"\n },\n {\n \"Address\": \"Carrera 52 con Ave. BolÃ\\u00advar #65-98 Llano Largo\",\n \"City\": \"Barquisimeto\",\n \"CompanyName\": \"LILA-Supermercado\",\n \"ContactName\": \"Carlos GonzÃ¡lez\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Venezuela\",\n \"CustomerID\": \"LILAS\",\n \"Fax\": \"(9) 331-7256\",\n \"Phone\": \"(9) 331-6954\",\n \"PostalCode\": \"3508\",\n \"Region\": \"Lara\"\n },\n {\n \"Address\": \"Ave. 5 de Mayo Porlamar\",\n \"City\": \"I. de Margarita\",\n \"CompanyName\": \"LINO-Delicateses\",\n \"ContactName\": \"Felipe Izquierdo\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Venezuela\",\n \"CustomerID\": \"LINOD\",\n \"Fax\": \"(8) 34-93-93\",\n \"Phone\": \"(8) 34-56-12\",\n \"PostalCode\": \"4980\",\n \"Region\": \"Nueva Esparta\"\n },\n {\n \"Address\": \"89 Chiaroscuro Rd.\",\n \"City\": \"Portland\",\n \"CompanyName\": \"Lonesome Pine Restaurant\",\n \"ContactName\": \"Fran Wilson\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"USA\",\n \"CustomerID\": \"LONEP\",\n \"Fax\": \"(503) 555-9646\",\n \"Phone\": \"(503) 555-9573\",\n \"PostalCode\": \"97219\",\n \"Region\": \"OR\"\n },\n {\n \"Address\": \"Via Ludovico il Moro 22\",\n \"City\": \"Bergamo\",\n \"CompanyName\": \"Magazzini Alimentari Riuniti\",\n \"ContactName\": \"Giovanni Rovelli\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"Italy\",\n \"CustomerID\": \"MAGAA\",\n \"Fax\": \"035-640231\",\n \"Phone\": \"035-640230\",\n \"PostalCode\": \"24100\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Rue Joseph-Bens 532\",\n \"City\": \"Bruxelles\",\n \"CompanyName\": \"Maison Dewey\",\n \"ContactName\": \"Catherine Dewey\",\n \"ContactTitle\": \"Sales Agent\",\n \"Country\": \"Belgium\",\n \"CustomerID\": \"MAISD\",\n \"Fax\": \"(02) 201 24 68\",\n \"Phone\": \"(02) 201 24 67\",\n \"PostalCode\": \"B-1180\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"43 rue St. Laurent\",\n \"City\": \"MontrÃ©al\",\n \"CompanyName\": \"MÃ¨re Paillarde\",\n \"ContactName\": \"Jean FresniÃ¨re\",\n \"ContactTitle\": \"Marketing Assistant\",\n \"Country\": \"Canada\",\n \"CustomerID\": \"MEREP\",\n \"Fax\": \"(514) 555-8055\",\n \"Phone\": \"(514) 555-8054\",\n \"PostalCode\": \"H1J 1C3\",\n \"Region\": \"QuÃ©bec\"\n },\n {\n \"Address\": \"Heerstr. 22\",\n \"City\": \"Leipzig\",\n \"CompanyName\": \"Morgenstern Gesundkost\",\n \"ContactName\": \"Alexander Feuer\",\n \"ContactTitle\": \"Marketing Assistant\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"MORGK\",\n \"Fax\": \"NULL\",\n \"Phone\": \"0342-023176\",\n \"PostalCode\": \"04179\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"South House 300 Queensbridge\",\n \"City\": \"London\",\n \"CompanyName\": \"North/South\",\n \"ContactName\": \"Simon Crowther\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"UK\",\n \"CustomerID\": \"NORTS\",\n \"Fax\": \"(171) 555-2530\",\n \"Phone\": \"(171) 555-7733\",\n \"PostalCode\": \"SW7 1RZ\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Ing. Gustavo Moncada 8585 Piso 20-A\",\n \"City\": \"Buenos Aires\",\n \"CompanyName\": \"OcÃ©ano AtlÃ¡ntico Ltda.\",\n \"ContactName\": \"Yvonne Moncada\",\n \"ContactTitle\": \"Sales Agent\",\n \"Country\": \"Argentina\",\n \"CustomerID\": \"OCEAN\",\n \"Fax\": \"(1) 135-5535\",\n \"Phone\": \"(1) 135-5333\",\n \"PostalCode\": \"1010\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"2743 Bering St.\",\n \"City\": \"Anchorage\",\n \"CompanyName\": \"Old World Delicatessen\",\n \"ContactName\": \"Rene Phillips\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"USA\",\n \"CustomerID\": \"OLDWO\",\n \"Fax\": \"(907) 555-2880\",\n \"Phone\": \"(907) 555-7584\",\n \"PostalCode\": \"99508\",\n \"Region\": \"AK\"\n },\n {\n \"Address\": \"Mehrheimerstr. 369\",\n \"City\": \"KÃ¶ln\",\n \"CompanyName\": \"Ottilies KÃ¤seladen\",\n \"ContactName\": \"Henriette Pfalzheim\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"OTTIK\",\n \"Fax\": \"0221-0765721\",\n \"Phone\": \"0221-0644327\",\n \"PostalCode\": \"50739\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"265 boulevard Charonne\",\n \"City\": \"Paris\",\n \"CompanyName\": \"Paris spÃ©cialitÃ©s\",\n \"ContactName\": \"Marie Bertrand\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"France\",\n \"CustomerID\": \"PARIS\",\n \"Fax\": \"(1) 42.34.22.77\",\n \"Phone\": \"(1) 42.34.22.66\",\n \"PostalCode\": \"75012\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Calle Dr. Jorge Cash 321\",\n \"City\": \"MÃ©xico D.F.\",\n \"CompanyName\": \"Pericles Comidas clÃ¡sicas\",\n \"ContactName\": \"Guillermo FernÃ¡ndez\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Mexico\",\n \"CustomerID\": \"PERIC\",\n \"Fax\": \"(5) 545-3745\",\n \"Phone\": \"(5) 552-3745\",\n \"PostalCode\": \"05033\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Geislweg 14\",\n \"City\": \"Salzburg\",\n \"CompanyName\": \"Piccolo und mehr\",\n \"ContactName\": \"Georg Pipps\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Austria\",\n \"CustomerID\": \"PICCO\",\n \"Fax\": \"6562-9723\",\n \"Phone\": \"6562-9722\",\n \"PostalCode\": \"5020\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Estrada da saÃºde n. 58\",\n \"City\": \"Lisboa\",\n \"CompanyName\": \"Princesa Isabel Vinhos\",\n \"ContactName\": \"Isabel de Castro\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Portugal\",\n \"CustomerID\": \"PRINI\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(1) 356-5634\",\n \"PostalCode\": \"1756\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Rua da Panificadora 12\",\n \"City\": \"Rio de Janeiro\",\n \"CompanyName\": \"Que DelÃ\\u00adcia\",\n \"ContactName\": \"Bernardo Batista\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"QUEDE\",\n \"Fax\": \"(21) 555-4545\",\n \"Phone\": \"(21) 555-4252\",\n \"PostalCode\": \"02389-673\",\n \"Region\": \"RJ\"\n },\n {\n \"Address\": \"Alameda dos CanÃ rios 891\",\n \"City\": \"Sao Paulo\",\n \"CompanyName\": \"Queen Cozinha\",\n \"ContactName\": \"LÃºcia Carvalho\",\n \"ContactTitle\": \"Marketing Assistant\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"QUEEN\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(11) 555-1189\",\n \"PostalCode\": \"05487-020\",\n \"Region\": \"SP\"\n },\n {\n \"Address\": \"TaucherstraÃŸe 10\",\n \"City\": \"Cunewalde\",\n \"CompanyName\": \"QUICK-Stop\",\n \"ContactName\": \"Horst Kloss\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"QUICK\",\n \"Fax\": \"NULL\",\n \"Phone\": \"0372-035188\",\n \"PostalCode\": \"01307\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Av. del Libertador 900\",\n \"City\": \"Buenos Aires\",\n \"CompanyName\": \"Rancho grande\",\n \"ContactName\": \"Sergio GutiÃ©rrez\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Argentina\",\n \"CustomerID\": \"RANCH\",\n \"Fax\": \"(1) 123-5556\",\n \"Phone\": \"(1) 123-5555\",\n \"PostalCode\": \"1010\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"2817 Milton Dr.\",\n \"City\": \"Albuquerque\",\n \"CompanyName\": \"Rattlesnake Canyon Grocery\",\n \"ContactName\": \"Paula Wilson\",\n \"ContactTitle\": \"Assistant Sales Representative\",\n \"Country\": \"USA\",\n \"CustomerID\": \"RATTC\",\n \"Fax\": \"(505) 555-3620\",\n \"Phone\": \"(505) 555-5939\",\n \"PostalCode\": \"87110\",\n \"Region\": \"NM\"\n },\n {\n \"Address\": \"Strada Provinciale 124\",\n \"City\": \"Reggio Emilia\",\n \"CompanyName\": \"Reggiani Caseifici\",\n \"ContactName\": \"Maurizio Moroni\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"Italy\",\n \"CustomerID\": \"REGGC\",\n \"Fax\": \"0522-556722\",\n \"Phone\": \"0522-556721\",\n \"PostalCode\": \"42100\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Av. Copacabana 267\",\n \"City\": \"Rio de Janeiro\",\n \"CompanyName\": \"Ricardo Adocicados\",\n \"ContactName\": \"Janete Limeira\",\n \"ContactTitle\": \"Assistant Sales Agent\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"RICAR\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(21) 555-3412\",\n \"PostalCode\": \"02389-890\",\n \"Region\": \"RJ\"\n },\n {\n \"Address\": \"Grenzacherweg 237\",\n \"City\": \"GenÃ¨ve\",\n \"CompanyName\": \"Richter Supermarkt\",\n \"ContactName\": \"Michael Holz\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Switzerland\",\n \"CustomerID\": \"RICSU\",\n \"Fax\": \"NULL\",\n \"Phone\": \"0897-034214\",\n \"PostalCode\": \"1203\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Gran VÃ\\u00ada 1\",\n \"City\": \"Madrid\",\n \"CompanyName\": \"Romero y tomillo\",\n \"ContactName\": \"Alejandra Camino\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Spain\",\n \"CustomerID\": \"ROMEY\",\n \"Fax\": \"(91) 745 6210\",\n \"Phone\": \"(91) 745 6200\",\n \"PostalCode\": \"28001\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Erling Skakkes gate 78\",\n \"City\": \"Stavern\",\n \"CompanyName\": \"SantÃ© Gourmet\",\n \"ContactName\": \"Jonas Bergulfsen\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Norway\",\n \"CustomerID\": \"SANTG\",\n \"Fax\": \"07-98 92 47\",\n \"Phone\": \"07-98 92 35\",\n \"PostalCode\": \"4110\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"187 Suffolk Ln.\",\n \"City\": \"Boise\",\n \"CompanyName\": \"Save-a-lot Markets\",\n \"ContactName\": \"Jose Pavarotti\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"USA\",\n \"CustomerID\": \"SAVEA\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(208) 555-8097\",\n \"PostalCode\": \"83720\",\n \"Region\": \"ID\"\n },\n {\n \"Address\": \"90 Wadhurst Rd.\",\n \"City\": \"London\",\n \"CompanyName\": \"Seven Seas Imports\",\n \"ContactName\": \"Hari Kumar\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"UK\",\n \"CustomerID\": \"SEVES\",\n \"Fax\": \"(171) 555-5646\",\n \"Phone\": \"(171) 555-1717\",\n \"PostalCode\": \"OX15 4NB\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"VinbÃ¦ltet 34\",\n \"City\": \"Kobenhavn\",\n \"CompanyName\": \"Simons bistro\",\n \"ContactName\": \"Jytte Petersen\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Denmark\",\n \"CustomerID\": \"SIMOB\",\n \"Fax\": \"31 13 35 57\",\n \"Phone\": \"31 12 34 56\",\n \"PostalCode\": \"1734\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"25 rue Lauriston\",\n \"City\": \"Paris\",\n \"CompanyName\": \"SpÃ©cialitÃ©s du monde\",\n \"ContactName\": \"Dominique Perrier\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"France\",\n \"CustomerID\": \"SPECD\",\n \"Fax\": \"(1) 47.55.60.20\",\n \"Phone\": \"(1) 47.55.60.10\",\n \"PostalCode\": \"75016\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"P.O. Box 555\",\n \"City\": \"Lander\",\n \"CompanyName\": \"Split Rail Beer & Ale\",\n \"ContactName\": \"Art Braunschweiger\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"USA\",\n \"CustomerID\": \"SPLIR\",\n \"Fax\": \"(307) 555-6525\",\n \"Phone\": \"(307) 555-4680\",\n \"PostalCode\": \"82520\",\n \"Region\": \"WY\"\n },\n {\n \"Address\": \"Boulevard Tirou 255\",\n \"City\": \"Charleroi\",\n \"CompanyName\": \"SuprÃªmes dÃ©lices\",\n \"ContactName\": \"Pascale Cartrain\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Belgium\",\n \"CustomerID\": \"SUPRD\",\n \"Fax\": \"(071) 23 67 22 21\",\n \"Phone\": \"(071) 23 67 22 20\",\n \"PostalCode\": \"B-6000\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"89 Jefferson Way Suite 2\",\n \"City\": \"Portland\",\n \"CompanyName\": \"The Big Cheese\",\n \"ContactName\": \"Liz Nixon\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"USA\",\n \"CustomerID\": \"THEBI\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(503) 555-3612\",\n \"PostalCode\": \"97201\",\n \"Region\": \"OR\"\n },\n {\n \"Address\": \"55 Grizzly Peak Rd.\",\n \"City\": \"Butte\",\n \"CompanyName\": \"The Cracker Box\",\n \"ContactName\": \"Liu Wong\",\n \"ContactTitle\": \"Marketing Assistant\",\n \"Country\": \"USA\",\n \"CustomerID\": \"THECR\",\n \"Fax\": \"(406) 555-8083\",\n \"Phone\": \"(406) 555-5834\",\n \"PostalCode\": \"59801\",\n \"Region\": \"MT\"\n },\n {\n \"Address\": \"Luisenstr. 48\",\n \"City\": \"MÃ¼nster\",\n \"CompanyName\": \"Toms SpezialitÃ¤ten\",\n \"ContactName\": \"Karin Josephs\",\n \"ContactTitle\": \"Marketing Manager\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"TOMSP\",\n \"Fax\": \"0251-035695\",\n \"Phone\": \"0251-031259\",\n \"PostalCode\": \"44087\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Avda. Azteca 123\",\n \"City\": \"MÃ©xico D.F.\",\n \"CompanyName\": \"Tortuga Restaurante\",\n \"ContactName\": \"Miguel Angel Paolino\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Mexico\",\n \"CustomerID\": \"TORTU\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(5) 555-2933\",\n \"PostalCode\": \"05033\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Av. InÃªs de Castro 414\",\n \"City\": \"Sao Paulo\",\n \"CompanyName\": \"TradiÃ§Ã£o Hipermercados\",\n \"ContactName\": \"Anabela Domingues\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"TRADH\",\n \"Fax\": \"(11) 555-2168\",\n \"Phone\": \"(11) 555-2167\",\n \"PostalCode\": \"05634-030\",\n \"Region\": \"SP\"\n },\n {\n \"Address\": \"722 DaVinci Blvd.\",\n \"City\": \"Kirkland\",\n \"CompanyName\": \"Trail's Head Gourmet Provisioners\",\n \"ContactName\": \"Helvetius Nagy\",\n \"ContactTitle\": \"Sales Associate\",\n \"Country\": \"USA\",\n \"CustomerID\": \"TRAIH\",\n \"Fax\": \"(206) 555-2174\",\n \"Phone\": \"(206) 555-8257\",\n \"PostalCode\": \"98034\",\n \"Region\": \"WA\"\n },\n {\n \"Address\": \"Smagsloget 45\",\n \"City\": \"Ã…rhus\",\n \"CompanyName\": \"Vaffeljernet\",\n \"ContactName\": \"Palle Ibsen\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Denmark\",\n \"CustomerID\": \"VAFFE\",\n \"Fax\": \"86 22 33 44\",\n \"Phone\": \"86 21 32 43\",\n \"PostalCode\": \"8200\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"2 rue du Commerce\",\n \"City\": \"Lyon\",\n \"CompanyName\": \"Victuailles en stock\",\n \"ContactName\": \"Mary Saveley\",\n \"ContactTitle\": \"Sales Agent\",\n \"Country\": \"France\",\n \"CustomerID\": \"VICTE\",\n \"Fax\": \"78.32.54.87\",\n \"Phone\": \"78.32.54.86\",\n \"PostalCode\": \"69004\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"59 rue de l'Abbaye\",\n \"City\": \"Reims\",\n \"CompanyName\": \"Vins et alcools Chevalier\",\n \"ContactName\": \"Paul Henriot\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"France\",\n \"CustomerID\": \"VINET\",\n \"Fax\": \"26.47.15.11\",\n \"Phone\": \"26.47.15.10\",\n \"PostalCode\": \"51100\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Adenauerallee 900\",\n \"City\": \"Stuttgart\",\n \"CompanyName\": \"Die Wandernde Kuh\",\n \"ContactName\": \"Rita MÃ¼ller\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"WANDK\",\n \"Fax\": \"0711-035428\",\n \"Phone\": \"0711-020361\",\n \"PostalCode\": \"70563\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Torikatu 38\",\n \"City\": \"Oulu\",\n \"CompanyName\": \"Wartian Herkku\",\n \"ContactName\": \"Pirkko Koskitalo\",\n \"ContactTitle\": \"Accounting Manager\",\n \"Country\": \"Finland\",\n \"CustomerID\": \"WARTH\",\n \"Fax\": \"981-443655\",\n \"Phone\": \"981-443655\",\n \"PostalCode\": \"90110\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"Rua do Mercado 12\",\n \"City\": \"Resende\",\n \"CompanyName\": \"Wellington Importadora\",\n \"ContactName\": \"Paula Parente\",\n \"ContactTitle\": \"Sales Manager\",\n \"Country\": \"Brazil\",\n \"CustomerID\": \"WELLI\",\n \"Fax\": \"NULL\",\n \"Phone\": \"(14) 555-8122\",\n \"PostalCode\": \"08737-363\",\n \"Region\": \"SP\"\n },\n {\n \"Address\": \"305 - 14th Ave. S. Suite 3B\",\n \"City\": \"Seattle\",\n \"CompanyName\": \"White Clover Markets\",\n \"ContactName\": \"Karl Jablonski\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"USA\",\n \"CustomerID\": \"WHITC\",\n \"Fax\": \"(206) 555-4115\",\n \"Phone\": \"(206) 555-4112\",\n \"PostalCode\": \"98128\",\n \"Region\": \"WA\"\n },\n {\n \"Address\": \"Keskuskatu 45\",\n \"City\": \"Helsinki\",\n \"CompanyName\": \"Wilman Kala\",\n \"ContactName\": \"Matti Karttunen\",\n \"ContactTitle\": \"Owner/Marketing Assistant\",\n \"Country\": \"Finland\",\n \"CustomerID\": \"WILMK\",\n \"Fax\": \"90-224 8858\",\n \"Phone\": \"90-224 8858\",\n \"PostalCode\": \"21240\",\n \"Region\": \"NULL\"\n },\n {\n \"Address\": \"ul. Filtrowa 68\",\n \"City\": \"Warszawa\",\n \"CompanyName\": \"Wolski Zajazd\",\n \"ContactName\": \"Zbyszek Piestrzeniewicz\",\n \"ContactTitle\": \"Owner\",\n \"Country\": \"Poland\",\n \"CustomerID\": \"WOLZA\",\n \"Fax\": \"(26) 642-7012\",\n \"Phone\": \"(26) 642-7012\",\n \"PostalCode\": \"01-012\",\n \"Region\": \"NULL\"\n }\n]"}],"_postman_id":"8dbde504-e3a0-4f44-b137-1288044af963"},{"name":"Create and entry into Customers","id":"f31b5521-5ed8-4ea7-9ff5-b2abfcae2bd9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"CustomerID\": \"ABED\",\n \"CompanyName\": \"CompanyNameXY\",\n \"ContactName\": \"ContactNameYZ\",\n \"ContactTitle\": \"ContactTitleZX\",\n \"Address\": \"AddressQ\",\n \"City\": \"CityA\",\n \"Region\": \"RegionB\",\n \"PostalCode\": 544422,\n \"Fax\": \"030-2385236\",\n \"Phone\": \"030-0074321\",\n \"Country\": \"India\"\n}"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/add","description":"

Adds an entry into the Northwind Database Customers table

\n
Provide all the fields as in Customer table schema. Refer to the example for better understanding.
\n

\n","urlObject":{"protocol":"http","port":"5000","path":["customer","add"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"0c622fdb-a38b-4511-befe-53ff0a96e0cf","name":"Create and entry into Customers","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"CustomerID\": \"ABED\",\n \"CompanyName\": \"CompanyNameXY\",\n \"ContactName\": \"ContactNameYZ\",\n \"ContactTitle\": \"ContactTitleZX\",\n \"Address\": \"AddressQ\",\n \"City\": \"CityA\",\n \"Region\": \"RegionB\",\n \"PostalCode\": 544422,\n \"Fax\": \"030-2385236\",\n \"Phone\": \"030-0074321\",\n \"Country\": \"India\"\n}"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/add"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Content-Length","value":"32"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:26:42 GMT"}],"cookie":[],"responseTime":null,"body":"Successfully Added the Customer!"}],"_postman_id":"f31b5521-5ed8-4ea7-9ff5-b2abfcae2bd9"},{"name":"Update an entry in Customers","id":"42a320bd-606b-4228-90ef-c73f5a874277","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"CustomerID\": \"ABED\",\n \"CompanyName\": \"CompanyNameXY Update\",\n \"ContactName\": \"ContactNameYZ Update\",\n \"ContactTitle\": \"ContactTitleZX Update\",\n \"Address\": \"AddressQ Update\",\n \"City\": \"CityA\",\n \"Region\": \"RegionB\",\n \"PostalCode\": 544422,\n \"Fax\": \"030-2385236\",\n \"Phone\": \"030-0074321\",\n \"Country\": \"India\"\n}"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/update/ABED","description":"

Update a specific entry in Customers

\n
Select the Customer to be update by using CustomerID and then provide all the fields in schema for a successful update. Refer the example for better understanding.
\n

\n","urlObject":{"protocol":"http","port":"5000","path":["customer","update","ABED"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"225d30e0-915e-4f4b-bdd2-d37e98338f57","name":"Update an entry in Customers","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\n \"CustomerID\": \"ABED\",\n \"CompanyName\": \"CompanyNameXY Update\",\n \"ContactName\": \"ContactNameYZ Update\",\n \"ContactTitle\": \"ContactTitleZX Update\",\n \"Address\": \"AddressQ Update\",\n \"City\": \"CityA\",\n \"Region\": \"RegionB\",\n \"PostalCode\": 544422,\n \"Fax\": \"030-2385236\",\n \"Phone\": \"030-0074321\",\n \"Country\": \"India\"\n}"},"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/update/ABED"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"334"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:27:44 GMT"}],"cookie":[],"responseTime":null,"body":"{\n \"Address\": \"AddressQ Update\",\n \"City\": \"CityA\",\n \"CompanyName\": \"CompanyNameXY Update\",\n \"ContactName\": \"ContactNameYZ Update\",\n \"ContactTitle\": \"ContactTitleZX Update\",\n \"Country\": \"India\",\n \"CustomerID\": \"ABED\",\n \"Fax\": \"030-2385236\",\n \"Phone\": \"030-0074321\",\n \"PostalCode\": \"544422\",\n \"Region\": \"RegionB\"\n}"}],"_postman_id":"42a320bd-606b-4228-90ef-c73f5a874277"},{"name":"Select a specific Customer entry by CustomerID","id":"2ddd5254-4d9d-4494-b329-f02e00a00757","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/ALFKI","description":"

List a particular customer in Customers table of Northwind Database using the CustomerID

\n","urlObject":{"protocol":"http","port":"5000","path":["customer","ALFKI"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"59e6889f-5343-4178-8d20-dafea5d60951","name":"Select a specific Customer entry by CustomerID","originalRequest":{"method":"GET","header":[],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/ALFKI"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"322"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:32:16 GMT"}],"cookie":[],"responseTime":null,"body":"{\n \"Address\": \"Obere Str. 57\",\n \"City\": \"Berlin\",\n \"CompanyName\": \"Alfreds Futterkiste\",\n \"ContactName\": \"Maria Anders\",\n \"ContactTitle\": \"Sales Representative\",\n \"Country\": \"Germany\",\n \"CustomerID\": \"ALFKI\",\n \"Fax\": \"030-0076545\",\n \"Phone\": \"030-0074321\",\n \"PostalCode\": \"12209\",\n \"Region\": \"NULL\"\n}"}],"_postman_id":"2ddd5254-4d9d-4494-b329-f02e00a00757"},{"name":"Delete an entry in Customers","id":"df49bdd9-0a7c-4388-b988-e0302507f6b7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/remove/ABED","description":"

Delete a customer entry by referencing it with CustomerID

\n","urlObject":{"protocol":"http","port":"5000","path":["customer","remove","ABED"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"b309348a-fbf2-40bf-9d10-678e2a206aa2","name":"Delete an entry in Customers","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json","type":"text"}],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/customer/remove/ABED"},"status":"OK","code":200,"_postman_previewlanguage":"html","header":[{"key":"Content-Type","value":"text/html; charset=utf-8"},{"key":"Content-Length","value":"29"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:30:00 GMT"}],"cookie":[],"responseTime":null,"body":"Deleted Customer Successfully"}],"_postman_id":"df49bdd9-0a7c-4388-b988-e0302507f6b7"},{"name":"Get order history of a Customer by CustomerID","id":"0f0de786-1a4f-47bd-8250-6753af53a784","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/orderhistory/ALFKI","description":"

Lists the order history of a customer

\n
Specify CustomerID to list the customer's order history. Refer to the example for better understanding.
\n

\n","urlObject":{"protocol":"http","port":"5000","path":["orderhistory","ALFKI"],"host":["ec2-3-129-64-144","us-east-2","compute","amazonaws","com"],"query":[],"variable":[]}},"response":[{"id":"f9d77e85-c90d-4734-bc36-7ef4b74d8b3b","name":"Get order history of a Customer by CustomerID","originalRequest":{"method":"GET","header":[],"url":"http://ec2-3-129-64-144.us-east-2.compute.amazonaws.com:5000/orderhistory/ALFKI"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Content-Length","value":"1087"},{"key":"Server","value":"Werkzeug/1.0.1 Python/3.7.5"},{"key":"Date","value":"Wed, 22 Jul 2020 15:31:18 GMT"}],"cookie":[],"responseTime":null,"body":"[\n {\n \"OrderDate\": \"Mon, 25 Aug 1997 00:00:00 GMT\",\n \"OrderID\": 10643,\n \"ShipCity\": \"Berlin\",\n \"ShipCountry\": \"Germany\",\n \"ShipName\": \"Alfreds Futterkiste\"\n },\n {\n \"OrderDate\": \"Fri, 03 Oct 1997 00:00:00 GMT\",\n \"OrderID\": 10692,\n \"ShipCity\": \"Berlin\",\n \"ShipCountry\": \"Germany\",\n \"ShipName\": \"Alfred's Futterkiste\"\n },\n {\n \"OrderDate\": \"Mon, 13 Oct 1997 00:00:00 GMT\",\n \"OrderID\": 10702,\n \"ShipCity\": \"Berlin\",\n \"ShipCountry\": \"Germany\",\n \"ShipName\": \"Alfred's Futterkiste\"\n },\n {\n \"OrderDate\": \"Thu, 15 Jan 1998 00:00:00 GMT\",\n \"OrderID\": 10835,\n \"ShipCity\": \"Berlin\",\n \"ShipCountry\": \"Germany\",\n \"ShipName\": \"Alfred's Futterkiste\"\n },\n {\n \"OrderDate\": \"Mon, 16 Mar 1998 00:00:00 GMT\",\n \"OrderID\": 10952,\n \"ShipCity\": \"Berlin\",\n \"ShipCountry\": \"Germany\",\n \"ShipName\": \"Alfred's Futterkiste\"\n },\n {\n \"OrderDate\": \"Thu, 09 Apr 1998 00:00:00 GMT\",\n \"OrderID\": 11011,\n \"ShipCity\": \"Berlin\",\n \"ShipCountry\": \"Germany\",\n \"ShipName\": \"Alfred's Futterkiste\"\n }\n]"}],"_postman_id":"0f0de786-1a4f-47bd-8250-6753af53a784"}]}