https:\/\/developer.nulab.com\/ja\/docs\/backlog\/api\/2\/get-issue-list\/#<\/a><\/p>\n\u5168\u8ab2\u984c\u3092\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u306f\u3001offset\u3084count\u306a\u3069\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u9069\u5207\u306b\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\ncount\u3067\u6307\u5b9a\u53ef\u80fd\u306a\u8ab2\u984c\u6570\u306f100\u4ef6\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3001100\u4ef6\u4ee5\u4e0a\u8ab2\u984c\u304c\u3042\u308b\u5834\u5408\u306fHTTP\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u6570\u56de\u306b\u5206\u3051offset\u3082\u6307\u5b9a\u3057\u3066\u5b9f\u884c\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\n <\/p>\n
Backlog\u8907\u6570\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8ab2\u984c\u60c5\u5831\u3092\u4e00\u62ec\u51fa\u529b<\/h3>\n
\u4e0a\u8a18\u307e\u3067\u7406\u89e3\u3067\u304d\u3066\u3044\u308c\u3070\u3001\u6b8b\u308a\u306e\u4f5c\u696d\u306fGAS\u306e\u57fa\u672c\u3084\u95a2\u9023\u60c5\u5831\u3092\u8abf\u3079\u306a\u304c\u3089\u3001\u4ee5\u4e0b\u3092\u9ed9\u3005\u3068\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3068\u306a\u308a\u307e\u3059\u3002
\n\u30fbHTTP\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u6570\u56de\u306b\u5206\u3051\u3066\u5b9f\u884c\u3057\u3001\u5168\u8ab2\u984c\u4e00\u89a7\u3092\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b
\n\u30fb\u53d6\u5f97\u3057\u305f\u8ab2\u984c\u60c5\u5831\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u51fa\u529b\u3059\u308b
\n\u30fb\u8907\u6570\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b
\n\u30fb\u5b9f\u884c\u306e\u9032\u6357\u72b6\u6cc1\u3092\u8868\u793a\u3059\u308b
\n\u306a\u3069\u3002<\/p>\n
\u5404\u3005\u5b9f\u88c5\u3057\u305fGAS\u304c\u4e0b\u8a18\u3068\u306a\u308a\u307e\u3059\u3002
\n\u5909\u6570DOMAIN\u3001API_KEY\u306b\u306f\u3001\u4e0a\u8a18\u3067\u78ba\u8a8d\u3057\u305f\u30c9\u30e1\u30a4\u30f3\u3001API\u30ad\u30fc\u3092\u8a18\u8f09\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n\u4e0b\u8a18\u30b3\u30fc\u30c9\u3067\u306f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30ad\u30fc\u3092\u8907\u6570\u5b9a\u7fa9\u53ef\u80fd\u3068\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u5909\u6570PROJECT_KEYS\u306b\u30ad\u30fc\u3092\u8a18\u8f09\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n\/\/ Backlog\u8907\u6570\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8ab2\u984c\u60c5\u5831\u3092\u4e00\u62ec\u51fa\u529b\nfunction backlogIssues() {\n \/\/ \u5b9a\u6570\n const DOMAIN = \"test.backlog.com\";\n const API_KEY = \"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\";\n const PROJECT_KEYS = [\n '100_PROJECT',\n '101_PROJECT',\n ];\n\n for(let i=0; i<PROJECT_KEYS.length; i++){\n \/\/ \u9032\u6357\u8868\u793a\n var toastStr = "";\n var projectCnt = i + 1;\n toastStr += projectCnt + "\/" + PROJECT_KEYS.length + "\u3000\u3000\u3000\u3000\u3000\u3000\u3000";\n toastStr += PROJECT_KEYS[i] + "\u3000\u53d6\u5f97\u4e2d" + "\u3000\u3000\u3000\u3000\u3000\u3000\u3000";\n SpreadsheetApp.getActiveSpreadsheet().toast(toastStr, '\u5b9f\u884c\u4e2d', 600);\n \/\/ \u8ab2\u984c\u60c5\u5831\u3092\u4e00\u62ec\u51fa\u529b\n backlogProjectIssues(DOMAIN, API_KEY, PROJECT_KEYS[i], toastStr);\n }\n\n \/\/ \u7d42\u4e86\u51e6\u7406\n SpreadsheetApp.getActiveSpreadsheet().toast('\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002', '\u5b8c\u4e86', 10);\n}\n\n\n\n\/\/ \u6307\u5b9a\u3057\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8ab2\u984c\u60c5\u5831\u3092\u4e00\u62ec\u51fa\u529b\nfunction backlogProjectIssues(domain, apiKey, projectKey, toastStr) {\n \/\/ Backlog\u9805\u76ee\n const BACKLOG_ITEMS = [\n '\u30ad\u30fc',\n '\u7a2e\u5225',\n '\u30ab\u30c6\u30b4\u30ea\u30fc\u540d',\n '\u767a\u751f\u30d0\u30fc\u30b8\u30e7\u30f3',\n '\u4ef6\u540d',\n '\u72b6\u614b',\n '\u512a\u5148\u5ea6',\n '\u30de\u30a4\u30eb\u30b9\u30c8\u30fc\u30f3',\n '\u5b8c\u4e86\u7406\u7531',\n '\u62c5\u5f53\u8005',\n '\u767b\u9332\u8005',\n '\u767b\u9332\u65e5',\n '\u958b\u59cb\u65e5',\n '\u671f\u9650\u65e5',\n \/*\n \/\/ \u53d6\u5f97\u305b\u305a\u3068\u3057\u305f\u9805\u76ee\n '\u89aa\u8ab2\u984c\u30ad\u30fc',\n '\u8a73\u7d30',\n 'ID',\n '\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID',\n '\u30ad\u30fcID',\n '\u7a2e\u5225ID',\n '\u30ab\u30c6\u30b4\u30ea\u30fcID',\n '\u30d0\u30fc\u30b8\u30e7\u30f3ID',\n '\u72b6\u614bID',\n '\u512a\u5148\u5ea6ID',\n '\u30de\u30a4\u30eb\u30b9\u30c8\u30fc\u30f3ID',\n '\u5b8c\u4e86\u7406\u7531ID',\n '\u62c5\u5f53\u8005ID',\n '\u767b\u9332\u8005ID',\n *\/\n ]\n\n const RESPONSE_VAL = [\n 'issueKey',\n 'issueType.name',\n 'category.0.name',\n 'versions.0.name',\n 'summary',\n 'status.name',\n 'priority.name',\n 'milestone.0.name',\n 'resolution.name',\n 'assignee.name',\n 'createdUser.name',\n 'created',\n 'startDate',\n 'dueDate',\n \/* \n \/\/ \u53d6\u5f97\u305b\u305a\u3068\u3057\u305f\u9805\u76ee\n 'parentIssueId',\n 'description',\n 'id',\n 'projectId',\n 'keyId',\n 'issueType.id',\n 'category.0.id',\n 'versions.0.id',\n 'status.id',\n 'priority.id',\n 'milestone.0.id',\n 'resolution.id',\n 'assignee.id',\n 'createdUser.id',\n *\/\n ]\n\n \/\/ API\u30ea\u30af\u30a8\u30b9\u30c8\n function request(url) {\n const response = UrlFetchApp.fetch(url);\n const headers = response.getHeaders();\n const responseJson = JSON.parse(response.getContentText());\n\n \/\/ \u30ea\u30af\u30a8\u30b9\u30c8\u5236\u9650\u5bfe\u5fdc\n \/\/ https:\/\/backlog.com\/ja\/blog\/backlog-api-rate-limit-announcement\/\n const requestLimit = Number(headers['x-ratelimit-remaining']);\n if(requestLimit = COUNT_SIZE;\n \/\/ \u9032\u6357\u8868\u793a\n var outputStr = toastStr + \"\u8ab2\u984c\u53d6\u5f97\u72b6\u6cc1\uff1a \" + offset + \"\/\" + issuesTotal + \"\u3000\u3000\u3000\u3000\u3000\u3000\u3000\";\n SpreadsheetApp.getActiveSpreadsheet().toast(outputStr, '\u5b9f\u884c\u4e2d', 600);\n console.log(outputStr);\n }\n\n \/\/ \u53d6\u5f97\u30c7\u30fc\u30bf\u3092\u30ec\u30b3\u30fc\u30c9\u5316\n var records = issues.map(function (issue) {\n return RESPONSE_VAL.map(function (response) {\n return response.split('.').reduce(function (obj, field) {\n return obj ? obj[field] : '';\n }, issue);\n });\n });\n\n \/\/ \u30ec\u30b3\u30fc\u30c9\u5185\u30c7\u30fc\u30bf\u3092\u7f6e\u63db\n recordDateReplace(records);\n function recordDateReplace(records) {\n let num;\n for(let i=0; i 0){ \n sheet.getRange(2, 1, records.length, RESPONSE_VAL.length).setValues(records);\n }\n \/\/ \u30b7\u30fc\u30c8\u306e\u5e45\u3092\u8abf\u6574\n sheet.autoResizeColumns(1, sheet.getMaxColumns());\n}\n\n\/\/ \u7279\u5b9a\u30bb\u30eb\u304b\u3089\u884c\u6700\u5f8c\u5c3e\u306e\u30bb\u30eb\u307e\u3067\u306e\u7bc4\u56f2\u3092\u53d6\u5f97\nfunction getRangeFromSpecificCellDownwardLastCell (sheet, specificCell) {\n var initCell = sheet.getRange(specificCell);\n var lastCell = initCell.getNextDataCell(SpreadsheetApp.Direction.DOWN);\n var range = sheet.getRange(initCell.getRow(), initCell.getColumn(), (lastCell.getRow() - initCell.getRow()+1), (lastCell.getColumn() - initCell.getColumn()+1));\n \/\/console.log(range.getA1Notation());\n return range;\n}\n<\/pre>\n <\/p>\n
\u304a\u308f\u308a\u306b<\/h3>\n
\u4ee5\u4e0a\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u7528\u3044\u3066Backlog\u306e\u8ab2\u984c\u60c5\u5831\u3092\u4e00\u62ec\u51fa\u529b\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3054\u7d39\u4ecb\u3044\u305f\u3057\u307e\u3057\u305f\u3002
\n\u8ab2\u984c\u3092\u51fa\u529b\u5f8c\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30b5\u30de\u30ea\u30fc\u7528\u306e\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3067\u3001\u65e5\u3005\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u5168\u4f53\u306e\u72b6\u6cc1\u306a\u3069\u3092\u628a\u63e1\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\n\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u30fb\u30bf\u30b9\u30af\u7ba1\u7406\u30c4\u30fc\u30eb\u3084GAS\u306a\u3069\u3001\u65e5\u3005\u9032\u5316\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u3053\u308c\u3089\u306e\u30c4\u30fc\u30eb\u3092\u6d3b\u7528\u3057\u3001\u696d\u52d9\u306e\u52b9\u7387\u5411\u4e0a\u306b\u304a\u5f79\u7acb\u3066\u3044\u305f\u3060\u3051\u308c\u3070\u5e78\u3044\u3067\u3059\u3002
\n\u305d\u308c\u3067\u306f\u3001\u307e\u305f\u304a\u4f1a\u3044\u3057\u307e\u3057\u3087\u3046\u3002
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
\u307f\u306a\u3055\u3093\u3001\u3053\u3093\u306b\u3061\u306f\u3002 \u30c7\u30d0\u30a4\u30b9\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u958b\u767a\u90e8\u306enomura\u3067\u3059\u3002 \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u30fb\u30bf\u30b9\u30af\u7ba1\u7406\u30c4\u30fc\u30eb\u306f\u6570\u591a\u304f\u5b58\u5728\u3057\u307e\u3059\u304c\u3001\u5f53\u793e\u3067\u306f\u76f4\u611f\u7684\u3067\u4f7f\u3044\u3084\u3059\u3044Backlog\u3092\u63a1\u7528\u3057\u3066\u3044\u307e\u3059\u3002 Backlog\u5358\u4f53\u3067\u3082\u30d7\u30ed\u30b8\u30a7\u30af […]<\/p>\n","protected":false},"author":82,"featured_media":11280,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[159,161,160,92],"_links":{"self":[{"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts\/11094"}],"collection":[{"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11094"}],"version-history":[{"count":68,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts\/11094\/revisions"}],"predecessor-version":[{"id":22755,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/posts\/11094\/revisions\/22755"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=\/wp\/v2\/media\/11280"}],"wp:attachment":[{"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ecomottblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.ecomottblog.com\/wp-content\/uploads\/2023\/10\/api\u30ad\u30fc\u767b\u9332.png\")
![\"\"](\"https:\/\/www.ecomottblog.com\/wp-content\/uploads\/2023\/10\/\u30d6\u30e9\u30a6\u30b6\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u60c5\u5831\u3092\u53d6\u5f97.png\")
![\"\"](\"https:\/\/www.ecomottblog.com\/wp-content\/uploads\/2023\/10\/appsscript.png\")
<\/p>\n![\"\"](\"https:\/\/www.ecomottblog.com\/wp-content\/uploads\/2023\/10\/gas\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u60c5\u5831\u3092\u53d6\u5f97.png\")
<\/p>\n![\"\"](\"https:\/\/www.ecomottblog.com\/wp-content\/uploads\/2023\/10\/gas\u627f\u8a8d\u753b\u9762.png\")
<\/p>\n![\"\"](\"https:\/\/www.ecomottblog.com\/wp-content\/uploads\/2023\/10\/gas\u3067\u8ab2\u984c\u4e00\u89a7\u3092\u53d6\u5f97.png\")
<\/p>\n