Доработать интеграцию asana.com и google sheet
В гугл таблицу выгружается массив в json
Его нужно записать в ячейки таблицы, разделив события.
дата события | название задачи | id задачи | имя ответственного
Нам нужно события при перемещении карточки и изменении ответственного, а также на отдельную страницу изменение даты дедлайна.
дата события | название задачи | дедлайн | имя ответственного
Событие изменение статуса задачи:
{"data":[{
"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},
"created_at":"2019-11-28T05:08:20.184Z",
"type":"task",
"action":"added",
"resource":{"gid":"1150778230638022","resource_type":"task","name":"test 3","resource_subtype":"default_task"},
"parent":{"gid":"1150704132093786","resource_type":"section","name":"Done"}},
{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},
"created_at":"2019-11-28T05:08:20.186Z",
"type":"task",
"action":"removed",
"resource":{"gid":"1150778230638022","resource_type":"task","name":"test 3","resource_subtype":"default_task"},
"parent":{"gid":"1150704132093785","resource_type":"section","name":"In Progress"}},
{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},
"created_at":"2019-11-28T05:08:20.318Z",
"type":"story",
"action":"added",
"resource":{
"gid":"1151622275317239",
"resource_type":"story",
"created_at":"2019-11-28T05:08:20.193Z",
"created_by":{
"gid":"1150701873267203",
"resource_type":"user",
"name":"Irina"},
"type":"system",
"text":"moved this Task from In Progress to Done"},
"parent":{"gid":"1150778230638022","resource_type":"task","name":"test 3","resource_subtype":"default_task"}}],
"sync":"be6c1028f50c93683eeb75160c7d430b:0"}
Событие изменение даты:
{"data":[{"user":{"gid":"1151704075864797","resource_type":"user","name":"Boris"},"created_at":"2019-11-28T17:27:40.440Z","type":"task","action":"changed","resource":{"gid":"1150950395807720","resource_type":"task","name":"Задача отв Борис","resource_subtype":"default_task"},"parent":null},{"user":{"gid":"1151704075864797","resource_type":"user","name":"Boris"},"created_at":"2019-11-28T17:27:40.398Z","type":"story","action":"removed","resource":{"gid":"1151708987827798","resource_type":"story","created_at":"2019-11-28T17:19:24.769Z","created_by":{"gid":"1151704075864797","resource_type":"user","name":"Boris"},"type":"system","text":"changed the due date to December 31"},"parent":{"gid":"1150950395807720","resource_type":"task","name":"Задача отв Борис","resource_subtype":"default_task"}},
{"user":{
"gid":"1151704075864797","resource_type":"user","name":"Boris"
},
"created_at":"2019-11-28T17:27:40.461Z",
"type":"story",
"action":"added",
"resource":{
"gid":"1151709612917845",
"resource_type":"story",
"created_at":"2019-11-28T17:27:40.285Z",
"created_by":{
"gid":"1151704075864797",
"resource_type":"user",
"name":"Boris"
},
"type":"system",
"text":"changed the due date to December 30"
},
"parent":{"gid":"1150950395807720","resource_type":"task","name":"Задача отв Борис","resource_subtype":"default_task"}}
],"sync":"58d1fa77357a1efe5260759050c0705b:0"}
Событие изменение дедлайна:
{"data":[
{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"created_at":"2019-12-03T12:18:07.286Z","type":"task","action":"changed","resource":{"gid":"1150778230638022","resource_type":"task","name":"Задача 2","resource_subtype":"default_task"},"parent":null},
{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"created_at":"2019-12-03T12:18:07.260Z","type":"story","action":"removed","resource":{"gid":"1152193366135963","resource_type":"story","created_at":"2019-12-03T12:16:51.030Z","created_by":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"type":"system","text":"changed the due date to January 8"},"parent":{"gid":"1150778230638022","resource_type":"task","name":"Задача 2","resource_subtype":"default_task"}},
{"user":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"created_at":"2019-12-03T12:18:07.290Z","type":"story","action":"added","resource":{"gid":"1152193366135964","resource_type":"story","created_at":"2019-12-03T12:18:07.175Z","created_by":{"gid":"1150701873267203","resource_type":"user","name":"Irina"},"type":"system","text":"changed the due date to January 13"},"parent":{"gid":"1150778230638022","resource_type":"task","name":"Задача 2","resource_subtype":"default_task"}}
],"sync":"d00077bce158b1fa6a9f6a66feff18ff:0"}