{"id":50915,"date":"2024-10-30T00:00:00","date_gmt":"2024-10-30T07:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/%e6%9c%aa%e5%88%86%e9%a1%9e\/automate-slide-creation-using-openai-and-node-js\/"},"modified":"2026-03-30T11:48:21","modified_gmt":"2026-03-30T18:48:21","slug":"automate-slide-creation-using-openai-and-node-js","status":"publish","type":"post","link":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/ja\/%e6%9c%aa%e5%88%86%e9%a1%9e\/automate-slide-creation-using-openai-and-node-js\/","title":{"rendered":"OpenAI\u3068Node.js\u3092\u4f7f\u3063\u3066\u30b9\u30e9\u30a4\u30c9\u4f5c\u6210\u3092\u81ea\u52d5\u5316\u3059\u308b"},"content":{"rendered":"

AI\u30c4\u30fc\u30eb\u306e\u53f0\u982d\u306b\u3088\u308a\u3001\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u30b9\u30e9\u30a4\u30c9\u306e\u4f5c\u6210\u3092\u542b\u3080\u591a\u304f\u306e\u624b\u4f5c\u696d\u3092\u81ea\u52d5\u5316\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u958b\u767a\u8005\u306f\u3001OpenAI\u306e\u8a00\u8a9e\u30e2\u30c7\u30eb\u3068Node.js\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30b9\u30e9\u30a4\u30c9\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u751f\u6210\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u81ea\u52d5\u5316\u306f\u78ba\u5b9f\u306b\u6642\u9593\u3092\u7bc0\u7d04\u3057\u307e\u3059\u3002\u30b3\u30f3\u30c6\u30f3\u30c4\u751f\u6210\u306bOpenAI\u3092\u4f7f\u3044\u3001\u30aa\u30fc\u30b1\u30b9\u30c8\u30ec\u30fc\u30b7\u30e7\u30f3\u306bNode.js\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u8aac\u5f97\u529b\u304c\u3042\u308a\u60c5\u5831\u91cf\u306e\u591a\u3044\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u306e\u4f5c\u6210\u30d7\u30ed\u30bb\u30b9\u3092\u697d\u306b\u52b9\u7387\u5316\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u3053\u306e\u6295\u7a3f\u3067\u306f\u3001OpenAI\u306e\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8API\u30e2\u30c7\u30eb\u3092\u4f7f\u3063\u3066\u30b9\u30e9\u30a4\u30c9\u30fb\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u4f5c\u6210\u3092\u81ea\u52d5\u5316\u3057\u3001Node.js\u3092\u4f7f\u3063\u3066\u30b9\u30e9\u30a4\u30c9\u30fb\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u3001GridDB\u3092\u4f7f\u3063\u3066\u30b9\u30e9\u30a4\u30c9\u60c5\u5831\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n

\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u5b9f\u884c<\/h2>\n

\u3053\u306eGitHub\u30ea\u30dd\u30b8\u30c8\u30ea<\/a>\u304b\u3089\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u30af\u30ed\u30fc\u30f3\u3057\u307e\u3059\u3002<\/p>\n

\n
git clone https:\/\/github.com\/griddbnet\/Blogs.git --branch slides<\/code><\/pre>\n<\/div>\n
\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u5b9f\u884c\u3059\u308b\u306b\u306f\u3001Node.js<\/a>\u3068GridDB<\/a>\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u5fc5\u8981\u306a\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092 apps<\/code> \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u5909\u66f4\u3057\u3066\u304b\u3089\u3001\u4f9d\u5b58\u95a2\u4fc2\u3092\u3059\u3079\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\uff1a<\/p>\n
\n
cd apps\nnpm install <\/code><\/pre>\n<\/div>\n
.env\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001\u3059\u3079\u3066\u306e\u74b0\u5883\u5909\u6570\u3092<\/code>.env.example` \u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u306f OpenAI \u30ad\u30fc\u304c\u5fc5\u8981\u3067\u3059\u3002\u30ad\u30fc\u306e\u53d6\u5f97\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f \u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n
OPENAI_API_KEY=sk-proj-secret\nVITE_APP_URL=http:\/\/localhost:3000<\/code><\/pre>\n<\/div>\n
VITE_APP_URL`\u3092\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u5909\u66f4\u3057\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff1a<\/p>\n
\n
npm run start:build<\/code><\/pre>\n<\/div>\n
\u6b21\u306b\u30d6\u30e9\u30a6\u30b6\u3092\u958b\u304d\u3001\u30a2\u30d7\u30ea\u306eURL\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u9078\u629e\u3057\u3001Create Slide<\/strong>\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\u30b9\u30e9\u30a4\u30c9\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u304c\u6b63\u5e38\u306b\u4f5c\u6210\u3055\u308c\u308b\u3068\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30ea\u30f3\u30af\u304c\u63d0\u4f9b\u3055\u308c\u307e\u3059\u3002<\/p>\n
\u306f\u3058\u3081\u306b<\/h2>\n
1. Node.js\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n
\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306fNode.js\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u4e0a\u3067\u52d5\u4f5c\u3057\u307e\u3059\u3002\u3053\u3061\u3089<\/a>\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u3001nvm<\/code> \u30d1\u30c3\u30b1\u30fc\u30b8\u30de\u30cd\u30fc\u30b8\u30e3\u3068 Node.js v16.20.2 LTS \u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n
\n
# installs nvm (Node Version Manager)\ncurl -o- https:\/\/raw.githubusercontent.com\/nvm-sh\/nvm\/v0.39.7\/install.sh | bash\n\n# download and install Node.js\nnvm install 16\n\n# verifies the right Node.js version is in the environment\nnode -v # should print `v16.20.2`\n\n# verifies the right NPM version is in the environment\nnpm -v # should print `8.19.4``<\/code><\/pre>\n<\/div>\n
Node.js\u3068GridDB\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u63a5\u7d9a\u3059\u308b\u306b\u306f\u3001gridb-node-api<\/a> npm\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n
2. GridDB\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/h3>\n
GridDB\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3057\u3066\u3001\u30ec\u30b7\u30d4\u3068\u6804\u990a\u5206\u6790\u3092\u4fdd\u5b58\u3057\u307e\u3059\u3002\u8a73\u3057\u3044\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5\u306fguide<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u3053\u3067\u306fUbuntu 20.04 LTS\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n
GridDB\u3092\u8d77\u52d5\u3057\u3001\u30b5\u30fc\u30d3\u30b9\u304c\u5b9f\u884c\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\uff1a<\/p>\n
\n
sudo systemctl status gridstore<\/code><\/pre>\n<\/div>\n
\u5b9f\u884c\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u3053\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5b9f\u884c\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\uff1a<\/p>\n
\n
sudo systemctl start gridstore<\/code><\/pre>\n<\/div>\n
3. OpenAI\u30ad\u30fc\u306e\u8a2d\u5b9a<\/h3>\n
OpenAI\u306e\u30ad\u30fc\u306f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u5358\u4f4d\u306a\u306e\u3067\u3001\u307e\u305aOpenAI\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
OpenAI\u306e\u30b5\u30fc\u30d3\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u306b\u306f\u3001\u6709\u52b9\u306a\u30ad\u30fc\u304c\u5fc5\u8981\u3067\u3059\u3002\u3053\u306e\u30ea\u30f3\u30af<\/a>\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u65b0\u3057\u3044 OpenAI \u30ad\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u4f7f\u7528\u3059\u308b\u30e2\u30c7\u30eb\u3092\u6709\u52b9\u306b\u3059\u308b\u5fc5\u8981\u3082\u3042\u308b\u3002\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u3001gpt-4o<\/code>\u30e2\u30c7\u30eb\u304c\u5fc5\u8981\u3067\u3059\u3002\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u8a2d\u5b9a\u3067\u3001\u6709\u52b9\u306b\u3059\u308b\u30e2\u30c7\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
.env\u30d5\u30a1\u30a4\u30eb\u306bOpenAI\u306e\u30ad\u30fc\u3092\u4fdd\u5b58\u3057\u3001<\/code>.gitignore`\u306b\u8ffd\u52a0\u3057\u3066\u30d0\u30fc\u30b8\u30e7\u30f3\u7ba1\u7406\u306b\u542b\u3081\u306a\u3044\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
4. AI\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/h3>\n
\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u306fAI\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u304c\u5fc5\u8981\u3067\u3059\u3002\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306b\u884c\u304d\u3001\u65b0\u3057\u3044\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
Instruction**\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u6ce8\u610f\u3092\u6255\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f\u3053\u306e\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u306b\u4f7f\u308f\u308c\u308b\u547d\u4ee4\u3067\u3059\uff1a<\/p>\n
\n
You are a data scientist assistant. When given data and a query, write the proper code and create the proper visualization.<\/code><\/pre>\n<\/div>\n
\u3053\u308c\u306f\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u304c\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u74b0\u5883\u3067\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u3001\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u307e\u3059\u3002\u3053\u306e\u6a5f\u80fd\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u3053\u3061\u3089<\/a>\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
AI\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u4f5c\u6210\u5f8c\u3001\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8ID\u3092\u30b3\u30d4\u30fc\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306eID\u306f\u3001\u3042\u306a\u305f\u304c\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9001\u4fe1\u3067\u304d\u308b\u30b3\u30fc\u30c9\u5185\u306e\u53c2\u7167\u3068\u3057\u3066\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n
\n
const dataScienceAssistantId = \"asst_FOqRnMVXw0WShTSGw70NZJAX\"<\/code><\/pre>\n<\/div>\n
\u30c7\u30fc\u30bf\u306e\u4f8b<\/h2>\n
\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u3001\u81ea\u52d5\u8eca\u306e\u30b9\u30da\u30a2\u30d1\u30fc\u30c4\u8ca9\u58f2\u306eJSON\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u306f data<\/code> \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u306f2020\u5e74\u304b\u30892024\u5e74\u307e\u3067\u306e\u30b9\u30da\u30a2\u30d1\u30fc\u30c4\u8ca9\u58f2\u30c7\u30fc\u30bf<\/a>\u3067\u3059\uff1a<\/p>\n
\n
[\n {\n  \"Year\": 2020,\n  \"Quarter\": \"Q1\",\n  \"Distribution channel\": \"Online Sales\",\n  \"Revenue ($M)\": 2.10,\n  \"Costs ($M)\": 1.905643,\n  \"Customer count\": 190,\n  \"Time\": \"2020 Q1\",\n  \"Product Category\": \"Engine Parts\",\n  \"Region\": \"North America\",\n  \"Units Sold\": 900,\n  \"Average Sale Price ($)\": 2333,\n  \"Discounts Given ($)\": 14000,\n  \"Returns ($)\": 4500,\n  \"Customer Satisfaction Rating\": 8.2,\n  \"Salesperson\": \"SP120\",\n  \"Marketing Spend ($)\": 18000\n },\n {\n  \"Year\": 2020,\n  \"Quarter\": \"Q1\",\n  \"Distribution channel\": \"Direct Sales\",\n  \"Revenue ($M)\": 2.15,\n  \"Costs ($M)\": 2.004112,\n  \"Customer count\": 200,\n  \"Time\": \"2020 Q1\",\n  \"Product Category\": \"Brakes\",\n  \"Region\": \"Europe\",\n  \"Units Sold\": 1000,\n  \"Average Sale Price ($)\": 2150,\n  \"Discounts Given ($)\": 12000,\n  \"Returns ($)\": 5000,\n  \"Customer Satisfaction Rating\": 8.0,\n  \"Salesperson\": \"SP121\",\n  \"Marketing Spend ($)\": 19000\n },\n ...\n {\n  \"Year\": 2024,\n  \"Quarter\": \"Q2\",\n  \"Distribution channel\": \"Direct Sales\",\n  \"Revenue ($M)\": 3.15,\n  \"Costs ($M)\": 2.525112,\n  \"Customer count\": 390,\n  \"Time\": \"2024 Q2\",\n  \"Product Category\": \"Brakes\",\n  \"Region\": \"Europe\",\n  \"Units Sold\": 1500,\n  \"Average Sale Price ($)\": 2095,\n  \"Discounts Given ($)\": 22000,\n  \"Returns ($)\": 17000,\n  \"Customer Satisfaction Rating\": 9.1,\n  \"Salesperson\": \"SP144\",\n  \"Marketing Spend ($)\": 38000\n }\n]<\/code><\/pre>\n<\/div>\n
\u7406\u60f3\u7684\u306b\u306f\u3001\u30c7\u30fc\u30bf\u306f\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u7d4c\u7531\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u308b\u3079\u304d\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u7c21\u5358\u306e\u305f\u3081\u3001\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u306e\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u304b\u3089\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u9078\u629e\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u304c\u76f4\u63a5\u51e6\u7406\u3055\u308c\u307e\u3059\u3002<\/p>\n
**OpenAI\u306f\u3069\u3046\u3084\u3063\u3066\u30d5\u30a1\u30a4\u30eb\u3092\u76f4\u63a5\u51e6\u7406\u3059\u308b\u306e\u3067\u3059\u304b\uff1f<\/p>\n
\u7b54\u3048\u306f\u3001\u307e\u305a\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u624b\u52d5\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306b\u884c\u304d\u3001\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u76ee\u7684\u306b\u6ce8\u610f\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u30d5\u30a1\u30a4\u30eb\u306f\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8<\/strong>\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n
\u5f8c\u3067\u3001\u3053\u308c\u3089\u306e\u30d5\u30a1\u30a4\u30ebID\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u304b\u3089\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u9078\u629e\u3057\u305f\u3068\u304d\u306b\u3001\u3069\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u4f7f\u7528\u3055\u308c\u308b\u304b\u3092\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n
\u30b3\u30f3\u30c6\u30f3\u30c4\u306e\u751f\u6210<\/h2>\n
\u30e6\u30fc\u30b6\u30fc\u304c\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u9078\u629e\u3057\u3001Create Slide<\/strong>\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8API\u304c\u30b3\u30f3\u30c6\u30f3\u30c4\u30b9\u30e9\u30a4\u30c9\u7528\u306e\u753b\u50cf\u3068\u30c6\u30ad\u30b9\u30c8\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u30b9\u30e9\u30a4\u30c9\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u751f\u6210\u3059\u308b\u305f\u3081\u306e\u30b3\u30fc\u30c9\u3067\u91cd\u8981\u306a\u30b9\u30c6\u30c3\u30d7\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\uff1a<\/p>\n
1. \u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u306e\u5206\u6790<\/h3>\n
OpenAI\u306f\u9078\u629e\u3055\u308c\u305f\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u5206\u6790\u3057\u3001\u56db\u534a\u671f\u3054\u3068\u3001\u5e74\u5ea6\u3054\u3068\u306b\u5229\u76ca\u3092\u8a08\u7b97\u3057\u3001\u30d7\u30ed\u30c3\u30c8\u3092\u8996\u899a\u5316\u3057\u307e\u3059\u3002<\/p>\n
\u3053\u306e\u30d7\u30ed\u30bb\u30b9\u306e\u30d7\u30ed\u30f3\u30d7\u30c8\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\uff1a<\/p>\n
\n
const analyzeDataPrompt = \"Calculate the profit (revenue minus cost) by quarter and year, and visualize as a line plot across the distribution channels, where the colors of the lines are green, light red, and light blue\"<\/code><\/pre>\n<\/div>\n
And this code will process the prompt and the selected file (see fileId<\/code>)<\/p>\n
\n
 const thread = await openai.beta.threads.create({\n  messages: [\n   {\n    \"role\": \"user\",\n    \"content\": analyzeDataPrompt,\n    \"attachments\": [\n     {\n      file_id: fileId,\n      tools: [{ type: \"code_interpreter\" }]\n     }\n    ]\n   }\n  ]\n });<\/code><\/pre>\n<\/div>\n
\u3053\u306e\u30b3\u30fc\u30c9\u304b\u3089\u3001\u30d7\u30ed\u30c3\u30c8\u753b\u50cf\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u306fpublic\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u4fdd\u5b58\u3055\u308c\u3001\u30b9\u30e9\u30a4\u30c9\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u3067\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/p>\n
2. \u7b87\u6761\u66f8\u304d\u306e\u751f\u6210<\/h3>\n
AI\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u306f\u30c7\u30fc\u30bf\u306b\u5bfe\u3059\u308b\u6d1e\u5bdf\u3092\u4e0e\u3048\u3001\u7b87\u6761\u66f8\u304d\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u3001AI\u306b\u30c7\u30fc\u30bf\u306b\u95a2\u3059\u308b2\u3064\u306e\u6d1e\u5bdf\u3092\u4e0e\u3048\u308b\u3088\u3046\u306b\u6307\u793a\u3059\u308b\u30d7\u30ed\u30f3\u30d7\u30c8\u3067\u3059\uff1a<\/p>\n
\n
const insightPrompt = `Give me two medium-length sentences (~20-30 words per sentence) of the most important insights from the plot you just created, and save each sentence as an item in one array. Give me a raw array, no formatting, no commentary. These will be used for a slide deck, and they should be about the 'so what' behind the data.`<\/code><\/pre>\n<\/div>\n
3. \u30a4\u30f3\u30b5\u30a4\u30c8\u30bf\u30a4\u30c8\u30eb\u306e\u751f\u6210<\/h3>\n
\u6700\u5f8c\u306e\u30b9\u30c6\u30c3\u30d7\u306f\u3001\u30a4\u30f3\u30b5\u30a4\u30c8\u306e\u30bf\u30a4\u30c8\u30eb\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u3053\u308c\u306f\u305d\u306e\u305f\u3081\u306e\u30d7\u30ed\u30f3\u30d7\u30c8\u3067\u3059\uff1a<\/p>\n
\n
const titlePrompt = \"Given the plot and bullet point you created, come up with a very brief title only for a slide. It should reflect just the main insights you came up with.\"<\/code><\/pre>\n<\/div>\n
\u30b9\u30e9\u30a4\u30c9\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u751f\u6210\u3059\u308b\u305f\u3081\u306e\u5b8c\u5168\u306a\u30b3\u30fc\u30c9\u306f\u3001libs\/ai.js<\/code><\/a>\u30d5\u30a1\u30a4\u30eb\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n
\u30b9\u30e9\u30a4\u30c9\u306e\u751f\u6210<\/h2>\n
\u3053\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306fPptxGenJS<\/a>\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u4f7f\u7528\u3057\u3066\u30b9\u30e9\u30a4\u30c9\u3092\u751f\u6210\u3057\u307e\u3059\u3002libs\/pptx.js`\u30d5\u30a1\u30a4\u30eb\u306b\u5b8c\u5168\u306a\u30b3\u30fc\u30c9\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
\u3053\u308c\u306fAI\u304c\u751f\u6210\u3057\u305f\u30b9\u30e9\u30a4\u30c9\u60c5\u5831\u306e\u6e96\u5099\u304c\u3067\u304d\u305f\u3068\u304d\u306b createPresentation()<\/code> \u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u30b3\u30fc\u30c9\u3067\u3059\u3002<\/p>\n
\n
\/\/...\nif (bulletPointsSummary.status === \"completed\") {\n                    const message = await openai.beta.threads.messages.list(thread.id)\n                    const dataVisTitle = message.data[0].content[0].text.value\n\n                    presentationOptions = {\n                        title: slideTitle,\n                        subtitle: slideSubtitle,\n                        dataVisTitle: dataVisTitle,\n                        chartImagePath: path.join(__dirname, \"public\", `${filename}`),\n                        keyInsights: \"Key Insights:\",\n                        bulletPoints: bulletPoints,\n                        outputFilename: path.join(__dirname, 'public', pptxFilename)\n                    };\n\n                    try {\n                        createPresentation(presentationOptions)\n                    } catch (error) {\n                        console.log(error)\n                    }\n}\n\/\/...<\/code><\/pre>\n<\/div>\n
\u751f\u6210\u3055\u308c\u305f\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306f public<\/code> \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u305d\u308c\u305e\u308c\u30e6\u30cb\u30fc\u30af\u306a\u540d\u524d\u3067\u4fdd\u5b58\u3055\u308c\u308b\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u30b9\u30e9\u30a4\u30c9\u60c5\u5831<\/h2>\n
\u30b9\u30e9\u30a4\u30c9\u60c5\u5831\u3092\u4fdd\u5b58\u3059\u308b\u305f\u3081\u306b\u3001GridDB\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u3002\u4ee5\u4e0b\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u3059\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n
Field Name<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
id<\/td>\nINTEGER<\/td>\n\u5404\u30ec\u30b3\u30fc\u30c9\u306e\u4e00\u610f\u306a\u8b58\u5225\u5b50\u3002\u3053\u308c\u306f\u30b3\u30f3\u30c6\u30ca\u306e\u4e3b\u30ad\u30fc\u3067\u3042\u308a\u3001\u30a8\u30f3\u30c8\u30ea\u3054\u3068\u306b\u4e00\u610f\u3067\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002<\/td>\n<\/tr>\n
title<\/td>\nSTRING<\/td>\n\u30b9\u30e9\u30a4\u30c9\u306e\u30e1\u30a4\u30f3\u30bf\u30a4\u30c8\u30eb\u3002\u30b9\u30e9\u30a4\u30c9\u306e\u5185\u5bb9\u3092\u8981\u7d04\u3057\u305f\u77ed\u3044\u8aac\u660e\u7684\u306a\u30bf\u30a4\u30c8\u30eb\u3067\u3059\u3002<\/td>\n<\/tr>\n
subtitle<\/td>\nSTRING<\/td>\n\u526f\u984c\u3084\u5c0f\u898b\u51fa\u3057\u306f\u3001\u4e3b\u984c\u306b\u95a2\u9023\u3059\u308b\u8ffd\u52a0\u7684\u306a\u6587\u8108\u3084\u7c21\u5358\u306a\u8aac\u660e\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
chartImage<\/td>\nSTRING<\/td>\n\u30d3\u30b8\u30e5\u30a2\u30eb\u306a\u30c7\u30fc\u30bf\u8868\u73fe\u3092\u30ea\u30f3\u30af\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u3001\u30b9\u30e9\u30a4\u30c9\u306b\u95a2\u9023\u4ed8\u3051\u3089\u308c\u305f\u30c1\u30e3\u30fc\u30c8\u306e\u753b\u50cf\u306eURL\u307e\u305f\u306f\u30d1\u30b9\u3002<\/td>\n<\/tr>\n
bulletPoints<\/td>\nSTRING<\/td>\n\u30b9\u30e9\u30a4\u30c9\u306e\u91cd\u8981\u306a\u60c5\u5831\u3084\u30cf\u30a4\u30e9\u30a4\u30c8\u3092\u8981\u7d04\u3057\u305f\u7b87\u6761\u66f8\u304d\u3092\u542b\u3080\u6587\u5b57\u5217\u3002\u5404\u7b87\u6761\u66f8\u304d\u306f\u901a\u5e38\u3001\u7279\u6b8a\u6587\u5b57\u307e\u305f\u306f\u6539\u884c\u3067\u533a\u5207\u3089\u308c\u307e\u3059\u3002<\/td>\n<\/tr>\n
pptx<\/td>\nSTRING<\/td>\n\u30b9\u30e9\u30a4\u30c9\u3092\u542b\u3080\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u3092\u30ea\u30f3\u30af\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\u3001\u30b9\u30e9\u30a4\u30c9\u3092\u542b\u3080PowerPoint\u30d5\u30a1\u30a4\u30eb\uff08.pptx\uff09\u306eURL\u307e\u305f\u306f\u30d1\u30b9\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
griddbservices.js\u3068<\/code>libs\/griddb.js`\u30d5\u30a1\u30a4\u30eb\u306f\u3059\u3079\u3066\u306e\u30b9\u30e9\u30a4\u30c9\u60c5\u5831\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3059\u308b\u5f79\u5272\u3092\u62c5\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u30b5\u30fc\u30d0\u306e\u30eb\u30fc\u30c8<\/h2>\n
Node.js\u30b5\u30fc\u30d0\u30fc\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u305f\u3081\u306b\u3044\u304f\u3064\u304b\u306e\u30eb\u30fc\u30c8\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u30eb\u30fc\u30c8\u306e\u5b8c\u5168\u306a\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u3059\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n
Method<\/th>\nRoute<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
GET<\/td>\n\/<\/code><\/td>\n\u300cdist\u300d\u30d5\u30a9\u30eb\u30c0\u304b\u3089\u300cindex.html\u300d\u30d5\u30a1\u30a4\u30eb\u3092\u914d\u4fe1\u3057\u307e\u3059 \u3002<\/td>\n<\/tr>\n
GET<\/td>\n\/create\/:fileId<\/code><\/td>\nAI\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u3092\u8d77\u52d5\u3057\u3066\u30d5\u30a1\u30a4\u30eb\u3092\u51e6\u7406\u3057\u3001\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u4fdd\u5b58\u72b6\u6cc1\u3068PPTX\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u8fd4\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
GET<\/td>\n\/metadata<\/code><\/td>\ndata<\/code> \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304b\u3089 metadata.json<\/code> \u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u307e\u3059\u3002<\/td>\n<\/tr>\n
GET<\/td>\n\/data\/files<\/code><\/td>\ndata<\/code> \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u5185\u306e\u3059\u3079\u3066\u306e JSON \u30d5\u30a1\u30a4\u30eb\u540d\u3092\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
GET<\/td>\n\/data\/files\/:filename<\/code><\/td>\ndata<\/code> \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304b\u3089\u7279\u5b9a\u306e JSON \u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u307e\u3059\u3002<\/td>\n<\/tr>\n
GET<\/td>\n\/slides<\/code><\/td>\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u3059\u3079\u3066\u306e\u30b9\u30e9\u30a4\u30c9\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u6700\u3082\u91cd\u8981\u306a\u30eb\u30fc\u30c8\u306f\/create\/:fileId<\/code>\u3067\u3001AI\u30a2\u30b7\u30b9\u30bf\u30f3\u30c8\u304c\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u5206\u6790\u3057\u3001\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u3001\u3059\u3079\u3066\u306e\u30b9\u30e9\u30a4\u30c9\u60c5\u5831\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3059\u308b\u30c8\u30ea\u30ac\u30fc\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n
\n
app.get('\/create\/:fileId', async (req, res) => {\n const fileId = req.params.fileId\n\n try {\n  const result = await aiAssistant(fileId)\n\n  if (result.status === \"completed\") {\n   const {\n    title: titlePptx,\n    subtitle: subtitlePptx,\n    dataVisTitle: dataVisTitlePptx,\n    chartImage: chartImagePptx,\n    bulletPoints: bulletPointsPptx,\n    outputFilename: pptxFile\n   } = result.data\n\n   const saveDataStatus = await saveData({ titlePptx, subtitlePptx, dataVisTitlePptx, chartImagePptx, bulletPointsPptx, pptxFile })\n\n   res.json({\n    save: saveDataStatus,\n    data: result.data,\n    pptx: result.pptx\n   })\n  } else {\n   res.status(500).json({\n    error: 'Task not completed', status: result.status\n   })\n  }\n\n } catch (error) {\n  console.error('Error in AI Assistant:', error)\n  res.status(500).json({ error: 'Error in AI Assistant', details: error.message })\n }\n})<\/code><\/pre>\n<\/div>\n
aiAssistant()\u95a2\u6570\u306f\u30c7\u30fc\u30bf\u30b5\u30f3\u30d7\u30eb\u3092\u5206\u6790\u3057\u3001\u30b9\u30e9\u30a4\u30c9\u306b\u95a2\u3059\u308b\u3059\u3079\u3066\u306e\u60c5\u5831\u3092\u8fd4\u3059\u30d7\u30ec\u30bc\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u3001<\/code>saveData()`\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u305d\u308c\u3089\u306e\u30b9\u30e9\u30a4\u30c9\u60c5\u5831\u3092GridDB\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n
\u3059\u3079\u3066\u306e\u30b9\u30e9\u30a4\u30c9\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001\/slides<\/code>\u30eb\u30fc\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3060\u3051\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3055\u308c\u305f\u3059\u3079\u3066\u306e\u30b9\u30e9\u30a4\u30c9\u30c7\u30fc\u30bf\u304c\u8fd4\u3055\u308c\u307e\u3059\u3002<\/p>\n
\"\"<\/a><\/p>\n
\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9<\/h2>\n
\"\"<\/a><\/p>\n
\u30e1\u30a4\u30f3\u30fb\u30e6\u30fc\u30b6\u30fc\u30fb\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306f2\u3064\u306e\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3067\u69cb\u6210\u3055\u308c\u3066\u3044\u307e\u3059\uff1a<\/p>\n