SQLite Web: app.db

id

Primary key. INTEGER

automation_id

INTEGER NOT NULL

status

TEXT NOT NULL

start_time

TEXT NOT NULL

end_time

TEXT

logs

[{"timestamp": "2026-03-06T05:53:37.446574", "level": "info", "message": "Starting automation execution. Context: {\"field_1771059625885\": \"ezrez\", \"field_1771059732881\": \"+212666666\", \"field_1771059775104\": \"0-50\", \"field_1771059785751\": \"\", \"field_1771059794160\": \"\", \"field_1771059803951\": \"Nom du cabinet: rezrez\\nEmail: amine@gmail.com\\n\\nrezrez\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 116, \"form_created_at\": \"2026-03-06T05:53:37.421048\", \"source\": \"doctors-agent-landing-page\", \"chatbot_id\": 38, \"name\": \"ezrez\", \"body\": \"Nom du cabinet: rezrez\\nEmail: amine@gmail.com\\n\\nrezrez\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"customer_name\": \"ezrez\", \"customer_phone\": \"+212666666\", \"message_volume\": \"0-50\", \"preferred_date\": \"\", \"preferred_time_slot\": \"\", \"additional_notes\": \"Nom du cabinet: rezrez\\nEmail: amine@gmail.com\\n\\nrezrez\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"_field_labels\": {\"field_1771059625885\": \"customer_name\", \"field_1771059732881\": \"customer_phone\", \"field_1771059775104\": \"message_volume\", \"field_1771059785751\": \"preferred_date\", \"field_1771059794160\": \"preferred_time_slot\", \"field_1771059803951\": \"additional_notes\"}}", "node_id": null}, {"timestamp": "2026-03-06T05:53:37.446835", "level": "info", "message": "Standardized variables: ['full_name']", "node_id": null}, {"timestamp": "2026-03-06T05:53:37.446943", "level": "info", "message": "Triggered by node trigger-1 (Form Submitted)", "node_id": "trigger-1"}, {"timestamp": "2026-03-06T05:53:37.447069", "level": "info", "message": "Executing node if_else-3-1772095076195 (if_else)", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-03-06T05:53:37.447244", "level": "info", "message": "DEBUG: Processing node if_else-3-1772095076195, type=if_else, action=None", "node_id": null}, {"timestamp": "2026-03-06T05:53:37.447413", "level": "info", "message": "If/Else: AND conditions [False] \u2192 branch='false'", "node_id": null}, {"timestamp": "2026-03-06T05:53:37.447808", "level": "info", "message": "Executing node action-4-1772095275643 (action)", "node_id": "action-4-1772095275643"}, {"timestamp": "2026-03-06T05:53:37.448006", "level": "info", "message": "DEBUG: Processing node action-4-1772095275643, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-06T05:53:38.649690", "level": "info", "message": "Successfully sent WA text message to 33766648942", "node_id": null}, {"timestamp": "2026-03-06T05:53:38.650004", "level": "info", "message": "Skipping edge to action-6-1772153862357 (handle='true' != branch='false')", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-03-06T05:53:38.650104", "level": "info", "message": "Executing node action-6-1772095880187 (action)", "node_id": "action-6-1772095880187"}, {"timestamp": "2026-03-06T05:53:38.650208", "level": "info", "message": "DEBUG: Processing node action-6-1772095880187, type=action, action=delay", "node_id": null}, {"timestamp": "2026-03-06T05:53:38.650858", "level": "info", "message": "Executing node action-5-1772095876275 (action)", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-03-06T05:53:38.650931", "level": "info", "message": "DEBUG: Processing node action-5-1772095876275, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-06T05:53:38.983103", "level": "error", "message": "Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212666666@s.whatsapp.net\",\"exists\":false,\"number\":\"212666666\"}]}}", "node_id": null}, {"timestamp": "2026-03-06T05:53:38.983506", "level": "info", "message": "End of path at node action-5-1772095876275", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-03-06T05:53:38.983715", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1771059625885": "ezrez", "field_1771059732881": "+212666666", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "form_id": 1, "form_name": "Product Form", "submission_id": 116, "form_created_at": "2026-03-06T05:53:37.421048", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "ezrez", "body": "Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "customer_name": "ezrez", "customer_phone": "+212666666", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "_field_labels": {"field_1771059625885": "customer_name", "field_1771059732881": "customer_phone", "field_1771059775104": "message_volume", "field_1771059785751": "preferred_date", "field_1771059794160": "preferred_time_slot", "field_1771059803951": "additional_notes"}, "trigger": {"field_1771059625885": "ezrez", "field_1771059732881": "+212666666", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "form_id": 1, "form_name": "Product Form", "submission_id": 116, "form_created_at": "2026-03-06T05:53:37.421048", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "ezrez", "body": "Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "customer_name": "ezrez", "customer_phone": "+212666666", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "_field_labels": {"field_1771059625885": "customer_name", "field_1771059732881": "customer_phone", "field_1771059775104": "message_volume", "field_1771059785751": "preferred_date", "field_1771059794160": "preferred_time_slot", "field_1771059803951": "additional_notes"}}, "full_name": "ezrez", "if_else-3-1772095076195": {"branch": "false"}, "action-4-1772095275643": {"status": "success", "recipient": "33766648942", "message_type": "text", "evolution_response": {"key": {"remoteJid": "33766648942@s.whatsapp.net", "fromMe": true, "id": "3EB03D904B1C77A65CF975"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "\ud83d\udce9 Nouveau Lead\n\ud83d\udc64 Nom :  ezrez\n\ud83d\udcde T\u00e9l\u00e9phone :+212666666\n\ud83c\udff7\ufe0fNombre de message par jour : 0-50\n\ud83d\udcd2Notes : Nom du cabinet: rezrez\nEmail: amine@gmail.com\n\nrezrez\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1772603617, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1772776417, "instanceId": "e31404f3-d009-4490-b898-9fca301520ef", "source": "web"}}, "action-6-1772095880187": {"status": "error", "error": "name 'context' is not defined"}, "action-5-1772095876275": {"status": "error", "error": "Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212666666@s.whatsapp.net\",\"exists\":false,\"number\":\"212666666\"}]}}"}}

TEXT

app.db — automation_runs

Update row 119 in automation_runs