Microsoft Teams チャネルへの毎日の Easy Redmine タスク要約

• •特別な前提条件なし、インポートしてすぐに使用可能

{
  "id": "xsuWTwhJDHUQQVjz",
  "meta": {
    "instanceId": "ccf4e500c5536799e0925f03390f0fd338e2b5a5bc862f6a57b5552acfdf3861",
    "templateCredsSetupCompleted": true
  },
  "name": "Daily Easy Redmine Task Digest to Microsoft Teams Channel",
  "tags": [],
  "nodes": [
    {
      "id": "fc2c5dd2-e626-4647-ba2c-af9d00f51264",
      "name": "デイリートリガー (8:30 営業日)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -160,
        360
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks",
              "triggerAtDay": [
                1,
                2,
                3,
                4,
                5
              ],
              "triggerAtHour": 8,
              "triggerAtMinute": 30
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cf290a32-5f96-4c70-926c-30e449a92e21",
      "name": "クエリによる課題取得",
      "type": "@easysoftware/n8n-nodes-easy-redmine.easyRedmine",
      "position": [
        80,
        360
      ],
      "parameters": {
        "issueQueryId": 4809
      },
      "credentials": {
        "easyRedmineApi": {
          "id": "abcd1234abcd1234",
          "name": "EasyRemide"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ef26cd7d-0950-4847-946b-fea9659db37f",
      "name": "課題の分割",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        340,
        360
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "issues"
      },
      "typeVersion": 1
    },
    {
      "id": "d7e750fb-6c80-46e1-bbfc-202937adc1c4",
      "name": "関連フィールドの保持とリンク追加",
      "type": "n8n-nodes-base.set",
      "position": [
        560,
        360
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "48f456af-93c0-47be-bf25-8bd3dff5a42e",
              "name": "id",
              "type": "number",
              "value": "={{ $json.id }}"
            },
            {
              "id": "3f02bc20-d310-40a5-85b2-81fe1e535c07",
              "name": "subject",
              "type": "string",
              "value": "={{ $json.subject }}"
            },
            {
              "id": "9869f590-352b-433a-adeb-deb5d36ad1e5",
              "name": "author.name",
              "type": "string",
              "value": "={{ $json.author.name }}"
            },
            {
              "id": "838ad7d9-05e1-4be7-b359-4805740c2a9c",
              "name": "description",
              "type": "string",
              "value": "={{ $json.description }}"
            },
            {
              "id": "124b94db-506d-4312-a802-694c22a88bc5",
              "name": "link",
              "type": "string",
              "value": "=https://easy-redmine-application.com/issues/{{ $json.id }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "c46b0f6a-9327-4251-97d6-6be532b310dd",
      "name": "チームチャネルへのメッセージ",
      "type": "n8n-nodes-base.microsoftTeams",
      "position": [
        1180,
        380
      ],
      "webhookId": "a6326de8-775a-4e72-ab6e-a83637a06c59",
      "parameters": {
        "chatId": {
          "__rl": true,
          "mode": "list",
          "value": "19:328bdd03-7527-428f-865b-87c50d8daa66_af502038-8477-4ce6-9694-d56231f5f8fa@unq.gbl.spaces",
          "cachedResultUrl": "https://teams.microsoft.com/l/chat/19%3A328bdd03-7527-428f-865b-87c50d8daa66_af502038-8477-4ce6-9694-d56231f5f8fa%40unq.gbl.spaces/0?tenantId=eb70cc06-ad73-44a6-ac58-5550fce11ed1",
          "cachedResultName": "My Team Channel"
        },
        "message": "=Name: <b>{{ $json.subject }}</b><br>Link: <a href=\"{{ $json.link }}\"\">{{ $json.id }}</a></b> <br> Author: <b>{{ $json.author.name }}</b> <br> Description:<br> {{ $json.description }} <b>",
        "options": {},
        "resource": "chatMessage",
        "contentType": "html"
      },
      "credentials": {
        "microsoftTeamsOAuth2Api": {
          "id": "asdf987654asdf987654",
          "name": "MS Teams"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "9623f022-6837-4a01-a2b0-77ff70412f66",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        160
      ],
      "parameters": {
        "color": 7,
        "width": 1600,
        "height": 480,
        "content": "## Call for issues in Easy Redmine & send relevant information to MS teams channel\n**1) GET issues by query via \"Easy Redmine node\"** - receive all issues corresponding to saved filter in Easy Redmine [(Read more about Easy Redmine filters)](https://www.easyredmine.com/documentation-of-easy-redmine/article/filters-1-0)\n**2) \"Split out\" issues array** - to work with separate issues as single items\n**3) \"Edit fields\" - keep relevant data & add URL to issue** - keep only issue id, subject, author, description, and create URL link to issue\n**4) \"Loop over items\" - send one issue at the time**\n**5) Send the message via \"MS Teams node\"** - use technical user & select relevant teams channel or chat "
      },
      "typeVersion": 1
    },
    {
      "id": "0ab382a3-70f9-49a2-84fd-306f14dac153",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1440,
        160
      ],
      "parameters": {
        "width": 340,
        "height": 480,
        "content": "## Final Output\n### Received in teams chat \nName: **Client ABC - request consulting help**\nLink: [1354](https://easyredmineapp.com/issues/1354) \n Author: **Jane Doe** \n\n Description:\n\n Service Request for consulting help: The necessary help including initiation of service delivery until the end of week. Client requested support with data migration and configuration of project modules including roles and permissions set-up. \n \n"
      },
      "typeVersion": 1
    },
    {
      "id": "ea8e1a81-b454-4785-9fe1-dd2468e990d0",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        160
      ],
      "parameters": {
        "width": 700,
        "height": 1120,
        "content": "## Daily Team Task Digest to MS Teams \n**Try out using a native Easy Redmine node to get issues according saved filter and send them to your MS Teams Channel.**\n\n### About Workflow\nThis workflow automatically collects newly assigned tasks for a specific team and posts them into a Microsoft Teams channel each morning.\n\n### Use Case \nAny team working with issues in Easy Redmine can benefit from automatic summary send to Teams - making sure all issues are addressed in time & saving time on meeting preparation without any copy pasting and no obsolete data.\n\n\n### How it works\n- Scheduled trigger will ensure the automatic run \n=> every work-day at 8:30\n- Easy Redmine node will GET all the issues by saved filter\n=> Issues | Get Many | Query Name or ID\n-  The filter is saved in Easy Redmine and assures all relevant issues are received\n=> Assignee is \"Consulting Team\" | Status is \"Open\" | Updated within \"last 3 days\"\n- Split out received data\n=> Output response is **one item**, which contains all received issues\n=> Split array \"issues\" to have 1 issue per item\n- Edit fields - keep only relevant data, adjust description, create URL link \n=> Fields: ID | Author | Subject | Description | URL Link\n=> URL link: Add expression https://easyredmineapp.com/issues/{{issue ID}} to create a link to the issue  \n- Loop over items - send one message per issue\n- Send to MS Teams - by native MS Teams node\n=> Chat Message | Create | Selected Channel | HTML content\n=> HTML content mapped from edit fields node\n\n### How to use\n- Adjust the set-up to your team's need\n- Use your preffered filter and teams chat\n- Fetch open tasks assigned to a selected group or role.\n- Use the workflow for multiple teams\n- Adjust trigger for different intervals\n\n### Requirements \n- Easy Redmine application\n=> ideally technical user for API calls with specific permissions\n- MS Teams\n=> ideally technical user for API calls with specific permissions\n\n### Need Help? \n- Reach out through n8n community => https://community.n8n.io/u/easy8.ai\n- Contant our team directly => Easy8.ai\n- Visit our youtube channel => https://www.youtube.com/@easy8ai \n"
      },
      "typeVersion": 1
    },
    {
      "id": "18f34577-cc2d-45d8-8b83-60529875eaa2",
      "name": "タスクごとの実行",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        800,
        360
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "39fcc592-bbc5-43b1-9bb6-b2f0f056017e",
  "connections": {
    "ef26cd7d-0950-4847-946b-fea9659db37f": {
      "main": [
        [
          {
            "node": "d7e750fb-6c80-46e1-bbfc-202937adc1c4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18f34577-cc2d-45d8-8b83-60529875eaa2": {
      "main": [
        [],
        [
          {
            "node": "c46b0f6a-9327-4251-97d6-6be532b310dd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cf290a32-5f96-4c70-926c-30e449a92e21": {
      "main": [
        [
          {
            "node": "ef26cd7d-0950-4847-946b-fea9659db37f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c46b0f6a-9327-4251-97d6-6be532b310dd": {
      "main": [
        [
          {
            "node": "18f34577-cc2d-45d8-8b83-60529875eaa2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fc2c5dd2-e626-4647-ba2c-af9d00f51264": {
      "main": [
        [
          {
            "node": "cf290a32-5f96-4c70-926c-30e449a92e21",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d7e750fb-6c80-46e1-bbfc-202937adc1c4": {
      "main": [
        [
          {
            "node": "18f34577-cc2d-45d8-8b83-60529875eaa2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}