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

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

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

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

Kore.ai Bots Platform provides access to bot development using secured APIs. Refer here to learn more on how to use these APIs<\/a>.<\/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><\/td>\n<\/tr>\n
viewName<\/td>\nThe table view form which to fetch data.<\/span><\/td>\n<\/tr>\n
sys_limit<\/td>\nThe maximum number of records to be fetched.<\/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\/views\/{{viewName}}\/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 Table View. To use this API, the app needs to be given Read access to the Table View from the Data Definition in DaaS (see here for details) POST https:\/\/{{host}}\/api\/public\/views\/{{viewName}}\/query?sys_limit={{limit_value}}&sys_offset={{offset_value}} Kore.ai Bots Platform provides access to bot development using secured APIs. Refer here to learn more on how to use...","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\/30457"}],"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=30457"}],"version-history":[{"count":3,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30457\/revisions"}],"predecessor-version":[{"id":30663,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30457\/revisions\/30663"}],"wp:attachment":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/media?parent=30457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/categories?post=30457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/tags?post=30457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}