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-13T23:11:35.707755", "level": "info", "message": "Starting automation execution. Context: {\"field_1771059625885\": \"test\", \"field_1771059732881\": \"+212666666666\", \"field_1771059775104\": \"0-50\", \"field_1771059785751\": \"\", \"field_1771059794160\": \"\", \"field_1771059803951\": \"Nom du cabinet: test\\nEmail: amine@test.com\\n\\nTEST\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 126, \"form_created_at\": \"2026-03-13T23:11:35.676532\", \"source\": \"doctors-agent-landing-page\", \"chatbot_id\": 38, \"name\": \"test\", \"body\": \"Nom du cabinet: test\\nEmail: amine@test.com\\n\\nTEST\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\", \"customer_name\": \"test\", \"customer_phone\": \"+212666666666\", \"message_volume\": \"0-50\", \"preferred_date\": \"\", \"preferred_time_slot\": \"\", \"additional_notes\": \"Nom du cabinet: test\\nEmail: amine@test.com\\n\\nTEST\\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-13T23:11:35.707917", "level": "info", "message": "Standardized variables: ['full_name']", "node_id": null}, {"timestamp": "2026-03-13T23:11:35.707986", "level": "info", "message": "Triggered by node trigger-1 (Form Submitted)", "node_id": "trigger-1"}, {"timestamp": "2026-03-13T23:11:35.708205", "level": "info", "message": "Executing node if_else-3-1772095076195 (if_else)", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-03-13T23:11:35.708285", "level": "info", "message": "DEBUG: Processing node if_else-3-1772095076195, type=if_else, action=None", "node_id": null}, {"timestamp": "2026-03-13T23:11:35.708521", "level": "info", "message": "If/Else: AND conditions [False] \u2192 branch='false'", "node_id": null}, {"timestamp": "2026-03-13T23:11:35.708604", "level": "info", "message": "Executing node action-4-1772095275643 (action)", "node_id": "action-4-1772095275643"}, {"timestamp": "2026-03-13T23:11:35.708654", "level": "info", "message": "DEBUG: Processing node action-4-1772095275643, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-13T23:11:36.495526", "level": "info", "message": "Successfully sent WA text message to 33766648942", "node_id": null}, {"timestamp": "2026-03-13T23:11:36.496172", "level": "info", "message": "Skipping edge to action-6-1772153862357 (handle='true' != branch='false')", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-03-13T23:11:36.496351", "level": "info", "message": "Executing node action-6-1772095880187 (action)", "node_id": "action-6-1772095880187"}, {"timestamp": "2026-03-13T23:11:36.496466", "level": "info", "message": "DEBUG: Processing node action-6-1772095880187, type=action, action=delay", "node_id": null}, {"timestamp": "2026-03-13T23:11:36.502658", "level": "info", "message": "Executing node action-5-1772095876275 (action)", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-03-13T23:11:36.502789", "level": "info", "message": "DEBUG: Processing node action-5-1772095876275, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-13T23:11:37.246801", "level": "info", "message": "Successfully sent WA text message to 212666666666", "node_id": null}, {"timestamp": "2026-03-13T23:11:37.247241", "level": "info", "message": "End of path at node action-5-1772095876275", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-03-13T23:11:37.247334", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1771059625885": "test", "field_1771059732881": "+212666666666", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "form_id": 1, "form_name": "Product Form", "submission_id": 126, "form_created_at": "2026-03-13T23:11:35.676532", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "test", "body": "Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "customer_name": "test", "customer_phone": "+212666666666", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\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": "test", "field_1771059732881": "+212666666666", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "form_id": 1, "form_name": "Product Form", "submission_id": 126, "form_created_at": "2026-03-13T23:11:35.676532", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "test", "body": "Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)", "customer_name": "test", "customer_phone": "+212666666666", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\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": "test", "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": "3EB05F296F65B723D48FBD"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "\ud83d\udce9 Nouveau Lead\n\ud83d\udc64 Nom :  test\n\ud83d\udcde T\u00e9l\u00e9phone :+212666666666\n\ud83c\udff7\ufe0fNombre de message par jour : 0-50\n\ud83d\udcd2Notes : Nom du cabinet: test\nEmail: amine@test.com\n\nTEST\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1773270696, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1773443496, "instanceId": "e31404f3-d009-4490-b898-9fca301520ef", "source": "web"}}, "action-6-1772095880187": {"status": "error", "error": "name 'context' is not defined"}, "action-5-1772095876275": {"status": "success", "recipient": "212666666666", "message_type": "text", "evolution_response": {"key": {"remoteJid": "212666666666@s.whatsapp.net", "fromMe": true, "id": "3EB022BB9973BDE7099FA2"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "Bonjour \ud83d\udc4b\nMerci pour votre demande d\u2019agent IA r\u00e9ceptionniste \n\nNotre \u00e9quipe souhaite vous appeler tr\u00e8s prochainement pour en discuter.\nComme nous sommes en p\u00e9riode de Ramadan et que vos journ\u00e9es sont certainement charg\u00e9es, pourriez-vous nous indiquer le moment de la journ\u00e9e qui vous conviendrait le mieux pour \u00eatre appel\u00e9 ?\n\n\u00c0 tr\u00e8s vite inchaAllah \ud83d\ude80"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1773270696, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1773443496, "instanceId": "e31404f3-d009-4490-b898-9fca301520ef", "source": "web"}}}

TEXT

app.db — automation_runs

Update row 129 in automation_runs