\u8a8d\u8a3c\u60c5\u5831\u306e\u8a2d\u5b9a\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u5b9f\u969b\u306b\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002OAuth 2.0\u306e\u5834\u5408\u3068\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u5834\u5408\u3067\u624b\u9806\u304c\u7570\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\n
\u8a8d\u8a3cURL\u3092\u751f\u6210\u3057\u30e6\u30fc\u30b6\u30fc\u306b\u8a8d\u53ef\u3092\u6c42\u3081\u308b<\/li>\n\n\n\n
\u30ea\u30c0\u30a4\u30ec\u30af\u30c8\u3067\u8a8d\u53ef\u30b3\u30fc\u30c9\u3092\u53d6\u5f97<\/li>\n\n\n\n
\u8a8d\u53ef\u30b3\u30fc\u30c9\u3092\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u306b\u4ea4\u63db<\/li>\n\n\n\n
\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u4f7f\u3063\u3066API\u547c\u3073\u51fa\u3057<\/li>\n<\/ol>\n<\/div>\n\n\n
\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u5834\u5408:<\/strong><\/p>\n\n\n\n
\n
\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306eJSON\u30ad\u30fc\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/li>\n\n\n\n
JWT\u3092\u751f\u6210\u3057\u3066\u7f72\u540d<\/li>\n\n\n\n
\u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306b\u30ea\u30af\u30a8\u30b9\u30c8<\/li>\n\n\n\n
\u8fd4\u5374\u3055\u308c\u305f\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u4f7f\u7528<\/li>\n<\/ol>\n\n\n\n
Python\u306e\u5834\u5408\u3001google-auth<\/code>\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u308c\u3089\u306e\u51e6\u7406\u3092\u7c21\u5358\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u5177\u4f53\u7684\u306a\u30b3\u30fc\u30c9\u4f8b\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\n\n\n\n<\/i>Looker Studio API\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3010Python\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u4ed8\u304d\u3011<\/span><\/span><\/h2>\n\n\n\n\u5b9f\u969b\u306ePython\u30b3\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u3001Looker Studio API\u306e\u57fa\u672c\u7684\u306a\u64cd\u4f5c\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u306e\u30b3\u30fc\u30c9\u3092\u305d\u306e\u307e\u307e\u5b9f\u884c\u3059\u308c\u3070\u3001\u3059\u3050\u306bAPI\u3092\u8a66\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n \u8a8d\u8a3c\u30d5\u30ed\u30fc\u306e\u5b9f\u88c5<\/h3>\n\n\n\n\u307e\u305a\u3001\u5fc5\u8981\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n pip install google-auth google-auth-oauthlib google-auth-httplib2 requests\n<\/code><\/pre>\n\n\n\n\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u305f\u8a8d\u8a3c\u306e\u5b9f\u88c5\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n from google.oauth2 import service_account\nimport requests\n\n# \u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306eJSON\u30ad\u30fc\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\nSCOPES = ['https:\/\/www.googleapis.com\/auth\/datastudio']\nSERVICE_ACCOUNT_FILE = 'service-account-key.json'\n\ncredentials = service_account.Credentials.from_service_account_file(\n SERVICE_ACCOUNT_FILE, scopes=SCOPES)\n\n# \u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u53d6\u5f97\ncredentials.refresh(requests.Request())\naccess_token = credentials.token\n<\/code><\/pre>\n\n\n\n\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306eJSON\u30ad\u30fc\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u8a8d\u8a3c\u60c5\u5831\u3092\u8aad\u307f\u8fbc\u307f\u3001\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002access_token<\/code>\u5909\u6570\u306b\u683c\u7d0d\u3055\u308c\u305f\u30c8\u30fc\u30af\u30f3\u3092\u4f7f\u3063\u3066\u3001\u4ee5\u964d\u306eAPI\u547c\u3073\u51fa\u3057\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n \u8a8d\u8a3c\u60c5\u5831\u306f\u6a5f\u5bc6\u60c5\u5831\u306e\u305f\u3081\u3001\u74b0\u5883\u5909\u6570\u3084\u79d8\u5bc6\u7ba1\u7406\u30b5\u30fc\u30d3\u30b9\u3067\u7ba1\u7406\u3057\u3001\u30b3\u30fc\u30c9\u306b\u76f4\u63a5\u8a18\u8ff0\u3057\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u30ec\u30dd\u30fc\u30c8\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b\u30b3\u30fc\u30c9<\/h3>\n\n\n\n\u8a8d\u8a3c\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u5b9f\u969b\u306b\u30ec\u30dd\u30fc\u30c8\u4e00\u89a7\u3092\u53d6\u5f97\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n import requests\nimport json\n\ndef get_reports(access_token):\n \"\"\"Looker Studio\u306e\u30ec\u30dd\u30fc\u30c8\u4e00\u89a7\u3092\u53d6\u5f97\"\"\"\n url = 'https:\/\/datastudio.googleapis.com\/v1\/assets:search'\n \n headers = {\n 'Authorization': f'Bearer {access_token}',\n 'Content-Type': 'application\/json'\n }\n \n params = {\n 'assetTypes': 'REPORT',\n 'pageSize': 50 # \u6700\u5927100\u307e\u3067\u6307\u5b9a\u53ef\u80fd\n }\n \n response = requests.post(url, headers=headers, json=params)\n \n if response.status_code == 200:\n return response.json()\n else:\n print(f'Error: {response.status_code}')\n print(response.text)\n return None\n\n# \u5b9f\u884c\u4f8b\nreports = get_reports(access_token)\nif reports:\n for asset in reports.get('assets', []):\n print(f\"\u30ec\u30dd\u30fc\u30c8\u540d: {asset.get('name')}\")\n print(f\"\u6700\u7d42\u66f4\u65b0: {asset.get('updateTime')}\")\n print('---')\n<\/code><\/pre>\n\n\n\n\u3053\u306e\u30b3\u30fc\u30c9\u306f\u3001\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u306a\u3059\u3079\u3066\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u53d6\u5f97\u3057\u3001\u30ec\u30dd\u30fc\u30c8\u540d\u3068\u6700\u7d42\u66f4\u65b0\u65e5\u6642\u3092\u8868\u793a\u3057\u307e\u3059\u3002pageSize<\/code>\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u4e00\u5ea6\u306b\u53d6\u5f97\u3059\u308b\u4ef6\u6570\u3092\u6307\u5b9a\u3067\u304d\u3001\u5927\u91cf\u306e\u30ec\u30dd\u30fc\u30c8\u304c\u3042\u308b\u5834\u5408\u306f\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u88c5\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u7279\u5b9a\u306e\u30ec\u30dd\u30fc\u30c8\u60c5\u5831\u3092\u691c\u7d22\u3059\u308b\u65b9\u6cd5<\/h3>\n\n\n\n\u7279\u5b9a\u306e\u6761\u4ef6\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u691c\u7d22\u3059\u308b\u5834\u5408\u3001\u30d5\u30a3\u30eb\u30bf\u6a5f\u80fd\u3092\u6d3b\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n def search_reports_by_owner(access_token, owner_email):\n \"\"\"\u7279\u5b9a\u306e\u30aa\u30fc\u30ca\u30fc\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u691c\u7d22\"\"\"\n url = 'https:\/\/datastudio.googleapis.com\/v1\/assets:search'\n \n headers = {\n 'Authorization': f'Bearer {access_token}',\n 'Content-Type': 'application\/json'\n }\n \n # \u691c\u7d22\u6761\u4ef6\u3092\u6307\u5b9a\n params = {\n 'assetTypes': 'REPORT',\n 'pageSize': 50,\n 'filter': f'owner:\"{owner_email}\"'\n }\n \n response = requests.post(url, headers=headers, json=params)\n return response.json() if response.status_code == 200 else None\n\n# \u4f7f\u7528\u4f8b\nowner_reports = search_reports_by_owner(access_token, 'user@example.com')\n<\/code><\/pre>\n\n\n\n\u30d5\u30a3\u30eb\u30bf\u6761\u4ef6\u3092\u5de5\u592b\u3059\u308b\u3053\u3068\u3067\u3001\u300c\u7279\u5b9a\u671f\u9593\u306b\u66f4\u65b0\u3055\u308c\u305f\u30ec\u30dd\u30fc\u30c8\u300d\u3084\u300c\u7279\u5b9a\u306e\u540d\u524d\u3092\u542b\u3080\u30ec\u30dd\u30fc\u30c8\u300d\u306a\u3069\u3082\u691c\u7d22\u3067\u304d\u307e\u3059\u3002\u8907\u96d1\u306a\u6761\u4ef6\u306e\u5834\u5408\u306f\u3001\u53d6\u5f97\u5f8c\u306bPython\u5074\u3067\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u3059\u308b\u65b9\u304c\u7c21\u5358\u306a\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u5171\u6709\u6a29\u9650\u3092\u78ba\u8a8d\u3059\u308bAPI\u547c\u3073\u51fa\u3057<\/h3>\n\n\n\n\u30ec\u30dd\u30fc\u30c8\u306e\u5171\u6709\u8a2d\u5b9a\u3092\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001\u500b\u5225\u306e\u30ec\u30dd\u30fc\u30c8\u60c5\u5831\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n def get_report_permissions(access_token, asset_name):\n \"\"\"\u30ec\u30dd\u30fc\u30c8\u306e\u6a29\u9650\u60c5\u5831\u3092\u53d6\u5f97\"\"\"\n url = f'https:\/\/datastudio.googleapis.com\/v1\/{asset_name}'\n \n headers = {\n 'Authorization': f'Bearer {access_token}'\n }\n \n response = requests.get(url, headers=headers)\n \n if response.status_code == 200:\n report_data = response.json()\n permissions = report_data.get('permissions', [])\n \n print(f\"\u30ec\u30dd\u30fc\u30c8: {report_data.get('displayName')}\")\n print(f\"\u30aa\u30fc\u30ca\u30fc: {report_data.get('owner')}\")\n print(\"\\n\u5171\u6709\u8a2d\u5b9a:\")\n for perm in permissions:\n print(f\"- {perm.get('email')}: {perm.get('role')}\")\n \n return report_data\n else:\n print(f'Error: {response.status_code}')\n return None\n<\/code><\/pre>\n\n\n\n\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u30aa\u30fc\u30ca\u30fc\u60c5\u5831\u3068\u3001\u5171\u6709\u3055\u308c\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u306e\u4e00\u89a7\u3068\u305d\u306e\u6a29\u9650\u30ec\u30d9\u30eb(\u95b2\u89a7\u8005\u3001\u7de8\u96c6\u8005\u306a\u3069)\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u76e3\u67fb\u306b\u6d3b\u7528\u3067\u304d\u308b\u91cd\u8981\u306a\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n \u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h3>\n\n\n\nAPI\u547c\u3073\u51fa\u3057\u3067\u306f\u3001\u3055\u307e\u3056\u307e\u306a\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u9069\u5207\u306a\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u3092\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3067\u3001\u5b89\u5b9a\u3057\u305f\u904b\u7528\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n import time\nfrom requests.exceptions import RequestException\n\ndef api_call_with_retry(func, max_retries=3, *args, **kwargs):\n \"\"\"\u30ea\u30c8\u30e9\u30a4\u6a5f\u80fd\u4ed8\u304dAPI\u547c\u3073\u51fa\u3057\"\"\"\n for attempt in range(max_retries):\n try:\n response = func(*args, **kwargs)\n \n if response.status_code == 200:\n return response.json()\n elif response.status_code == 429: # \u30ec\u30fc\u30c8\u5236\u9650\n wait_time = (2 ** attempt) * 2 # \u6307\u6570\u30d0\u30c3\u30af\u30aa\u30d5\n print(f'\u30ec\u30fc\u30c8\u5236\u9650\u5230\u9054\u3002{wait_time}\u79d2\u5f85\u6a5f\u3057\u307e\u3059...')\n time.sleep(wait_time)\n elif response.status_code == 401: # \u8a8d\u8a3c\u30a8\u30e9\u30fc\n print('\u8a8d\u8a3c\u30a8\u30e9\u30fc\u3002\u30c8\u30fc\u30af\u30f3\u3092\u518d\u53d6\u5f97\u3057\u3066\u304f\u3060\u3055\u3044\u3002')\n return None\n else:\n print(f'\u30a8\u30e9\u30fc: {response.status_code} - {response.text}')\n return None\n \n except RequestException as e:\n print(f'\u30ea\u30af\u30a8\u30b9\u30c8\u30a8\u30e9\u30fc: {e}')\n if attempt < max_retries - 1:\n time.sleep(2 ** attempt)\n else:\n return None\n \n return None\n<\/code><\/pre>\n\n\n\n\u3053\u306e\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u3067\u306f\u3001\u30ec\u30fc\u30c8\u5236\u9650\u30a8\u30e9\u30fc(429)\u306e\u5834\u5408\u306f\u6307\u6570\u30d0\u30c3\u30af\u30aa\u30d5\u3067\u518d\u8a66\u884c\u3057\u3001\u8a8d\u8a3c\u30a8\u30e9\u30fc(401)\u306e\u5834\u5408\u306f\u5373\u5ea7\u306b\u51e6\u7406\u3092\u4e2d\u65ad\u3057\u307e\u3059\u3002\u672c\u756a\u74b0\u5883\u3067\u306f\u3001\u30ed\u30b0\u8a18\u9332\u3084\u76e3\u8996\u30a2\u30e9\u30fc\u30c8\u306e\u9001\u4fe1\u3082\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \n\n\n\n<\/i>\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u3067\u30ec\u30dd\u30fc\u30c8\u306b\u30c7\u30fc\u30bf\u3092\u9023\u643a\u3059\u308b\u65b9\u6cd5<\/span><\/span><\/h2>\n\n\n\n\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6a19\u6e96\u3067\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092Looker Studio\u306b\u63a5\u7d9a\u3067\u304d\u307e\u3059\u3002Google Apps Script\u3067\u5b9f\u88c5\u3059\u308b\u305f\u3081\u3001JavaScript\u306e\u77e5\u8b58\u304c\u3042\u308c\u3070\u6bd4\u8f03\u7684\u7c21\u5358\u306b\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n Google Apps Script\u3067\u306e\u30b3\u30cd\u30af\u30bf\u4f5c\u6210<\/h3>\n\n\n\n\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u306e\u4f5c\u6210\u306f\u3001Google Apps Script\u306e\u5c02\u7528\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304b\u3089\u59cb\u3081\u307e\u3059\u3002Apps Script\u30a8\u30c7\u30a3\u30bf(https:\/\/script.google.com\/)\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u300c\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u300d\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u5f8c\u3001\u5de6\u5074\u306e\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300c\u30a8\u30c7\u30a3\u30bf\u300d\u3092\u9078\u629e\u3057\u3001\u753b\u9762\u4e0a\u90e8\u306e\u300c+\u300d\u30dc\u30bf\u30f3\u304b\u3089\u300cApps Script\u30d5\u30a1\u30a4\u30eb\u300d\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u30d5\u30a1\u30a4\u30eb\u540d\u306f\u300cCode.gs\u300d\u306a\u3069\u308f\u304b\u308a\u3084\u3059\u3044\u540d\u524d\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n \u30b3\u30cd\u30af\u30bf\u3068\u3057\u3066\u6a5f\u80fd\u3055\u305b\u308b\u305f\u3081\u306b\u306f\u3001Looker Studio\u304c\u8981\u6c42\u3059\u308b\u7279\u5b9a\u306e\u95a2\u6570\u3092\u5b9f\u88c5\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u95a2\u6570\u306f\u6c7a\u3081\u3089\u308c\u305f\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5f93\u3046\u5fc5\u8981\u304c\u3042\u308a\u3001\u6b63\u3057\u304f\u5b9f\u88c5\u3057\u306a\u3044\u3068\u30b3\u30cd\u30af\u30bf\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u8a2d\u5b9a\u3067\u3001\u300c\u30e9\u30a4\u30d6\u30e9\u30ea\u300d\u30bb\u30af\u30b7\u30e7\u30f3\u304b\u3089\u5fc5\u8981\u306a\u5916\u90e8\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u5b9f\u884c\u901f\u5ea6\u3078\u306e\u5f71\u97ff\u3092\u8003\u616e\u3057\u3001\u5fc5\u8981\u6700\u5c0f\u9650\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u4f7f\u7528\u306b\u7559\u3081\u308b\u3053\u3068\u304c\u63a8\u5968\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n \u5fc5\u9808\u95a2\u6570(getAuthType\/getConfig\/getSchema\/getData)\u306e\u5b9f\u88c5<\/h3>\n\n\n\nLooker Studio\u306e\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u306b\u306f\u30014\u3064\u306e\u5fc5\u9808\u95a2\u6570\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \/\/ 1. \u8a8d\u8a3c\u30bf\u30a4\u30d7\u306e\u5b9a\u7fa9\nfunction getAuthType() {\n return {\n type: 'NONE' \/\/ \u8a8d\u8a3c\u4e0d\u8981\u306e\u5834\u5408\n \/\/ \u307e\u305f\u306f 'USER_PASS', 'KEY', 'OAUTH2' \u306a\u3069\n };\n}\n\n\/\/ 2. \u30e6\u30fc\u30b6\u30fc\u8a2d\u5b9a\u9805\u76ee\u306e\u5b9a\u7fa9\nfunction getConfig() {\n var config = {\n configParams: [\n {\n type: 'TEXTINPUT',\n name: 'api_url',\n displayName: 'API URL',\n helpText: '\u63a5\u7d9a\u5148\u306eAPI URL\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044',\n placeholder: 'https:\/\/api.example.com\/data'\n }\n ]\n };\n return config;\n}\n\n\/\/ 3. \u30c7\u30fc\u30bf\u30b9\u30ad\u30fc\u30de\u306e\u5b9a\u7fa9\nfunction getSchema(request) {\n return {\n schema: [\n {\n name: 'date',\n label: '\u65e5\u4ed8',\n dataType: 'STRING',\n semantics: {\n conceptType: 'DIMENSION'\n }\n },\n {\n name: 'value',\n label: '\u5024',\n dataType: 'NUMBER',\n semantics: {\n conceptType: 'METRIC'\n }\n }\n ]\n };\n}\n\n\/\/ 4. \u5b9f\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\nfunction getData(request) {\n var apiUrl = request.configParams.api_url;\n var response = UrlFetchApp.fetch(apiUrl);\n var data = JSON.parse(response.getContentText());\n \n var rows = data.map(function(item) {\n return {\n values: [item.date, item.value]\n };\n });\n \n return {\n schema: getSchema(request).schema,\n rows: rows\n };\n}\n<\/code><\/pre>\n\n\n\n\u3053\u308c\u3089\u306e\u95a2\u6570\u304c\u3059\u3079\u3066\u6b63\u3057\u304f\u5b9f\u88c5\u3055\u308c\u3066\u521d\u3081\u3066\u3001Looker Studio\u304b\u3089\u30b3\u30cd\u30af\u30bf\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u3059\u3002\u5404\u95a2\u6570\u306e\u5f79\u5272\u3092\u7406\u89e3\u3057\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u7279\u6027\u306b\u5408\u308f\u305b\u3066\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u5916\u90e8API\u304b\u3089\u306e\u30c7\u30fc\u30bf\u53d6\u5f97<\/h3>\n\n\n\n\u5b9f\u969b\u306e\u5916\u90e8API\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u969b\u306f\u3001UrlFetchApp<\/code>\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306f\u3001REST API\u304b\u3089JSON\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u5b9f\u88c5\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n function fetchDataFromAPI(apiUrl, apiKey) {\n var options = {\n 'method': 'get',\n 'headers': {\n 'Authorization': 'Bearer ' + apiKey,\n 'Content-Type': 'application\/json'\n },\n 'muteHttpExceptions': true\n };\n \n try {\n var response = UrlFetchApp.fetch(apiUrl, options);\n var statusCode = response.getResponseCode();\n \n if (statusCode === 200) {\n return JSON.parse(response.getContentText());\n } else {\n Logger.log('API Error: ' + statusCode);\n return null;\n }\n } catch (e) {\n Logger.log('Fetch Error: ' + e.message);\n return null;\n }\n}\n<\/code><\/pre>\n\n\n\n\u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u3092\u9069\u5207\u306b\u5b9f\u88c5\u3057\u3001API\u547c\u3073\u51fa\u3057\u304c\u5931\u6557\u3057\u305f\u5834\u5408\u3067\u3082\u30b3\u30cd\u30af\u30bf\u5168\u4f53\u304c\u30af\u30e9\u30c3\u30b7\u30e5\u3057\u306a\u3044\u3088\u3046\u306b\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n CSV\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b\u5834\u5408\u306f\u3001Utilities.parseCsv()<\/code>\u3092\u4f7f\u7528\u3057\u3066\u30d1\u30fc\u30b9\u3057\u307e\u3059\u3002\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5834\u5408\u306f\u3001\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u88c5\u3057\u3066\u30e1\u30e2\u30ea\u4f7f\u7528\u91cf\u3092\u6291\u3048\u308b\u5de5\u592b\u3082\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n Looker Studio\u3078\u306e\u63a5\u7d9a\u65b9\u6cd5<\/h3>\n\n\n\n\u30b3\u30cd\u30af\u30bf\u306e\u5b9f\u88c5\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001\u30c7\u30d7\u30ed\u30a4\u3057\u3066\u516c\u958b\u3057\u307e\u3059\u3002Apps Script\u30a8\u30c7\u30a3\u30bf\u306e\u53f3\u4e0a\u306b\u3042\u308b\u300c\u30c7\u30d7\u30ed\u30a4\u300d\u2192\u300c\u65b0\u3057\u3044\u30c7\u30d7\u30ed\u30a4\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30c7\u30d7\u30ed\u30a4\u30bf\u30a4\u30d7\u306f\u300cApps Script\u30a2\u30c9\u30aa\u30f3\u300d\u3067\u306f\u306a\u304f\u3001\u300c\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u300d\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306f\u3001\u7d44\u7e54\u5185\u306e\u307f\u3067\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f\u300c\u7d44\u7e54\u5185\u306e\u30e6\u30fc\u30b6\u30fc\u300d\u3001\u4e00\u822c\u516c\u958b\u3059\u308b\u5834\u5408\u306f\u300c\u5168\u54e1\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30c7\u30d7\u30ed\u30a4\u304c\u5b8c\u4e86\u3059\u308b\u3068\u3001\u30c7\u30d7\u30ed\u30a4ID\u304c\u767a\u884c\u3055\u308c\u307e\u3059\u3002\u3053\u306eID\u3092\u4f7f\u3063\u3066\u3001Looker Studio\u304b\u3089\u30b3\u30cd\u30af\u30bf\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n Looker Studio\u3067\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u969b\u3001\u300c\u30b3\u30cd\u30af\u30bf\u300d\u30bb\u30af\u30b7\u30e7\u30f3\u304b\u3089\u300c\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u300d\u3092\u9078\u629e\u3057\u3001\u5148\u307b\u3069\u306e\u30c7\u30d7\u30ed\u30a4ID\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u63a5\u7d9a\u304c\u6210\u529f\u3059\u308b\u3068\u3001\u8a2d\u5b9a\u753b\u9762(getConfig()<\/code>\u3067\u5b9a\u7fa9\u3057\u305f\u9805\u76ee)\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n \u5fc5\u8981\u306a\u8a2d\u5b9a\u3092\u5165\u529b\u3057\u3001\u300c\u63a5\u7d9a\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304c\u4f5c\u6210\u3055\u308c\u3001\u30ec\u30dd\u30fc\u30c8\u3067\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u5b9f\u88c5\u6642\u306e\u6ce8\u610f\u70b9<\/h3>\n\n\n\n\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u3092\u5b9f\u88c5\u3059\u308b\u969b\u306f\u3001\u4ee5\u4e0b\u306e\u70b9\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9:<\/strong> Apps Script\u306b\u306f\u5b9f\u884c\u6642\u9593\u306e\u5236\u9650(6\u5206)\u304c\u3042\u308b\u305f\u3081\u3001\u5927\u91cf\u30c7\u30fc\u30bf\u3092\u4e00\u5ea6\u306b\u53d6\u5f97\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u306f\u5fc5\u8981\u6700\u5c0f\u9650\u306b\u6291\u3048\u3001\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3092\u6d3b\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n \u30ad\u30e3\u30c3\u30b7\u30e5:<\/strong> \u540c\u3058\u30c7\u30fc\u30bf\u3092\u7e70\u308a\u8fd4\u3057\u53d6\u5f97\u3057\u306a\u3044\u3088\u3046\u3001CacheService\u3092\u4f7f\u3063\u305f\u30ad\u30e3\u30c3\u30b7\u30e5\u5b9f\u88c5\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u308c\u306b\u3088\u308a\u3001API\u306e\u547c\u3073\u51fa\u3057\u56de\u6570\u3092\u524a\u6e1b\u3057\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u8868\u793a\u901f\u5ea6\u3082\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8:<\/strong> \u30e6\u30fc\u30b6\u30fc\u306b\u308f\u304b\u308a\u3084\u3059\u3044\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8fd4\u3059\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002\u5358\u306b\u300c\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u300d\u3067\u306f\u306a\u304f\u3001\u300cAPI URL\u304c\u6b63\u3057\u304f\u3042\u308a\u307e\u305b\u3093\u300d\u300c\u8a8d\u8a3c\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u300d\u306a\u3069\u3001\u5177\u4f53\u7684\u306a\u539f\u56e0\u3092\u793a\u3059\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u5b9f\u88c5\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3:<\/strong> API\u30ad\u30fc\u3084\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u306f\u3001getConfig()<\/code>\u3067isCredential: true<\/code>\u3092\u8a2d\u5b9a\u3057\u3001\u5b89\u5168\u306b\u7ba1\u7406\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u30ed\u30b0\u306b\u6a5f\u5bc6\u60c5\u5831\u3092\u51fa\u529b\u3057\u306a\u3044\u3088\u3046\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n \n\n\n\n<\/i>Looker Studio API\u306e\u30c8\u30e9\u30d6\u30eb\u30b7\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0<\/span><\/span><\/h2>\n\n\n\nLooker Studio API\u3092\u904b\u7528\u3057\u3066\u3044\u308b\u3068\u3001\u3055\u307e\u3056\u307e\u306a\u30c8\u30e9\u30d6\u30eb\u306b\u906d\u9047\u3057\u307e\u3059\u3002\u3088\u304f\u3042\u308b\u554f\u984c\u3068\u305d\u306e\u89e3\u6c7a\u65b9\u6cd5\u3092\u77e5\u3063\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u30b9\u30e0\u30fc\u30ba\u306a\u904b\u7528\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u8a8d\u8a3c\u30a8\u30e9\u30fc\u306e\u89e3\u6c7a\u65b9\u6cd5<\/h3>\n\n\n\n\u8a8d\u8a3c\u30a8\u30e9\u30fc(401 Unauthorized)\u306f\u3001\u6700\u3082\u983b\u7e41\u306b\u767a\u751f\u3059\u308b\u554f\u984c\u306e\u4e00\u3064\u3067\u3059\u3002\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u539f\u56e0\u3092\u7279\u5b9a\u3057\u89e3\u6c7a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u539f\u56e01: \u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u306e\u671f\u9650\u5207\u308c<\/strong> OAuth 2.0\u306e\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u306f\u901a\u5e381\u6642\u9593\u3067\u671f\u9650\u5207\u308c\u306b\u306a\u308a\u307e\u3059\u3002\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u30c8\u30fc\u30af\u30f3\u3092\u4f7f\u3063\u3066\u65b0\u3057\u3044\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u3092\u53d6\u5f97\u3059\u308b\u5b9f\u88c5\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n # \u30c8\u30fc\u30af\u30f3\u66f4\u65b0\u306e\u5b9f\u88c5\u4f8b\ndef refresh_access_token(refresh_token, client_id, client_secret):\n url = 'https:\/\/oauth2.googleapis.com\/token'\n data = {\n 'refresh_token': refresh_token,\n 'client_id': client_id,\n 'client_secret': client_secret,\n 'grant_type': 'refresh_token'\n }\n response = requests.post(url, data=data)\n return response.json()['access_token']\n<\/code><\/pre>\n\n\n\n\u539f\u56e02: \u30b9\u30b3\u30fc\u30d7\u4e0d\u8db3<\/strong> \u5fc5\u8981\u306a\u30b9\u30b3\u30fc\u30d7(https:\/\/www.googleapis.com\/auth\/datastudio<\/code>)\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u3082\u8a8d\u8a3c\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002OAuth\u540c\u610f\u753b\u9762\u3067\u30b9\u30b3\u30fc\u30d7\u3092\u78ba\u8a8d\u3057\u3001\u4e0d\u8db3\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u518d\u8a8d\u8a3c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u539f\u56e03: \u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u6a29\u9650\u4e0d\u8db3<\/strong> \u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u305d\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u306bLooker Studio\u30ec\u30dd\u30fc\u30c8\u3078\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u304c\u4ed8\u4e0e\u3055\u308c\u3066\u3044\u306a\u3044\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u30ec\u30dd\u30fc\u30c8\u306e\u5171\u6709\u8a2d\u5b9a\u3067\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n API\u5236\u9650(\u30af\u30a9\u30fc\u30bf)\u3078\u306e\u5bfe\u51e6<\/h3>\n\n\n\nLooker Studio API\u306b\u306f\u3001\u5229\u7528\u5236\u9650(\u30af\u30a9\u30fc\u30bf)\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u5236\u9650\u3092\u8d85\u3048\u308b\u3068\u3001429\u30a8\u30e9\u30fc(Too Many Requests)\u304c\u8fd4\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n \u5bfe\u51e6\u6cd51: \u30ea\u30af\u30a8\u30b9\u30c8\u6570\u306e\u524a\u6e1b<\/strong> \u4e0d\u8981\u306aAPI\u547c\u3073\u51fa\u3057\u3092\u6e1b\u3089\u3057\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u3088\u3046\u6700\u9069\u5316\u3057\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u5168\u30ec\u30dd\u30fc\u30c8\u3092\u6bce\u56de\u53d6\u5f97\u3059\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u5dee\u5206\u306e\u307f\u3092\u53d6\u5f97\u3059\u308b\u4ed5\u7d44\u307f\u3092\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u5bfe\u51e6\u6cd52: \u30d0\u30c3\u30af\u30aa\u30d5\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u306e\u5b9f\u88c5<\/strong> 429\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u3001\u6307\u6570\u30d0\u30c3\u30af\u30aa\u30d5\u3067\u5f85\u6a5f\u6642\u9593\u3092\u5897\u3084\u3057\u306a\u304c\u3089\u518d\u8a66\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n import time\n\ndef exponential_backoff(attempt):\n wait_time = min(2 ** attempt, 64) # \u6700\u592764\u79d2\n time.sleep(wait_time)\n \nfor attempt in range(5):\n response = call_api()\n if response.status_code == 429:\n exponential_backoff(attempt)\n elif response.status_code == 200:\n break\n<\/code><\/pre>\n\n\n\n\u5bfe\u51e6\u6cd53: \u30ad\u30e3\u30c3\u30b7\u30e5\u306e\u6d3b\u7528<\/strong> \u983b\u7e41\u306b\u5909\u66f4\u3055\u308c\u306a\u3044\u30c7\u30fc\u30bf(\u30ec\u30dd\u30fc\u30c8\u4e00\u89a7\u306a\u3069)\u306f\u3001\u30ed\u30fc\u30ab\u30eb\u3084Redis\u306a\u3069\u306b\u30ad\u30e3\u30c3\u30b7\u30e5\u3057\u3001API\u547c\u3073\u51fa\u3057\u56de\u6570\u3092\u524a\u6e1b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30af\u30a9\u30fc\u30bf\u306e\u5177\u4f53\u7684\u306a\u4e0a\u9650\u306f\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u5909\u66f4\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u305f\u3081\u3001\u5b9a\u671f\u7684\u306b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30c7\u30fc\u30bf\u53d6\u5f97\u304c\u9045\u3044\u5834\u5408\u306e\u6700\u9069\u5316<\/h3>\n\n\n\n\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u3067\u30c7\u30fc\u30bf\u53d6\u5f97\u304c\u9045\u3044\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u6700\u9069\u5316\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u6700\u9069\u53161: \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u88c5<\/strong> \u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u4e00\u5ea6\u306b\u53d6\u5f97\u305b\u305a\u3001\u30da\u30fc\u30b8\u30f3\u30b0\u3067\u5206\u5272\u3057\u3066\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n function getDataWithPagination(apiUrl, pageSize) {\n var allData = [];\n var page = 1;\n var hasMore = true;\n \n while (hasMore) {\n var url = apiUrl + '?page=' + page + '&size=' + pageSize;\n var response = UrlFetchApp.fetch(url);\n var data = JSON.parse(response.getContentText());\n \n allData = allData.concat(data.items);\n hasMore = data.hasNext;\n page++;\n \n \/\/ \u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u5bfe\u7b56\n if (page > 50) break;\n }\n \n return allData;\n}\n<\/code><\/pre>\n\n\n\n\u6700\u9069\u53162: \u4e26\u5217\u30ea\u30af\u30a8\u30b9\u30c8<\/strong> Apps Script\u306eUrlFetchApp.fetchAll()<\/code>\u3092\u4f7f\u3063\u3066\u3001\u8907\u6570\u306eAPI\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u4e26\u5217\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u6700\u9069\u53163: \u4e0d\u8981\u306a\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u9664\u5916<\/strong> API\u30ec\u30b9\u30dd\u30f3\u30b9\u304b\u3089\u3001Looker Studio\u3067\u4f7f\u7528\u3057\u306a\u3044\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u9664\u5916\u3057\u3001\u30c7\u30fc\u30bf\u91cf\u3092\u524a\u6e1b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u6700\u9069\u53164: CacheService\u306e\u6d3b\u7528<\/strong> Apps Script\u306eCacheService\u3092\u4f7f\u3063\u3066\u3001API\u30ec\u30b9\u30dd\u30f3\u30b9\u3092\u30ad\u30e3\u30c3\u30b7\u30e5\u3057\u307e\u3059\u3002\u30ad\u30e3\u30c3\u30b7\u30e5\u671f\u9593\u306f\u3001\u30c7\u30fc\u30bf\u306e\u66f4\u65b0\u983b\u5ea6\u306b\u5fdc\u3058\u3066\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u3068\u5bfe\u51e6\u6cd5<\/h3>\n\n\n\n\u305d\u306e\u4ed6\u3001\u983b\u51fa\u3059\u308b\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9\u3068\u5bfe\u51e6\u6cd5\u3092\u4e00\u89a7\u306b\u307e\u3068\u3081\u307e\u3057\u305f\u3002<\/p>\n\n\n \n\u30a8\u30e9\u30fc\u30b3\u30fc\u30c9<\/th> \u610f\u5473<\/th> \u5bfe\u51e6\u6cd5<\/th><\/tr><\/thead> 400 Bad Request<\/td> \u30ea\u30af\u30a8\u30b9\u30c8\u5f62\u5f0f\u304c\u4e0d\u6b63<\/td> JSON\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3001\u30d1\u30e9\u30e1\u30fc\u30bf\u540d\u3092\u78ba\u8a8d<\/td><\/tr> 403 Forbidden<\/td> \u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306a\u3057<\/td> \u30ec\u30dd\u30fc\u30c8\u306e\u5171\u6709\u8a2d\u5b9a\u3092\u78ba\u8a8d<\/td><\/tr> 404 Not Found<\/td> \u30ea\u30bd\u30fc\u30b9\u304c\u5b58\u5728\u3057\u306a\u3044<\/td> \u30ec\u30dd\u30fc\u30c8ID\u304c\u6b63\u3057\u3044\u304b\u78ba\u8a8d<\/td><\/tr> 500 Internal Server Error<\/td> \u30b5\u30fc\u30d0\u30fc\u5074\u30a8\u30e9\u30fc<\/td> \u6642\u9593\u3092\u304a\u3044\u3066\u518d\u8a66\u884c<\/td><\/tr> 503 Service Unavailable<\/td> \u30b5\u30fc\u30d3\u30b9\u4e00\u6642\u505c\u6b62<\/td> Google Cloud Status Dashboard\u3092\u78ba\u8a8d<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n\n\n\u30a8\u30e9\u30fc\u304c\u7d99\u7d9a\u3059\u308b\u5834\u5408\u306f\u3001\u30ec\u30b9\u30dd\u30f3\u30b9\u30dc\u30c7\u30a3\u306b\u542b\u307e\u308c\u308b\u8a73\u7d30\u306a\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u78ba\u8a8d\u3057\u3001Google Cloud\u306e\u30b5\u30dd\u30fc\u30c8\u306b\u554f\u3044\u5408\u308f\u305b\u308b\u3053\u3068\u3082\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u30ed\u30b0\u3092\u9069\u5207\u306b\u8a18\u9332\u3057\u3066\u304a\u304f\u3053\u3068\u3067\u3001\u30c8\u30e9\u30d6\u30eb\u767a\u751f\u6642\u306e\u539f\u56e0\u7279\u5b9a\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002Cloud Logging\u306a\u3069\u306e\u30ed\u30b0\u7ba1\u7406\u30b5\u30fc\u30d3\u30b9\u306e\u6d3b\u7528\u3082\u304a\u3059\u3059\u3081\u3067\u3059\u3002<\/p>\n\n\n\n \n\n\n\n<\/i>\u3088\u304f\u3042\u308b\u8cea\u554f<\/span><\/span><\/h2>\n\n\n\nLooker Studio API\u306b\u95a2\u3057\u3066\u3001\u3088\u304f\u3044\u305f\u3060\u304f\u8cea\u554f\u3068\u305d\u306e\u56de\u7b54\u3092\u307e\u3068\u3081\u307e\u3057\u305f\u3002\u5b9f\u88c5\u524d\u306e\u7591\u554f\u89e3\u6d88\u306b\u304a\u5f79\u7acb\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n Looker Studio API\u306f\u7121\u6599\u3067\u4f7f\u3048\u307e\u3059\u304b?<\/h3>\n\n\n\nLooker Studio API\u81ea\u4f53\u306f\u7121\u6599\u3067\u5229\u7528\u3067\u304d\u307e\u3059\u3002API\u306e\u547c\u3073\u51fa\u3057\u306b\u5bfe\u3059\u308b\u5f93\u91cf\u8ab2\u91d1\u306f\u306a\u304f\u3001Google Cloud\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u6709\u52b9\u5316\u3059\u308c\u3070\u8ab0\u3067\u3082\u4f7f\u7528\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n \u305f\u3060\u3057\u3001\u4ee5\u4e0b\u306e\u70b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n \u9593\u63a5\u7684\u306a\u30b3\u30b9\u30c8:<\/strong><\/p>\n\n\n\n \nGoogle Cloud Platform\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u306f\u8acb\u6c42\u5148\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u767b\u9332\u304c\u5fc5\u8981(API\u306e\u5229\u7528\u81ea\u4f53\u306f\u7121\u6599)<\/li>\n\n\n\n API\u547c\u3073\u51fa\u3057\u3092\u5b9f\u884c\u3059\u308b\u30b5\u30fc\u30d0\u30fc(Cloud Functions\u3084Cloud Run\u306a\u3069)\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u3001\u305d\u306e\u30b5\u30fc\u30d0\u30fc\u306e\u5229\u7528\u6599\u91d1\u304c\u767a\u751f<\/li>\n\n\n\n \u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092BigQuery\u306a\u3069\u306b\u4fdd\u5b58\u3059\u308b\u5834\u5408\u3001\u30b9\u30c8\u30ec\u30fc\u30b8\u6599\u91d1\u304c\u767a\u751f<\/li>\n<\/ul>\n\n\n\n\u5229\u7528\u5236\u9650(\u30af\u30a9\u30fc\u30bf):<\/strong> \u7121\u6599\u3067\u3042\u308b\u4ee3\u308f\u308a\u306b\u30011\u65e5\u3042\u305f\u308a\u306eAPI\u547c\u3073\u51fa\u3057\u56de\u6570\u306b\u306f\u5236\u9650\u304c\u3042\u308a\u307e\u3059\u3002\u5177\u4f53\u7684\u306a\u4e0a\u9650\u306f\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u901a\u5e38\u306e\u696d\u52d9\u5229\u7528\u3067\u3042\u308c\u3070\u3001\u3053\u306e\u5236\u9650\u306b\u9054\u3059\u308b\u3053\u3068\u306f\u307b\u3068\u3093\u3069\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n \u500b\u4eba\u3067\u306e\u5b66\u7fd2\u3084\u3001\u5c0f\u898f\u6a21\u306a\u696d\u52d9\u5229\u7528\u3067\u3042\u308c\u3070\u3001\u5b9f\u8cea\u7684\u306b\u7121\u6599\u3067\u904b\u7528\u3067\u304d\u307e\u3059\u3002\u5927\u898f\u6a21\u306a\u30b7\u30b9\u30c6\u30e0\u3092\u69cb\u7bc9\u3059\u308b\u5834\u5408\u306f\u3001\u95a2\u9023\u30b5\u30fc\u30d3\u30b9\u306e\u30b3\u30b9\u30c8\u3092\u4e8b\u524d\u306b\u8a66\u7b97\u3059\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n API\u3067\u53d6\u5f97\u3057\u305f\u30ec\u30dd\u30fc\u30c8\u60c5\u5831\u306f\u3069\u3053\u307e\u3067\u8a73\u7d30\u306b\u78ba\u8a8d\u3067\u304d\u307e\u3059\u304b?<\/h3>\n\n\n\n\u7ba1\u7406\u7cfbAPI\u3067\u53d6\u5f97\u3067\u304d\u308b\u60c5\u5831\u306f\u3001\u4e3b\u306b\u300c\u30e1\u30bf\u30c7\u30fc\u30bf\u300d(\u30c7\u30fc\u30bf\u306b\u3064\u3044\u3066\u306e\u30c7\u30fc\u30bf)\u3067\u3059\u3002\u5177\u4f53\u7684\u306b\u306f\u4ee5\u4e0b\u306e\u60c5\u5831\u304c\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n \u53d6\u5f97\u53ef\u80fd\u306a\u60c5\u5831:<\/strong><\/p>\n\n\n\n \n\u30ec\u30dd\u30fc\u30c8\u540d(displayName)<\/li>\n\n\n\n \u30ec\u30dd\u30fc\u30c8ID(name\/assetId)<\/li>\n\n\n\n \u4f5c\u6210\u65e5\u6642(createTime)<\/li>\n\n\n\n \u6700\u7d42\u66f4\u65b0\u65e5\u6642(updateTime)<\/li>\n\n\n\n \u30aa\u30fc\u30ca\u30fc\u60c5\u5831(owner)<\/li>\n\n\n\n \u5171\u6709\u8a2d\u5b9a(permissions)<\/li>\n\n\n\n \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u60c5\u5831(linkedDataSources)<\/li>\n<\/ul>\n\n\n\n\u53d6\u5f97\u3067\u304d\u306a\u3044\u60c5\u5831:<\/strong><\/p>\n\n\n\n \n\u30ec\u30dd\u30fc\u30c8\u5185\u306e\u30c1\u30e3\u30fc\u30c8\u3084\u30c6\u30fc\u30d6\u30eb\u306e\u8a73\u7d30\u8a2d\u5b9a<\/li>\n\n\n\n \u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u306e\u30c7\u30b6\u30a4\u30f3<\/li>\n\n\n\n \u30d5\u30a3\u30eb\u30bf\u3084\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306e\u8a2d\u5b9a<\/li>\n\n\n\n \u30ec\u30dd\u30fc\u30c8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u5b9f\u30c7\u30fc\u30bf<\/li>\n<\/ul>\n\n\n\n\u3064\u307e\u308a\u3001\u300c\u8ab0\u304c\u3044\u3064\u3069\u3093\u306a\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u3063\u305f\u304b\u300d\u300c\u8ab0\u3068\u5171\u6709\u3055\u308c\u3066\u3044\u308b\u304b\u300d\u3068\u3044\u3063\u305f\u7ba1\u7406\u60c5\u5831\u306f\u53d6\u5f97\u3067\u304d\u307e\u3059\u304c\u3001\u300c\u30ec\u30dd\u30fc\u30c8\u306e\u4e2d\u8eab\u300d\u81ea\u4f53\u306f\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n \u30ec\u30dd\u30fc\u30c8\u306e\u4e2d\u8eab(\u5b9f\u30c7\u30fc\u30bf)\u3092\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u306f\u3001Looker Studio Linking API\u307e\u305f\u306fBigQuery\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u6a5f\u80fd\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u7528\u9014\u306b\u5fdc\u3058\u3066\u9069\u5207\u306aAPI\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/p>\n\n\n\n \u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u306e\u958b\u767a\u306b\u3069\u306e\u304f\u3089\u3044\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u304b?<\/h3>\n\n\n\n\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u306e\u958b\u767a\u6642\u9593\u306f\u3001\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u8907\u96d1\u3055\u3068\u958b\u767a\u8005\u306e\u30b9\u30ad\u30eb\u30ec\u30d9\u30eb\u306b\u3088\u3063\u3066\u5927\u304d\u304f\u7570\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u30b7\u30f3\u30d7\u30eb\u306aREST API\u306e\u5834\u5408(\u521d\u7d1a\u8005):<\/strong><\/p>\n\n\n\n \n\u57fa\u672c\u7684\u306a\u5b9f\u88c5: 4\u301c8\u6642\u9593<\/li>\n\n\n\n \u30c6\u30b9\u30c8\u3068\u30c7\u30d0\u30c3\u30b0: 2\u301c4\u6642\u9593<\/li>\n\n\n\n \u5408\u8a08: 6\u301c12\u6642\u9593\u7a0b\u5ea6<\/li>\n<\/ul>\n\n\n\n\u8907\u96d1\u306aAPI\u306e\u5834\u5408(\u4e2d\u7d1a\u8005):<\/strong><\/p>\n\n\n\n \nOAuth\u8a8d\u8a3c\u306e\u5b9f\u88c5\u3092\u542b\u3080: 8\u301c16\u6642\u9593<\/li>\n\n\n\n \u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3084\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u5909\u63db: 4\u301c8\u6642\u9593<\/li>\n\n\n\n \u5408\u8a08: 12\u301c24\u6642\u9593\u7a0b\u5ea6<\/li>\n<\/ul>\n\n\n\n\u7d4c\u9a13\u8005\u306e\u5834\u5408:<\/strong> \u30b7\u30f3\u30d7\u30eb\u306a\u30b3\u30cd\u30af\u30bf\u3067\u3042\u308c\u30702\u301c3\u6642\u9593\u3067\u5b9f\u88c5\u53ef\u80fd\u3067\u3059\u3002\u904e\u53bb\u306b\u4f5c\u6210\u3057\u305f\u30b3\u30cd\u30af\u30bf\u3092\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u3057\u3066\u518d\u5229\u7528\u3059\u308c\u3070\u3001\u3055\u3089\u306b\u77ed\u7e2e\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n \u958b\u767a\u6642\u9593\u3092\u77ed\u7e2e\u3059\u308b\u30b3\u30c4:<\/strong><\/p>\n\n\n\n \nGoogle\u516c\u5f0f\u306e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3092\u30d9\u30fc\u30b9\u306b\u958b\u59cb\u3059\u308b<\/li>\n\n\n\n \u307e\u305a\u6700\u5c0f\u9650\u306e\u6a5f\u80fd\u3067\u52d5\u4f5c\u78ba\u8a8d\u3057\u3066\u304b\u3089\u62e1\u5f35\u3059\u308b<\/li>\n\n\n\n \u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306f\u5f8c\u304b\u3089\u8ffd\u52a0\u3059\u308b<\/li>\n\n\n\n \u65e2\u5b58\u306e\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u30b3\u30cd\u30af\u30bf\u3092\u53c2\u8003\u306b\u3059\u308b<\/li>\n<\/ol>\n\n\n\n\u521d\u3081\u3066\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u3092\u4f5c\u6210\u3059\u308b\u5834\u5408\u3001\u5b66\u7fd2\u6642\u9593\u3082\u542b\u3081\u30661\u9031\u9593\u7a0b\u5ea6\u3092\u898b\u8fbc\u3080\u3068\u5b89\u5fc3\u3067\u3059\u30022\u3064\u76ee\u4ee5\u964d\u306f\u5927\u5e45\u306b\u77ed\u7e2e\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n \u8907\u6570\u306eLooker Studio\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4e00\u62ec\u7ba1\u7406\u3067\u304d\u307e\u3059\u304b?<\/h3>\n\n\n\n\u306f\u3044\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u6570\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u4e00\u62ec\u7ba1\u7406\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n \u5b9f\u88c5\u65b9\u6cd5:<\/strong><\/p>\n\n\n\n \n\u7ba1\u7406\u7528\u306e\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210<\/li>\n\n\n\n \u7ba1\u7406\u5bfe\u8c61\u306e\u5404\u30ec\u30dd\u30fc\u30c8\u306b\u3001\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u300c\u95b2\u89a7\u8005\u300d\u307e\u305f\u306f\u300c\u7de8\u96c6\u8005\u300d\u3068\u3057\u3066\u8ffd\u52a0<\/li>\n\n\n\n \u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f7f\u3063\u3066API\u3092\u5b9f\u884c\u3057\u3001\u3059\u3079\u3066\u306e\u30ec\u30dd\u30fc\u30c8\u60c5\u5831\u3092\u53d6\u5f97<\/li>\n<\/ol>\n\n\n\n\u7d44\u7e54\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u5834\u5408:<\/strong> Google Workspace\u306e\u7d44\u7e54\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u30c9\u30e1\u30a4\u30f3\u5168\u4f53\u306e\u59d4\u4efb\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u3055\u3089\u306b\u52b9\u7387\u7684\u306b\u7ba1\u7406\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u500b\u5225\u306b\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u5171\u6709\u3057\u306a\u304f\u3066\u3082\u3001\u7d44\u7e54\u5185\u306e\u3059\u3079\u3066\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u8907\u6570\u7d44\u7e54\u3092\u307e\u305f\u3050\u5834\u5408:<\/strong> \u5b8c\u5168\u306b\u7570\u306a\u308b\u7d44\u7e54(\u7570\u306a\u308b\u30c9\u30e1\u30a4\u30f3)\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u7ba1\u7406\u3059\u308b\u5834\u5408\u3001\u5404\u7d44\u7e54\u3067\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u3001\u305d\u308c\u305e\u308c\u500b\u5225\u306b\u8a8d\u8a3c\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u4e00\u3064\u306e\u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u8907\u6570\u7d44\u7e54\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n \u5b9a\u671f\u7684\u306b\u5168\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u60c5\u5831\u3092\u53ce\u96c6\u3057\u3001\u7d71\u5408\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3067\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u3067\u3001\u52b9\u7387\u7684\u306a\u30de\u30eb\u30c1\u30a2\u30ab\u30a6\u30f3\u30c8\u7ba1\u7406\u304c\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n API\u306e\u5229\u7528\u306b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u77e5\u8b58\u306f\u5fc5\u9808\u3067\u3059\u304b?<\/h3>\n\n\n\n\u57fa\u672c\u7684\u306b\u306f\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u77e5\u8b58\u304c\u5fc5\u8981\u3067\u3059\u3002\u305f\u3060\u3057\u3001\u521d\u5fc3\u8005\u5411\u3051\u306e\u30c4\u30fc\u30eb\u3084\u30ce\u30fc\u30b3\u30fc\u30c9\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3082\u5b58\u5728\u3057\u307e\u3059\u3002<\/p>\n\n\n\n \u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u7d4c\u9a13\u304c\u3042\u308b\u5834\u5408:<\/strong> Python\u3084JavaScript\u306e\u57fa\u790e\u77e5\u8b58\u304c\u3042\u308c\u3070\u3001\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3068\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3092\u53c2\u8003\u306b\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002\u7279\u306bPython\u306f\u3001Google\u516c\u5f0f\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u5145\u5b9f\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u6bd4\u8f03\u7684\u5bb9\u6613\u306b\u958b\u767a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n \u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u521d\u5fc3\u8005\u306e\u5834\u5408:<\/strong> \u4ee5\u4e0b\u306e\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \nGoogle Apps Script\u304b\u3089\u59cb\u3081\u308b:<\/strong>\n\n\u30d6\u30e9\u30a6\u30b6\u3060\u3051\u3067\u958b\u767a\u53ef\u80fd<\/li>\n\n\n\n JavaScript\u306e\u7c21\u6613\u7248\u3067\u5b66\u7fd2\u3057\u3084\u3059\u3044<\/li>\n\n\n\n Looker Studio\u3068\u306e\u89aa\u548c\u6027\u304c\u9ad8\u3044<\/li>\n<\/ul>\n<\/div><\/li>\n\n\n\n \u30ce\u30fc\u30b3\u30fc\u30c9\u30c4\u30fc\u30eb\u306e\u6d3b\u7528:<\/strong>\n\nZapier\u3001Make(\u65e7Integromat)\u306a\u3069\u306e\u30c4\u30fc\u30eb\u3067Looker Studio API\u3092\u547c\u3073\u51fa\u305b\u308b\u5834\u5408\u304c\u3042\u308b<\/li>\n\n\n\n \u305f\u3060\u3057\u3001\u7d30\u304b\u3044\u5236\u5fa1\u306f\u96e3\u3057\u3044<\/li>\n<\/ul>\n<\/div><\/li>\n\n\n\n \u65e2\u5b58\u306e\u30c4\u30fc\u30eb\u3084\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5229\u7528:<\/strong>\n\nGitHub\u306b\u516c\u958b\u3055\u308c\u3066\u3044\u308b\u30aa\u30fc\u30d7\u30f3\u30bd\u30fc\u30b9\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u6d3b\u7528<\/li>\n\n\n\n \u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u5909\u66f4\u3059\u308b\u3060\u3051\u3067\u4f7f\u3048\u308b\u3082\u306e\u3082\u3042\u308b<\/li>\n<\/ul>\n<\/div><\/li>\n<\/ol>\n\n\n\n\u5b66\u7fd2\u30ea\u30bd\u30fc\u30b9:<\/strong> Google\u304c\u63d0\u4f9b\u3059\u308b\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3084Codelabs\u306b\u306f\u3001\u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u3089\u3092\u9806\u756a\u306b\u9032\u3081\u308b\u3053\u3068\u3067\u3001\u521d\u5fc3\u8005\u3067\u3082\u57fa\u672c\u7684\u306a\u5b9f\u88c5\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u672c\u683c\u7684\u306a\u904b\u7528\u3092\u76ee\u6307\u3059\u306a\u3089\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u77e5\u8b58\u306e\u7fd2\u5f97\u306b\u6295\u8cc7\u3059\u308b\u4fa1\u5024\u306f\u5341\u5206\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \n\n\n\n<\/i>\u307e\u3068\u3081:\u76ee\u7684\u5225\u306eLooker Studio API\u6d3b\u7528\u30ac\u30a4\u30c9<\/span><\/span><\/h2>\n\n\n\n\u3053\u3053\u307e\u3067\u3001Looker Studio API\u306e\u57fa\u672c\u304b\u3089\u5b9f\u88c5\u65b9\u6cd5\u3001\u6d3b\u7528\u4e8b\u4f8b\u307e\u3067\u8a73\u3057\u304f\u89e3\u8aac\u3057\u3066\u304d\u307e\u3057\u305f\u3002\u6700\u5f8c\u306b\u3001\u76ee\u7684\u5225\u306b\u3069\u306eAPI\u3092\u9078\u629e\u3059\u3079\u304d\u304b\u3001\u6b21\u306b\u4f55\u3092\u5b66\u3076\u3079\u304d\u304b\u3092\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n\n\n\n \u30ec\u30dd\u30fc\u30c8\u7ba1\u7406\u306a\u3089\u7ba1\u7406\u7cfbAPI<\/h3>\n\n\n\n\u30ec\u30dd\u30fc\u30c8\u306e\u68da\u5378\u3057\u3001\u6a29\u9650\u76e3\u67fb\u3001\u8cc7\u7523\u7ba1\u7406\u3068\u3044\u3063\u305f\u300c\u7ba1\u7406\u696d\u52d9\u300d\u3092\u52b9\u7387\u5316\u3057\u305f\u3044\u5834\u5408\u306f\u3001Looker Studio API(\u7ba1\u7406\u7cfb)\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u3053\u3093\u306a\u8ab2\u984c\u3092\u89e3\u6c7a\u3067\u304d\u307e\u3059:<\/strong><\/p>\n\n\n\n \n\u5168\u793e\u306e\u30ec\u30dd\u30fc\u30c8\u304c\u628a\u63e1\u3067\u304d\u3066\u3044\u306a\u3044<\/li>\n\n\n\n \u8ab0\u304c\u3069\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u6301\u3063\u3066\u3044\u308b\u304b\u5206\u304b\u3089\u306a\u3044<\/li>\n\n\n\n \u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306e\u7ba1\u7406\u304c\u5c5e\u4eba\u5316\u3057\u3066\u3044\u308b<\/li>\n\n\n\n \u9000\u8077\u8005\u306e\u30ec\u30dd\u30fc\u30c8\u304c\u653e\u7f6e\u3055\u308c\u3066\u3044\u308b<\/li>\n\n\n\n \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u76e3\u67fb\u306b\u6642\u9593\u304c\u304b\u304b\u308a\u3059\u304e\u308b<\/li>\n<\/ul>\n\n\n\n\u5b9f\u88c5\u306e\u7b2c\u4e00\u6b69:<\/strong><\/p>\n\n\n\n \nGoogle Cloud\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u3066API\u3092\u6709\u52b9\u5316<\/li>\n\n\n\n \u30b5\u30fc\u30d3\u30b9\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u3066\u8a8d\u8a3c\u8a2d\u5b9a<\/li>\n\n\n\n Python\u3067\u7c21\u5358\u306a\u30ec\u30dd\u30fc\u30c8\u4e00\u89a7\u53d6\u5f97\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210<\/li>\n\n\n\n \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u51fa\u529b\u3057\u3066\u53ef\u8996\u5316<\/li>\n\n\n\n \u5b9a\u671f\u5b9f\u884c(Cloud Scheduler)\u3067\u81ea\u52d5\u5316<\/li>\n<\/ol>\n\n\n\n\u7ba1\u7406\u7cfbAPI\u306f\u3001\u4e00\u5ea6\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3059\u308c\u3070\u9577\u671f\u7684\u306b\u904b\u7528\u30b3\u30b9\u30c8\u3092\u524a\u6e1b\u3067\u304d\u308b\u6295\u8cc7\u3067\u3059\u3002\u7279\u306b\u3001\u7d44\u7e54\u898f\u6a21\u304c\u5927\u304d\u3044\u5834\u5408\u3084\u30b3\u30f3\u30d7\u30e9\u30a4\u30a2\u30f3\u30b9\u8981\u4ef6\u304c\u53b3\u3057\u3044\u696d\u7a2e\u3067\u306f\u3001\u5c0e\u5165\u52b9\u679c\u304c\u9ad8\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n \u30c7\u30fc\u30bf\u53d6\u5f97\u306a\u3089\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf<\/h3>\n\n\n\n\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u306e\u30c7\u30fc\u30bf\u3092Looker Studio\u3067\u53ef\u8996\u5316\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n \u3053\u3093\u306a\u8ab2\u984c\u3092\u89e3\u6c7a\u3067\u304d\u307e\u3059:<\/strong><\/p>\n\n\n\n \n\u6a19\u6e96\u30b3\u30cd\u30af\u30bf\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044SaaS\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3044\u305f\u3044<\/li>\n\n\n\n \u793e\u5185\u30b7\u30b9\u30c6\u30e0\u306e\u30c7\u30fc\u30bf\u3092\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u5316\u3057\u305f\u3044<\/li>\n\n\n\n \u8907\u6570\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u7d71\u5408\u3057\u305f\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u308a\u305f\u3044<\/li>\n\n\n\n \u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3057\u305f\u3044<\/li>\n\n\n\n \u72ec\u81ea\u306e\u30c7\u30fc\u30bf\u52a0\u5de5\u30ed\u30b8\u30c3\u30af\u3092\u7d44\u307f\u8fbc\u307f\u305f\u3044<\/li>\n<\/ul>\n\n\n\n\u5b9f\u88c5\u306e\u7b2c\u4e00\u6b69:<\/strong><\/p>\n\n\n \n\nGoogle Apps Script\u3067\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210<\/li>\n\n\n\n \u5fc5\u9808\u95a2\u6570(getAuthType\u3001getConfig\u3001getSchema\u3001getData)\u3092\u5b9f\u88c5<\/li>\n\n\n\n \u7c21\u5358\u306aAPI\u304b\u3089\u30c7\u30fc\u30bf\u53d6\u5f97\u3092\u8a66\u3059<\/li>\n\n\n\n Looker Studio\u304b\u3089\u30b3\u30cd\u30af\u30bf\u306b\u63a5\u7d9a\u3057\u3066\u30c6\u30b9\u30c8<\/li>\n\n\n\n \u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u3068\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u6700\u9069\u5316<\/li>\n<\/ol>\n<\/div>\n\n\n\u30ab\u30b9\u30bf\u30e0\u30b3\u30cd\u30af\u30bf\u306f\u3001\u4e00\u5ea6\u4f5c\u6210\u3059\u308c\u3070\u7d44\u7e54\u5185\u3067\u5171\u6709\u3067\u304d\u3001\u8907\u6570\u306e\u30ec\u30dd\u30fc\u30c8\u3067\u518d\u5229\u7528\u3067\u304d\u307e\u3059\u3002\u958b\u767a\u6295\u8cc7\u304c\u7d44\u7e54\u5168\u4f53\u306e\u52b9\u7387\u5411\u4e0a\u306b\u3064\u306a\u304c\u308a\u307e\u3059\u3002<\/p>\n\n\n\n Looker Studio API\u306f\u3001\u5358\u306a\u308b\u6280\u8853\u30c4\u30fc\u30eb\u3067\u306f\u306a\u304f\u3001\u7d44\u7e54\u306e\u30c7\u30fc\u30bf\u30c9\u30ea\u30d6\u30f3\u6587\u5316\u3092\u63a8\u9032\u3059\u308b\u91cd\u8981\u306a\u57fa\u76e4\u3067\u3059\u3002\u7d99\u7d9a\u7684\u306a\u5b66\u7fd2\u3068\u6539\u5584\u3092\u901a\u3058\u3066\u3001\u30c7\u30fc\u30bf\u6d3b\u7528\u306e\u6210\u719f\u5ea6\u3092\u9ad8\u3081\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n \u672c\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u305f\u5185\u5bb9\u3092\u5b9f\u8df5\u3059\u308b\u3053\u3068\u3067\u3001Looker Studio\u306e\u904b\u7528\u52b9\u7387\u3092\u5287\u7684\u306b\u5411\u4e0a\u3055\u305b\u3001\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u304f\u610f\u601d\u6c7a\u5b9a\u3092\u3055\u3089\u306b\u52a0\u901f\u3067\u304d\u307e\u3059\u3002\u307e\u305a\u306f\u5c0f\u3055\u304f\u59cb\u3081\u3066\u3001\u6bb5\u968e\u7684\u306b\u6a5f\u80fd\u3092\u62e1\u5f35\u3057\u3066\u3044\u304f\u30a2\u30d7\u30ed\u30fc\u30c1\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n \n\u69d8\u3005\u306a\u30ec\u30dd\u30fc\u30c8\u3092\u53d6\u308a\u6271\u3063\u3066\u304a\u308a\u307e\u3059\u3002\u7528\u9014\u3084\u30b7\u30fc\u30f3\u306b\u5408\u308f\u305b\u3066\u3001\u6700\u9069\u306a\u30ec\u30dd\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u3044\u305f\u3060\u304f\u3053\u3068\u3067\u3001\u65e5\u3005\u306e\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u3084\u30c7\u30fc\u30bf\u5206\u6790\u306e\u304a\u5f79\u306b\u7acb\u3061\u307e\u3059\uff01 \u30ec\u30dd\u30fc\u30c8\u4e00\u89a7\u306f\u3053\u3061\u3089<\/a><\/p>\n<\/div><\/div>\n\n\n \u95a2\u9023\u8a18\u4e8b<\/strong><\/p>\n\n\n\n \u3010\u5b8c\u5168\u30ac\u30a4\u30c9\u3011Looker Studio\u3068BigQuery\u9023\u643a\uff5c\u8a2d\u5b9a\u624b\u9806\u304b\u3089\u6d3b\u7528\u4e8b\u4f8b\u307e\u3067<\/a><\/p>\n\n\n\n \u3010\u3059\u3050\u89e3\u6c7a\u3011Looker Studio\u30a8\u30e9\u30fc\u5bfe\u51e6\u6cd5\uff5c\u3088\u304f\u3042\u308b10\u306e\u554f\u984c\u3068\u89e3\u6c7a\u624b\u9806<\/a><\/p>\n\n\n\n \u3010\u5b8c\u5168\u7248\u3011Looker Studio\u52d5\u7684\u30d5\u30a3\u30eb\u30bf\u30fc\u306e\u4f7f\u3044\u65b9\uff5c\u30d1\u30e9\u30e1\u30fc\u30bf\u8a2d\u5b9a\u304b\u3089\u5fdc\u7528\u4f8b\u307e\u3067\u5b9f\u52d9\u3067\u4f7f\u3048\u308b\u5168\u624b\u9806<\/a><\/p>\n\n\n \n\u7121\u6599\u63d0\u4f9b\u4e2d\u30ec\u30dd\u30fc\u30c8<\/span><\/strong><\/p>\n\n\n\n\u3010\u7121\u6599\u7248\u3011GA4\u3068\u30b5\u30fc\u30c1\u30b3\u30f3\u30bd\u30fc\u30eb\u30ec\u30dd\u30fc\u30c8\u516852P\u306e\u7121\u6599\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/a><\/p>\n\n\n\n \u3010\u7121\u6599\u3011Looker Studio\u3067\u55b6\u696d\u30ea\u30fc\u30c9\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3092\u69cb\u7bc9\uff5c\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u6d3b\u7528\u5b8c\u5168\u89e3\u8aac<\/a><\/p>\n\n\n\n \u3010\u5b8c\u5168\u7121\u6599\u3011YouTube\u00d7Looker Studio\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\uff5c5\u30da\u30fc\u30b8\u3067\u30c1\u30e3\u30f3\u30cd\u30eb\u5206\u6790\u3092\u5b8c\u5168\u81ea\u52d5\u5316<\/a><\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":" \u300cLooker Studio\u306e\u30ec\u30dd\u30fc\u30c8\u304c\u5897\u3048\u3059\u304e\u3066\u7ba1\u7406\u304c\u5927\u5909\u300d\u300c\u8ab0\u304c\u3069\u306e\u30ec\u30dd\u30fc\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u306e\u304b\u628a\u63e1\u3067\u304d\u306a\u3044\u300d\u3053\u306e\u3088\u3046\u306a\u8ab2\u984c\u3092\u62b1\u3048\u3066\u3044\u307e\u305b\u3093\u304b? Looker Studio API\u3092\u6d3b\u7528\u3059\u308c\u3070\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u4e00\u89a7\u53d6\u5f97\u3084\u6a29 … <\/p>\n","protected":false},"author":1,"featured_media":8533,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-8532","post","type-post","status-publish","format-standard","has-post-thumbnail","category-looker-studio-explanation","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/posts\/8532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/comments?post=8532"}],"version-history":[{"count":11,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/posts\/8532\/revisions"}],"predecessor-version":[{"id":10774,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/posts\/8532\/revisions\/10774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/media\/8533"}],"wp:attachment":[{"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/media?parent=8532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/categories?post=8532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inno-mark.jp\/datavista\/wp-json\/wp\/v2\/tags?post=8532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}