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-14T22:07:43.656280", "level": "info", "message": "Starting automation execution. Context: {\"field_1781075194735\": \"Othmane\", \"field_1781075209963\": \"elcaidi\", \"field_1781075240170\": \"+212600603132\", \"field_1781075185808\": \"Douleur ou urgence\", \"field_1781076568798\": \"fbclid=PAZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8xMjQwMjQ1NzQyODc0MTQAAacQCEiLQZ63Yq2XQ211seTNBxpp71ENdB27JHK6nTQShaTVZZPlBoHOXnka8Q_aem_gw_XbXcfc43Ge7HSuBT9gw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Instagram_Stories&utm_source=Meta-ads&utm_term=120246478449130599\", \"form_id\": 2, \"form_name\": \"Walid-Form\", \"submission_id\": 160, \"form_created_at\": \"2026-06-14T22:07:43.627273\", \"source\": \"landing-page\", \"chatbot_id\": 47, \"phone\": \"+212600603132\", \"Phone\": \"+212600603132\", \"name\": \"Douleur ou urgence\", \"motif\": \"Douleur ou urgence\", \"pr\\u00e9nom\": \"Othmane\", \"nom\": \"elcaidi\", \"t\\u00e9l\\u00e9phone\": \"+212600603132\", \"utm\": \"fbclid=PAZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8xMjQwMjQ1NzQyODc0MTQAAacQCEiLQZ63Yq2XQ211seTNBxpp71ENdB27JHK6nTQShaTVZZPlBoHOXnka8Q_aem_gw_XbXcfc43Ge7HSuBT9gw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Instagram_Stories&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-14T22:07:43.656494", "level": "info", "message": "Standardized variables: ['full_name', 'phone_number']", "node_id": null}, {"timestamp": "2026-06-14T22:07:43.656587", "level": "info", "message": "Triggered by node trigger-1 [form_submission] (canvas label: 'Form Submitted')", "node_id": "trigger-1"}, {"timestamp": "2026-06-14T22:07:43.656663", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-06-14T22:07:43.656736", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-14T22:07:46.385297", "level": "info", "message": "Successfully sent WA text message to 212600603132", "node_id": null}, {"timestamp": "2026-06-14T22:07:46.385674", "level": "info", "message": "Executing node action-3-1781455990284 (action)", "node_id": "action-3-1781455990284"}, {"timestamp": "2026-06-14T22:07:46.386042", "level": "info", "message": "DEBUG: Processing node action-3-1781455990284, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-14T22:07:47.390650", "level": "info", "message": "Successfully sent WA text message to 212629035220", "node_id": null}, {"timestamp": "2026-06-14T22:07:47.391159", "level": "info", "message": "End of path at node action-3-1781455990284", "node_id": "action-3-1781455990284"}, {"timestamp": "2026-06-14T22:07:47.391524", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1781075194735": "Othmane", "field_1781075209963": "elcaidi", "field_1781075240170": "+212600603132", "field_1781075185808": "Douleur ou urgence", "field_1781076568798": "fbclid=PAZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8xMjQwMjQ1NzQyODc0MTQAAacQCEiLQZ63Yq2XQ211seTNBxpp71ENdB27JHK6nTQShaTVZZPlBoHOXnka8Q_aem_gw_XbXcfc43Ge7HSuBT9gw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Instagram_Stories&utm_source=Meta-ads&utm_term=120246478449130599", "form_id": 2, "form_name": "Walid-Form", "submission_id": 160, "form_created_at": "2026-06-14T22:07:43.627273", "source": "landing-page", "chatbot_id": 47, "phone": "+212600603132", "Phone": "+212600603132", "name": "Douleur ou urgence", "motif": "Douleur ou urgence", "pr\u00e9nom": "Othmane", "nom": "elcaidi", "t\u00e9l\u00e9phone": "+212600603132", "utm": "fbclid=PAZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8xMjQwMjQ1NzQyODc0MTQAAacQCEiLQZ63Yq2XQ211seTNBxpp71ENdB27JHK6nTQShaTVZZPlBoHOXnka8Q_aem_gw_XbXcfc43Ge7HSuBT9gw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Instagram_Stories&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": "Othmane", "field_1781075209963": "elcaidi", "field_1781075240170": "+212600603132", "field_1781075185808": "Douleur ou urgence", "field_1781076568798": "fbclid=PAZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8xMjQwMjQ1NzQyODc0MTQAAacQCEiLQZ63Yq2XQ211seTNBxpp71ENdB27JHK6nTQShaTVZZPlBoHOXnka8Q_aem_gw_XbXcfc43Ge7HSuBT9gw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Instagram_Stories&utm_source=Meta-ads&utm_term=120246478449130599", "form_id": 2, "form_name": "Walid-Form", "submission_id": 160, "form_created_at": "2026-06-14T22:07:43.627273", "source": "landing-page", "chatbot_id": 47, "phone": "+212600603132", "Phone": "+212600603132", "name": "Douleur ou urgence", "motif": "Douleur ou urgence", "pr\u00e9nom": "Othmane", "nom": "elcaidi", "t\u00e9l\u00e9phone": "+212600603132", "utm": "fbclid=PAZXh0bgNhZW0BMABhZGlkAasziU68eBdzcnRjBmFwcF9pZA8xMjQwMjQ1NzQyODc0MTQAAacQCEiLQZ63Yq2XQ211seTNBxpp71ENdB27JHK6nTQShaTVZZPlBoHOXnka8Q_aem_gw_XbXcfc43Ge7HSuBT9gw&utm_campaign=Compagne Dentaire 14/06&utm_content=image-avant-apres&utm_id=120246478449110599&utm_medium=Instagram_Stories&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": "+212600603132", "automation_id": 8, "action-1": {"status": "success", "recipient": "212600603132", "message_type": "text", "evolution_response": {"key": {"remoteJid": "212600603132@s.whatsapp.net", "fromMe": true, "id": "3EB03CD45249FEEA1ECBAD"}, "pushName": "Voc\u00ea", "status": "PENDING", "message": {"conversation": "Bonjour Othmane \ud83d\udc4b\n\nOn a bien re\u00e7u votre demande pour **Douleur ou urgence**.\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": 1781302063, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1781474865, "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": "3EB0162F3EEDFE2879F21B"}, "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_?:  Douleur ou urgence\n\nNum\u00e9ro: +212600603132\n\nnom_complet: Othmane"}, "contextInfo": {"mentionedJid": [], "groupMentions": [], "ephemeralSettingTimestamp": {"low": 1781302066, "high": 0, "unsigned": false}, "disappearingMode": {"initiator": 0}}, "messageType": "conversation", "messageTimestamp": 1781474866, "instanceId": "80df0d6d-b789-4338-9827-3aa32194d00d", "source": "web"}}}

TEXT

app.db — automation_runs

Update row 166 in automation_runs