{"info":{"_postman_id":"32619b88-60dd-4dba-ad01-6a1a22c2ad04","name":"HarperDB Getting Started Example","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json"},"item":[{"name":"Create Schema","id":"69d084a5-4a6e-4f8a-ad6c-c64969feb2d0","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic YWRtaW46MTQwMA=="}],"body":{"mode":"raw","raw":"{\n\"operation\":\"create_schema\",\n\"schema\":\"dev\"\n}"},"url":"http://localhost:9925","description":"We first need to create a Schema.  A Schema can be thought of as a container of tables that are independent from tables in other schemas.  An example might be the Schema dev with a table called dog.  The Schema prod may also have a table dog. \n\nNote that if you see the error response \"Cannot complete request: User 'admin' not found\", you need to set the basic auth to the user and password you entered during the install process.  What the heck is basic auth?  Read our article on it here: https://harperdbhelp.zendesk.com/hc/en-us/articles/115010250207-Basic-Auth-with-Postman"},"response":[{"id":"9b50009b-eb6c-4c83-a72b-84b7a55017db","name":"Create Schema","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n\"operation\":\"create_schema\",\n\"schema\":\"dev\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"45","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 21:14:04 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"2d-GPJz4Nu7aSF7N/KODFK3o/TNPUw\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"schema dev successfully created\"}"}],"_postman_id":"69d084a5-4a6e-4f8a-ad6c-c64969feb2d0"},{"name":"Create dog table","id":"2fca241d-5f8a-4af5-b9ad-c9d8b7362428","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic YWRtaW46MTQwMA=="}],"body":{"mode":"raw","raw":"{\n\"operation\":\"create_table\",\n\"schema\":\"dev\",\n\"table\":\"dog\",\n\"hash_attribute\":\"id\"\n}"},"url":"http://localhost:9925","description":"Now that we have a Schema, we're able to create a table.  We have so many dogs here at Harper, we're starting to lose count.  So we are going to create a table to track them.  Tables in HarperDB are schema-less, so we don't need to add any attributes other than a hash_attribute to create this table.  A hash attribute is an attribute that defines the unique identifier for each row in your table.  In a traditional RDMS this would be called a primary key."},"response":[{"id":"8cf373d2-17b0-49fc-9fff-295ad80dbed8","name":"Create dog table","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n\"operation\":\"create_table\",\n\"schema\":\"dev\",\n\"table\":\"dog\",\n\"hash_attribute\":\"id\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"49","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 21:19:30 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"31-2FV9i2eJXU1F9rNuA4B9T7Vu7EA\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"table dev.dog successfully created.\"}"}],"_postman_id":"2fca241d-5f8a-4af5-b9ad-c9d8b7362428"},{"name":"Create breed Table","id":"73411849-2052-4ee7-a717-4b6b187eb18f","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic YWRtaW46MTQwMA=="}],"body":{"mode":"raw","raw":"{\n\"operation\":\"create_table\",\n\"schema\":\"dev\",\n\"table\":\"breed\",\n\"hash_attribute\":\"id\"\n}"},"url":"http://localhost:9925","description":"Now that we have a table to store our dog data, we also want to create a table to track known breeds.  Just as with the dog table, the only attribute we need to specify is the hash_attribute."},"response":[{"id":"666f1901-d7eb-4912-9139-903a259f4350","name":"Create breed Table","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n\"operation\":\"create_table\",\n\"schema\":\"dev\",\n\"table\":\"breed\",\n\"hash_attribute\":\"id\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"51","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 21:28:00 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"33-yJK4lsgvTjK9euHyxjd9kgGCB6Y\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"table dev.breed successfully created.\"}"}],"_postman_id":"73411849-2052-4ee7-a717-4b6b187eb18f"},{"name":"NoSQL Insert 1 row","id":"f37a8699-d745-4dd6-a345-e7d0d962d67e","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic YWRtaW46MTQwMA=="}],"body":{"mode":"raw","raw":"{\n    \"operation\":\"insert\",\n    \"schema\" :  \"dev\",\n    \"table\":\"dog\",\n    \"records\": [\n      {\n        \"id\" : 1,\n        \"dog_name\" : \"Penny\",\n        \"owner_name\": \"Kyle\",\n        \"breed_id\":154,\n        \"age\":5,\n        \"weight_lbs\":35,\n        \"adorable\":true\n      }\n    ]\n}"},"url":"http://localhost:9925","description":"We're ready to add some dog data.  Penny is our CTO's pup, so she gets ID 1 or we're all fired.  We are specifying attributes in this call, but this doesn't prevent us from specifying additional attributes in subsequent calls."},"response":[{"id":"c445f5bf-6512-4925-a484-60fe4ee91276","name":"NoSQL Insert 1 row","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n    \"operation\":\"insert\",\n    \"schema\" :  \"dev\",\n    \"table\":\"dog\",\n    \"records\": [\n      {\n        \"id\" : 1,\n        \"doc\" : \"Penny\",\n        \"owner_name\": \"Kyle\",\n        \"breed_id\":154,\n        \"age\":5,\n        \"weight_lbs\":35,\n        \"adorable\":true\n      }\n    ]\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"42","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 21:36:16 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"2a-ej8lhx1Q+iRBBct5qevTAGvotAM\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"successfully wrote 1 records\"}"}],"_postman_id":"f37a8699-d745-4dd6-a345-e7d0d962d67e"},{"name":"NoSQL insert multiple rows","id":"c11f00fe-a31f-4634-856a-b04c884bf50c","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n    \"operation\":\"insert\",\n    \"schema\" :  \"dev\",\n    \"table\":\"dog\",\n    \"records\": [\n      {\n        \"id\" : 2,\n        \"dog_name\" : \"Harper\",\n        \"owner_name\": \"Stephen\",\n        \"breed_id\":346,\n        \"age\":5,\n        \"weight_lbs\":55,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 3,\n        \"dog_name\" : \"Alby\",\n        \"owner_name\": \"Kaylan\",\n        \"breed_id\":348,\n        \"age\":5,\n        \"weight_lbs\":84,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 4,\n        \"dog_name\" : \"Billy\",\n        \"owner_name\": \"Zach\",\n        \"breed_id\":347,\n        \"age\":4,\n        \"weight_lbs\":60,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 5,\n        \"dog_name\" : \"Rose Merry\",\n        \"owner_name\": \"Zach\",\n        \"breed_id\":348,\n        \"age\":6,\n        \"weight_lbs\":15,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 6,\n        \"dog_name\" : \"Kato\",\n        \"owner_name\": \"Kyle\",\n        \"breed_id\":351,\n        \"age\":4,\n        \"weight_lbs\":28,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 7,\n        \"dog_name\" : \"Simon\",\n        \"owner_name\": \"Fred\",\n        \"breed_id\":349,\n        \"age\":1,\n        \"weight_lbs\":35,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 8,\n        \"dog_name\" : \"Gemma\",\n        \"owner_name\": \"Stephen\",\n        \"breed_id\":350,\n        \"age\":3,\n        \"weight_lbs\":55,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 9,\n        \"dog_name\" : \"Gertrude\",\n        \"owner_name\": \"Eli\",\n        \"breed_id\":158,\n        \"age\":5,\n        \"weight_lbs\":70,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 10,\n        \"dog_name\" : \"Big Louie\",\n        \"owner_name\": \"Eli\",\n        \"breed_id\":241,\n        \"age\":11,\n        \"weight_lbs\":20,\n        \"adorable\":false\n      }\n    ]\n}"},"url":"http://localhost:9925","description":"Lets add some more Harper doggies!  We can add as many dog objects as we want into the records collection.  If you're adding a lot of objects, we would recommend using the .csv upload option (see the next section where we populate the breed table)."},"response":[{"id":"70800819-fae8-4155-b9bd-3e57c617c1b0","name":"NoSQL insert multiple rows","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n    \"operation\":\"insert\",\n    \"schema\" :  \"dev\",\n    \"table\":\"dog\",\n    \"records\": [\n      {\n        \"id\" : 2,\n        \"dog_name\" : \"Harper\",\n        \"owner_name\": \"Stephen\",\n        \"breed_id\":346,\n        \"age\":5,\n        \"weight_lbs\":55,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 3,\n        \"dog_name\" : \"Alby\",\n        \"owner_name\": \"Kaylan\",\n        \"breed_id\":348,\n        \"age\":5,\n        \"weight_lbs\":84,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 4,\n        \"dog_name\" : \"Billy\",\n        \"owner_name\": \"Zach\",\n        \"breed_id\":347,\n        \"age\":4,\n        \"weight_lbs\":60,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 5,\n        \"dog_name\" : \"Rose Merry\",\n        \"owner_name\": \"Zach\",\n        \"breed_id\":348,\n        \"age\":6,\n        \"weight_lbs\":15,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 6,\n        \"dog_name\" : \"Kato\",\n        \"owner_name\": \"Kyle\",\n        \"breed_id\":351,\n        \"age\":4,\n        \"weight_lbs\":28,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 7,\n        \"dog_name\" : \"Simon\",\n        \"owner_name\": \"Fred\",\n        \"breed_id\":349,\n        \"age\":1,\n        \"weight_lbs\":35,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 8,\n        \"dog_name\" : \"Gemma\",\n        \"owner_name\": \"Stephen\",\n        \"breed_id\":350,\n        \"age\":3,\n        \"weight_lbs\":55,\n        \"adorable\":true\n      },\n      {\n        \"id\" : 9,\n        \"dog_name\" : \"Gertrude\",\n        \"owner_name\": \"Eli\",\n        \"breed_id\":158,\n        \"age\":5,\n        \"weight_lbs\":70,\n        \"adorable\":true\n      }\n    ]\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"42","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 21:55:41 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"2a-za7dp/HEA0qAhqdM1W/4I342gyM\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"successfully wrote 8 records\"}"}],"_postman_id":"c11f00fe-a31f-4634-856a-b04c884bf50c"},{"name":"Bulk Load from csv","id":"9c0928b2-08ed-421b-83f3-dabbc20627d1","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic YWRtaW46MTQwMA=="}],"body":{"mode":"raw","raw":"{\n  \"operation\":\"csv_file_load\",\n  \"schema\":\"dev\",\n  \"table\":\"breed\",\n  \"file_path\":\"/home/kyle/Documents/breeds.csv\"\n}"},"url":"http://localhost:9925","description":"We need to populate the 'breed' table with some data so we can reference it later.  For larger data sets, we recommend using our CSV upload option.  See our user guide for further guidance on this: https://harperdbhelp.zendesk.com/hc/en-us/articles/115002007573-1Gigabyte-Limit-to-Request-Bodies.\n\nEach header in a column will be consisdered as an attribute, and each row in the file will be a row in the table.  Simply specify the file path and the table to upload to, and HarperDB will take care of the rest.  You can pull the breeds.csv file from here: https://s3.amazonaws.com/complimentarydata/breeds.csv"},"response":[{"id":"8d9ea018-e660-4d53-9316-4037bcad559c","name":"Bulk Load from csv","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n  \"operation\":\"csv_file_load\",\n  \"schema\":\"dev\",\n  \"table\":\"breed\",\n  \"file_path\":\"/home/eli/Documents/breeds.csv\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"45","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 22:04:41 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"2d-59GkoX81i6OMA/OYM8QtTn9XCRY\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"successfully loaded 350 records\"}"}],"_postman_id":"9c0928b2-08ed-421b-83f3-dabbc20627d1"},{"name":"SQL update 1 row","id":"93bbfff4-1d91-4304-9648-7a7888b27d55","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n  \"operation\": \"sql\",\n  \"sql\":\"UPDATE dev.dog SET dog_name = 'Penny B' WHERE id = 1\"\n}"},"url":"http://localhost:9925","description":"Whaaaaat?  HarperDB supports NoSQL and SQL commands?  Hell yeah it does!  We're gonna update the dog table to show Penny's last initial."},"response":[{"id":"b7eeeb5a-fdc5-49ce-818a-307f41e1a994","name":"SQL update 1 row","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n  \"operation\": \"sql\",\n  \"sql\":\"UPDATE dev.dog SET dog_name = 'Penny B' WHERE id = 1\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"79","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 22:13:54 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"4f-XGNCkCMfhgRNnnfpsYCMwnzC7go\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"{\"message\":\"updated 1 of 1 records\",\"update_hashes\":[1],\"skipped_hashes\":[\"1\"]}"}],"_postman_id":"93bbfff4-1d91-4304-9648-7a7888b27d55"},{"name":"SQL simple SELECT","id":"20cb5c88-a70b-4033-aa20-49d00ecdb919","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n  \"operation\": \"sql\",\n  \"sql\":\"SELECT * FROM dev.dog where id = 1\"\n}"},"url":"http://localhost:9925","description":"Now we're going to use a simple SELECT call to pull Penny's updated data.  Note we now see Penny's last initial in the dog name."},"response":[{"id":"eea5d5e7-d388-4040-92a0-3ad81027d253","name":"SQL simple SELECT","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n  \"operation\": \"sql\",\n  \"sql\":\"SELECT * FROM dev.dog where ID=1\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"120","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 22:15:39 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"78-YWwcol97eF8ux2qVSiLlP7FPs9A\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"[{\"id\":1,\"doc\":\"Penny\",\"age\":5,\"breed_id\":154,\"adorable\":true,\"dog_name\":\"Penny B\",\"owner_name\":\"Kyle\",\"weight_lbs\":35}]"}],"_postman_id":"20cb5c88-a70b-4033-aa20-49d00ecdb919"},{"name":"SQL complex SELECT","id":"8871f6bf-064c-43f9-96ac-b48cef5e70e1","request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Basic YWRtaW46MTQwMA=="}],"body":{"mode":"raw","raw":"{\n  \"operation\": \"sql\",\n  \"sql\":\"SELECT d.id, d.dog_name, d.owner_name, b.name, b.section FROM dev.dog AS d INNER JOIN dev.breed AS b ON d.breed_id = b.id WHERE d.owner_name IN ('Kyle', 'Zach', 'Stephen') AND b.section = 'Mutt' ORDER BY d.dog_name\"\n}"},"url":"http://localhost:9925","description":"HarperDB supports standard ANSI SQL commands.  In this call we will join the breed table on dog.  We will also pull only the pups belonging to Kyle, Zach, and Stephen."},"response":[{"id":"6005e154-ec56-42f6-bdf4-e801a6523130","name":"SQL complex SELECT","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","type":"text","name":"Authorization","value":"Basic ZWxpOnBhc3M="}],"body":{"mode":"raw","raw":"{\n  \"operation\": \"sql\",\n  \"sql\":\"SELECT d.id, d.dog_name, d.owner_name, b.name, b.section FROM dev.dog AS d INNER JOIN dev.breed AS b ON d.breed_id = b.id WHERE d.owner_name IN ('Kyle', 'Zach', 'Stephen') AND b.section = 'Mutt' ORDER BY d.dog_name\"\n}"},"url":"http://localhost:9925"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"name":"access-control-allow-origin","key":"access-control-allow-origin","value":"chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop","description":""},{"name":"connection","key":"connection","value":"keep-alive","description":""},{"name":"content-length","key":"content-length","value":"389","description":""},{"name":"content-type","key":"content-type","value":"application/json; charset=utf-8","description":""},{"name":"date","key":"date","value":"Fri, 13 Oct 2017 22:23:56 GMT","description":""},{"name":"etag","key":"etag","value":"W/\"185-LFddXxWjnIf4b2Y2sij3GMxdkLw\"","description":""},{"name":"vary","key":"vary","value":"Origin","description":""},{"name":"x-powered-by","key":"x-powered-by","value":"HarperDB","description":""}],"cookie":[],"responseTime":null,"body":"[{\"id\":347,\"dog_name\":\"Billy\",\"owner_name\":\"Zach\",\"name\":\"LABRADOR / GREAT DANE MIX\",\"section\":\"Mutt\"},{\"id\":350,\"dog_name\":\"Gemma\",\"owner_name\":\"Stephen\",\"name\":\"SHORT HAIRED SETTER MIX\",\"section\":\"Mutt\"},{\"id\":346,\"dog_name\":\"Harper\",\"owner_name\":\"Stephen\",\"name\":\"HUSKY MIX\",\"section\":\"Mutt\"},{\"id\":348,\"dog_name\":\"Rose Merry\",\"owner_name\":\"Zach\",\"name\":\"TERRIER MIX\",\"section\":\"Mutt\"}]"}],"_postman_id":"8871f6bf-064c-43f9-96ac-b48cef5e70e1"}]}