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-06-10T08:43:42.333451", "level": "info", "message": "Starting automation execution. Context: {\"field_1781075194735\": \"Mohamed Amine\", \"field_1781075209963\": \"Saada\", \"field_1781075240170\": \"+33766648942\", \"field_1781075185808\": \"Blanchiment / esth\\u00e9tique\", \"field_1781076568798\": \"utm_medium=local&utm_source=test\", \"form_id\": 2, \"form_name\": \"Walid-Form\", \"submission_id\": 139, \"form_created_at\": \"2026-06-10T08:43:42.301612\", \"source\": \"landing-page\", \"chatbot_id\": 47, \"phone\": \"+33766648942\", \"Phone\": \"+33766648942\", \"name\": \"Blanchiment / esth\\u00e9tique\", \"motif\": \"Blanchiment / esth\\u00e9tique\", \"pr\\u00e9nom\": \"Mohamed Amine\", \"nom\": \"Saada\", \"t\\u00e9l\\u00e9phone\": \"+33766648942\", \"utm\": \"utm_medium=local&utm_source=test\", \"_field_labels\": {\"field_1781075185808\": \"motif\", \"field_1781075194735\": \"Pr\\u00e9nom\", \"field_1781075209963\": \"Nom\", \"field_1781075240170\": \"T\\u00e9l\\u00e9phone\", \"field_1781076568798\": \"utm\"}}", "node_id": null}, {"timestamp": "2026-06-10T08:43:42.333642", "level": "info", "message": "Standardized variables: ['full_name', 'phone_number']", "node_id": null}, {"timestamp": "2026-06-10T08:43:42.333752", "level": "info", "message": "Triggered by node trigger-1 [form_submission] (canvas label: 'Form Submitted')", "node_id": "trigger-1"}, {"timestamp": "2026-06-10T08:43:42.333876", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-06-10T08:43:42.333969", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-10T08:43:45.713076", "level": "info", "message": "Successfully sent WA text message to 33766648942", "node_id": null}, {"timestamp": "2026-06-10T08:43:45.713513", "level": "info", "message": "End of path at node action-1", "node_id": "action-1"}, {"timestamp": "2026-06-10T08:43:45.713639", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1781075194735": "Mohamed Amine", "field_1781075209963": "Saada", "field_1781075240170": "+33766648942", "field_1781075185808": "Blanchiment / esth\u00e9tique", "field_1781076568798": "utm_medium=local&utm_source=test", "form_id": 2, "form_name": "Walid-Form", "submission_id": 139, "form_created_at": "2026-06-10T08:43:42.301612", "source": "landing-page", "chatbot_id": 47, "phone": "+33766648942", "Phone": "+33766648942", "name": "Blanchiment / esth\u00e9tique", "motif": "Blanchiment / esth\u00e9tique", "pr\u00e9nom": "Mohamed Amine", "nom": "Saada", "t\u00e9l\u00e9phone": "+33766648942", "utm": "utm_medium=local&utm_source=test", "_field_labels": {"field_1781075185808": "motif", "field_1781075194735": "Pr\u00e9nom", "field_1781075209963": "Nom", "field_1781075240170": "T\u00e9l\u00e9phone", "field_1781076568798": "utm"}, "trigger": {"field_1781075194735": "Mohamed Amine", "field_1781075209963": "Saada", "field_1781075240170": "+33766648942", "field_1781075185808": "Blanchiment / esth\u00e9tique", "field_1781076568798": "utm_medium=local&utm_source=test", "form_id": 2, "form_name": "Walid-Form", "submission_id": 139, "form_created_at": "2026-06-10T08:43:42.301612", "source": "landing-page", "chatbot_id": 47, "phone": "+33766648942", "Phone": "+33766648942", "name": "Blanchiment / esth\u00e9tique", "motif": "Blanchiment / esth\u00e9tique", "pr\u00e9nom": "Mohamed Amine", "nom": "Saada", "t\u00e9l\u00e9phone": "+33766648942", "utm": "utm_medium=local&utm_source=test", "_field_labels": {"field_1781075185808": "motif", "field_1781075194735": "Pr\u00e9nom", "field_1781075209963": "Nom", "field_1781075240170": "T\u00e9l\u00e9phone", "field_1781076568798": "utm"}, "automation_id": 8}, "full_name": "Blanchiment / esth\u00e9tique", "phone_number": "+33766648942", "automation_id": 8, "action-1": {"status": "success", "recipient": "33766648942", "message_type": "text", "evolution_response": {"key": {"remoteJid": "33766648942@s.whatsapp.net", "fromMe": true, "id": "3EB05072B04E098665C7DB"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "Bonjour Mohamed Amine \ud83d\udc4b\n\nOn a bien re\u00e7u votre demande pour **Blanchiment / esth\u00e9tique**.\n\nBonne nouvelle : votre premi\u00e8re consultation au Centre Dentaire Halim est enti\u00e8rement gratuite \ud83c\udf89\n\nDites-nous vos disponibilit\u00e9s (jour et cr\u00e9neau) et le Dr Walid vous confirmera un rendez-vous.\n\n\ud83d\udccd Immeuble 89, 1er \u00e9tage, Avenue Abou Bakr El Kadiri, Casablanca\n\ud83d\uddfa\ufe0f https://maps.app.goo.gl/S1mK6eAmV7iRy69S9\n\nNous recevons du lundi au jeudi et le samedi, de 9h \u00e0 18h.\n\n\u00c0 tr\u00e8s vite \ud83d\ude0a"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1780908222, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1781081023, "instanceId": "80df0d6d-b789-4338-9827-3aa32194d00d", "source": "web"}}}

TEXT

app.db — automation_runs

Update row 159 in automation_runs