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-04-17T04:06:32.590644", "level": "info", "message": "Starting automation execution. Context: {\"triggered_at\": \"2026-04-17T04:06:32.542986\", \"trigger_type\": \"incoming_message\", \"chatbot_id\": 35, \"meta_channel\": \"whatsapp\", \"phone_number_id\": \"759143770623474\", \"user_id\": \"212713513339\", \"phone\": \"212713513339\", \"chat_id\": \"212713513339\", \"is_group\": false, \"message_id\": \"meta_759143770623474_wamid.HBgMMjEyNzEzNTEzMzM5FQIAEhgUMkE5RTRENzg1NUE1ODM4Nzk3OTAA\", \"message_type\": \"interactive\", \"message_text\": \"Fran\\u00e7ais\", \"text\": \"Fran\\u00e7ais\", \"body\": \"Fran\\u00e7ais\", \"quick_reply_payload\": \"fr\", \"selected\": \"fr\", \"force_run_automations\": false}", "node_id": null}, {"timestamp": "2026-04-17T04:06:32.590846", "level": "info", "message": "Standardized variables: ['phone_number']", "node_id": null}, {"timestamp": "2026-04-17T04:06:32.590935", "level": "info", "message": "Triggered by node trigger-1 [incoming_message] (canvas label: 'Incoming WhatsApp message')", "node_id": "trigger-1"}, {"timestamp": "2026-04-17T04:06:32.591027", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-04-17T04:06:32.591112", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp_meta", "node_id": null}, {"timestamp": "2026-04-17T04:06:33.198692", "level": "info", "message": "Sent Meta interactive buttons to 212713513339", "node_id": null}, {"timestamp": "2026-04-17T04:06:33.269504", "level": "info", "message": "Paused for WhatsApp reply; resumes at ['if_else-4-1776055262388'] on next inbound message", "node_id": "action-1"}, {"timestamp": "2026-04-17T04:06:33.269653", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"triggered_at": "2026-04-17T04:06:32.542986", "trigger_type": "incoming_message", "chatbot_id": 35, "meta_channel": "whatsapp", "phone_number_id": "759143770623474", "user_id": "212713513339", "phone": "212713513339", "chat_id": "212713513339", "is_group": false, "message_id": "meta_759143770623474_wamid.HBgMMjEyNzEzNTEzMzM5FQIAEhgUMkE5RTRENzg1NUE1ODM4Nzk3OTAA", "message_type": "interactive", "message_text": "Fran\u00e7ais", "text": "Fran\u00e7ais", "body": "Fran\u00e7ais", "quick_reply_payload": "fr", "selected": "fr", "force_run_automations": false, "trigger": {"triggered_at": "2026-04-17T04:06:32.542986", "trigger_type": "incoming_message", "chatbot_id": 35, "meta_channel": "whatsapp", "phone_number_id": "759143770623474", "user_id": "212713513339", "phone": "212713513339", "chat_id": "212713513339", "is_group": false, "message_id": "meta_759143770623474_wamid.HBgMMjEyNzEzNTEzMzM5FQIAEhgUMkE5RTRENzg1NUE1ODM4Nzk3OTAA", "message_type": "interactive", "message_text": "Fran\u00e7ais", "text": "Fran\u00e7ais", "body": "Fran\u00e7ais", "quick_reply_payload": "fr", "selected": "fr", "force_run_automations": false, "automation_id": 7}, "phone_number": "212713513339", "automation_id": 7, "action-1": {"status": "success", "recipient": "212713513339", "message_type": "buttons", "pause_for_customer_reply": true}}

TEXT

app.db — automation_runs

Update row 145 in automation_runs