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

Questions
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
2

You would have to replace items in your code with $input.all()

So changing the second line from

const tasks = items[0].json.tasks;

to

const tasks = $input.all()[0].json.tasks;
3

Thanks! Yeah, I think that was obvious, but not for me :man_facepalming:.
Although now I got ERROR: timeLogs is not iterable [line 13]

Here is a screenshot. Can you please help me with this also?

Screenshot_18
Screenshot_181304×639 52.2 KB

4

Glad to hear that it was helpful. Can you please share how the data looks like that you send into the node. Because the problem here is that you do not process it correctly (you assume that the value time_logs is an array but it is not).

5

@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_19
Screenshot_19882×835 71.8 KB

6

I can sadly not see any time_logs in that data, nor duration, which is apparently supposed to be underneath it.

7

@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
}];
8

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
}];
9

@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":
6
},
"orderindex":
7557.00015690000000000000000000000000,
"date_created":
1669314629648,
"date_updated":
1671549691410,
"date_closed":
1671549683791,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/...."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"861m45agd",
"custom_id":
,
"name":
"Website → ......",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7554.00006270000000000000000000000000,
"date_created":
1671546917607,
"date_updated":
1671547881032,
"date_closed":
1671547877567,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/...."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"....",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"....",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"861m3rzrj",
"custom_id":
,
"name":
"Website → ...",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7546.00008570000000000000000000000000,
"date_created":
1671190152560,
"date_updated":
1671200403212,
"date_closed":
1671200399668,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"34ajec4",
"custom_id":
,
"name":
"...",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7513.00027500000000000000000000000000,
"date_created":
1669313370807,
"date_updated":
1670405254077,
"date_closed":
1670405250445,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"34ajf50",
"custom_id":
,
"name":
"...",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7512.00020630000000000000000000000000,
"date_created":
1669314566258,
"date_updated":
1670405092517,
"date_closed":
1670405076389,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"34ajdy4",
"custom_id":
,
"name":
"...",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7509.00014850000000000000000000000000,
"date_created":
1669312766254,
"date_updated":
1670332338385,
"date_closed":
1670332336170,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"37hjpej",
"custom_id":
,
"name":
"...",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7508.00007290000000000000000000000000,
"date_created":
1670164727712,
"date_updated":
1670332332521,
"date_closed":
1670332320121,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
},
{
"id":
"34ajdur",
"custom_id":
,
"name":
"...",
"status":
{
"status":
"complete",
"color":
"#6bc950",
"type":
"closed",
"orderindex":
6
},
"orderindex":
7506.00003000000000000000000000000000,
"date_created":
1669312645595,
"date_updated":
1670331255450,
"date_closed":
1670331236335,
"archived":
false,
"creator":
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"email":
"[email protected]",
"profilePicture":
"https://attachments.clickup.com/profilePictures/..."
},
"assignees":
[
{
"id":
2649265,
"username":
"...",
"color":
"#202020",
"initials":
"DD",
"email":
"[email protected]",
"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":
"[email protected]",
"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":
"[email protected]",
"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":
true
},
"project":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"folder":
{
"id":
128152221,
"name":
"...",
"hidden":
false,
"access":
true
},
"space":
{
"id":
2609048
},
"subtasks_count":
0
}
],
"last_page":
true
}
]

Screenshot_20
Screenshot_201481×464 40.5 KB

10

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:

image
image1419×819 69.5 KB

Hope this helps! Let me know if you have any questions on this.

11

@MutedJam thanks a lot! It works!

1 Like
12

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.