Data is Overwritten in Workflow Preventing Upsert of Table (n8n Cloud)

Describe the problem/error/question

I’m fetching data from the ClickUp API and when I attempt to use the data it is overwritten with the first item’s value before I even get to the next node.

Only the value I’m trying to update is changed. All other values seem to be the same.

I’ve attempted to remove splits and anything in between and it still gets overwritten.

The specific workflow section has been copied to a new workflow and it is still the same experience. No other nodes to complicate this.

See video of the data being overwritten in real time, twice.

What is the error message (if any)?

No Errors.

The nodes run, but the data is overwritten before it even gets to the last node to Upsert tables.

Please share your workflow/screenshots/recording

https://drive.google.com/file/d/1S457gq1J0b995ar0QAJhi8dcNImlHr4a/view?usp=sharing

Share the output returned by the last node

The output of the PREVIOUS node gets changed before the next node is executed.

The IDs are the same but the NAMES, which we’re checking and storing, are being changed to the first item’s name.

Before:

[
  {
    "id": "901112192504",
    "name": "STRONG START EARLY CHILD CARE DATA",
    "orderindex": 0,
    "status": null,
    "priority": null,
    "assignee": null,
    "task_count": 2,
    "due_date": null,
    "start_date": null,
    "folder": {
      "id": "90117168043",
      "name": "DATA REPO",
      "hidden": false,
      "access": true
    },
    "space": {
      "id": "90113933303",
      "name": "Road to Scale™",
      "access": true
    },
    "archived": false,
    "override_statuses": null,
    "permission_level": "create"
  },
  {
    "id": "901112295428",
    "name": "NEW DUPE",
    "orderindex": 2,
    "status": null,
    "priority": null,
    "assignee": null,
    "task_count": 2,
    "due_date": null,
    "start_date": null,
    "folder": {
      "id": "90117168043",
      "name": "DATA REPO",
      "hidden": false,
      "access": true
    },
    "space": {
      "id": "90113933303",
      "name": "Road to Scale™",
      "access": true
    },
    "archived": false,
    "override_statuses": false,
    "permission_level": "create"
  }
]


After:

[
  {
    "id": "901112192504",
    "name": "STRONG START EARLY CHILD CARE DATA",
    "orderindex": 0,
    "status": null,
    "priority": null,
    "assignee": null,
    "task_count": 2,
    "due_date": null,
    "start_date": null,
    "folder": {
      "id": "90117168043",
      "name": "DATA REPO",
      "hidden": false,
      "access": true
    },
    "space": {
      "id": "90113933303",
      "name": "Road to Scale™",
      "access": true
    },
    "archived": false,
    "override_statuses": null,
    "permission_level": "create"
  },
  {
    "id": "901112295428",
    "name": "STRONG START EARLY CHILD CARE DATA",
    "orderindex": 2,
    "status": null,
    "priority": null,
    "assignee": null,
    "task_count": 2,
    "due_date": null,
    "start_date": null,
    "folder": {
      "id": "90117168043",
      "name": "DATA REPO",
      "hidden": false,
      "access": true
    },
    "space": {
      "id": "90113933303",
      "name": "Road to Scale™",
      "access": true
    },
    "archived": false,
    "override_statuses": false,
    "permission_level": "create"
  }
]

Debug info

core

  • n8nVersion: 1.117.2

  • platform: docker (cloud)

  • nodeJsVersion: 22.18.0

  • nodeEnv: production

  • database: sqlite

  • executionMode: regular

  • concurrency: 5

  • license: community

storage

  • success: all

  • error: all

  • progress: false

  • manual: true

  • binaryMode: filesystem

pruning

  • enabled: true

  • maxAge: 168 hours

  • maxCount: 2500 executions

client

  • userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/141.0.0.0 safari/537.36

  • isTouchDevice: false

Generated at: 2025-10-27T18:52:54.151Z}

Hi @SWDS-ID

the issue comes from using = in your expression, this assigns a value instead of comparing it which causes the unexpected results you’re seeing..

Please use == instead:

image

2 Likes

I see!

Thanks. Probably just needed extra eyes on this.

1 Like

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