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-15T15:28:51.454485", "level": "info", "message": "Starting automation execution. Context: {\"field_1781075194735\": \"Ggg\", \"field_1781075209963\": \"Hh\", \"field_1781075240170\": \"+212622222222\", \"field_1781075185808\": \"Blanchiment / esth\\u00e9tique\", \"field_1781076568798\": \"fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAo2NjI4NTY4Mzc5AAEe59RX2AnMf6-md4o_-B4bdgKe1Jk7nEampaKGz6ogGoUKlsU2s3Ety4AVNbc_aem_RWkNjaUmX9xy6_4Gz6Bsvw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Reels&utm_source=Meta-ads&utm_term=120246478449130599\", \"form_id\": 2, \"form_name\": \"Walid-Form\", \"submission_id\": 165, \"form_created_at\": \"2026-06-15T15:28:51.425624\", \"source\": \"landing-page\", \"chatbot_id\": 47, \"phone\": \"+212622222222\", \"Phone\": \"+212622222222\", \"name\": \"Blanchiment / esth\\u00e9tique\", \"motif\": \"Blanchiment / esth\\u00e9tique\", \"pr\\u00e9nom\": \"Ggg\", \"nom\": \"Hh\", \"t\\u00e9l\\u00e9phone\": \"+212622222222\", \"utm\": \"fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAo2NjI4NTY4Mzc5AAEe59RX2AnMf6-md4o_-B4bdgKe1Jk7nEampaKGz6ogGoUKlsU2s3Ety4AVNbc_aem_RWkNjaUmX9xy6_4Gz6Bsvw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Reels&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-15T15:28:51.454565", "level": "info", "message": "Standardized variables: ['full_name', 'phone_number']", "node_id": null}, {"timestamp": "2026-06-15T15:28:51.454607", "level": "info", "message": "Triggered by node trigger-1 [form_submission] (canvas label: 'Form Submitted')", "node_id": "trigger-1"}, {"timestamp": "2026-06-15T15:28:51.454733", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-06-15T15:28:51.454821", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-15T15:28:51.827729", "level": "error", "message": "Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212622222222@s.whatsapp.net\",\"exists\":false,\"number\":\"212622222222\"}]}}", "node_id": null}, {"timestamp": "2026-06-15T15:28:51.828191", "level": "error", "message": "Node action-1 failed (error): Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212622222222@s.whatsapp.net\",\"exists\":false,\"number\":\"212622222222\"}]}}", "node_id": "action-1"}, {"timestamp": "2026-06-15T15:28:51.828323", "level": "error", "message": "Automation stopped after a failed step (fail-fast)", "node_id": null}]

TEXT

context_snapshot

{"field_1781075194735": "Ggg", "field_1781075209963": "Hh", "field_1781075240170": "+212622222222", "field_1781075185808": "Blanchiment / esth\u00e9tique", "field_1781076568798": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAo2NjI4NTY4Mzc5AAEe59RX2AnMf6-md4o_-B4bdgKe1Jk7nEampaKGz6ogGoUKlsU2s3Ety4AVNbc_aem_RWkNjaUmX9xy6_4Gz6Bsvw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Reels&utm_source=Meta-ads&utm_term=120246478449130599", "form_id": 2, "form_name": "Walid-Form", "submission_id": 165, "form_created_at": "2026-06-15T15:28:51.425624", "source": "landing-page", "chatbot_id": 47, "phone": "+212622222222", "Phone": "+212622222222", "name": "Blanchiment / esth\u00e9tique", "motif": "Blanchiment / esth\u00e9tique", "pr\u00e9nom": "Ggg", "nom": "Hh", "t\u00e9l\u00e9phone": "+212622222222", "utm": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAo2NjI4NTY4Mzc5AAEe59RX2AnMf6-md4o_-B4bdgKe1Jk7nEampaKGz6ogGoUKlsU2s3Ety4AVNbc_aem_RWkNjaUmX9xy6_4Gz6Bsvw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Reels&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": "Ggg", "field_1781075209963": "Hh", "field_1781075240170": "+212622222222", "field_1781075185808": "Blanchiment / esth\u00e9tique", "field_1781076568798": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAo2NjI4NTY4Mzc5AAEe59RX2AnMf6-md4o_-B4bdgKe1Jk7nEampaKGz6ogGoUKlsU2s3Ety4AVNbc_aem_RWkNjaUmX9xy6_4Gz6Bsvw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Reels&utm_source=Meta-ads&utm_term=120246478449130599", "form_id": 2, "form_name": "Walid-Form", "submission_id": 165, "form_created_at": "2026-06-15T15:28:51.425624", "source": "landing-page", "chatbot_id": 47, "phone": "+212622222222", "Phone": "+212622222222", "name": "Blanchiment / esth\u00e9tique", "motif": "Blanchiment / esth\u00e9tique", "pr\u00e9nom": "Ggg", "nom": "Hh", "t\u00e9l\u00e9phone": "+212622222222", "utm": "fbclid=IwZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZAo2NjI4NTY4Mzc5AAEe59RX2AnMf6-md4o_-B4bdgKe1Jk7nEampaKGz6ogGoUKlsU2s3Ety4AVNbc_aem_RWkNjaUmX9xy6_4Gz6Bsvw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Facebook_Mobile_Reels&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": "Blanchiment / esth\u00e9tique", "phone_number": "+212622222222", "automation_id": 8, "action-1": {"status": "error", "error": "Failed to send WA message. Status: 400, Body: {\"status\":400,\"error\":\"Bad Request\",\"response\":{\"message\":[{\"jid\":\"212622222222@s.whatsapp.net\",\"exists\":false,\"number\":\"212622222222\"}]}}"}}

TEXT

app.db — automation_runs

Update row 171 in automation_runs