{"id":3440,"date":"2020-03-20T18:10:33","date_gmt":"2020-03-20T09:10:33","guid":{"rendered":"http:\/\/kats-eye.net\/info\/?p=3440"},"modified":"2021-06-12T08:25:08","modified_gmt":"2021-06-11T23:25:08","slug":"comic-list-01","status":"publish","type":"post","link":"https:\/\/kats-eye.net\/info\/2020\/03\/20\/comic-list-01\/","title":{"rendered":"\u30a8\u30af\u30bb\u30eb\u3068\u66f8\u7c4dAPI\u3067\u3001\u6f2b\u753b\u672c\u30ea\u30b9\u30c8\u4f5c\u6210\u81ea\u52d5\u5316"},"content":{"rendered":"<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">\u5927\u91cf\u306e\u6f2b\u753b\u672c\u3092\u767a\u898b<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u4eca\u5e74\u3001\u306a\u3093\u3068\u304b\u5927\u5b66\u53d7\u9a13\u3092\u7d42\u3048\u305f\u606f\u5b50\u304c\u6574\u7406\u3092\u59cb\u3081\u307e\u3057\u305f\u3002\u7d0d\u6238\u306b\u6f2b\u753b\u672c\u304c\u305f\u304f\u3055\u3093\u3042\u308b\u306e\u306f\u77e5\u3063\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u3044\u3056\u606f\u5b50\u306e\u90e8\u5c4b\u306b\u904b\u3073\u5165\u308c\u3001\u5c71\u7a4d\u307f\u3055\u308c\u305f\u6f2b\u753b\u672c\u3092\u898b\u3066\u6115\u7136\u3068\u3057\u307e\u3057\u305f\u3002\u53d7\u9a13\u671f\u9593\u4e2d\u306b\u3082\u76f8\u5f53\u91cf\u306e\u6f2b\u753b\u672c\u3092\u8cfc\u5165\u3057\u3066\u3044\u305f\u69d8\u3067\u3059\u3002\u4eca\u3055\u3089\u8a00\u3063\u3066\u3082\u4ed5\u65b9\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u3082\u3063\u3068\u3057\u3063\u304b\u308a\u52c9\u5f37\u3057\u3066\u6b32\u3057\u304b\u3063\u305f\u3002<br \/>\n<span style=\"font-size: 12pt;\">\u3000\u4e0b\u306e\u5199\u771f\u304c\u5c71\u7a4d\u72b6\u614b\u306e\u6f2b\u753b\u672c\u3067\u3059\u3002\u30ab\u30e9\u30fc\u30dc\u30c3\u30af\u30b9\u306b\u306f\u5965\u3068\u624b\u524d\u306b\u53ce\u7d0d\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/span><br \/>\n<img loading=\"lazy\" class=\"aligncenter size-medium wp-image-3448\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/002-5-300x281.png\" alt=\"\" width=\"300\" height=\"281\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/002-5-300x281.png 300w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/002-5.png 618w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><span style=\"font-size: 12pt;\">\u3000\u305d\u306e\u606f\u5b50\u304b\u3089\u300c\u3042\u307e\u308a\u306b\u305f\u304f\u3055\u3093\u306e\u6f2b\u753b\u672c\u304c\u3042\u308b\u306e\u3067\u3001\u3069\u3053\u306b\u3042\u308b\u306e\u304b\u5206\u304b\u3089\u306a\u304f\u306a\u308b\u3002\u6f2b\u753b\u672c\u30ea\u30b9\u30c8\u3092\u4f5c\u308a\u305f\u3044\u3002\u300d\u3068\u3044\u3046\u76f8\u8ac7\u3092\u53d7\u3051\u307e\u3057\u305f\u3002\u89aa\u3068\u3057\u3066\u6f2b\u753b\u30fb\u30b9\u30de\u30db\u30fb\u30b2\u30fc\u30e0\u3092\u618e\u3080\u79c1\u3068\u3057\u3066\u306f\u3001\u6c7a\u3057\u3066\u5feb\u3044\u3053\u3068\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u52b9\u7387\u7684\u306b\u7ba1\u7406\u3059\u308b\u8996\u70b9\u306f\u5fc5\u8981\u3067\u3059\u3002\u307e\u305f\u6f2b\u753b\u672c\u7ba1\u7406\u306b\u7121\u99c4\u306a\u6642\u9593\u3092\u4f7f\u3063\u3066\u6b32\u3057\u304f\u306a\u3044\u306e\u3067\u30ea\u30b9\u30c8\u4f5c\u6210\u52b9\u7387\u5316\u306b\u5354\u529b\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/span><br \/>\n<\/span><\/p>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">ISBN\u756a\u53f7<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000ISBN\uff08International Standard Book Number \uff09\u306f\u3001\u66f8\u7c4d\u985e\u306e\u8b58\u5225\u7528\u306b\u8a2d\u5b9a\u3055\u308c\u305f\u56fd\u969b\u898f\u683c\u30b3\u30fc\u30c9\u3068\u306e\u3053\u3068\u3067\u3059\u3002\u901a\u5e38\u3001\u4e0b\u56f3\u306e\u69d8\u306b\u672c\u306e\u80cc\u9762\u306b\u3001\u756a\u53f7\u3068\u30d0\u30fc\u30b3\u30fc\u30c9\u8868\u8a18\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u3001\u30c6\u30b9\u30c8\u3057\u305f\u672c\u306e\u4e2d\u306b\u306f\u30d0\u30fc\u30b3\u30fc\u30c9\u304c\u7121\u3044\u3082\u306e\u3082\u3042\u308a\u307e\u3057\u305f\u3002<\/span><br \/>\n<span style=\"font-size: 12pt;\">\u3000\u65e5\u672c\u306e\u5834\u5408\u306f\u300c<strong><span style=\"color: #ff0000;\">\uff19\uff17\uff18\uff14<\/span><\/strong>\u300d\u3067\u59cb\u307e\u308a\u307e\u3059\u3002<\/span><br \/>\n<img loading=\"lazy\" class=\"aligncenter size-full wp-image-3443\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/001-4.png\" alt=\"\" width=\"885\" height=\"468\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/001-4.png 885w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/001-4-300x159.png 300w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/001-4-768x406.png 768w\" sizes=\"(max-width: 885px) 100vw, 885px\" \/><\/p>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">\u66f8\u7c4dAPI \u306b\u3064\u3044\u3066<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u3044\u308d\u3044\u308d\u8abf\u3079\u3066\u3044\u308b\u3068\u300c\u66f8\u7c4dAPI\u300d\u3068\u3044\u3046\u3082\u306e\u304c\u3042\u308b\u3053\u3068\u3092\u77e5\u308a\u307e\u3057\u305f\u3002\uff08\u4e0b\u8868\uff09&nbsp; \u66f8\u7c4dAPI\u3092\u4f7f\u3063\u3066\u3001ISBN\u756a\u53f7\u304b\u3089\u984c\u540d\uff65\u8457\u8005\uff65\u51fa\u7248\u65e5\u7b49\u306e\u60c5\u5831\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<br \/>\n<span style=\"font-size: 12pt;\">\u3000\u5e7e\u3064\u304b\u3042\u308b\u66f8\u7c4dAPI\u306e\u4e2d\u304b\u3089\u300c<strong><span style=\"color: #ff0000;\">openBD<\/span><\/strong>\u300d\u3092\u4f7f\u3046\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002\u3069\u308c\u304c\u826f\u3044\u3068\u3044\u3046\u3053\u3068\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u4e0b\u8868\u2460\u2461\u306f\u767b\u9332\u304c\u5fc5\u8981\u306a\u306e\u3067\u5bfe\u8c61\u5916\u3068\u3057\u307e\u3057\u305f\u3002\u6b21\u306b\u2463Google Books APIs \u3092\u4f7f\u7528\u3057\u3001\u30a8\u30af\u30bb\u30ebVBA\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u5e7e\u3064\u304b\u306e\u79c1\u306e\u66f8\u7c4d\u3067\u30c6\u30b9\u30c8\u3057\u3001\u307b\u3068\u3093\u3069\u691c\u7d22\u51fa\u6765\u305f\u306e\u3067\u3059\u304c\u3001\u5b9f\u969b\u306b\u606f\u5b50\u306e\u6f2b\u753b\u672c\u3092\u6301\u3063\u3066\u304d\u3066\u30c6\u30b9\u30c8\u3059\u308b\u3068\u307b\u307c\u5168\u6ec5\u3067\u3059\u3002\u4e00\u65b9\u3001\u2464openBD \u306f\u6f2b\u753b\u672c\u3060\u3051\u3067\u306a\u304f\u3001\u2463Google Books APIs \u3067\u691c\u7d22\u51fa\u6765\u306a\u304b\u3063\u305f\u79c1\u306e\u672c\u306e\u30c7\u30fc\u30bf\u3082\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3057\u305f\u3002<br \/>\n<\/span><\/span><span style=\"font-size: 12pt;\"><span style=\"font-size: 12pt;\">\u3000\u2462\u56fd\u7acb\u56fd\u4f1a\u56f3\u66f8\u9928\u30b5\u30fc\u30c1\u306e\u691c\u7d22\u7528API \u306b\u3064\u3044\u3066\u306f\u3001\u30c7\u30fc\u30bf\u5f62\u5f0f\u304c\u3001\u201cxml\u201d \u3067\u6700\u521d\u306b\u4f5c\u6210\u3057\u305f \u201cjson\u201d \u5bfe\u5fdc\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u6d41\u7528\u3057\u306b\u304f\u3044\u306a\u3069\u306e\u7406\u7531\u3067\u6df1\u304f\u78ba\u8a8d\u306f\u3057\u3066\u3044\u307e\u305b\u3093\u3002<\/span><\/span><\/p>\n<table style=\"width: 96.4548%; border-collapse: collapse; border-style: none; height: 168px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 62.5945%; border-color: #000000; border-style: none; background-color: #ffffff; height: 24px; text-align: left;\" colspan=\"2\"><span style=\"font-size: 14pt;\"><strong><span style=\"color: #ffffff;\"><span style=\"color: #000000;\">\u3010\u4e3b\u306a\u66f8\u7c4dAPI\u3011<\/span><\/span><\/strong><\/span><\/td>\n<td style=\"width: 11.3884%; text-align: center; border-color: #000000; border-style: none; background-color: #ffffff; height: 24px;\"><span style=\"color: #ffffff;\">&nbsp;<\/span><\/td>\n<td style=\"width: 11.2091%; text-align: center; border-color: #000000; border-style: none; background-color: #ffffff; height: 24px;\"><span style=\"color: #ffffff;\">&nbsp;<\/span><\/td>\n<td style=\"width: 11.5553%; text-align: center; border-color: #000000; border-style: none; background-color: #ffffff; height: 24px;\"><span style=\"color: #ffffff;\">&nbsp;<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 5.37975%; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"color: #ffffff;\">No<\/span><\/td>\n<td style=\"width: 57.2148%; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"font-size: 12pt; color: #ffffff;\">\u66f8\u7c4dAPI<\/span><\/td>\n<td style=\"width: 11.3884%; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"color: #ffffff;\">\u767b\u9332<\/span><\/td>\n<td style=\"width: 11.2091%; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"color: #ffffff;\">\uff83\uff9e\uff70\uff80<\/span><\/td>\n<td style=\"width: 11.5553%; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"color: #ffffff;\">\u63a1\u7528<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 5.37975%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u2460<\/td>\n<td style=\"width: 57.2148%; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">Amazon Product Advertising API<\/span><\/td>\n<td style=\"width: 11.3884%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u8981<\/td>\n<td style=\"width: 11.2091%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u30fc<\/td>\n<td style=\"width: 11.5553%; text-align: center; border-style: solid; border-color: #000000; height: 24px;\"><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 5.37975%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u2461<\/td>\n<td style=\"width: 57.2148%; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">\u697d\u5929\u30d6\u30c3\u30af\u30b9\u66f8\u7c4d\u691c\u7d22API<\/span><\/td>\n<td style=\"width: 11.3884%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u8981<\/td>\n<td style=\"width: 11.2091%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u30fc<\/td>\n<td style=\"width: 11.5553%; text-align: center; border-style: solid; border-color: #000000; height: 24px;\"><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 5.37975%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u2462<\/td>\n<td style=\"width: 57.2148%; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">\u56fd\u7acb\u56fd\u4f1a\u56f3\u66f8\u9928\u30b5\u30fc\u30c1\u306e\u691c\u7d22\u7528API<\/span><\/td>\n<td style=\"width: 11.3884%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u4e0d\u8981<\/td>\n<td style=\"width: 11.2091%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">xml<\/td>\n<td style=\"width: 11.5553%; text-align: center; border-style: solid; border-color: #000000; height: 24px;\"><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 5.37975%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u2463<\/td>\n<td style=\"width: 57.2148%; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">Google Books APIs<\/span><\/td>\n<td style=\"width: 11.3884%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">\u4e0d\u8981<\/td>\n<td style=\"width: 11.2091%; height: 24px; text-align: center; border-style: solid; border-color: #000000;\">json<\/td>\n<td style=\"width: 11.5553%; text-align: center; border-style: solid; border-color: #000000; height: 24px;\"><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 5.37975%; height: 24px; text-align: center; border-style: solid; border-color: #000000; background-color: #effa20;\">\u2464<\/td>\n<td style=\"width: 57.2148%; height: 24px; border-style: solid; border-color: #000000; background-color: #effa20;\"><span style=\"font-size: 12pt; color: #ff0000;\">openBD<\/span><\/td>\n<td style=\"width: 11.3884%; height: 24px; text-align: center; border-style: solid; border-color: #000000; background-color: #effa20;\">\u4e0d\u8981<\/td>\n<td style=\"width: 11.2091%; height: 24px; text-align: center; border-style: solid; border-color: #000000; background-color: #effa20;\">json<\/td>\n<td style=\"width: 11.5553%; text-align: center; border-style: solid; border-color: #000000; height: 24px; background-color: #effa20;\">\u3007<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\"><br \/>\n<span style=\"font-size: 12pt;\">\u3000\u6b21\u306b\u66f8\u7c4dAPI\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u3067\u3059\u3002\u5148\u305a\u3001\u4e0b\u8868\u306b\u66f8\u7c4dAPI\u3078\u306e\u63a5\u7d9aURL\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002<\/span><\/span><\/p>\n<table style=\"height: 327px; width: 489px; border-collapse: collapse; border-style: none;\" border=\"1\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 508px; border-color: #000000; border-style: none; background-color: #ffffff; height: 24px; text-align: left;\" colspan=\"2\"><strong><span style=\"font-size: 14pt;\">\u3010\u66f8\u7c4dAPI\u306e\u63a5\u7d9aURL\u3011<\/span><br \/>\n<span style=\"font-size: 12pt;\"><span style=\"color: #ff0000;\">&nbsp; &nbsp;{isbn}<\/span><\/span><\/strong><span style=\"font-size: 10pt;\"><span style=\"color: #ff0000;\"><span style=\"color: #000000;\">\uff1aISBN\u756a\u53f7\uff0c<\/span><\/span><\/span><strong><span style=\"font-size: 12pt;\"><span style=\"color: #ff0000;\">{appID}<\/span><\/span><\/strong><span style=\"font-size: 10pt;\"><span style=\"color: #ff0000;\"><span style=\"color: #000000;\">\uff1a\u767b\u9332ID\uff08\u697d\u5929\u30d6\u30c3\u30af\u30b9\uff09<\/span><\/span><\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 21px; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"color: #ffffff;\">No<\/span><\/td>\n<td style=\"width: 487px; text-align: center; background-color: #454242; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"font-size: 12pt; color: #ffffff;\">\u66f8\u7c4dAPI\u63a5\u7d9aURL<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 21px; height: 48px; text-align: center; border-style: solid; border-color: #000000;\" rowspan=\"2\">\u2460<\/td>\n<td style=\"width: 487px; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">\u697d\u5929\u30d6\u30c3\u30af\u30b9\u66f8\u7c4d\u691c\u7d22API<br \/>\n<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 487px; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">https:\/\/app.rakuten.co.jp\/services\/api\/BooksTotal\/Search\/20170404?format=json&amp;isbnjan=<strong><span style=\"color: #ff0000;\">{isbn}<\/span><\/strong>&amp;applicationId=<strong><span style=\"color: #ff0000;\">{appID}<\/span><\/strong><br \/>\n<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 21px; height: 24px; text-align: center; border-style: solid; border-color: #000000;\" rowspan=\"2\">\u2461<\/td>\n<td style=\"width: 487px; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">\u56fd\u7acb\u56fd\u4f1a\u56f3\u66f8\u9928\u30b5\u30fc\u30c1\u306e\u691c\u7d22\u7528API<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 487px; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"font-size: 12pt;\">http:\/\/iss.ndl.go.jp\/api\/sru?operation=searchRetrieve&amp;query=isbn=<strong><span style=\"color: #ff0000;\">{isbn}<\/span><\/strong><\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 21px; height: 24px; text-align: center; border-style: solid; border-color: #000000;\" rowspan=\"2\">\u2463<\/td>\n<td style=\"width: 487px; height: 24px; border-style: solid; border-color: #000000;\"><span style=\"font-size: 12pt;\">Google Books APIs<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 487px; border-style: solid; border-color: #000000; height: 24px;\"><span style=\"font-size: 12pt;\">https:\/\/www.googleapis.com\/books\/v1\/volumes?q=isbn:<strong><span style=\"color: #ff0000;\">{isbn}<\/span><\/strong><\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 21px; height: 24px; text-align: center; border-style: solid; border-color: #000000; background-color: #ffffff;\" rowspan=\"2\"><span style=\"color: #000000;\">\u2464<\/span><\/td>\n<td style=\"width: 487px; height: 24px; border-style: solid; border-color: #000000; background-color: #ffffff;\"><span style=\"font-size: 12pt; color: #000000;\">openBD<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 487px; border-style: solid; border-color: #000000; height: 24px; background-color: #ffffff;\"><span style=\"font-size: 12pt; color: #000000;\">https:\/\/api.openbd.jp\/v1\/get?isbn=<strong><span style=\"color: #ff0000;\">{isbn}<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\"><br \/>\n<span style=\"font-size: 12pt;\">\u3000Google Books APIs\u306e\u63a5\u7d9aURL\u5185\u306e ISBN\u756a\u53f7\uff08<strong><span style=\"color: #ff0000;\">{isbn}<\/span><\/strong>\uff09\u306b\u691c\u7d22\u3057\u305f\u3044\u66f8\u7c4d\u306eISBN\u756a\u53f7\u3092\u8a2d\u5b9a\u3057\u3001GoogleChrome\u3067URL\u5165\u529b\u3059\u308b\u3068 \u6b21\u306e\u56f3\u306e\u69d8\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002<span style=\"font-size: 12pt;\">\u8d64\u304f\u30de\u30fc\u30af\u3057\u305f\u7b87\u6240\u3092\u307f\u308b\u3068\u30bf\u30a4\u30c8\u30eb\u30fb\u8457\u8005\u30fb\u51fa\u7248\u65e5\u7b49\u306e\u60c5\u5831\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n<\/span>\u3000\u66f8\u7c4d ISBN\u756a\u53f7\u3092\u8aad\u307f\u53d6\u308a\u3001\u30a8\u30af\u30bb\u30ebVBA\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f7f\u3063\u3066\u3001\u66f8\u7c4dAPI\u306e\u63a5\u7d9aURL\u306bISBN\u756a\u53f7\u3092<\/span><\/span><span style=\"font-size: 12pt;\"><span style=\"font-size: 12pt;\">\u8a2d\u5b9a\u3001HTTP\u30ea\u30af\u30a8\u30b9\u30c8\u3001\u8fd4\u4fe1\u7d50\u679c\u53d7\u4fe1\u30fb\u89e3\u6790\u51fa\u6765\u308c\u3070\u3001\u30ea\u30b9\u30c8\u4f5c\u6210\u3092\u81ea\u52d5\u5316\u3067\u304d\u305d\u3046\u3067\u3059\u3002<br \/>\n<\/span><\/span><img loading=\"lazy\" class=\"aligncenter size-full wp-image-3454\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/003-5.png\" alt=\"\" width=\"735\" height=\"358\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/003-5.png 735w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/003-5-300x146.png 300w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/p>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">\u30a8\u30af\u30bb\u30ebVBA\u3067HTTP\u30ea\u30af\u30a8\u30b9\u30c8<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u30a8\u30af\u30bb\u30ebVBA\u3067\u306eHTTP\u30ea\u30af\u30a8\u30b9\u30c8\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/span><\/p>\n<p>\u2460\u53c2\u7167\u8a2d\u5b9a\uff08Microsoft XML, v6.0\uff09<br \/>\n<span style=\"font-size: 12pt;\">\u3000\u30a8\u30af\u30bb\u30ebVBE\u3092\u958b\u3044\u3066\u3001\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300c\u30c4\u30fc\u30eb\u300d\u2192\u300c\u53c2\u7167\u8a2d\u5b9a\u300d\u3092\u958b\u304d\u307e\u3059\u3002\u300c\u53c2\u7167\u8a2d\u5b9a\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u958b\u3044\u305f\u3089\u300cMicrosoft XML, v6.0\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3066\u201cOK\u201d\u3057\u307e\u3059\u3002<\/span><br \/>\n<img loading=\"lazy\" class=\"aligncenter size-full wp-image-3460\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/006-1.png\" alt=\"\" width=\"865\" height=\"301\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/006-1.png 865w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/006-1-300x104.png 300w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/006-1-768x267.png 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><br \/>\n\u2461HTTP\u30ea\u30af\u30a8\u30b9\u30c8\u95a2\u6570\uff08VBA\uff09<br \/>\n<span style=\"font-size: 12pt;\">\u3000\u6b21\u306e\u95a2\u6570\u3092 ISBN\u756a\u53f7\u3092\u6307\u5b9a\u3057\u3066\u547c\u3076\u3068\u30b5\u30fc\u30d0\u30fc\u304b\u3089\u306e\u30ec\u30b9\u30dd\u30f3\u30b9\u3092\u53d7\u3051\u53d6\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\uff08<span style=\"font-size: 12pt; color: #000000;\">openBD<\/span>\uff09<\/span><\/p>\n<pre class=\"lang:default mark:5 decode:true \" title=\"http_request\u3000(VBA)\">Private Function HTTP_REQ(isbn_no)   \n    Dim httpReturn\n    Dim http_url\n    Dim httpReq As XMLHTTP60\n    http_url = \"https:\/\/api.openbd.jp\/v1\/get?isbn=\" &amp; isbn_no\n    \nOn Error GoTo Err_Handling   \n    Set httpReq = New XMLHTTP60\n    httpReq.Open \"GET\", http_url\n    httpReq.Send\n \n    Do While httpReq.readyState &lt; 4\n        DoEvents\n    Loop\n \n    httpReturn = httpReq.responseText\n    Set httpReq = Nothing\n    HTTP_REQ = httpReturn\n    Exit Function\n \nErr_Handling:\n    Set httpReq = Nothing\n    HTTP_REQ = \"ERR\"\nEnd Function<\/pre>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">JSON\u5f62\u5f0f\u30c7\u30fc\u30bf\u89e3\u6790<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u6b21\u306b\u53d7\u4fe1\u3057\u305fJSON\u5f62\u5f0f\u30c7\u30fc\u30bf\u306e\u89e3\u6790\u3067\u3059\u3002<br \/>\n<span style=\"font-size: 12pt;\">\u3000JSON\u3068\u306f\u6b21\u306e\u69d8\u306a\u3082\u306e\u3067\u3059\u3002<\/span><\/span><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\">JavaScript Object Notation\uff08JSON\u3001\u30b8\u30a7\u30a4\u30bd\u30f3\uff09\u306f\u8efd\u91cf\u306a\u30c7\u30fc\u30bf\u8a18\u8ff0\u8a00\u8a9e\u306e1\u3064\u3067\u3042\u308b\u3002\u69cb\u6587\u306fJavaScript\u306b\u304a\u3051\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u8868\u8a18\u6cd5\u3092\u30d9\u30fc\u30b9\u3068\u3057\u3066\u3044\u308b\u304c\u3001JSON\u306fJavaScript\u5c02\u7528\u306e\u30c7\u30fc\u30bf\u5f62\u5f0f\u3067\u306f\u6c7a\u3057\u3066\u306a\u304f\u3001\u69d8\u3005\u306a\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3084\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u9593\u306b\u304a\u3051\u308b\u30c7\u30fc\u30bf\u306e\u53d7\u3051\u6e21\u3057\u306b\u4f7f\u3048\u308b\u3088\u3046\u8a2d\u8a08\u3055\u308c\u3066\u3044\u308b\u3002<br \/>\n\u30d5\u30ea\u30fc\u767e\u79d1\u4e8b\u5178\u300e\u30a6\u30a3\u30ad\u30da\u30c7\u30a3\u30a2\uff08Wikipedia\uff09\u300f\u3088\u308a<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\"><br \/>\n<span style=\"font-size: 12pt;\">\u3000\u4f55\u3068\u306a\u304f\u96f0\u56f2\u6c17\u306f\u7406\u89e3\u3057\u307e\u3057\u305f\u304c\u3001\u53b3\u5bc6\u306b\u306f\u5224\u308a\u307e\u305b\u3093\u3002\u6240\u8a6e\u606f\u5b50\u306e\u6f2b\u753b\u672c\u7ba1\u7406\u7528\u306a\u306e\u3067\u3001\u3053\u3053\u3067\u306f\u52b4\u529b\u3092\u304b\u3051\u305a\u306b\u5358\u306a\u308b\u30c6\u30ad\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u53d7\u4fe1\u3057\u305f\u3082\u306e\u3068\u3057\u3066\u51e6\u7406\u3057\u307e\u3059\u3002<br \/>\n<span style=\"font-size: 12pt;\">\u3000\u4e0b\u8a18\u306f \u201c<span style=\"color: #000000;\">openBD\u201d \u306bHTTP\u30ea\u30af\u30a8\u30b9\u30c8\u3057\u3001\u53d7\u4fe1\u3057\u305f\u30c7\u30fc\u30bf\u3067\u3059\u3002\u6700\u5f8c\u306e &#8220;summary&#8221; \u4ee5\u964d\uff08\u8d64\u8272\u90e8\uff09\u306e\u90e8\u5206\u306b\u5165\u624b\u3057\u305f\u3044\u60c5\u5831\u304c\u96c6\u7d04\u3055\u308c\u3066\u3044\u308b\u69d8\u3067\u3059\u3002<\/span><\/span><br \/>\n<img loading=\"lazy\" class=\"aligncenter size-full wp-image-3469\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/007-1.png\" alt=\"\" width=\"911\" height=\"448\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/007-1.png 911w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/007-1-300x148.png 300w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/007-1-768x378.png 768w\" sizes=\"(max-width: 911px) 100vw, 911px\" \/>\u3000<span style=\"color: #000000;\">&#8220;summary&#8221; \u4ee5\u964d\u306e\u90e8\u5206\u3092\u629c\u304d\u51fa\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u3001\u6b32\u3057\u3044\u60c5\u5831\u306f\u3001&#8221;title&#8221;\uff08\u984c\u540d\uff09\uff0c&#8221;author&#8221;\uff08\u4f5c\u8005\uff09\uff0c&#8221;pubdate&#8221;\uff08\u51fa\u7248\u65e5\uff09\u7a0b\u5ea6\u3067\u3059\u3002\u3064\u307e\u308a\u3001&nbsp;<span style=\"background-color: #ffff00;\">&#8220;summary&#8221;: { <strong><span style=\"color: #ff0000;\">\u6b32\u3057\u3044\u60c5\u5831\u7fa4<\/span><\/strong> }&nbsp;<\/span><\/span><\/span><\/span>\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<br \/>\n<span style=\"font-size: 12pt;\">\u3000\u6587\u5b57\u5217\u95a2\u6570 ( InStr\u7b49 ) \u3092\u4f7f\u3063\u3066\u3001<span style=\"color: #000000;\"><span style=\"background-color: #ffff00;\">&#8220;summary&#8221;<\/span><\/span>\u306e\u4f4d\u7f6e\u3092\u691c\u51fa\u3057\u3001\u66f4\u306b\u3053\u306e\u4f4d\u7f6e\u3088\u308a\u5f8c\u306b\u3042\u308b\u6700\u521d\u306e \u201c<span style=\"background-color: #ffff00;\"><strong><span style=\"color: #ff0000;\"> {<\/span><\/strong> <\/span>\u201d , \u201c<strong><span style=\"background-color: #ffff00; color: #ff0000;\"> } <\/span><\/strong>\u201d \u306e\u9593\u306b\u3042\u308b\u6587\u5b57\u5217\u304c<span style=\"color: #000000;\"><span style=\"background-color: #ffff00;\"> <strong><span style=\"color: #ff0000;\">\u6b32\u3057\u3044\u60c5\u5831\u7fa4<\/span><\/strong> <\/span><\/span>\u3067\u3059\u3002\u3053\u306e\u4e2d\u306e&nbsp;<span style=\"background-color: #00ffff;\">&#8220;title&#8221;<\/span>\uff0c<span style=\"background-color: #00ffff;\">&#8220;pubdate&#8221;<\/span>\uff0c<span style=\"background-color: #00ffff;\">&#8220;author&#8221;<\/span>&nbsp;\u306b\u5bfe\u5fdc\u3059\u308b\u6587\u5b57\u5217\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/span><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><span style=\"font-size: 12pt;\"><span style=\"background-color: #ffff00;\">&#8220;summary&#8221;: {<\/span>&#8220;isbn&#8221;: &#8220;9784774175942&#8221;, <span style=\"background-color: #00ffff;\">&#8220;title&#8221;<\/span>: &#8220;C#6\u5b9f\u8df5\u7684\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3008\u5165\u9580\u3009\u8b1b\u5ea7&#8221;, &#8220;volume&#8221;: &#8220;&#8221;, &#8220;series&#8221;: &#8220;&#8221;, &#8220;publisher&#8221;: &#8220;\u6280\u8853\u8a55\u8ad6\u793e&#8221;, <span style=\"background-color: #00ffff;\">&#8220;pubdate&#8221;<\/span>: &#8220;2015-09&#8221;, &#8220;cover&#8221;: &#8220;https:\/\/cover.openbd.jp\/9784774175942.jpg&#8221;, <span style=\"background-color: #00ffff;\">&#8220;author&#8221;<\/span>: &#8220;\u5ddd\u4fe3\u6676\uff0f\u8457&#8221;<span style=\"background-color: #ffff00;\">&nbsp;}&nbsp;<\/span>}]<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">&nbsp;<\/span><\/p>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">\u30a8\u30af\u30bb\u30ebVBA\u306b\u3088\u308b\u30ea\u30b9\u30c8\u4f5c\u6210<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u4e0b\u306e\u56f3\u304c\u4eca\u56de\u4f5c\u6210\u3057\u305f\u30a8\u30af\u30bb\u30ebVBA\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059\u3002\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u306e\u4e0a\u5074\u306b\u3042\u308b\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\uff11\uff13\u6841\u306eISBN\u756a\u53f7\u3092\u5165\u529b\u3059\u308b\u3068TextBox\u30c1\u30a7\u30f3\u30b8\u30a4\u30d9\u30f3\u30c8\u3067\u81ea\u52d5\u7684\u306b\u51e6\u7406\u3092\u958b\u59cb\u3057\u307e\u3059\u3002\u51e6\u7406\u304c\u7d42\u308f\u308b\u3068\u56f3\u306e\u6c34\u8272\u90e8\u306b\u691c\u7d22\u7d50\u679c\u3092\u8868\u793a\u3057\u3001\u540c\u6642\u306b\uff11\uff10\u884c\u76ee\u4ee5\u964d\u306e\u30ea\u30b9\u30c8\u90e8\u5206\u306e\u6700\u4e0b\u884c\u306b\u7d50\u679c\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/span><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-3474\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/008-1.png\" alt=\"\" width=\"925\" height=\"885\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/008-1.png 925w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/008-1-300x287.png 300w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2020\/03\/008-1-768x735.png 768w\" sizes=\"(max-width: 925px) 100vw, 925px\" \/><\/p>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">\u30d0\u30fc\u30b3\u30fc\u30c9\u30ea\u30fc\u30c0\u30fc\u306b\u3088\u308b\u9023\u7d9a\u51e6\u7406<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u4eca\u56de\u4f5c\u6210\u3057\u305f\u30a8\u30af\u30bb\u30ebVBA\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u30d0\u30fc\u30b3\u30fc\u30c9\u30ea\u30fc\u30c0\u30fc\u3092\u7528\u3044\u305f\u9023\u7d9a\u51e6\u7406\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002\u5f93\u3063\u3066\u3001\u30d1\u30bd\u30b3\u30f3\u306b\u76f4\u63a5ISBN\u756a\u53f7\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002bluetooth\u7b49\u306e\u7121\u7dda\u30d0\u30fc\u30b3\u30fc\u30c9\u30ea\u30fc\u30c0\u30fc\u3092\u4f7f\u3048\u3070\u5c11\u3057\u96e2\u308c\u305f\u3068\u3053\u308d\u304b\u3089\u3001\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u9023\u7d9a\u7684\u306b\u30d0\u30fc\u30b3\u30fc\u30c9\u3092\u8aad\u307f\u8fbc\u3093\u3067\u30ea\u30b9\u30c8\u3092\u8ffd\u52a0\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br \/>\n<\/span><\/p>\n<p><script type=\"text\/javascript\"><br \/>\n(function(b,c,f,g,a,d,e){b.MoshimoAffiliateObject=a;<br \/>\nb[a]=b[a]||function(){arguments.currentScript=c.currentScript<br \/>\n||c.scripts[c.scripts.length-2];(b[a].q=b[a].q||[]).push(arguments)};<br \/>\nc.getElementById(a)||(d=c.createElement(f),d.src=g,<br \/>\nd.id=a,e=c.getElementsByTagName(\"body\")[0],e.appendChild(d))})<br \/>\n(window,document,\"script\",\"\/\/dn.msmstatic.com\/site\/cardlink\/bundle.js\",\"msmaflink\");<br \/>\nmsmaflink({\"n\":\"\u7121\u7dda\u30d0\u30fc\u30b3\u30fc\u30c9\u30c7\u30fc\u30bf\u30b3\u30ec\u30af\u30bf\u30fc OPN-2002i [Bluetooth MFi\u30e9\u30a4\u30bb\u30f3\u30b9\u8a8d\u8a3c\u88fd\u54c1] \u30ec\u30fc\u30b6\u30fc\u30b9\u30ad\u30e3\u30ca\u30fc\u30e2\u30c7\u30eb \u30a6\u30a7\u30eb\u30b3\u30e0\u30c7\u30b6\u30a4\u30f3\",\"b\":\"\",\"t\":\"\",\"d\":\"https:\\\/\\\/thumbnail.image.rakuten.co.jp\",\"c_p\":\"\\\/@0_gold\\\/welcom-barcode\\\/images\\\/divar\\\/coolcradle\",\"p\":[\"\\\/opn-2002i-wht-01.jpg\",\"\\\/opn2002i-3.jpg\"],\"u\":{\"u\":\"https:\\\/\\\/item.rakuten.co.jp\\\/welcom-barcode\\\/opn-2002i-wht\\\/\",\"t\":\"rakuten\",\"r_v\":\"\"},\"aid\":{\"amazon\":\"1848374\",\"rakuten\":\"1848376\",\"yahoo\":\"1848375\"},\"eid\":\"SOneH\",\"s\":\"s\"});<br \/>\n<\/script><\/p>\n<div id=\"msmaflink-SOneH\">\u30ea\u30f3\u30af<\/div>\n<p><!-- MoshimoAffiliateEasyLink END --><\/p>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">VBA\u30d7\u30ed\u30b0\u30e9\u30e0<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u5168\u4f53\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u6b21\u306e\u901a\u308a\u3067\u3059\u3002\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u4e0a\u306b\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\u3068\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092\u914d\u7f6e\u3057\u307e\u3059\u3002<\/span><\/p>\n<pre class=\"height-set:true lang:default decode:true \" title=\"ISBN VBA Program\">Option Explicit\n\n'\u30dc\u30bf\u30f3\u30af\u30ea\u30c3\u30af\u3067\u51e6\u7406\u3092\u958b\u59cb\u3059\u308b\nPrivate Sub CommandButton1_Click()\n\n    Dim isbn_no\n\n    isbn_no = Trim(TextBox1.Text)   'ISBN\u756a\u53f7\n    \n    If Len(isbn_no) = 13 Or Len(isbn_no) = 10 Then\n        chk_isbn_info (isbn_no)\n    Else\n        MsgBox \"ISBN\u756a\u53f7\u306e\u306f\u300110\u6841 \u307e\u305f\u306f 13\u6841\u3067\u3059\u3002\", vbOKOnly + vbCritical\n    End If\n\n\nEnd Sub\n\n'\u30b7\u30fc\u30c8\u5185\u306e\u30c6\u30ad\u30b9\u30c8\u6587\u5b57\u6570\u306b\u3088\u3063\u3066\u51e6\u7406\u3092\u958b\u59cb\u3059\u308b\nPrivate Sub TextBox1_Change()\n\n    Dim isbn_no\n\n    isbn_no = Trim(TextBox1.Text)   'ISBN\u756a\u53f7\n    \n    If Len(isbn_no) = 13 Then\n        chk_isbn_info (isbn_no)\n    End If\n\nEnd Sub\n\n\n'ISBN\u691c\u7d22\u51e6\u7406\u3068\u7d50\u679c\u5206\u6790\nPrivate Sub chk_isbn_info(isbn_no)\n\n    Dim sht\n    Dim book_info\n    \n    sht = ActiveSheet.Name          '\u30b7\u30fc\u30c8\u540d\n    \n    Worksheets(sht).Range(Cells(6, 1), Cells(6, 5)).Interior.ColorIndex = xlNone\n    Worksheets(sht).Range(Cells(6, 1), Cells(6, 5)).Value = \"\"\n\n    \n    book_info = HTTP_REQ(isbn_no, 1, sht)\n    \n    If book_info = \"[null]\" Then\n        'HTTP\u901a\u4fe1\u30a8\u30e9\u30fc\n        Worksheets(sht).Cells(6, 1).Value = \"\u30c7\u30fc\u30bf\u7121\uff01\"\n        Worksheets(sht).Range(Cells(6, 1), Cells(6, 5)).Interior.ColorIndex = 6\n        MsgBox \"[null]\u304c\u8fd4\u4fe1\u3055\u308c\u307e\u3057\u305f\u3002\", vbOKOnly + vbCritical\n    \n    ElseIf book_info &lt;&gt; \"ERR\" Then\n        Call JSON_analyzer_api_openbd(book_info, isbn_no, sht)\n        'Call JSON_analyzer_simple(book_info, isbn_no, sht) 'Google Books APIs\n    \n    Else\n        'HTTP\u901a\u4fe1\u30a8\u30e9\u30fc\n        Worksheets(sht).Cells(6, 1).Value = \"HTTP\u30a8\u30e9\u30fc\uff01\"\n        Worksheets(sht).Range(Cells(6, 1), Cells(6, 5)).Interior.ColorIndex = 3\n        MsgBox \"HTTP\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002\", vbOKOnly + vbCritical\n    \n    End If\n    \n    With ActiveSheet.TextBox1\n        .SelStart = 0\n        .SelLength = Len(TextBox1)\n    End With\n\nEnd Sub\n\n\n\nPrivate Sub JSON_analyzer_api_openbd(jsn_inf, isbn_no, sht)\n    Dim chr_cnt\n    Dim kgr_cnt\n    Dim tmp_chr\n    Dim max_row\n    Dim ii  ', jj\n    Dim jsn_summary\n\n    Dim s_chr(3)\n    \n    \n    s_chr(0) = \"summary\"        '\u30a2\u30a4\u30c6\u30e0\u6570\n    s_chr(1) = \"title\"          '\u984c\u540d\n    s_chr(2) = \"author\"         '\u4f5c\u8005\n    s_chr(3) = \"pubdate\"        '\u51fa\u7248\u65e5\n    \n    \n    '\u6700\u7d42\u884c\u756a\u53f7\u53d6\u5f97\n    max_row = Worksheets(sht).Range(\"B9\").End(xlDown).Row\n    If max_row &gt; 10000 Then max_row = 9\n\n    chr_cnt = InStr(jsn_inf, s_chr(0))\n    jsn_summary = Right(jsn_inf, Len(jsn_inf) - chr_cnt - 6)\n    \n    \n    '\u5bfe\u8c61\u9805\u76ee\u3092\u691c\u7d22\u3059\u308b\u30eb\u30fc\u30d7\n    For ii = 1 To 3\n        chr_cnt = InStr(jsn_summary, s_chr(ii))\n        \n        If chr_cnt &gt; 0 Then\n            kgr_cnt = InStr(chr_cnt, jsn_summary, \",\")\n        \n            If kgr_cnt = 0 Then\n                kgr_cnt = InStr(chr_cnt, jsn_summary, \"}\")\n            End If\n                \n            tmp_chr = Mid(jsn_summary, chr_cnt, kgr_cnt - chr_cnt)\n            tmp_chr = Trim(Replace(Replace(Replace(Replace(Replace(Replace(tmp_chr, s_chr(ii), \"\"), \"\"\"\", \"\"), \":\", \"\"), \"[\", \"\"), \"]\", \"\"), Chr(10), \"\"))\n                \n            If ii = 0 Then\n                If tmp_chr = \"0\" Then\n                    Worksheets(sht).Cells(6, 1).Value = \"\u30c7\u30fc\u30bf\u7121\uff01\"\n                    Worksheets(sht).Range(Cells(6, 1), Cells(6, 5)).Interior.ColorIndex = 6\n                    MsgBox \"\u5bfe\u8c61\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u51fa\u6765\u307e\u305b\u3093\u3067\u3057\u305f\u3002\", vbOKOnly + vbCritical\n                    Exit Sub\n                End If\n            Else\n                If ii = 1 Then\n                    Worksheets(sht).Cells(max_row + 1, 1).Value = max_row - 8\n                    Worksheets(sht).Cells(max_row + 1, 2).Value = isbn_no\n                End If\n                 \n                Worksheets(sht).Cells(max_row + 1, 2 + ii).Value = tmp_chr\n            \n            End If\n            \n        End If\n    Next\n    \n    Worksheets(sht).Cells(6, 1).Value = \"\u6210\u529f\uff01\"\n    Worksheets(sht).Cells(6, 3).Value = Worksheets(sht).Cells(max_row + 1, 3).Value\n    Worksheets(sht).Range(Cells(6, 1), Cells(6, 5)).Interior.ColorIndex = 28\n    \n    Worksheets(sht).Range(Cells(10, 1), Cells(max_row, 5)).Interior.ColorIndex = xlNone\n    Worksheets(sht).Range(Cells(max_row + 1, 1), Cells(max_row + 1, 5)).Interior.ColorIndex = 28\n    \n    Application.Goto Cells(max_row + 2, 1), True\n    ActiveWindow.LargeScroll Down:=-1\n  \n    \nEnd Sub\n\n\n\n\n'ISBN\u756a\u53f7\u304b\u3089\u3001HTTP\u30ea\u30af\u30a8\u30b9\u30c8\u3057\u3001\u95a2\u9023\u60c5\u5831(JSON\u5f62\u5f0f)\u53d6\u5f97\n'\u3010\u4f8b\u3011https:\/\/www.googleapis.com\/books\/v1\/volumes?q=isbn:9784798046266\nPrivate Function HTTP_REQ(isbn_no, kbn, sht)\n    \n    Dim httpReturn\n    Dim http_url\n    Dim tmp\n \n    Dim httpReq As XMLHTTP60\n    \nOn Error GoTo Err_Handling\n    \n    Set httpReq = New XMLHTTP60\n    \n    If kbn = 0 Then\n        'Google Books APIs\n        http_url = \"https:\/\/www.googleapis.com\/books\/v1\/volumes?q=isbn:\" &amp; isbn_no\n    Else\n        'openBD\n        http_url = \"https:\/\/api.openbd.jp\/v1\/get?isbn=\" &amp; isbn_no\n    End If\n    \n    Worksheets(sht).Cells(7, 1).Value = http_url\n\n    httpReq.Open \"GET\", http_url\n    httpReq.Send\n \n    Do While httpReq.readyState &lt; 4\n        DoEvents\n    Loop\n \n    httpReturn = httpReq.responseText\n \n    Set httpReq = Nothing\n    \n    HTTP_REQ = httpReturn\n    \n    Exit Function\n \nErr_Handling:\n\n    \n    Set httpReq = Nothing\n    HTTP_REQ = \"ERR\"\n \nEnd Function<\/pre>\n<table style=\"width: 100%; border-collapse: collapse; border-style: none; height: 27px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px; border-bottom: 3px #0000ff solid;\">\n<td style=\"width: 2.76583%; border-style: none; background-color: #0000ff; height: 27px;\"><\/td>\n<td style=\"width: 3.58649%; border-style: none; height: 27px; background-color: #ffffff;\"><\/td>\n<td style=\"border-style: none; height: 27px; background-color: #ffffff; width: 96.2025%;\"><span style=\"font-family: verdana, geneva, sans-serif; font-size: 18pt;\"><strong><span class=\"alignleft size-full wp-image-3298\">\u307e\u3068\u3081<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\">\u3000\u606f\u5b50\u306e\u8981\u671b\u306f\u6e80\u305f\u305b\u305f\u69d8\u3067\u3059\u3002<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5927\u91cf\u306e\u6f2b\u753b\u672c\u3092\u767a\u898b \u3000\u4eca\u5e74\u3001\u306a\u3093\u3068\u304b\u5927\u5b66\u53d7\u9a13\u3092\u7d42\u3048\u305f\u606f\u5b50\u304c\u6574\u7406\u3092\u59cb\u3081\u307e\u3057\u305f\u3002\u7d0d\u6238\u306b\u6f2b\u753b\u672c\u304c\u305f\u304f\u3055\u3093\u3042\u308b\u306e\u306f\u77e5\u3063\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u3044\u3056\u606f\u5b50\u306e\u90e8\u5c4b\u306b\u904b\u3073\u5165\u308c\u3001\u5c71\u7a4d\u307f\u3055\u308c\u305f\u6f2b\u753b\u672c\u3092\u898b\u3066\u6115\u7136\u3068\u3057\u307e\u3057\u305f\u3002\u53d7\u9a13\u671f\u9593\u4e2d\u306b\u3082\u76f8\u5f53\u91cf\u306e\u6f2b\u753b\u672c\u3092 &hellip; <a href=\"https:\/\/kats-eye.net\/info\/2020\/03\/20\/comic-list-01\/\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u30a8\u30af\u30bb\u30eb\u3068\u66f8\u7c4dAPI\u3067\u3001\u6f2b\u753b\u672c\u30ea\u30b9\u30c8\u4f5c\u6210\u81ea\u52d5\u5316<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":3474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[98],"tags":[96,95,97],"_links":{"self":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/3440"}],"collection":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/comments?post=3440"}],"version-history":[{"count":37,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/3440\/revisions"}],"predecessor-version":[{"id":6009,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/3440\/revisions\/6009"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media\/3474"}],"wp:attachment":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media?parent=3440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/categories?post=3440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/tags?post=3440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}