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-08T17:10:25.778571", "level": "info", "message": "Starting automation execution. Context: {\"field_1771059625885\": \"Haitham boutaib\", \"field_1771059732881\": \"+212680203451\", \"field_1771059775104\": \"0-50\", \"field_1771059785751\": \"\", \"field_1771059794160\": \"\", \"field_1771059803951\": \"Nom du cabinet: Tangerbay\\nEmail: haithambt340@gmail.com\\n\\nMedecin dentiste\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\\n[TRACKING]\\nutm_source: facebook\\nutm_medium: Dynamic Creatives \\u2013 Interests\\nutm_campaign: New Leads campaign\\nutm_content: all-creatives-interests-demog\\nutm_term: Instagram_Reels\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 124, \"form_created_at\": \"2026-03-08T17:10:25.746731\", \"source\": \"doctors-agent-landing-page\", \"chatbot_id\": 38, \"name\": \"Haitham boutaib\", \"body\": \"Nom du cabinet: Tangerbay\\nEmail: haithambt340@gmail.com\\n\\nMedecin dentiste\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\\n[TRACKING]\\nutm_source: facebook\\nutm_medium: Dynamic Creatives \\u2013 Interests\\nutm_campaign: New Leads campaign\\nutm_content: all-creatives-interests-demog\\nutm_term: Instagram_Reels\", \"customer_name\": \"Haitham boutaib\", \"customer_phone\": \"+212680203451\", \"message_volume\": \"0-50\", \"preferred_date\": \"\", \"preferred_time_slot\": \"\", \"additional_notes\": \"Nom du cabinet: Tangerbay\\nEmail: haithambt340@gmail.com\\n\\nMedecin dentiste\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\\n[TRACKING]\\nutm_source: facebook\\nutm_medium: Dynamic Creatives \\u2013 Interests\\nutm_campaign: New Leads campaign\\nutm_content: all-creatives-interests-demog\\nutm_term: Instagram_Reels\", \"_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-08T17:10:25.778799", "level": "info", "message": "Standardized variables: ['full_name']", "node_id": null}, {"timestamp": "2026-03-08T17:10:25.778886", "level": "info", "message": "Triggered by node trigger-1 (Form Submitted)", "node_id": "trigger-1"}, {"timestamp": "2026-03-08T17:10:25.779182", "level": "info", "message": "Executing node if_else-3-1772095076195 (if_else)", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-03-08T17:10:25.779306", "level": "info", "message": "DEBUG: Processing node if_else-3-1772095076195, type=if_else, action=None", "node_id": null}, {"timestamp": "2026-03-08T17:10:25.779822", "level": "info", "message": "If/Else: AND conditions [False] \u2192 branch='false'", "node_id": null}, {"timestamp": "2026-03-08T17:10:25.779958", "level": "info", "message": "Executing node action-4-1772095275643 (action)", "node_id": "action-4-1772095275643"}, {"timestamp": "2026-03-08T17:10:25.780076", "level": "info", "message": "DEBUG: Processing node action-4-1772095275643, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-08T17:10:27.151445", "level": "info", "message": "Successfully sent WA text message to 33766648942", "node_id": null}, {"timestamp": "2026-03-08T17:10:27.151667", "level": "info", "message": "Skipping edge to action-6-1772153862357 (handle='true' != branch='false')", "node_id": "if_else-3-1772095076195"}, {"timestamp": "2026-03-08T17:10:27.151725", "level": "info", "message": "Executing node action-6-1772095880187 (action)", "node_id": "action-6-1772095880187"}, {"timestamp": "2026-03-08T17:10:27.151755", "level": "info", "message": "DEBUG: Processing node action-6-1772095880187, type=action, action=delay", "node_id": null}, {"timestamp": "2026-03-08T17:10:27.152888", "level": "info", "message": "Executing node action-5-1772095876275 (action)", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-03-08T17:10:27.152940", "level": "info", "message": "DEBUG: Processing node action-5-1772095876275, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-03-08T17:10:29.111362", "level": "info", "message": "Successfully sent WA text message to 212680203451", "node_id": null}, {"timestamp": "2026-03-08T17:10:29.111901", "level": "info", "message": "End of path at node action-5-1772095876275", "node_id": "action-5-1772095876275"}, {"timestamp": "2026-03-08T17:10:29.112104", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1771059625885": "Haitham boutaib", "field_1771059732881": "+212680203451", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels", "form_id": 1, "form_name": "Product Form", "submission_id": 124, "form_created_at": "2026-03-08T17:10:25.746731", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "Haitham boutaib", "body": "Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels", "customer_name": "Haitham boutaib", "customer_phone": "+212680203451", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels", "_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": "Haitham boutaib", "field_1771059732881": "+212680203451", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels", "form_id": 1, "form_name": "Product Form", "submission_id": 124, "form_created_at": "2026-03-08T17:10:25.746731", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "Haitham boutaib", "body": "Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels", "customer_name": "Haitham boutaib", "customer_phone": "+212680203451", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels", "_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": "Haitham boutaib", "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": "3EB03A9AEB8BE817AEFD08"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "\ud83d\udce9 Nouveau Lead\n\ud83d\udc64 Nom :  Haitham boutaib\n\ud83d\udcde T\u00e9l\u00e9phone :+212680203451\n\ud83c\udff7\ufe0fNombre de message par jour : 0-50\n\ud83d\udcd2Notes : Nom du cabinet: Tangerbay\nEmail: haithambt340@gmail.com\n\nMedecin dentiste\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nutm_source: facebook\nutm_medium: Dynamic Creatives \u2013 Interests\nutm_campaign: New Leads campaign\nutm_content: all-creatives-interests-demog\nutm_term: Instagram_Reels"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1772817026, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1772989826, "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": "212680203451", "message_type": "text", "evolution_response": {"key": {"remoteJid": "212680203451@s.whatsapp.net", "fromMe": true, "id": "3EB0FF53F1E4161CBDDD0A"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "Bonjour \ud83d\udc4b\nMerci pour votre demande d\u2019agent IA r\u00e9ceptionniste \ud83e\udd16\nNotre \u00e9quipe va vous appeler tr\u00e8s prochainement inchaAllah pour en discuter.\n\n\u00c0 tr\u00e8s vite ! \ud83d\ude80"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1772817027, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1772989827, "instanceId": "e31404f3-d009-4490-b898-9fca301520ef", "source": "web"}}}

TEXT

app.db — automation_runs

Update row 127 in automation_runs