Copying tasks from ChatWork to Backlog

Hello, this is Goto from the Web System Development Department

Our company uses ChatWork, and although tasks are assigned on ChatWork,
if there are too many of them, they can get lost, or it can be difficult to understand priorities and deadlines.

On the other hand, Backlog allows you to manage tasks using a Gantt chart, making it easy to understand deadlines and importance

So, I wrote
a process to move tasks from ChatWork to Backlog I hope it will be helpful for those who are thinking of using the ChatWork API or Backlog API.

Each function will be introduced

1. Get tasks from ChatWork

You will need four pieces of information to retrieve a task from ChatWork

• Account ID of the person assigned the task
• Account ID of the person who assigned the task
• The chat room ID where the task was assigned
• Selecting completed or incomplete tasks

Each of these pieces of information can be found below

• The number after To: to the person assigned the task
• The number after To: to the person who assigned the task
• https://www.chatwork.com/#!ridThe number here (rid is not required)
• Completed done : Incomplete open

By adding these to the URL as GET parameters and making a request, task information will be returned in JSON format

function get_tasks_from_cw($account_id, $assigned_by_account_id, $room_id){ $params = array( 'account_id' = $account_id, // ID of the person who was assigned the task 'assigned_by_account_id' = $assigned_by_account_id, // ID of the person who assigned the task 'status' = 'open', // Open task ); $url = 'https://api.chatwork.com/v1/rooms/'.$room_id.'/tasks?'.http_build_query($params); $headers = array( 'http' => array( 'method' = 'GET', 'header' = implode("rn", $headers), ) ); $json_cw_tasks = file_get_contents($url, false, stream_context_create($context)); return json_decode($json_cw_tasks); }

2. Register an issue in Backlog

The following items are required to register with Backlog

• Project ID to register
• Issue type ID
• priority
• Issue subject

These are set as follows:

• • The ID of the project you want to register can be determined from the URL of the project's "Project Settings" page

https://byd.backlog.jp/EditProject.action?project.id=the number here

• • For the types of assignments, see 2-a
  • Priority is 2 is high, 3 is medium, and 4 is low
  • Feel free to choose the subject

function add_task_to_backlog($task, $project_id, $backlog_api_key){ $issue_type_id = get_issue_type_id_of_tasks($project_id); //Get the issueTypeId of the task mb_regex_encoding('UTF-8'); $params = array( 'projectId' = $project_id, 'issueTypeId' = $issue_type_id, 'priorityId' = 3, //Medium priority 'summary' = 'Task from ChatWork', 'description' = $task['body'], //Content of the issue to be registered (text of the task (body) obtained from CW) ); $url = 'https://space_name.backlog.jp/api/v2/issues?apiKey='.$backlog_api_key'&'.http_build_query($params, '&'); $header = array('Content-Type:application/x-www-form-urlencoded'); $context= array( 'http' => array( 'method' = 'POST', 'header' = $header, 'ignore_errors' = true, ) ); file_get_contents($url, false, stream_context_create($context)); }

2-a. Get the issueTypeId of the issue type "Task"

The type of issue depends on the project, so we will obtain the issueTypeId for that project from the API.
In this example, we will obtain the issueTypeId for the "Task" type.

*There is no need to use curl here. I just tried it

function get_issue_type_id_of_tasks($project_id, $backlog_api_key){ $param = array('apiKey' = $backlog_api_key); $url = 'https://space_name.backlog.jp/api/v2/projects/'.$project_id.'/issueTypes?'.http_build_query($param); $ch = curl_init(); $options = array( CURLOPT_URL = $url, CURLOPT_HTTPGET = true, CURLOPT_HTTPHEADER = array( 'HTTP/1.0', 'Content-Type: application/x-www-form-urlencoded', ), CURLOPT_RETURNTRANSFER = true, ); curl_setopt_array($ch, $options); $issue_type_json = curl_exec($ch); $issue_types = json_decode($issue_type_json); //The return value is the ID of the retrieved issue whose type is "Task". foreach ($issue_types as $issue_type) { if ($issue_type->name == 'Task'){ $issu_type = $issue_type->id; } } return $issu_type; }

It's roughly like this

ChatWork tasks have a limit_time element that can be used to obtain the due date as a timestamp, so
if you convert this to the dueDate parameter when registering a task in the backlog, you can copy the due date as well, which is very convenient
.