{"id":3521,"date":"2022-08-31T21:11:27","date_gmt":"2022-08-31T12:11:27","guid":{"rendered":"https:\/\/weseek.co.jp\/tech\/?p=3521"},"modified":"2023-04-17T10:47:25","modified_gmt":"2023-04-17T01:47:25","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%9d%e3%83%bc%e3%82%bf%e3%83%ab%e3%81%ae%e3%82%b3%e3%83%8d%e3%82%af%e3%82%bf%e3%82%92%e4%bd%9c%e3%82%8a%e3%80%81rest-api%e3%81%8b%e3%82%89%e3%83%87%e3%83%bc%e3%82%bf","status":"publish","type":"post","link":"https:\/\/weseek.co.jp\/tech\/3521\/","title":{"rendered":"Looker Studio(\u65e7\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb)\u306e\u30b3\u30cd\u30af\u30bf\u3092\u81ea\u4f5c\u3057\u3001REST API\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b"},"content":{"rendered":"\n\n\n\n\n\n
\u30b9\u30c6\u30fc\u30bf\u30b9<\/th>\n\u6709\u7528\u5ea6<\/th>\n\u65e5\u6642<\/th>\n\u5099\u8003<\/th>\n<\/tr>\n<\/thead>\n
\u516c\u958b<\/td>\n\u2605\u2605\u2605<\/td>\n2022\/08\/31<\/td>\n<\/td>\n<\/tr>\n
\u66f4\u65b0<\/td>\n\u2605\u2605\u2605<\/td>\n2022\/11\/20<\/td>\nLooker Studio \u306b\u5bfe\u5fdc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u3053\u3093\u306b\u3061\u306f \u7530\u6751<\/a> \u3067\u3059\u3002<\/p>\n

Google Looker Studio (\u65e7\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb)<\/a> \u306f\u3001Google \u304c\u63d0\u4f9b\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u3092\u4e2d\u5fc3\u306b\u69d8\u3005\u306a\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u5229\u7528\u3057\u3066\u3001\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306e\u69cb\u7bc9\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u306a\u3044\u3082\u306e\u3067\u3082\u81ea\u5206\u3067\u30b3\u30cd\u30af\u30bf\u3092\u4f5c\u6210\u3057\u3066\u3001 Google Looker Studio \u306b\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3081\u307e\u3059\u3002\u30b3\u30cd\u30af\u30bf\u306f Google Apps Script \u3067\u8a18\u8ff0\u3057\u3001 Web API\u3001 CSV \u3001 JSON \u3001 XML \u3001Apps Script Services \u3001 JDBC API \u306a\u3069\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u4eca\u56de\u306f\u3001 REST API \u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080\u30b3\u30cd\u30af\u30bf\u3092\u4f5c\u308a\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 REST API \u306e\u30b5\u30fc\u30d3\u30b9\u3068\u3057\u3066\u3001 Redmine \u3092\u30d9\u30fc\u30b9\u306b\u8aac\u660e\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u57fa\u672c\u7684\u306b\u3069\u3093\u306a REST API \u3067\u3082\u69cb\u7bc9\u306e\u4ed5\u65b9\u306f\u540c\u69d8\u306b\u3067\u304d\u308b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3001\u9069\u5b9c\u3054\u81ea\u8eab\u306e\u3054\u5229\u7528\u3057\u305f\u3044\u30b5\u30fc\u30d3\u30b9\u306b\u7f6e\u304d\u63db\u3048\u3066\u304a\u8aad\u307f\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u306f\u3058\u3081\u306b Looker Studio \u306e\u5b8c\u6210\u5f62\u306e\u30a4\u30e1\u30fc\u30b8\u3092\u304a\u898b\u305b\u3059\u308b\u3068\u3001\u3053\u306e\u3088\u3046\u306a\u5f62\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\"file\"<\/p>\n

<\/p>\n\n

WESEEK \u306e\u958b\u767a\u624b\u6cd5<\/h2>\n

\u5f0a\u793e\u3067\u306f\u3001\u30a2\u30b8\u30e3\u30a4\u30eb\u958b\u767a\u306e\u7ba1\u7406\u30c4\u30fc\u30eb\u3068\u3057\u3066\u3001\u3053\u306e Redmine \u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002 sprint \u3054\u3068\u306b\u3069\u308c\u304f\u3089\u3044\u901f\u5ea6\uff08\u30d9\u30ed\u30b7\u30c6\u30a3\uff09\u304c\u51fa\u305b\u3066\u3044\u308b\u304b\u3084\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u3088\u3063\u3066\u306f\u3042\u308b\u671f\u9593\u306b\u304a\u3044\u3066\u3069\u308c\u304f\u3089\u3044\u30b9\u30c8\u30fc\u30ea\u30fc\u30dd\u30a4\u30f3\u30c8\u3092\u6d88\u5316\u3057\u3066\u3044\u308b\u304b\u306f\u6c17\u306b\u306a\u308b\u3068\u3053\u308d\u3067\u3059\u3002 Redmine \u306e REST API \u3092\u5229\u7528\u3057\u3066\u5b9f\u7e3e\u60c5\u5831\u3092\u53d6\u5f97\u3057\u3001 Looker Studio \u3067\u95b2\u89a7\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3089\u4fbf\u5229\u3060\u306a\u3068\u3044\u3046\u306e\u304c\u3001\u3053\u306e\u30b3\u30cd\u30af\u30bf\u30fc\u4f5c\u6210\u306e\u304d\u3063\u304b\u3051\u3067\u3059\u3002<\/p>\n

Redmine \u306e API \u3092\u4f7f\u3046<\/h2>\n

API \u306e\u6709\u52b9\u5316<\/h3>\n

\u7ba1\u7406<\/code> > \u8a8d\u8a3c<\/code> > REST\u306b\u3088\u308bWeb\u30b5\u30fc\u30d3\u30b9\u3092\u6709\u52b9\u306b\u3059\u308b<\/code> \u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3066\u3001 Redmine \u3067 REST API \u3092\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n

\"file\"<\/p>\n

API \u30a2\u30af\u30bb\u30b9\u30ad\u30fc\u306e\u78ba\u8a8d<\/h3>\n

Redmine REST API \u3092\u547c\u3073\u51fa\u3059\u3068\u304d\u306f\u3001 API \u30a2\u30af\u30bb\u30b9\u30ad\u30fc\u304c\u5fc5\u8981\u3067\u3059\u3002 \u500b\u4eba\u8a2d\u5b9a<\/code> > API\u30a2\u30af\u30bb\u30b9\u30ad\u30fc<\/code> \u304b\u3089\u78ba\u8a8d\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n

\"file\"<\/p>\n

\u30c1\u30b1\u30c3\u30c8\u4e00\u89a7\u306e\u53d6\u5f97<\/h3>\n

\u8a66\u3057\u306b REST API \u3092\u5229\u7528\u3057\u3066\u3001\u30c1\u30b1\u30c3\u30c8\u4e00\u89a7\u3092\u53d6\u5f97\u3057\u3066\u307f\u307e\u3059\u3002
\nHTTP Header \u306b X-Redmine-API-Key<\/code> \u3092\u8ffd\u52a0\u3057\u3001 API \u30a2\u30af\u30bb\u30b9\u30ad\u30fc\u3092\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002
\ncurl \u3067\u547c\u3073\u51fa\u3057\u3066\u307f\u308b\u3068\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u30c1\u30b1\u30c3\u30c8\u4e00\u89a7\u304c\u53d6\u5f97\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n

$ curl -s --request GET 'https:\/\/[REDMINE HOSTNAME]\/issues.json?project_id=1&limit=2' --header 'X-Redmine-API-Key: [REDMINE API TOKEN]' | jq .\n{\n    "issues": [\n    {\n      "id": 3503,\n      "project": {\n        "id": 1,\n        "name": "[FILTERED]"\n      },\n      "tracker": {\n        "id": 5,\n        "name": "\u30bf\u30b9\u30af"\n      },\n      "status": {\n        "id": 1,\n        "name": "\u65b0\u898f"\n      },\n      "priority": {\n        "id": 2,\n        "name": "\u901a\u5e38"\n      },\n      "author": {\n        "id": 141,\n        "name": "[FILTERED]"\n      },\n      "fixed_version": {\n        "id": 943,\n        "name": "sprint-25"\n      },\n      "parent": {\n        "id": 103421\n      },\n      "subject": "\u52d5\u4f5c\u78ba\u8a8d",\n      "description": "",\n      "start_date": "2022-05-19",\n      "done_ratio": 0,\n      "created_on": "2022-08-29T07:36:06Z",\n      "updated_on": "2022-08-29T07:36:06Z"\n    },\n    {\n      "id": 3502,\n      "project": {\n        "id": 1,\n        "name": "[FILTERED]"\n      },\n      "tracker": {\n        "id": 5,\n        "name": "\u30bf\u30b9\u30af"\n      },\n      "status": {\n        "id": 1,\n        "name": "\u65b0\u898f"\n      },\n      "priority": {\n        "id": 2,\n        "name": "\u901a\u5e38"\n      },\n      "author": {\n        "id": 141,\n        "name": "[FILTERED]"\n      },\n      "fixed_version": {\n        "id": 943,\n        "name": "sprint-25"\n      },\n      "parent": {\n        "id": 103421\n      },\n      "subject": "PR & Merge #3240",\n      "description": "PR\\r\\n\u30bf\u30b9\u30af\\r\\n#3240",\n      "start_date": "2022-05-19",\n      "done_ratio": 0,\n      "created_on": "2022-08-29T07:35:58Z",\n      "updated_on": "2022-08-29T07:35:58Z"\n    }\n  ],\n  "total_count": 82,\n  "offset": 0,\n  "limit": 2\n}<\/code><\/pre>\n
Redmine REST API \u306e\u8a73\u7d30\u306f \u3053\u3061\u3089<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
Looker Studio \u30b3\u30df\u30e5\u30cb\u30c6\u30a3 \u30b3\u30cd\u30af\u30bf\u3092\u4f5c\u308b<\/h2>\n
Google Looker Studio \u306e Codelab<\/a> \u3092\u53c2\u8003\u306b\u69cb\u7bc9\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n
Apps Script \u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308a\u3001\u4e0b\u8a18\u306e4\u3064\u306e\u95a2\u6570\u3092\u5b9a\u7fa9\u3057\u3066\u3001\u30b3\u30cd\u30af\u30bf\u3092\u4f5c\u6210\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n