Function node - `items` is not defined. Did you mean `$input.all()`? - Questions

相关文章推荐
道上混的饭盒 · Get-Date ...· 4 月前 ·
冷静的热带鱼 · 【jdk1.8】LocalDateTime ...· 4 月前 ·
睿智的砖头 · java日期格式化 - 不要划水 · 4 月前 ·
机灵的煎饼果子 · 時間（Transact-SQL） - ...· 2 月前 ·
微笑的海龟 · Task.ContinueWith 方法 ...· 1 月前 ·
爱听歌的红烧肉 · 【假借冠名】網傳「侯友宜到高雄舉辦造勢活動參 ...· 11 月前 ·
傲视众生的佛珠 · 丰镐遗址_百度百科· 1 年前 ·
焦虑的煎饼 · 牛总会成员月度大事迹| 2022年8月· 1 年前 ·
博学的板凳 · 龙族Ⅴ：悼亡者的归来会是龙族系列的最后一部吗 ...· 1 年前 ·
粗眉毛的电脑桌 · “双一流”建设不搞“终身制”-清华大学· 1 年前 ·
Describe the issue/error/question
Hey. I’m trying to get the sum of all tracked time from a list view in ClickUp. Everything works fine, and I can see the individual time tracked per task in the penultimate node. In the last node, I’m trying to sum that up in a function node but I get an error: “ERROR: items is not defined. Did you mean $input.all() ? [line 2]”."
Here is the function:
// Get the tasks from the HTTP Request node output
const tasks = items[0].json.tasks;
// Initialize a variable to store the total tracked time
let totalTime = 0;
// Iterate through the tasks
for (const task of tasks) {
  // Get the time logs for the task
  const timeLogs = task.time_logs;
  // Iterate through the time logs
  for (const timeLog of timeLogs) {
    // Add the duration of the time log to the total tracked time
    totalTime += timeLog.duration;
// Set the output data to the total tracked time
return {
  totalTime: totalTime
What is the error message (if any)?
ERROR: items is not defined. Did you mean $input.all()? [line 2]
Please share the workflow
Information on your n8n setup
n8n version:0.199.0
Database you’re using (default: SQLite):
Running n8n via Docker
              You would have to replace items in your code with $input.all()
So changing the second line from
const tasks = items[0].json.tasks;
const tasks = $input.all()[0].json.tasks;
Thanks! Yeah, I think that was obvious, but not for me .

Although now I got ERROR: timeLogs is not iterable [line 13]
Here is a screenshot. Can you please help me with this also?
Screenshot_181304×639 52.2 KB
              @jan I’m not sure, because I’m not very technical but here’s a screenshot, hope it helps.

“time_spent” is the value that I need for the sum.
Screenshot_19882×835 71.8 KB
              @jan yeah, you’re right. But is there any solution in which I get all the “time_spent” and sum all the values, from the “Get CU view” node?
Also tried editing the Code function to this, but no luck:
const FIELD_NAME = 'time_spent';
let result = 0;
for (const item of $input.all()) {
  result = result + parseFloat(item.json[FIELD_NAME]);
return [{
  total: result
              time_spent is apparently underneath tasks. As you did just share a part of the output and not the full one I assume now tasks is an object and not an array, and there is no other level between. In this case, you simply have to add tasks in front of it:
const FIELD_NAME = 'time_spent';
let result = 0;
for (const item of $input.all()) {
  result = result + parseFloat(item.json.tasks[FIELD_NAME]);
return [{
  total: result
              @jan thanks for the help. Now it doesn’t show any error, but in the code function it shows total = null. I’ll post a screenshot, but here’s the Output from the “Get CU view” node:
"tasks":
"id":
"34ajf6h",
"custom_id":
"name":
"Website → .....",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7557.00015690000000000000000000000000,
"date_created":
1669314629648,
"date_updated":
1671549691410,
"date_closed":
1671549683791,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/...."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures...."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
"... ...",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures....."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/...",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"861m45agd",
"custom_id":
"name":
"Website → ......",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7554.00006270000000000000000000000000,
"date_created":
1671546917607,
"date_updated":
1671547881032,
"date_closed":
1671547877567,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/...."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"time_spent":
196428,
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
"... ...",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"....",
"email":
"...",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/...",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
".....",
"access":
"project":
"id":
128152221,
"name":
"....",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"....",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"861m3rzrj",
"custom_id":
"name":
"Website → ...",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7546.00008570000000000000000000000000,
"date_created":
1671190152560,
"date_updated":
1671200403212,
"date_closed":
1671200399668,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"time_spent":
900000,
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
"... ...",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/861m3rzrj",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"34ajec4",
"custom_id":
"name":
"...",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7513.00027500000000000000000000000000,
"date_created":
1669313370807,
"date_updated":
1670405254077,
"date_closed":
1670405250445,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"value":
".....",
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
"...",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/34ajec4",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"34ajf50",
"custom_id":
"name":
"...",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7512.00020630000000000000000000000000,
"date_created":
1669314566258,
"date_updated":
1670405092517,
"date_closed":
1670405076389,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"time_spent":
965000,
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"value":
"....",
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
".. ..",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/34ajf50",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"34ajdy4",
"custom_id":
"name":
"...",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7509.00014850000000000000000000000000,
"date_created":
1669312766254,
"date_updated":
1670332338385,
"date_closed":
1670332336170,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
".. ..",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/34ajdy4",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"37hjpej",
"custom_id":
"name":
"...",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7508.00007290000000000000000000000000,
"date_created":
1670164727712,
"date_updated":
1670332332521,
"date_closed":
1670332320121,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"time_spent":
968829,
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
"... ...",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/37hjpej",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"id":
"34ajdur",
"custom_id":
"name":
"...",
"status":
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
"orderindex":
7506.00003000000000000000000000000000,
"date_created":
1669312645595,
"date_updated":
1670331255450,
"date_closed":
1670331236335,
"archived":
false,
"creator":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"assignees":
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"......s@yahoo.com",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"watchers":
"checklists":
"tags":
"parent":
"priority":
"due_date":
"start_date":
"points":
"time_estimate":
"time_spent":
1762164,
"custom_fields":
"id":
"6b6eafee-ba78-40cd-91bd-adf00a3e4052",
"name":
"Email client",
"type":
"email",
"type_config":
"date_created":
1658341556852,
"hide_from_guests":
false,
"value":
"office@....ro",
"required":
false
"id":
"d85cda66-4eb5-4f02-8871-b75df96ede2b",
"name":
"FIles",
"type":
"short_text",
"type_config":
"date_created":
1658816692591,
"hide_from_guests":
false,
"required":
false
"id":
"edfa31ee-d8e6-4525-be48-71e1f3e07966",
"name":
"Name",
"type":
"short_text",
"type_config":
"date_created":
1658342115370,
"hide_from_guests":
false,
"value":
"... ...",
"required":
false
"id":
"4baa587c-dd28-4ed3-bb41-ef7cc74b754e",
"name":
"TEAM",
"type":
"users",
"type_config":
"single_user":
false,
"include_groups":
true,
"include_guests":
false,
"include_team_members":
false
"date_created":
1655444428608,
"hide_from_guests":
false,
"value":
"id":
"7c279e09-3d7a-423c-a7b8-ac2e7f0a6c71",
"team_id":
2447799,
"userid":
2649265,
"name":
"Web Development",
"handle":
"web-development",
"date_created":
1655444207144,
"initials":
"WD",
"members":
"id":
2649265,
"username":
"...",
"email":
"......s@yahoo.com",
"color":
"#202020",
"initials":
"DD",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
"avatar":
"attachment_id":
"color":
"#1ABC9C",
"source":
"fas",
"icon":
"desktop"
"required":
false
"id":
"2117035b-c62d-49f9-b794-bbf1ed972ad7",
"name":
"Task created",
"type":
"checkbox",
"type_config":
"date_created":
1658411154686,
"hide_from_guests":
false,
"value":
"true",
"required":
false
"id":
"8ba44e34-6401-4f17-95bf-da1408c32ce6",
"name":
"QA",
"type":
"checkbox",
"type_config":
"date_created":
1655812788333,
"hide_from_guests":
false,
"required":
false
"dependencies":
"linked_tasks":
"team_id":
2447799,
"url":
"https://app.clickup.com/t/34ajdur",
"permission_level":
"create",
"list":
"id":
170188873,
"name":
"... Tasks",
"access":
"project":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"folder":
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
"space":
"id":
2609048
"subtasks_count":
"last_page":
Screenshot_201481×464 40.5 KB
              So it seems your tasks field is in fact an array rather than an object. Meaning you’d also have to loop through the individual items of this array to perform your calculation. Here’s a quick example workflow (living on GitHub as its code is too long for the forum) also taking into consideration tasks without a time_spent field.
The relevant code snippet is this one:
const FIELD_NAME = 'time_spent';
let result = 0;
for (const item of $input.all()) {
  for (const task of item.json.tasks) {
    console.log(task[FIELD_NAME]);
    if (task[FIELD_NAME]) {
      result = result + parseFloat(task[FIELD_NAME]); 
return [{
  total: result
This seems to work fine using your example data and produces the following result:
image1419×819 69.5 KB
Hope this helps! Let me know if you have any questions on this.