\u30ec\u30b3\u30fc\u30c9\u306e\u4e00\u62ec\u53d6\u5f97 -cybozu developer network<\/a><\/p>\n <\/p>\n
\u7c21\u5358\u306b\u8a00\u3046\u3068\u3001\u4e00\u62ec\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30ad\u30fc\u3092\u53d6\u5f97\u3057\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u3063\u3066\u3044\u304f\u4ed5\u7d44\u307f\uff1f<\/p>\n
\u3082\u3068\u3082\u3068\u7528\u610f\u3055\u308c\u3066\u305f\u3082\u306e\u306f\u3001\u5358\u7d14\u306b<\/p>\n
\u30ea\u30af\u30a8\u30b9\u30c8\u306a\u3052\u3066\u53d6\u5f97\uff081\uff5e999\u307e\u3067\uff09<\/p>\n
\u30ea\u30af\u30a8\u30b9\u30c8\u306a\u3052\u3066\u53d6\u5f97\uff081000\uff5e1999\u307e\u3067\uff09<\/p>\n
\u2026\u3092\u56de\u6570\u5206\u7e70\u308a\u8fd4\u3057\u3002<\/p>\n
<\/p>\n
<\/p>\n
\u30ab\u30fc\u30bd\u30ebAPI\u4f7f\u3046\u5834\u5408\u306f\u3001<\/p>\n
\u30fb\u30ea\u30af\u30a8\u30b9\u30c8\uff08\u30d1\u30e9\u30e1\u30fc\u30bf\u3044\u308d\u3044\u308d\uff09\u6295\u3052\u3066ID\u53d6\u5f97<\/p>\n
\u30fb\u30ea\u30af\u30a8\u30b9\u30c8\u306bID\u8fbc\u3081\u3066\u6295\u3052\u308b\u3068\u30c7\u30fc\u30bf\u53d6\u5f97<\/p>\n
\u30fb\u7d42\u308f\u3063\u305f\u3089\u30ea\u30af\u30a8\u30b9\u30c8\u306bID\u8fbc\u3081\u3066\u6295\u3052\u3066\u30ab\u30fc\u30bd\u30eb\u524a\u9664<\/p>\n
<\/p>\n
<\/p>\n
use strict;\r\nuse warnings;\r\nuse utf8;\r\nuse Encode;\r\nuse LWP::UserAgent;\r\nuse HTTP::Request;\r\nuse JSON;\r\nuse MIME::Base64;\r\n\r\nbinmode STDOUT, ':utf8';\r\n\r\n\r\nmy $access_basicauth_id = \"basicid\";\r\nmy $access_basicauth_pass = \"basicpass\";\r\n\r\nmy $kintone_host = \"kintonedev.cybozu.jp\";\r\nmy $kintone_id = \"kintoneid\";\r\nmy $kintone_pass = \"kitonepass\";\r\nmy $kintone_app = \"1\";\r\nmy $kintone_getdata_per_page = \"500\";\t# 1\u56de\u3054\u3068\u306e\u53d6\u5f97\u30c7\u30fc\u30bf\u6570\uff08\u6700\u5927500\uff09\r\n\r\n\r\nmy $kintone_auth = encode_base64($kintone_host.\":\".$kintone_pass);\r\nmy $basic_auth = sprintf \"basic %s\", encode_base64($access_basicauth_id.\":\".$access_basicauth_pass);\r\n\r\nmy $requrl = \"https:\/\/\" . $kintone_host . \".\/k\/v1\/records\/cursor.json\";\r\n\r\n\r\n\r\n# \u30ab\u30fc\u30bd\u30eb\u306e\u4f5c\u6210\uff08POST\u30ea\u30af\u30a8\u30b9\u30c8\uff09\r\nmy $req = HTTP::Request->new('POST', => $requrl);\r\n\r\n$req->header(\r\n\t'Authorization' => $basic_auth,\r\n\t'X-Cybozu-Ahthorization' => $kintone_auth,\r\n\t'Host' => $kintone_host,\r\n\t'Content-Type' => 'application\/json'\r\n);\r\n\r\n\r\n# fields\u3068query\u3044\u308c\u306a\u3051\u3070\u5168\u4ef6\u53d6\u5f97\r\nmy $req_json = {\r\n\t\"app\" => $kintone_app,\r\n#\t\"fields\" => [\"\u30ec\u30b3\u30fc\u30c9\u756a\u53f7\",\"\u4f5c\u6210\u8005\",\"\u4f5c\u6210\u65e5\u6642\"],\r\n#\t\"query\" => \"\u4f5c\u6210\u65e5\u6642 = TODAY() order by \u30ec\u30b3\u30fc\u30c9\u756a\u53f7 asc\",\r\n\t\"size\" => $kintone_getdata_per_page\r\n};\r\n\r\n\r\n$req->content(encode_json($req_json));\r\n\r\nmy $ua = LWP::UserAgent->new;\r\nmy $res = $ua->request($req);\r\nmy $content = $res->content;\r\n\r\nmy $cursorobj = decode_json($content);\r\n\r\nmy $cursor_id = $cursorobj->{'id'};\t\t# \u30ab\u30fc\u30bd\u30ebID\r\nmy $totalcount = $cursorobj->{'totalCount'};\t# \u53d6\u5f97\u3055\u308c\u308b\u8981\u7d20\u6570\r\n\r\n\r\n\r\n\r\n\r\n# \u30c7\u30fc\u30bf\u306e\u53d6\u5f97\uff08GET\u30ea\u30af\u30a8\u30b9\u30c8\uff09\r\n$req = HTTP::Request->new('GET', => $requrl.\"id=\".$cursor_id);\r\n\r\n$req->header(\r\n\t'Authorization' => $basic_auth,\r\n\t'X-Cybozu-Ahthorization' => $kintone_auth,\r\n\t'Host' => $kintone_host,\r\n\t'Content-Type' => 'application\/json'\r\n);\r\n\r\n# \u5fc5\u8981\u56de\u6570\u30eb\u30fc\u30d7\u3055\u305b\u3066\u53d6\u5f97\r\nfor (my $i = 0; $i < $totalcount \/ $kintone_getdata_per_page; $i++)\r\n{\r\n\t$res = $ua->request($req);\r\n\tmy $resjson = decode_json($res->content);\r\n\t\r\n\t# \u3053\u3053\u306b\u8af8\u3005\u51e6\u7406\r\n}\r\n\r\n\r\n\r\n\r\n\r\n# \u30ab\u30fc\u30bd\u30eb\u306e\u524a\u9664\uff08DELETE\u30ea\u30af\u30a8\u30b9\u30c8\uff09\r\n$req = HTTP::Request->new('DELETE', => $requrl);\r\n\r\n\r\n$req_json = {\r\n\t\"id\" => $cursor_id\r\n};\r\n\r\n\r\n$req->header(\r\n\t'Authorization' => $basic_auth,\r\n\t'X-Cybozu-Ahthorization' => $kintone_auth,\r\n\t'Host' => $kintone_host,\r\n\t'Content-Type' => 'application\/json'\r\n);\r\n\r\n$req->content(encode_json($req_json));\r\n$res = $ua->request($req);\r\n\r\n\r\n<\/pre>\n <\/p>\n
\u5b9f\u884c\u3057\u3066\u306a\u3044\u306e\u3067\u30b3\u30d4\u30da\u3057\u3066\u307e\u307e\u52d5\u304b\u306a\u304b\u3063\u305f\u3089\u306a\u3093\u3068\u306a\u304f\u76f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30e1\u30e2\u3060\u3088\u3002 Perl\u304b\u3089Kintone\u306e\u30ab\u30fc\u30bd\u30ebAPI\u3092\u52d5\u304b\u3057\u307e\u3059\u3002 \u203b\u9593\u9055\u3063\u3066\u3066\u3082\u8cac\u4efb\u6301\u3061\u307e\u305b\u3093\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,8],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=\/wp\/v2\/posts\/239"}],"collection":[{"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=239"}],"version-history":[{"count":5,"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":319,"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions\/319"}],"wp:attachment":[{"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.grandaria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}