\u6700\u7d42\u884c\u3067\u74b0\u5883\u5909\u6570’tableau_token’\u306b\u53d6\u5f97\u3057\u305f\u8a8d\u8a3c\u30c8\u30fc\u30af\u30f3\u3092\u4ee3\u5165\u3057\u3066\u3044\u307e\u3059\u3002<\/li>\n<\/ul>\nimport json\r\nimport pandas as pd\r\nimport requests\r\n\r\n\r\n# \u30c8\u30fc\u30af\u30f3\u306e\u53d6\u5f97\r\ndef get_token(server, name, secret, site):\r\n # URL\u306e\u69cb\u7bc9(API\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u5909\u66f4\u3059\u308b\u969b\u306f3.13\u306e\u90e8\u5206\u3092\u5909\u66f4)\r\n url = server + \"\/api\/3.13\/auth\/signin\"\r\n # \u30d8\u30c3\u30c0\u30fc\r\n headers = {\r\n \"accept\": \"application\/json\",\r\n \"content-type\": \"application\/json\"\r\n }\r\n # \u30dc\u30c7\u30a3\r\n body = {\r\n \"credentials\": {\"personalAccessTokenName\": name,\r\n \"personalAccessTokenSecret\": secret,\r\n \"site\": {\"contentUrl\": site}}}\r\n # POST\r\n pst = requests.post(url, json=body, headers=headers)\r\n # \u7d50\u679c\u53d6\u5f97\r\n response = pst.json()\r\n token = response[\"credentials\"][\"token\"]\r\n return token\r\n \r\n\r\nif __name__ == '__main__':\r\n # \u5404\u7a2e\u8a2d\u5b9a\r\n server = \"\u30b5\u30fc\u30d0\u30fc\u306eURL\" #ex)\"https:\/\/us-west-2b.online.tableau.com\"\r\n name = tableau_pat_name\r\n secret = tableau_pat_secret\r\n site = \"\u30b5\u30a4\u30c8\u540d\"\r\n # \u95a2\u6570\u5b9f\u884c\r\n token = get_token(server, name, secret, site)\r\n context.updateVariable('tableau_token', token)<\/code><\/pre>\n5. \u30e1\u30bf\u30c7\u30fc\u30bf\u60c5\u5831\u3092\u53d6\u5f97\u2192DWH\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u51e6\u7406\u3092\u201dAPI Query\u201d\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3092\u7528\u3044\u3066\u4f5c\u6210<\/h5>\n
“API Query”\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u306eProperties\u6b04\u304b\u3089\u5404\u7a2e\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n![\"\"](\"https:\/\/gri.jp\/media\/wp\/wp-content\/uploads\/2023\/10\/mat_05.png\")
\n
\u3053\u306e\u969b\u3001\u4ee5\u4e0b\u30dd\u30a4\u30f3\u30c8\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n\n- Authentication Method\u3067\u306f”Bearer Token”\u3067\u306f\u306a\u304f”Other”\u3092\u9078\u629e\u3059\u308b<\/li>\n
- Connection Options\u306eParameter\u306b\u201dCustomHeaders\u201d\u3001Value\u306b\u201dX-tableau-auth:${token\u304c\u5165\u3063\u3066\u3044\u308b\u5909\u6570\u540d}\u201d\u3092\u5165\u529b\u3059\u308b
\n![\"\"](\"https:\/\/gri.jp\/media\/wp\/wp-content\/uploads\/2023\/10\/mat_06.png\")
<\/li>\n<\/ul>\n\u3042\u3068\u306f\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u8a2d\u5b9a\u3059\u308c\u3070\u30b8\u30e7\u30d6\u306f\u4e00\u901a\u308a\u5b8c\u6210\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3053\u3061\u3089\u306e\u8a18\u4e8b\u306e\u7d9a\u304d\u3067\u3059\u3002 https:\/\/gri.jp\/media\/entry\/31336 \u672c\u8a18\u4e8b\u3067\u306fELT\u30c4\u30fc\u30eb\u306eMatillion\u3067Tableau\u30e1\u30bf\u30c7\u30fc\u30bfAPI\u3092\u5229\u7528\u2192\u30e1\u30bf\u30c7\u30fc\u30bf\u60c5\u5831\u3092DWH\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u65b9\u6cd5\u3092<\/p>\n","protected":false},"author":10,"featured_media":30625,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[124,131],"tags":[],"class_list":["post-32039","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","category-matillion"],"acf":[],"meta_field":{"_edit_lock":["1701070849:44"],"_edit_last":["44"],"_oembed_deeda94791f4b08720d6244c9694afef":["{{unknown}}"],"_thumbnail_id":["30625"],"hidden_toppage":["0"],"_hidden_toppage":["field_61933136630d2"],"note_url":[""],"_note_url":["field_61243c8278b90"],"_oembed_03aff6ae0c970e0a31cd627511c49328":["{{unknown}}"],"_oembed_139629198d2671a20aa10dd4118ed207":["{{unknown}}"],"_pv_count":["a:24:{i:19;i:36;i:21;i:11;i:11;i:52;i:14;i:53;i:5;i:20;i:16;i:55;i:17;i:54;i:20;i:25;i:0;i:17;i:9;i:24;i:13;i:47;i:18;i:50;i:6;i:22;i:22;i:9;i:12;i:35;i:8;i:21;i:2;i:21;i:15;i:81;i:3;i:26;i:1;i:19;i:23;i:20;i:4;i:18;i:10;i:36;i:7;i:14;}"],"pv_count":["766"],"_oembed_b8ba489bae8643db98cf25f914e259d2":["{{unknown}}"],"_oembed_fdf0ed9abb797fd256fb0cd21660e56a":["{{unknown}}"],"_oembed_4a1017f595b0a7f49d8072d8e019d779":["{{unknown}}"],"_oembed_453d4766896bd0d7ae12470e6d8c7f6c":["{{unknown}}"],"_oembed_7048bb15734a2366042318168c3781f5":["{{unknown}}"],"_oembed_2d147444a1abfa1df3885f343864c605":["{{unknown}}"],"_oembed_62b04220d3beb8ec2832dd5f728c1291":["{{unknown}}"],"_oembed_4f205f51a2fb6eeeed89e043f70c431f":["{{unknown}}"],"_oembed_71b8a5805610c206612c854e26b3b45c":["{{unknown}}"],"_oembed_2effecddb9581e1c841b875113a1fb88":["{{unknown}}"],"_oembed_e526b2b099c32c6209bfd6fdcbed181d":["{{unknown}}"],"_oembed_137933a300d702df94a070856c663c23":["{{unknown}}"],"_oembed_7e0ec6ef1ba83b6957fd4623b7a3fa90":["{{unknown}}"]},"_links":{"self":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/32039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/comments?post=32039"}],"version-history":[{"count":38,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/32039\/revisions"}],"predecessor-version":[{"id":32348,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/posts\/32039\/revisions\/32348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/media\/30625"}],"wp:attachment":[{"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/media?parent=32039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/categories?post=32039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gri.jp\/media\/wp-json\/wp\/v2\/tags?post=32039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/gri.jp\/media\/wp\/wp-content\/uploads\/2023\/10\/mat_01.png\")
\n![\"\"](\"https:\/\/gri.jp\/media\/wp\/wp-content\/uploads\/2023\/10\/mat_03.png\")
![\"\"](\"https:\/\/gri.jp\/media\/wp\/wp-content\/uploads\/2023\/10\/mat_04.png\")
<\/h5>\n