SQLite Web: app.db

id

Primary key. INTEGER

name

TEXT NOT NULL

description

TEXT

chatbot_id

INTEGER NOT NULL

trigger_type

TEXT NOT NULL

is_active

INTEGER (default 1

flow_data

{"nodes": [{"id": "trigger-1", "type": "trigger", "position": {"x": 250, "y": 72}, "data": {"label": "Incoming WhatsApp message", "triggerType": "incoming_message"}, "width": 246, "height": 111, "selected": false, "dragging": false, "positionAbsolute": {"x": 250, "y": 72}}, {"id": "action-1", "type": "action", "position": {"x": 697.2578972941494, "y": 91.37152376602165}, "data": {"label": "Send WhatsApp", "actionType": "send_whatsapp_meta", "message": "Hi", "message_type": "buttons", "buttons_items": "[{\"type\":\"reply\",\"displayText\":\"\u0627\u0644\u062f\u0627\u0631\u062c\u0629 \u0627\u0644\u0645\u063a\u0631\u0628\u064a\u0629\",\"id\":\"ar\"},{\"type\":\"reply\",\"displayText\":\"Fran\u00e7ais\",\"id\":\"fr\"},{\"type\":\"reply\",\"displayText\":\"English\",\"id\":\"en\"}]", "buttons_title": " \u0645\u0631\u062d\u0628\u0627 \u0628\u064a\u0643 \u0641 \n ! \ud83c\udf82\u2728 D\u00e9lices du Maroc\n\nBienvenue chez D\u00e9lices du Maroc! \n\nWelcome to D\u00e9lices du Maroc!", "nodeName": "Language", "testResult": {"id": 406, "chatbot_id": 62, "channel": "whatsapp", "user_id": "33766648942", "instance_id": 109, "conversation_name": "~", "is_dev_mode": false, "bot_paused": false, "bot_paused_at": null, "started_at": "2026-03-31T07:40:53.123666", "last_message_at": "2026-04-13T04:25:12.873445", "message_count": 393, "unread_count": 3, "max_follow_ups": null, "profile_picture_url": null, "contact_name": "~", "is_online": false, "last_seen": null, "status": "open", "tags": ["automation_sourced"], "is_group": false, "trigger": {"id": 406, "chatbot_id": 62, "channel": "whatsapp", "user_id": "33766648942", "instance_id": 109, "conversation_name": "~", "is_dev_mode": false, "bot_paused": false, "bot_paused_at": null, "started_at": "2026-03-31T07:40:53.123666", "last_message_at": "2026-04-13T04:25:12.873445", "message_count": 393, "unread_count": 3, "max_follow_ups": null, "profile_picture_url": null, "contact_name": "~", "is_online": false, "last_seen": null, "status": "open", "tags": ["automation_sourced"], "is_group": false}}}, "width": 220, "height": 111, "selected": false, "dragging": false, "positionAbsolute": {"x": 697.2578972941494, "y": 91.37152376602165}}, {"id": "action-3-1776023913663", "type": "action", "position": {"x": 1213.0787854653393, "y": 351.7724708116747}, "data": {"label": "New Action", "actionType": "send_whatsapp_meta", "message_type": "buttons", "buttons_title": "\u0623\u0647\u0644\u0627 \u0648\u0633\u0647\u0644\u0627! \ud83d\ude0d \u0628\u0627\u0634 \u0646\u0642\u062f\u0631\u0648 \u0646\u0639\u0627\u0648\u0646\u0648\u0643 \u0627\u0644\u064a\u0648\u0645\u061f", "buttons_items": "[{\"type\":\"reply\",\"displayText\":\"\ud83c\udf82 Tarte \u0646\u0637\u0644\u0628\",\"id\":\"tarte\"},{\"type\":\"reply\",\"displayText\":\"\ud83d\udccb \u0646\u0634\u0648\u0641 \u0627\u0644\u0645\u0646\u062a\u062c\u0627\u062a\",\"id\":\"products\"},{\"type\":\"reply\",\"displayText\":\"\ud83d\udccd \u0641\u064a\u0646 \u062a\u0644\u0642\u0627\u0648\u0646\u0627\",\"id\":\"localisation\"}]", "buttons_description": "", "testResult": {"id": 406, "chatbot_id": 62, "channel": "whatsapp", "user_id": "33766648942", "instance_id": 109, "conversation_name": "~", "is_dev_mode": false, "bot_paused": false, "bot_paused_at": null, "started_at": "2026-03-31T07:40:53.123666", "last_message_at": "2026-04-13T04:25:12.873445", "message_count": 393, "unread_count": 3, "max_follow_ups": null, "profile_picture_url": null, "contact_name": "~", "is_online": false, "last_seen": null, "status": "open", "tags": ["automation_sourced"], "is_group": false, "trigger": {"id": 406, "chatbot_id": 62, "channel": "whatsapp", "user_id": "33766648942", "instance_id": 109, "conversation_name": "~", "is_dev_mode": false, "bot_paused": false, "bot_paused_at": null, "started_at": "2026-03-31T07:40:53.123666", "last_message_at": "2026-04-13T04:25:12.873445", "message_count": 393, "unread_count": 3, "max_follow_ups": null, "profile_picture_url": null, "contact_name": "~", "is_online": false, "last_seen": null, "status": "open", "tags": ["automation_sourced"], "is_group": false, "trigger": {"id": 406, "chatbot_id": 62, "channel": "whatsapp", "user_id": "33766648942", "instance_id": 109, "conversation_name": "~", "is_dev_mode": false, "bot_paused": false, "bot_paused_at": null, "started_at": "2026-03-31T07:40:53.123666", "last_message_at": "2026-04-13T04:25:12.873445", "message_count": 393, "unread_count": 3, "max_follow_ups": null, "profile_picture_url": null, "contact_name": "~", "is_online": false, "last_seen": null, "status": "open", "tags": ["automation_sourced"], "is_group": false}}}}, "width": 231, "height": 111, "selected": false, "dragging": false, "positionAbsolute": {"x": 1213.0787854653393, "y": 351.7724708116747}}, {"id": "if_else-4-1776055262388", "type": "if_else", "position": {"x": 628.2233379361883, "y": 314.025678027665}, "data": {"combinator": "OR", "conditions": [{"left": "{{trigger.quick_reply_payload}}", "operator": "equals", "right": "ar"}]}, "width": 372, "height": 153, "selected": false, "dragging": false, "positionAbsolute": {"x": 628.2233379361883, "y": 314.025678027665}}, {"id": "if_else-1776056683297", "type": "if_else", "position": {"x": 1113.0926129011668, "y": 702.2857075478976}, "data": {"combinator": "OR", "conditions": [{"left": "{{trigger.quick_reply_payload}}", "operator": "equals", "right": "tarte"}], "nodeName": "products or not "}, "width": 395, "height": 153, "selected": false, "positionAbsolute": {"x": 1113.0926129011668, "y": 702.2857075478976}, "dragging": false}, {"id": "action-7-1776056749938", "type": "action", "position": {"x": 1854.522559111499, "y": 701.6218411874626}, "data": {"label": "New Action", "actionType": "send_whatsapp_meta", "media_file_id": 250, "message": "", "message_type": "buttons", "buttons_title": "  : La Tarte \u0648\u0627\u0634 ", "buttons_items": "[{\"type\":\"reply\",\"displayText\":\"\u0639\u0631\u0633\",\"id\":\"btn_1\"},{\"type\":\"reply\",\"displayText\":\"\u0639\u064a\u062f \u0645\u064a\u0644\u0627\u062f\",\"id\":\"btn_2\"},{\"type\":\"reply\",\"displayText\":\"\u0645\u0646\u0627\u0633\u0628\u0629 \u062e\u0631\u0649\",\"id\":\"btn_3\"}]"}, "width": 231, "height": 111, "selected": false, "positionAbsolute": {"x": 1854.522559111499, "y": 701.6218411874626}, "dragging": false}, {"id": "action-7-1776057797746", "type": "action", "position": {"x": 1865.7936281885623, "y": 886.8916029240486}, "data": {"label": "New Action", "actionType": "send_whatsapp_media", "message_type": "buttons", "media_file_id": 4022}, "width": 220, "height": 111, "selected": false, "positionAbsolute": {"x": 1865.7936281885623, "y": 886.8916029240486}, "dragging": false}, {"id": "action-1776058013521", "type": "action", "position": {"x": 1963.7936281885623, "y": 1336.5733957661364}, "data": {"label": "New Action", "actionType": "send_whatsapp_media", "message_type": "buttons", "media_file_id": 4021}, "width": 220, "height": 111, "selected": false, "dragging": false, "positionAbsolute": {"x": 1963.7936281885623, "y": 1336.5733957661364}}, {"id": "action-10-1776058021311", "type": "action", "position": {"x": 1818.9291627270936, "y": 1130.2172398752557}, "data": {"label": "New Action", "actionType": "delay", "seconds": 3}, "width": 220, "height": 111, "selected": false, "dragging": false, "positionAbsolute": {"x": 1818.9291627270936, "y": 1130.2172398752557}}, {"id": "action-10-1776059863765", "type": "action", "position": {"x": 2137.9291627270936, "y": 1618.2172398752557}, "data": {"label": "New Action", "actionType": "send_whatsapp_meta", "template": "\u0647\u0627\u0647\u0648\u0645\u0627 \u0634\u064a \u0645\u0648\u062f\u064a\u0644\u0627\u062a \u0644\u064a \u0639\u0646\u062f\u0646\u0627 \ud83d\udc46\n\u0644\u0634\u062d\u0627\u0644 \u062f\u064a\u0627\u0644 \u0627\u0644\u0646\u0627\u0633 \u0628\u063a\u064a\u062a\u0648\u0647\u0627 \u061f", "message": "\u0647\u0627\u0647\u0648\u0645\u0627 \u0634\u064a \u0645\u0648\u062f\u064a\u0644\u0627\u062a \u0644\u064a \u0639\u0646\u062f\u0646\u0627 \ud83d\udc46\n\u0644\u0634\u062d\u0627\u0644 \u062f\u064a\u0627\u0644 \u0627\u0644\u0646\u0627\u0633 \u0628\u063a\u064a\u062a\u0648\u0647\u0627 \u061f", "message_type": "buttons", "buttons_title": "\u0647\u0627\u0647\u0648\u0645\u0627 \u0634\u064a \u0645\u0648\u062f\u064a\u0644\u0627\u062a \u0644\u064a \u0639\u0646\u062f\u0646\u0627 \ud83d\udc46\n\u0644\u0634\u062d\u0627\u0644 \u062f\u064a\u0627\u0644 \u0627\u0644\u0646\u0627\u0633 \u0628\u063a\u064a\u062a\u0648\u0647\u0627 \u061f", "buttons_items": "[{\"type\":\"reply\",\"displayText\":\"\ud83d\udc64 6-10 \u0623\u0634\u062e\u0627\u0635 (Small)\",\"id\":\"btn_1\"},{\"type\":\"reply\",\"displayText\":\"\ud83d\udc65 10-20 \u0634\u062e\u0635 (Medium)\",\"id\":\"btn_2\"},{\"type\":\"reply\",\"displayText\":\"\ud83d\udc65\ud83d\udc65 +20 \u0634\u062e\u0635 (Large)\",\"id\":\"btn_3\"}]"}, "width": 231, "height": 111, "selected": false, "positionAbsolute": {"x": 2137.9291627270936, "y": 1618.2172398752557}, "dragging": false}, {"id": "action-1776060129410", "type": "action", "position": {"x": 1712.9291627270936, "y": 1568.2172398752557}, "data": {"label": "New Action", "actionType": "delay", "seconds": 3}, "width": 220, "height": 111, "selected": false, "positionAbsolute": {"x": 1712.9291627270936, "y": 1568.2172398752557}, "dragging": false}, {"id": "action-13-1776061291476", "type": "action", "position": {"x": 2038.2808136309923, "y": 1785.4501229570951}, "data": {"label": "New Action", "actionType": "send_whatsapp_meta", "template": "", "message": " \u062f\u0627\u0628\u0627 \u063a\u0627\u062f\u064a \u0646\u062f\u0648\u0632\u0643 \u0639\u0646\u062f l'assistant\n\n \u0642\u0648\u0644\u064a\u0647 \u0628\u0627\u0644\u0636\u0628\u0637 \u0634\u0646\u0648 \u0628\u0627\u063a\u064a \u0648\u0647\u0648 \u063a\u0627\u062f\u064a \u064a\u062a\u0643\u0644\u0641 \u0628\u0643\u0648\u0644\u0634\u064a \ud83d\ude09"}, "width": 231, "height": 111, "selected": true, "dragging": false, "positionAbsolute": {"x": 2038.2808136309923, "y": 1785.4501229570951}}, {"id": "action-13-1776061877791", "type": "action", "position": {"x": 2191.2808136309923, "y": 2053.450122957095}, "data": {"label": "New Action", "actionType": "agent_handoff", "template": " une tarte \u0627\u0644\u0639\u0645\u064a\u0644 \u0628\u0627\u063a\u064a\n\u062f\u064a\u0627\u0644 \u0639\u064a\u062f \u0627\u0644\u0645\u064a\u0644\u0627\u062f \ud83c\udf82 \u0644\u0639\u062f\u062f \u0645\u0627 \u0628\u064a\u0646 6 \u062d\u062a\u0649 \u0644\u064010 \u062f\u064a\u0627\u0644 \u0627\u0644\u0646\u0627\u0633\u060c \u0648\u0643\u064a\u062a\u0648\u0627\u0635\u0644 \u0628\u0627\u0644\u062f\u0627\u0631\u062c\u0629 \u0627\u0644\u0645\u063a\u0631\u0628\u064a\u0629", "link_preview": false, "instructions": " une tarte \u0627\u0644\u0639\u0645\u064a\u0644 \u0628\u0627\u063a\u064a\n\u062f\u064a\u0627\u0644 \u0639\u064a\u062f \u0627\u0644\u0645\u064a\u0644\u0627\u062f \ud83c\udf82 \u0644\u0639\u062f\u062f \u0645\u0627 \u0628\u064a\u0646 6 \u062d\u062a\u0649 \u0644\u064010 \u062f\u064a\u0627\u0644 \u0627\u0644\u0646\u0627\u0633\u060c \u0648\u0643\u064a\u062a\u0648\u0627\u0635\u0644 \u0628\u0627\u0644\u062f\u0627\u0631\u062c\u0629 \u0627\u0644\u0645\u063a\u0631\u0628\u064a\u0629"}, "width": 220, "height": 111, "selected": false, "dragging": false}], "edges": [{"id": "e1-2", "source": "trigger-1", "target": "action-1", "type": "deletableSmoothstep"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-1", "sourceHandle": null, "target": "if_else-4-1776055262388", "targetHandle": null, "id": "reactflow__edge-action-1-if_else-4-1776055262388"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "if_else-4-1776055262388", "sourceHandle": "true", "target": "action-3-1776023913663", "targetHandle": null, "id": "reactflow__edge-if_else-4-1776055262388true-action-3-1776023913663"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-3-1776023913663", "sourceHandle": null, "target": "if_else-1776056683297", "targetHandle": null, "id": "reactflow__edge-action-3-1776023913663-if_else-1776056683297"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "if_else-1776056683297", "sourceHandle": "true", "target": "action-7-1776056749938", "targetHandle": null, "id": "reactflow__edge-if_else-1776056683297true-action-7-1776056749938"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-7-1776056749938", "sourceHandle": null, "target": "action-7-1776057797746", "targetHandle": null, "id": "reactflow__edge-action-7-1776056749938-action-7-1776057797746"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-7-1776057797746", "sourceHandle": null, "target": "action-10-1776058021311", "targetHandle": null, "id": "reactflow__edge-action-7-1776057797746-action-10-1776058021311"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-10-1776058021311", "sourceHandle": null, "target": "action-1776058013521", "targetHandle": null, "id": "reactflow__edge-action-10-1776058021311-action-1776058013521"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-1776058013521", "sourceHandle": null, "target": "action-1776060129410", "targetHandle": null, "id": "reactflow__edge-action-1776058013521-action-1776060129410"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-1776060129410", "sourceHandle": null, "target": "action-10-1776059863765", "targetHandle": null, "id": "reactflow__edge-action-1776060129410-action-10-1776059863765"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-10-1776059863765", "sourceHandle": null, "target": "action-13-1776061291476", "targetHandle": null, "id": "reactflow__edge-action-10-1776059863765-action-13-1776061291476"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-13-1776061291476", "sourceHandle": null, "target": "action-13-1776061877791", "targetHandle": null, "id": "reactflow__edge-action-13-1776061291476-action-13-1776061877791"}]}

TEXT NOT NULL

schedule

TEXT

created_at

TEXT NOT NULL

updated_at

TEXT

webhook_token

TEXT

app.db — automations

Update row 7 in automations