{"id":30453,"date":"2021-08-24T12:03:54","date_gmt":"2021-08-24T11:03:54","guid":{"rendered":"https:\/\/multisite.korebots.com\/v9-0\/uncategorised-ja\/query-data-table-api\/"},"modified":"2021-08-24T12:10:13","modified_gmt":"2021-08-24T11:10:13","slug":"query-data-table-api","status":"publish","type":"post","link":"https:\/\/multisite.korebots.com\/v9-0\/uncategorised-ja\/query-data-table-api\/","title":{"rendered":"\u30af\u30a8\u30ea\u30c7\u30fc\u30bf\uff08\u30c6\u30fc\u30d6\u30eb\uff09API"},"content":{"rendered":"

Used to get data from Data Table.<\/p>\n

To use this API, the app needs to be given Read access to the Data Table from the Data Definition in DaaS (see here for details<\/a>)<\/p>\n

POST<\/b> https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/query?sys_limit={{limit_value}}&sys_offset={{offset_value}}<\/code><\/span><\/p>\n<\/div><\/div>

<\/div><\/div>

<\/span>Query Parameters<\/span><\/h3>\n\n\n\n\n\n\n\n\n
Parameter<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
host<\/span><\/td>\nEnvironment URL, for example, https:\/\/bots.kore.ai<\/code><\/span>
\n<\/span><\/td>\n<\/tr>\n
tableName<\/span><\/td>\nName of the Table to fetch data<\/span><\/td>\n<\/tr>\n
sys_limit<\/td>\nThe maximum number of records to be fetched.
\nBy default this is set to 10 and the maximum allowed is 100.<\/span><\/td>\n<\/tr>\n
sys_offset<\/td>\nThe number of records to be skipped from the beginning of the results dataset.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>
<\/div><\/div>

<\/span>\u672c\u6587\u30d1\u30e9\u30e1\u30fc\u30bf<\/span><\/h3>\n\n\n\n\n\n
\u30d1\u30e9\u30e1\u30fc\u30bf<\/th>\n\u8aac\u660e<\/th>\n<\/tr>\n<\/thead>\n
\u30af\u30a8\u30ea<\/td>\n\u53d6\u5f97\u3055\u308c\u308b\u884c\u3092\u7279\u5b9a\u3059\u308b\u30d5\u30a3\u30eb\u30bf\u306e\u57fa\u6e96<\/p>\n
 "query":{ "expressions": [ {"field": "<col1_name>", "operand": "=\/!=\/<\/>", "value": "<value1>"}, {"field": "<col2_name>", "operand": "=\/!=\/<\/>", "value": "<value2>"} ], "operator": "and\/or" }<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u8a8d\u8a3c<\/span><\/h3>\n
\u4ee5\u4e0b\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001JWT\u3092\u30d8\u30c3\u30c0\u30fc\u306b\u542b\u3080API\u3092\u547c\u3073\u51fa\u3057\u307e\u3059\u3002 auth: {{JWT}}<\/code><\/p>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u5fdc\u7b54\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u30bf\u30a4\u30d7<\/span><\/h3>\n
application\/json<\/code><\/p>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u30b5\u30f3\u30d7\u30eb\u30ea\u30af\u30a8\u30b9\u30c8<\/span><\/h3>\n
curl -X POST \\ http:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/query?sys_limit=4&sys_offset=0 \\ -H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}<\/em>' \\ -H 'content-type: application\/json' \\ -d '{ "query":{ "expressions": [ {"field": "firstName", "operand": "=", "value": "Jane"}, {"field": "lastName", "operand": "=", "value": "Doe"} ], "operator": "or" } }'<\/pre>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u30b5\u30f3\u30d7\u30eb\u5fdc\u7b54<\/span><\/h3>\n
{ "metaInfo": [ { "name": "gender", "type": "string" }, { "name": "lastName", "type": "string" } ], "queryResult": [ { "age": male, "last_name":tony, } ] }<\/pre>\n<\/div><\/div>
<\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"Used to get data from Data Table. To use this API, the app needs to be given Read access to the Data Table from the Data Definition in DaaS (see here for details) POST https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/query?sys_limit={{limit_value}}&sys_offset={{offset_value}} Query Parameters Parameter Description host Environment URL, for example, https:\/\/bots.kore.ai tableName Name of the Table to fetch data sys_limit The...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30453"}],"collection":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/comments?post=30453"}],"version-history":[{"count":3,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30453\/revisions"}],"predecessor-version":[{"id":30659,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30453\/revisions\/30659"}],"wp:attachment":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/media?parent=30453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/categories?post=30453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/tags?post=30453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}