Problem/error/question:
The workflow works fine, onliy if I disconnect the postgresql node from the output of the AI Agent node
But when I connect the POSTGRESQL node to the output (I need to save the conversations and their metadata to later analyze them)
The chat output comes to me in JSON format
The error message:
the chat messages come in this format
{ “chat_id”: “31d2514b8d5c436c8704d95e8ec84047”, “user_input”: “hola”, “ai_output”: “¡Hola! Soy tu asistente virtual. Estoy aquí para ayudarte con lo que necesites. ¿En qué puedo ayudarte hoy?”, “timestamp”: “2025-02-12T22:36:53.130Z” }
What I need is to be able to save the conversations along with metadata such as time and user, since the memory node does not save timestamp or extra data
Workflow
Share the output returned by the last node
Information on your n8n setup
- **n8n version:1.77.3
- **Database (default: SQLite):default
- **n8n EXECUTIONS_PROCESS setting (default: own, main):default
- **Running n8n via (Docker, npm, n8n cloud, desktop app):docker
- **Operating system:ubuntu