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-14T19:18:20.041155", "level": "info", "message": "Starting automation execution. Context: {\"field_1781075194735\": \"Ali\", \"field_1781075209963\": \"Amine idrissi\", \"field_1781075240170\": \"+212695907841\", \"field_1781075185808\": \"Premi\\u00e8re consultation / bilan\", \"field_1781076568798\": \"fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8yNzUyNTQ2OTI1OTgyNzkAAR5r9d5ZgAq9YWFxFphxE5IcrfnR8ebJ7AOVh-q4QgDPPvB8co9ZkDXEDOSJLw_aem_V2q7dk_4uVCYvtA-011K0Q&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Feed&utm_source=Meta-ads&utm_term=120246478449130599\", \"form_id\": 2, \"form_name\": \"Walid-Form\", \"submission_id\": 159, \"form_created_at\": \"2026-06-14T19:18:20.013700\", \"source\": \"landing-page\", \"chatbot_id\": 47, \"phone\": \"+212695907841\", \"Phone\": \"+212695907841\", \"name\": \"Premi\\u00e8re consultation / bilan\", \"motif\": \"Premi\\u00e8re consultation / bilan\", \"pr\\u00e9nom\": \"Ali\", \"nom\": \"Amine idrissi\", \"t\\u00e9l\\u00e9phone\": \"+212695907841\", \"utm\": \"fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8yNzUyNTQ2OTI1OTgyNzkAAR5r9d5ZgAq9YWFxFphxE5IcrfnR8ebJ7AOVh-q4QgDPPvB8co9ZkDXEDOSJLw_aem_V2q7dk_4uVCYvtA-011K0Q&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Feed&utm_source=Meta-ads&utm_term=120246478449130599\", \"_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-14T19:18:20.041312", "level": "info", "message": "Standardized variables: ['full_name', 'phone_number']", "node_id": null}, {"timestamp": "2026-06-14T19:18:20.041400", "level": "info", "message": "Triggered by node trigger-1 [form_submission] (canvas label: 'Form Submitted')", "node_id": "trigger-1"}, {"timestamp": "2026-06-14T19:18:20.041590", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-06-14T19:18:20.041680", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-14T19:18:22.719646", "level": "info", "message": "Successfully sent WA text message to 212695907841", "node_id": null}, {"timestamp": "2026-06-14T19:18:22.720037", "level": "info", "message": "Executing node action-3-1781455990284 (action)", "node_id": "action-3-1781455990284"}, {"timestamp": "2026-06-14T19:18:22.720171", "level": "info", "message": "DEBUG: Processing node action-3-1781455990284, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-14T19:18:23.847860", "level": "info", "message": "Successfully sent WA text message to 212629035220", "node_id": null}, {"timestamp": "2026-06-14T19:18:23.848295", "level": "info", "message": "End of path at node action-3-1781455990284", "node_id": "action-3-1781455990284"}, {"timestamp": "2026-06-14T19:18:23.848401", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1781075194735": "Ali", "field_1781075209963": "Amine idrissi", "field_1781075240170": "+212695907841", "field_1781075185808": "Premi\u00e8re consultation / bilan", "field_1781076568798": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8yNzUyNTQ2OTI1OTgyNzkAAR5r9d5ZgAq9YWFxFphxE5IcrfnR8ebJ7AOVh-q4QgDPPvB8co9ZkDXEDOSJLw_aem_V2q7dk_4uVCYvtA-011K0Q&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Feed&utm_source=Meta-ads&utm_term=120246478449130599", "form_id": 2, "form_name": "Walid-Form", "submission_id": 159, "form_created_at": "2026-06-14T19:18:20.013700", "source": "landing-page", "chatbot_id": 47, "phone": "+212695907841", "Phone": "+212695907841", "name": "Premi\u00e8re consultation / bilan", "motif": "Premi\u00e8re consultation / bilan", "pr\u00e9nom": "Ali", "nom": "Amine idrissi", "t\u00e9l\u00e9phone": "+212695907841", "utm": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8yNzUyNTQ2OTI1OTgyNzkAAR5r9d5ZgAq9YWFxFphxE5IcrfnR8ebJ7AOVh-q4QgDPPvB8co9ZkDXEDOSJLw_aem_V2q7dk_4uVCYvtA-011K0Q&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Feed&utm_source=Meta-ads&utm_term=120246478449130599", "_field_labels": {"field_1781075185808": "motif", "field_1781075194735": "Pr\u00e9nom", "field_1781075209963": "Nom", "field_1781075240170": "T\u00e9l\u00e9phone", "field_1781076568798": "utm"}, "trigger": {"field_1781075194735": "Ali", "field_1781075209963": "Amine idrissi", "field_1781075240170": "+212695907841", "field_1781075185808": "Premi\u00e8re consultation / bilan", "field_1781076568798": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8yNzUyNTQ2OTI1OTgyNzkAAR5r9d5ZgAq9YWFxFphxE5IcrfnR8ebJ7AOVh-q4QgDPPvB8co9ZkDXEDOSJLw_aem_V2q7dk_4uVCYvtA-011K0Q&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Feed&utm_source=Meta-ads&utm_term=120246478449130599", "form_id": 2, "form_name": "Walid-Form", "submission_id": 159, "form_created_at": "2026-06-14T19:18:20.013700", "source": "landing-page", "chatbot_id": 47, "phone": "+212695907841", "Phone": "+212695907841", "name": "Premi\u00e8re consultation / bilan", "motif": "Premi\u00e8re consultation / bilan", "pr\u00e9nom": "Ali", "nom": "Amine idrissi", "t\u00e9l\u00e9phone": "+212695907841", "utm": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8yNzUyNTQ2OTI1OTgyNzkAAR5r9d5ZgAq9YWFxFphxE5IcrfnR8ebJ7AOVh-q4QgDPPvB8co9ZkDXEDOSJLw_aem_V2q7dk_4uVCYvtA-011K0Q&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Feed&utm_source=Meta-ads&utm_term=120246478449130599", "_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": "Premi\u00e8re consultation / bilan", "phone_number": "+212695907841", "automation_id": 8, "action-1": {"status": "success", "recipient": "212695907841", "message_type": "text", "evolution_response": {"key": {"remoteJid": "212695907841@s.whatsapp.net", "fromMe": true, "id": "3EB00A05A7FAB88C9F2E04"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "Bonjour Ali \ud83d\udc4b\n\nOn a bien re\u00e7u votre demande pour **Premi\u00e8re consultation / bilan**.\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": 1781291900, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1781464701, "instanceId": "80df0d6d-b789-4338-9827-3aa32194d00d", "source": "web"}}, "action-3-1781455990284": {"status": "success", "recipient": "212629035220", "message_type": "text", "evolution_response": {"key": {"remoteJid": "212629035220@s.whatsapp.net", "fromMe": true, "id": "3EB05BEFC4D6764015EF89"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "Bonjour ! J\u2019ai rempli votre formulaire et j\u2019aimerais en savoir plus sur votre entreprise.\n\nquel_est_le_principal_motif_de_votre_visite_?:  Premi\u00e8re consultation / bilan\n\nNum\u00e9ro: +212695907841\n\nnom_complet: Ali"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1781291903, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1781464703, "instanceId": "80df0d6d-b789-4338-9827-3aa32194d00d", "source": "web"}}}

TEXT

app.db — automation_runs

Update row 165 in automation_runs