Hi everyone,
I’m building a sub-workflow (subwf_GetRealtorById) to fetch realtor data from a Supabase Postgres database.
The workflow structure is basically: Start → Set (test input telegram_id) → Postgres (execute query) → Set (format output).
The Postgres node (named “Get Realtor”) executes the query SELECT telegram_id, name, status, access_code FROM public."Realtors" WHERE telegram_id = $1; successfully. When testing with an existing telegram_id (e.g., 12345), I can see in the Input panel of the next node that the Postgres node correctly returns the data, for example:
JSON[ { "telegram_id": 12345, "name": "Test Realtor", "status": "active", "access_code": "testcode123" } ]
The final node is a Set node (“Format Output”) configured as follows:
- Mode:
Manual Mapping - Include Other Input Fields:
true - Fields to Set:
- Name:
realtor_data - Type:
Object - Value (Expression):
{{ $node["Get Realtor"].json[0] ?? null }}
- Name:
The workflow executes successfully without any error messages.
However, when I check the output of the final “Format Output” Set node (both in the node’s Output panel and in the final Execution data view), the realtor_data field consistently shows null instead of the expected realtor object.
I’ve tried changing the Set node Mode to Merge, simplifying the expression, checking input data carefully, but the result remains null.
(What is the error message (if any)?)
There is no error message; the workflow completes successfully, but the output data from the final Set node is incorrect (null instead of the object).
workflow
n8n Version 1.84.3
Database: Supabase Postgres
n8n EXECUTIONS_PROCESS setting (default: own, main): default (own)
Running n8n via: n8n cloud
Operating system: Windows 10
