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-16T12:42:25.494370", "level": "info", "message": "Starting automation execution. Context: {\"field_1781075194735\": \"Halim\", \"field_1781075209963\": \"Ziad\", \"field_1781075240170\": \"+212660675744\", \"field_1781075185808\": \"Douleur ou urgence\", \"field_1781076568798\": \"fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR7Vnlh-Aw9KNj7THVZNpAMsUzOVDtPHBlJ5SrfCjbGORpRpl0jLVZjuROdg2w_aem_Emg6-j1iW1KAOS-7Cy3XKA&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\": 172, \"form_created_at\": \"2026-06-16T12:42:25.438869\", \"source\": \"landing-page\", \"chatbot_id\": 47, \"phone\": \"+212660675744\", \"Phone\": \"+212660675744\", \"name\": \"Douleur ou urgence\", \"motif\": \"Douleur ou urgence\", \"pr\\u00e9nom\": \"Halim\", \"nom\": \"Ziad\", \"t\\u00e9l\\u00e9phone\": \"+212660675744\", \"utm\": \"fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR7Vnlh-Aw9KNj7THVZNpAMsUzOVDtPHBlJ5SrfCjbGORpRpl0jLVZjuROdg2w_aem_Emg6-j1iW1KAOS-7Cy3XKA&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-16T12:42:25.494482", "level": "info", "message": "Standardized variables: ['full_name', 'phone_number']", "node_id": null}, {"timestamp": "2026-06-16T12:42:25.494548", "level": "info", "message": "Triggered by node trigger-1 [form_submission] (canvas label: 'Form Submitted')", "node_id": "trigger-1"}, {"timestamp": "2026-06-16T12:42:25.494606", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-06-16T12:42:25.494661", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-16T12:42:25.771698", "level": "error", "message": "Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212660675744@s.whatsapp.net\",\"exists\":false,\"number\":\"212660675744\"}]}}", "node_id": null}, {"timestamp": "2026-06-16T12:42:25.771979", "level": "error", "message": "Node action-1 failed (error): Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212660675744@s.whatsapp.net\",\"exists\":false,\"number\":\"212660675744\"}]}}", "node_id": "action-1"}, {"timestamp": "2026-06-16T12:42:25.772096", "level": "error", "message": "Automation stopped after a failed step (fail-fast)", "node_id": null}]

TEXT

context_snapshot

{"field_1781075194735": "Halim", "field_1781075209963": "Ziad", "field_1781075240170": "+212660675744", "field_1781075185808": "Douleur ou urgence", "field_1781076568798": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR7Vnlh-Aw9KNj7THVZNpAMsUzOVDtPHBlJ5SrfCjbGORpRpl0jLVZjuROdg2w_aem_Emg6-j1iW1KAOS-7Cy3XKA&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": 172, "form_created_at": "2026-06-16T12:42:25.438869", "source": "landing-page", "chatbot_id": 47, "phone": "+212660675744", "Phone": "+212660675744", "name": "Douleur ou urgence", "motif": "Douleur ou urgence", "pr\u00e9nom": "Halim", "nom": "Ziad", "t\u00e9l\u00e9phone": "+212660675744", "utm": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR7Vnlh-Aw9KNj7THVZNpAMsUzOVDtPHBlJ5SrfCjbGORpRpl0jLVZjuROdg2w_aem_Emg6-j1iW1KAOS-7Cy3XKA&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": "Halim", "field_1781075209963": "Ziad", "field_1781075240170": "+212660675744", "field_1781075185808": "Douleur ou urgence", "field_1781076568798": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR7Vnlh-Aw9KNj7THVZNpAMsUzOVDtPHBlJ5SrfCjbGORpRpl0jLVZjuROdg2w_aem_Emg6-j1iW1KAOS-7Cy3XKA&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": 172, "form_created_at": "2026-06-16T12:42:25.438869", "source": "landing-page", "chatbot_id": 47, "phone": "+212660675744", "Phone": "+212660675744", "name": "Douleur ou urgence", "motif": "Douleur ou urgence", "pr\u00e9nom": "Halim", "nom": "Ziad", "t\u00e9l\u00e9phone": "+212660675744", "utm": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR7Vnlh-Aw9KNj7THVZNpAMsUzOVDtPHBlJ5SrfCjbGORpRpl0jLVZjuROdg2w_aem_Emg6-j1iW1KAOS-7Cy3XKA&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": "Douleur ou urgence", "phone_number": "+212660675744", "automation_id": 8, "action-1": {"status": "error", "error": "Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212660675744@s.whatsapp.net\",\"exists\":false,\"number\":\"212660675744\"}]}}"}}

TEXT

app.db — automation_runs

Update row 178 in automation_runs