{"id":41266,"date":"2022-04-21T08:34:25","date_gmt":"2022-04-21T07:34:25","guid":{"rendered":"https:\/\/developer.kore.ai\/v10-1\/?p=41266"},"modified":"2022-04-21T08:34:43","modified_gmt":"2022-04-21T07:34:43","slug":"query-data-table-api","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/api-guide\/query-data-table-api\/?lang=ko","title":{"rendered":"\ucffc\ub9ac \ub370\uc774\ud130(\ud14c\uc774\ube14) API"},"content":{"rendered":"<section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row type_default valign_top\"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>\ub370\uc774\ud130 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<p class=\"note\">\uc774 API\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \uc571\uc5d0 DaaS\uc758 \ub370\uc774\ud130 \uc815\uc758\uc5d0\uc11c \ub370\uc774\ud130 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc77d\uae30 \uc561\uc138\uc2a4 \uad8c\ud55c\uc774 \ubd80\uc5ec\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4(<a href=\"https:\/\/multisite.korebots.com\/docs-ko\/bots-ko\/advanced-topics-ko-2\/data-as-a-service\/?lang=ko#Assignments\" target=\"_blank\" rel=\"noopener noreferrer\">\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc5ec\uae30 \ucc38\uc870<\/a>).<\/p>\n<p><b>POST<\/b> <span style=\"font-weight: 400\"><code>https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/query?sys_limit={{limit_value}}&amp;sys_offset={{offset_value}}<\/code><\/span><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"i\">\ucffc\ub9ac \ub9e4\uac1c \ubcc0\uc218<\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>\ub9e4\uac1c \ubcc0\uc218<\/th>\n<th>\uc124\uba85<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400\">host<\/span><\/td>\n<td><span style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ud658\uacbd URL, \uc608: <code>https:\/\/bots.kore.ai<\/code><\/span><\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">tableName<\/span><\/td>\n<td><span style=\"font-weight: 400\">\ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \ud14c\uc774\ube14\uc758 \uc774\ub984<\/span><\/td>\n<\/tr>\n<tr>\n<td>sys_limit<\/td>\n<td><span style=\"font-weight: 400\">\uac00\uc838\uc62c \ucd5c\ub300 \ub808\ucf54\ub4dc \uc218\uc785\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \uc774 \uac12\uc740 10\uc73c\ub85c \uc124\uc815\ub418\uace0 \ud5c8\uc6a9\ub418\ub294 \ucd5c\ub300\uac12\uc740 100\uc785\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n<tr>\n<td>sys_offset<\/td>\n<td><span style=\"font-weight: 400\">\uacb0\uacfc \ub370\uc774\ud130 \uc138\ud2b8\uc758 \uc2dc\uc791 \ubd80\ubd84\uc5d0\uc11c \uac74\ub108\ub6f4 \ub808\ucf54\ub4dc \uc218\uc785\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"i-2\">\ubcf8\ubb38 \ub9e4\uac1c \ubcc0\uc218<\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>\ub9e4\uac1c \ubcc0\uc218<\/th>\n<th>\uc124\uba85<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>query<\/td>\n<td>\n<p>\uac00\uc838\uc62c \ud589\uc744 \uc2dd\ubcc4\ud558\ub294 \ud544\ud130 \uae30\uc900<\/p>\n<pre>&nbsp;\"query\":{\r\n\t\"expressions\": [\r\n\t   {\"field\": \"&lt;col1_name&gt;\", \"operand\": \"=\/!=\/&lt;\/&gt;\", \"value\": \"&lt;value1&gt;\"},\r\n\t   {\"field\": \"&lt;col2_name&gt;\", \"operand\": \"=\/!=\/&lt;\/&gt;\", \"value\": \"&lt;value2&gt;\"}\r\n\t],\r\n\t\"operator\": \"and\/or\"\r\n\t   }<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"i-3\">\uad8c\ud55c \ubd80\uc5ec<\/span><\/h3>\n<p>\ub2e4\uc74c \uad6c\ubb38\uc744 \ud3ec\ud568\ud55c \ud5e4\ub354\uc5d0 JWT\ub97c \ud3ec\ud568\ud55c API\ub97c \ud638\ucd9c\ud569\ub2c8\ub2e4. <code>auth: {{JWT}}<\/code><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"i-4\">\ucf58\ud150\uce20 \uc720\ud615 \uc751\ub2f5<\/span><\/h3>\n<p><code>application\/json<\/code><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"i-5\">\uc0d8\ud50c \uc694\uccad<\/span><\/h3>\n<pre>curl -X POST \\\r\n  http:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/query?sys_limit=4&amp;sys_offset=0 \\\r\n  -H 'auth: {{<em>YOUR_JWT_ACCESS_TOKEN}}<\/em>' \\\r\n  -H 'content-type: application\/json' \\\r\n  -d '{\r\n      \"query\":{\r\n \t\"expressions\": [\r\n        \t{\"field\": \"firstName\", \"operand\": \"=\", \"value\": \"Jane\"},\r\n\t\t{\"field\": \"lastName\", \"operand\": \"=\", \"value\": \"Doe\"}\r\n\t\t],\r\n\t\t\"operator\": \"or\"\r\n\t   }\r\n}'<\/pre>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"i-6\">\uc0d8\ud50c \uc751\ub2f5<\/span><\/h3>\n<pre>{\r\n    \"metaInfo\": [\r\n        {\r\n            \"name\": \"gender\",\r\n            \"type\": \"string\"\r\n        },\r\n        {\r\n            \"name\": \"lastName\",\r\n            \"type\": \"string\"\r\n        }\r\n    ],\r\n    \"queryResult\": [\r\n        {\r\n            \"age\": male,\r\n            \"last_name\":tony,\r\n        }\r\n    ]\r\n}\r\n<\/pre>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"\ub370\uc774\ud130 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 API\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \uc571\uc5d0 DaaS\uc758 \ub370\uc774\ud130 \uc815\uc758\uc5d0\uc11c \ub370\uc774\ud130 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc77d\uae30 \uc561\uc138\uc2a4 \uad8c\ud55c\uc774 \ubd80\uc5ec\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4(\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc5ec\uae30 \ucc38\uc870). POST https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/query?sys_limit={{limit_value}}&amp;sys_offset={{offset_value}} \ucffc\ub9ac \ub9e4\uac1c \ubcc0\uc218 \ub9e4\uac1c \ubcc0\uc218 \uc124\uba85 host \ud658\uacbd URL, \uc608: https:\/\/bots.kore.ai tableName \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \ud14c\uc774\ube14\uc758 \uc774\ub984 sys_limit \uac00\uc838\uc62c \ucd5c\ub300 \ub808\ucf54\ub4dc \uc218\uc785\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c \uc774 \uac12\uc740 10\uc73c\ub85c \uc124\uc815\ub418\uace0 \ud5c8\uc6a9\ub418\ub294 \ucd5c\ub300\uac12\uc740 100\uc785\ub2c8\ub2e4....","protected":false},"author":22,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-41266","post","type-post","status-publish","format-standard","hentry","category-api-guide"],"_links":{"self":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/41266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/comments?post=41266"}],"version-history":[{"count":1,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/41266\/revisions"}],"predecessor-version":[{"id":41267,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/41266\/revisions\/41267"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/media?parent=41266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/categories?post=41266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/tags?post=41266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}