Edit Fields note outputs NULL

Questions
1

Describe the problem/error/question

When running the workflow, Edit Fields outputs NULL for SQL_newDateTime. When manually running the node, output is correct.

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.29.1
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): Default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
3

Hey @lordimac,

Can you share the JSON output of the MSSQL node so I can take a look?

4

Hello, yes, of course. Anonymous Output is the following:

[
  {
    "No_": "MA-00xxxx",
    "First Name": "Anonym",
    "Last Name": "Anonym",
    "E-Mail": "[email protected]",
    "Status": 0,
    "Exclude from Segment": 0,
    "Last Date Modified": "2024-02-29T00:00:00.000Z",
    "Last Time Modified": "1754-01-01T11:37:20.077Z"
  }
]
5

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