-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost:3306 -- Tiempo de generación: 02-12-2025 a las 15:32:27 -- Versión del servidor: 8.0.43-cll-lve -- Versión de PHP: 8.4.14 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Base de datos: `artechso_apitestwsp` -- CREATE DATABASE IF NOT EXISTS `artechso_apitestwsp` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; USE `artechso_apitestwsp`; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `billing_events` -- CREATE TABLE `billing_events` ( `id` bigint NOT NULL, `message_id` bigint NOT NULL, `billable` tinyint(1) NOT NULL DEFAULT '0', `category` enum('marketing','utility','authentication','service') NOT NULL, `unit_price` decimal(10,5) DEFAULT NULL, `currency` char(3) DEFAULT NULL, `market` varchar(64) DEFAULT NULL, `ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `billing_events` -- INSERT INTO `billing_events` (`id`, `message_id`, `billable`, `category`, `unit_price`, `currency`, `market`, `ts`) VALUES (1, 2, 1, 'marketing', NULL, NULL, NULL, '2025-09-18 02:03:53'), (3, 3, 1, 'marketing', NULL, NULL, NULL, '2025-09-18 02:21:18'), (5, 6, 1, 'marketing', NULL, NULL, NULL, '2025-10-28 15:00:00'), (8, 8, 1, 'marketing', NULL, NULL, NULL, '2025-10-28 15:12:39'), (10, 9, 1, 'marketing', NULL, NULL, NULL, '2025-10-28 15:19:11'), (13, 10, 1, 'utility', NULL, NULL, NULL, '2025-10-30 22:31:54'), (17, 11, 1, 'utility', NULL, NULL, NULL, '2025-10-31 03:35:03'), (21, 12, 1, 'utility', NULL, NULL, NULL, '2025-11-02 15:05:19'), (25, 13, 1, 'utility', NULL, NULL, NULL, '2025-11-18 20:20:07'), (29, 14, 1, 'utility', NULL, NULL, NULL, '2025-11-18 22:13:45'), (32, 15, 1, 'utility', NULL, NULL, NULL, '2025-11-18 22:13:50'), (35, 16, 1, 'utility', NULL, NULL, NULL, '2025-11-18 22:13:54'), (38, 17, 1, 'utility', NULL, NULL, NULL, '2025-11-18 23:16:14'), (43, 18, 1, 'utility', NULL, NULL, NULL, '2025-11-19 13:35:39'), (45, 19, 1, 'utility', NULL, NULL, NULL, '2025-11-21 19:03:47'), (48, 20, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 02:50:05'), (53, 21, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 02:50:51'), (56, 22, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:07:39'), (60, 23, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:07:41'), (62, 24, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:07:44'), (66, 25, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:38'), (68, 26, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:44'), (69, 27, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:46'), (72, 28, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:49'), (74, 29, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:51'), (75, 30, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:53'), (78, 31, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:15:58'), (80, 32, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:16:00'), (82, 33, 1, 'marketing', NULL, NULL, NULL, '2025-11-24 03:16:02'), (92, 34, 1, 'utility', NULL, NULL, NULL, '2025-11-24 17:18:37'), (95, 35, 1, 'utility', NULL, NULL, NULL, '2025-11-25 14:37:38'), (99, 36, 1, 'marketing', NULL, NULL, NULL, '2025-11-25 14:38:57'), (103, 37, 1, 'utility', NULL, NULL, NULL, '2025-11-25 14:43:53'), (107, 38, 1, 'utility', NULL, NULL, NULL, '2025-11-26 16:17:16'), (111, 39, 1, 'utility', NULL, NULL, NULL, '2025-11-26 17:10:20'), (115, 40, 1, 'utility', NULL, NULL, NULL, '2025-11-29 02:52:52'), (120, 41, 1, 'marketing', NULL, NULL, NULL, '2025-11-29 02:53:26'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `crm_sessions` -- CREATE TABLE `crm_sessions` ( `id` varchar(128) NOT NULL, `user_id` int NOT NULL, `ip_address` varchar(45) NOT NULL, `user_agent` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `expires_at` timestamp NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `crm_users` -- CREATE TABLE `crm_users` ( `id` int NOT NULL, `username` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `password_hash` varchar(255) NOT NULL, `full_name` varchar(100) NOT NULL, `role` enum('admin','agent','viewer') DEFAULT 'agent', `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `crm_users` -- INSERT INTO `crm_users` (`id`, `username`, `email`, `password_hash`, `full_name`, `role`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'admin', 'admin@demo.local', '$2y$12$pRMMT8RbTMP3hzpCiAxMNuc.MymjAEJkaapJhMthqUcunkpRxZqIy', 'Administrador CRM', 'admin', 1, '2025-10-28 20:22:31', '2025-10-28 20:34:15'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `messages` -- CREATE TABLE `messages` ( `id` bigint NOT NULL, `to_e164` varchar(20) NOT NULL, `template_name` varchar(160) NOT NULL, `category` enum('marketing','utility','authentication','service') NOT NULL, `phone_number_id` varchar(32) NOT NULL, `wa_message_id` varchar(80) DEFAULT NULL, `sent_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `messages` -- INSERT INTO `messages` (`id`, `to_e164`, `template_name`, `category`, `phone_number_id`, `wa_message_id`, `sent_at`, `created_at`) VALUES (1, '593998205053', 'mensaje_prueba', 'marketing', '817854531405693', NULL, NULL, '2025-09-18 02:01:32'), (2, '593998205053', 'mensaje_prueba', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEQ2NDYwMThEODUzM0VEMEVDAA==', '2025-09-18 02:03:51', '2025-09-18 02:03:50'), (3, '593986664229', 'mensaje_prueba', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSMUNEQTI4RTExNDYyQjhDMEFGAA==', '2025-09-18 02:21:16', '2025-09-18 02:21:15'), (4, '593998205053', 'mensaje_prueba', 'marketing', '817854531405693', NULL, NULL, '2025-09-24 02:53:18'), (5, '593998205053', 'mensaje_prueba', 'marketing', '817854531405693', NULL, NULL, '2025-10-28 14:55:19'), (6, '593998205053', 'mensaje_prueba', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNUFCRDY1OUU3MzlFMzg2RkVCAA==', '2025-10-28 14:59:57', '2025-10-28 14:59:55'), (7, '593998205053', 'mensaje_prueba', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNzMwOUJGMzU3OEQxQzRDMjFDAA==', '2025-10-28 15:10:32', '2025-10-28 15:10:30'), (8, '593962996838', 'mensaje_prueba', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSRUYyRTFEMTQ4MDQwRUExOTM5AA==', '2025-10-28 15:12:35', '2025-10-28 15:12:34'), (9, '593959224414', 'mensaje_prueba', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSMTY4MTRENjlDMUFEQTREN0RCAA==', '2025-10-28 15:19:10', '2025-10-28 15:19:09'), (10, '593998205053', 'mensaje_prueba', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRjcyQ0JERjc2NTM3NjQwRDcxAA==', '2025-10-30 22:31:53', '2025-10-30 22:31:53'), (11, '593998205053', 'mensaje_prueba', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQTIwMjRFOURBNjY0NTBCNjRCAA==', '2025-10-31 03:35:01', '2025-10-31 03:35:01'), (12, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRkYxRkQzOTk1ODI1NDgxNTYxAA==', '2025-11-02 15:05:11', '2025-11-02 15:05:11'), (13, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNjJDRDY4MDJGRDlBMDdBNEY0AA==', '2025-11-18 20:19:57', '2025-11-18 20:19:57'), (14, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUE1MTU1MkIzODk5Njc3OEU3AA==', '2025-11-18 22:13:36', '2025-11-18 22:13:36'), (15, '593968961298', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTY4OTYxMjk4FQIAERgSRDhCMjUxNDhBMzgwRDNCQkE1AA==', '2025-11-18 22:13:39', '2025-11-18 22:13:39'), (16, '593959224414', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTRDMDEzQUYzRjdCQUJCREEzAA==', '2025-11-18 22:13:42', '2025-11-18 22:13:42'), (17, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkI2MUQ3RENEQjY4NDAyOTc4AA==', '2025-11-18 23:16:06', '2025-11-18 23:16:06'), (18, '593987917678', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTg3OTE3Njc4FQIAERgSMERGNDgyNjUyMkRDMTRERjE1AA==', '2025-11-19 13:35:30', '2025-11-19 13:35:30'), (19, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTQ1QjFFQ0Q1MUE3QzdCNTIxAA==', '2025-11-21 19:03:37', '2025-11-21 19:03:37'), (20, '593998205053', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMDJDMzI1N0RFMDNCRUNCN0EzAA==', '2025-11-24 02:50:04', '2025-11-24 02:50:04'), (21, '593986664229', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSQjUzRTlENENGMTc5MDFFRkMzAA==', '2025-11-24 02:50:48', '2025-11-24 02:50:48'), (22, '593998205053', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEUwNENEMDUzNjc2N0NFRDY4AA==', '2025-11-24 03:07:36', '2025-11-24 03:07:36'), (23, '593968961298', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTY4OTYxMjk4FQIAERgSQ0U1NzcyRDJCNDAwQTcxRjBCAA==', '2025-11-24 03:07:39', '2025-11-24 03:07:39'), (24, '593959224414', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSM0FCQTY2OEY0RjFGNEM5OEE4AA==', '2025-11-24 03:07:42', '2025-11-24 03:07:42'), (25, '593979014678', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTc5MDE0Njc4FQIAERgSNzEyMzhGMzMyNUE2NjUxMDZCAA==', '2025-11-24 03:15:37', '2025-11-24 03:15:37'), (26, '593998796641', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4Nzk2NjQxFQIAERgSRTQ5QjA3MTM1RUE2Q0ZGQTE5AA==', '2025-11-24 03:15:40', '2025-11-24 03:15:40'), (27, '593961367272', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTYxMzY3MjcyFQIAERgSOUZDRjQ3MTc3Q0Q2RThFODBBAA==', '2025-11-24 03:15:43', '2025-11-24 03:15:43'), (28, '593998213046', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjEzMDQ2FQIAERgSNzU5MUU0Mzc5NzEzOTZEQjkxAA==', '2025-11-24 03:15:46', '2025-11-24 03:15:46'), (29, '593990860721', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTkwODYwNzIxFQIAERgSQjhFREE5MEI1NDFDQUYzN0IxAA==', '2025-11-24 03:15:49', '2025-11-24 03:15:49'), (30, '593999682147', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk5NjgyMTQ3FQIAERgSNDdENDY0NDVENDY0QTk5NDBEAA==', '2025-11-24 03:15:51', '2025-11-24 03:15:51'), (31, '593981565276', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTgxNTY1Mjc2FQIAERgSMTBCOUFGNTI2RDIyMDk5MjI5AA==', '2025-11-24 03:15:54', '2025-11-24 03:15:54'), (32, '593967683271', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTY3NjgzMjcxFQIAERgSMTM3RUZFMTI5OTc2QUJDQkI3AA==', '2025-11-24 03:15:57', '2025-11-24 03:15:57'), (33, '593985038494', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTg1MDM4NDk0FQIAERgSNEJBNTdDODk0OTg2QjM5OENGAA==', '2025-11-24 03:15:59', '2025-11-24 03:15:59'), (34, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUVENUQ5NTQ3NjcwRENFNDdBAA==', '2025-11-24 17:18:28', '2025-11-24 17:18:28'), (35, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSODE1ODk2QThEMkVFQzVERjNCAA==', '2025-11-25 14:37:29', '2025-11-25 14:37:29'), (36, '593998205053', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkY0MTY1RTRERTAxMUM3MzQyAA==', '2025-11-25 14:38:54', '2025-11-25 14:38:54'), (37, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMkYzRjVCRTRCQUIzNzNGMzkxAA==', '2025-11-25 14:43:45', '2025-11-25 14:43:45'), (38, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjAzOTZCM0FFQ0EyM0QyMTY0AA==', '2025-11-26 16:17:06', '2025-11-26 16:17:06'), (39, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzk5ODAxRjc1Q0Y5RTFDQ0UwAA==', '2025-11-26 17:10:11', '2025-11-26 17:10:11'), (40, '593998205053', 'bienvenida_cuenta_activa', 'utility', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEE2MzQwRDMzREJCNjcxNTc3AA==', '2025-11-29 02:52:44', '2025-11-29 02:52:44'), (41, '593998205053', 'facturacion_electronica_demo_v1', 'marketing', '817854531405693', 'wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTY3N0IwRENCNUMxRjdEMkZDAA==', '2025-11-29 02:53:25', '2025-11-29 02:53:25'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `message_status` -- CREATE TABLE `message_status` ( `id` bigint NOT NULL, `message_id` bigint NOT NULL, `status` enum('sent','delivered','read','failed') NOT NULL, `error_code` varchar(40) DEFAULT NULL, `error_title` varchar(120) DEFAULT NULL, `error_detail` varchar(255) DEFAULT NULL, `ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `message_status` -- INSERT INTO `message_status` (`id`, `message_id`, `status`, `error_code`, `error_title`, `error_detail`, `ts`) VALUES (1, 2, 'sent', NULL, NULL, NULL, '2025-09-18 02:03:51'), (2, 2, 'delivered', NULL, NULL, NULL, '2025-09-18 02:03:53'), (3, 2, 'sent', NULL, NULL, NULL, '2025-09-18 02:03:53'), (4, 2, 'read', NULL, NULL, NULL, '2025-09-18 02:03:57'), (5, 3, 'sent', NULL, NULL, NULL, '2025-09-18 02:21:16'), (6, 3, 'sent', NULL, NULL, NULL, '2025-09-18 02:21:18'), (7, 3, 'delivered', NULL, NULL, NULL, '2025-09-18 02:21:19'), (8, 3, 'read', NULL, NULL, NULL, '2025-09-18 02:44:50'), (9, 6, 'sent', NULL, NULL, NULL, '2025-10-28 14:59:57'), (10, 6, 'delivered', NULL, NULL, NULL, '2025-10-28 15:00:00'), (11, 6, 'sent', NULL, NULL, NULL, '2025-10-28 15:00:00'), (12, 6, 'read', NULL, NULL, NULL, '2025-10-28 15:00:13'), (13, 7, 'sent', NULL, NULL, NULL, '2025-10-28 15:10:32'), (14, 7, 'failed', '131049', 'This message was not delivered to maintain healthy ecosystem engagement.', NULL, '2025-10-28 15:10:33'), (15, 8, 'sent', NULL, NULL, NULL, '2025-10-28 15:12:35'), (16, 8, 'sent', NULL, NULL, NULL, '2025-10-28 15:12:39'), (17, 8, 'delivered', NULL, NULL, NULL, '2025-10-28 15:12:39'), (18, 9, 'sent', NULL, NULL, NULL, '2025-10-28 15:19:10'), (19, 9, 'sent', NULL, NULL, NULL, '2025-10-28 15:19:11'), (20, 9, 'delivered', NULL, NULL, NULL, '2025-10-28 15:19:11'), (21, 9, 'read', NULL, NULL, NULL, '2025-10-28 15:19:13'), (22, 10, 'sent', NULL, NULL, NULL, '2025-10-30 22:31:54'), (23, 10, 'delivered', NULL, NULL, NULL, '2025-10-30 22:31:56'), (25, 10, 'read', NULL, NULL, NULL, '2025-10-30 22:32:03'), (26, 11, 'sent', NULL, NULL, NULL, '2025-10-31 03:35:03'), (27, 11, 'delivered', NULL, NULL, NULL, '2025-10-31 03:35:04'), (29, 11, 'read', NULL, NULL, NULL, '2025-10-31 03:35:14'), (30, 12, 'delivered', NULL, NULL, NULL, '2025-11-02 15:05:19'), (32, 12, 'sent', NULL, NULL, NULL, '2025-11-02 15:05:19'), (33, 12, 'read', NULL, NULL, NULL, '2025-11-02 15:05:20'), (34, 13, 'sent', NULL, NULL, NULL, '2025-11-18 20:20:07'), (35, 13, 'delivered', NULL, NULL, NULL, '2025-11-18 20:20:08'), (37, 13, 'read', NULL, NULL, NULL, '2025-11-18 20:20:10'), (38, 14, 'sent', NULL, NULL, NULL, '2025-11-18 22:13:45'), (39, 14, 'delivered', NULL, NULL, NULL, '2025-11-18 22:13:46'), (41, 15, 'sent', NULL, NULL, NULL, '2025-11-18 22:13:50'), (42, 14, 'read', NULL, NULL, NULL, '2025-11-18 22:13:51'), (43, 15, 'delivered', NULL, NULL, NULL, '2025-11-18 22:13:52'), (44, 16, 'sent', NULL, NULL, NULL, '2025-11-18 22:13:54'), (45, 16, 'delivered', NULL, NULL, NULL, '2025-11-18 22:13:54'), (46, 16, 'read', NULL, NULL, NULL, '2025-11-18 22:14:02'), (47, 17, 'delivered', NULL, NULL, NULL, '2025-11-18 23:16:14'), (48, 17, 'sent', NULL, NULL, NULL, '2025-11-18 23:16:15'), (49, 17, 'delivered', NULL, NULL, NULL, '2025-11-18 23:16:15'), (51, 17, 'read', NULL, NULL, NULL, '2025-11-18 23:16:17'), (52, 18, 'sent', NULL, NULL, NULL, '2025-11-19 13:35:39'), (53, 18, 'delivered', NULL, NULL, NULL, '2025-11-19 13:35:40'), (54, 19, 'sent', NULL, NULL, NULL, '2025-11-21 19:03:47'), (55, 19, 'delivered', NULL, NULL, NULL, '2025-11-21 19:03:48'), (56, 19, 'read', NULL, NULL, NULL, '2025-11-21 19:10:52'), (57, 20, 'sent', NULL, NULL, NULL, '2025-11-24 02:50:05'), (58, 20, 'delivered', NULL, NULL, NULL, '2025-11-24 02:50:05'), (61, 20, 'read', NULL, NULL, NULL, '2025-11-24 02:50:15'), (62, 21, 'sent', NULL, NULL, NULL, '2025-11-24 02:50:51'), (63, 21, 'delivered', NULL, NULL, NULL, '2025-11-24 02:50:51'), (64, 21, 'read', NULL, NULL, NULL, '2025-11-24 02:51:04'), (65, 22, 'delivered', NULL, NULL, NULL, '2025-11-24 03:07:38'), (66, 22, 'sent', NULL, NULL, NULL, '2025-11-24 03:07:39'), (67, 22, 'delivered', NULL, NULL, NULL, '2025-11-24 03:07:39'), (69, 23, 'sent', NULL, NULL, NULL, '2025-11-24 03:07:41'), (70, 23, 'delivered', NULL, NULL, NULL, '2025-11-24 03:07:43'), (71, 24, 'sent', NULL, NULL, NULL, '2025-11-24 03:07:44'), (72, 24, 'delivered', NULL, NULL, NULL, '2025-11-24 03:07:45'), (73, 22, 'read', NULL, NULL, NULL, '2025-11-24 03:07:52'), (74, 24, 'read', NULL, NULL, NULL, '2025-11-24 03:08:04'), (75, 25, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:38'), (76, 25, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:43'), (77, 26, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:44'), (78, 27, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:46'), (79, 26, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:46'), (80, 27, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:46'), (81, 28, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:49'), (82, 28, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:49'), (83, 29, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:51'), (84, 30, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:53'), (85, 29, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:53'), (86, 30, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:55'), (87, 31, 'sent', NULL, NULL, NULL, '2025-11-24 03:15:58'), (88, 31, 'delivered', NULL, NULL, NULL, '2025-11-24 03:15:59'), (89, 32, 'sent', NULL, NULL, NULL, '2025-11-24 03:16:00'), (90, 32, 'delivered', NULL, NULL, NULL, '2025-11-24 03:16:02'), (91, 33, 'sent', NULL, NULL, NULL, '2025-11-24 03:16:02'), (92, 33, 'delivered', NULL, NULL, NULL, '2025-11-24 03:16:04'), (93, 29, 'read', NULL, NULL, NULL, '2025-11-24 03:16:44'), (94, 32, 'read', NULL, NULL, NULL, '2025-11-24 03:17:13'), (95, 25, 'read', NULL, NULL, NULL, '2025-11-24 04:52:41'), (96, 31, 'read', NULL, NULL, NULL, '2025-11-24 09:56:16'), (97, 26, 'read', NULL, NULL, NULL, '2025-11-24 10:22:13'), (98, 33, 'read', NULL, NULL, NULL, '2025-11-24 10:29:29'), (99, 27, 'read', NULL, NULL, NULL, '2025-11-24 11:21:45'), (100, 30, 'read', NULL, NULL, NULL, '2025-11-24 11:57:36'), (101, 34, 'sent', NULL, NULL, NULL, '2025-11-24 17:18:37'), (102, 34, 'delivered', NULL, NULL, NULL, '2025-11-24 17:18:37'), (103, 34, 'read', NULL, NULL, NULL, '2025-11-24 17:18:42'), (104, 35, 'sent', NULL, NULL, NULL, '2025-11-25 14:37:38'), (105, 35, 'delivered', NULL, NULL, NULL, '2025-11-25 14:37:39'), (107, 35, 'read', NULL, NULL, NULL, '2025-11-25 14:37:42'), (108, 36, 'sent', NULL, NULL, NULL, '2025-11-25 14:38:57'), (109, 36, 'delivered', NULL, NULL, NULL, '2025-11-25 14:38:57'), (111, 36, 'read', NULL, NULL, NULL, '2025-11-25 14:40:48'), (112, 37, 'sent', NULL, NULL, NULL, '2025-11-25 14:43:53'), (113, 37, 'delivered', NULL, NULL, NULL, '2025-11-25 14:43:54'), (115, 37, 'read', NULL, NULL, NULL, '2025-11-25 14:46:20'), (116, 38, 'delivered', NULL, NULL, NULL, '2025-11-26 16:17:16'), (117, 38, 'sent', NULL, NULL, NULL, '2025-11-26 16:17:16'), (119, 38, 'read', NULL, NULL, NULL, '2025-11-26 16:17:17'), (120, 39, 'delivered', NULL, NULL, NULL, '2025-11-26 17:10:20'), (122, 39, 'sent', NULL, NULL, NULL, '2025-11-26 17:10:20'), (123, 39, 'read', NULL, NULL, NULL, '2025-11-26 17:10:29'), (124, 40, 'delivered', NULL, NULL, NULL, '2025-11-29 02:52:52'), (125, 40, 'sent', NULL, NULL, NULL, '2025-11-29 02:52:52'), (128, 40, 'read', NULL, NULL, NULL, '2025-11-29 02:52:53'), (129, 41, 'sent', NULL, NULL, NULL, '2025-11-29 02:53:26'), (130, 41, 'delivered', NULL, NULL, NULL, '2025-11-29 02:53:27'), (132, 41, 'read', NULL, NULL, NULL, '2025-11-29 02:53:29'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `template_variable_mapping` -- CREATE TABLE `template_variable_mapping` ( `id` int NOT NULL, `template_id` varchar(50) NOT NULL, `variable_position` int NOT NULL COMMENT 'Posición en Meta (1,2,3...)', `variable_name` varchar(50) NOT NULL COMMENT 'Nombre descriptivo (nombre, pedido, etc)', `variable_type` enum('text','number','date','phone') DEFAULT 'text', `is_required` tinyint(1) DEFAULT '1', `example_value` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `template_variable_mapping` -- INSERT INTO `template_variable_mapping` (`id`, `template_id`, `variable_position`, `variable_name`, `variable_type`, `is_required`, `example_value`, `created_at`) VALUES (71, 'facturacion_electronica_demo_v1', 1, 'variable_1', 'text', 1, 'Ejemplo 1', '2025-11-24 02:27:41'), (72, 'bienvenida_cuenta_activa', 1, 'variable_1', 'text', 1, 'Ejemplo 1', '2025-11-24 02:27:41'), (73, 'bienvenida_cuenta_activa', 2, 'variable_2', 'text', 1, 'Ejemplo 2', '2025-11-24 02:27:41'); -- -------------------------------------------------------- -- -- Estructura Stand-in para la vista `vw_last_status` -- (Véase abajo para la vista actual) -- CREATE TABLE `vw_last_status` ( `last_status` text ,`last_status_at` text ,`message_id` bigint ); -- -------------------------------------------------------- -- -- Estructura Stand-in para la vista `vw_status_times` -- (Véase abajo para la vista actual) -- CREATE TABLE `vw_status_times` ( `delivered_at` timestamp ,`failed_at` timestamp ,`message_id` bigint ,`read_at` timestamp ,`sent_at` timestamp ); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `webhooks_raw` -- CREATE TABLE `webhooks_raw` ( `id` bigint NOT NULL, `payload` json NOT NULL, `received_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `webhooks_raw` -- INSERT INTO `webhooks_raw` (`id`, `payload`, `received_at`) VALUES (1, '{\"entry\": [{\"id\": \"0\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"16315551181\", \"profile\": {\"name\": \"test user name\"}}], \"messages\": [{\"id\": \"ABGGFlA5Fpa\", \"from\": \"16315551181\", \"text\": {\"body\": \"this is a text message\"}, \"type\": \"text\", \"timestamp\": \"1504902988\"}], \"metadata\": {\"phone_number_id\": \"123456123\", \"display_phone_number\": \"16505551111\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 01:58:04'), (2, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEQ2NDYwMThEODUzM0VEMEVDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1758161033\", \"conversation\": {\"id\": \"1bf76451b769af5147ecf2bf4368e313\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 02:03:53'), (3, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEQ2NDYwMThEODUzM0VEMEVDAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1758161033\", \"conversation\": {\"id\": \"1bf76451b769af5147ecf2bf4368e313\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1758161033\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 02:03:53'), (4, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEQ2NDYwMThEODUzM0VEMEVDAA==\", \"status\": \"read\", \"timestamp\": \"1758161037\", \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 02:03:57'), (5, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSMUNEQTI4RTExNDYyQjhDMEFGAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1758162078\", \"conversation\": {\"id\": \"ee11b2ec7c7bcc00392b97c4b64ed5f4\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1758162078\"}, \"recipient_id\": \"593986664229\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 02:21:18'), (6, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSMUNEQTI4RTExNDYyQjhDMEFGAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1758162079\", \"conversation\": {\"id\": \"ee11b2ec7c7bcc00392b97c4b64ed5f4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593986664229\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 02:21:19'), (7, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSMUNEQTI4RTExNDYyQjhDMEFGAA==\", \"status\": \"read\", \"timestamp\": \"1758163489\", \"recipient_id\": \"593986664229\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-09-18 02:44:50'), (8, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593990168382\", \"profile\": {\"name\": \"593990168382\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTkwMTY4MzgyFQIAEhgSM0FDRkVDNDhFMEE3QzFCMTk4AA==\", \"from\": \"593990168382\", \"type\": \"unsupported\", \"errors\": [{\"code\": 131051, \"title\": \"Message type unknown\", \"message\": \"Message type unknown\", \"error_data\": {\"details\": \"Message type is currently not supported.\"}}], \"timestamp\": \"1760152099\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-11 03:08:21'), (9, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593990168382\", \"profile\": {\"name\": \"593990168382\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTkwMTY4MzgyFQIAEhgSRkYzODdBNUNBMEQ3QzE4OTEyAA==\", \"from\": \"593990168382\", \"type\": \"unsupported\", \"errors\": [{\"code\": 131051, \"title\": \"Message type unknown\", \"message\": \"Message type unknown\", \"error_data\": {\"details\": \"Message type is currently not supported.\"}}], \"timestamp\": \"1761454393\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-26 04:53:15'), (10, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNUFCRDY1OUU3MzlFMzg2RkVCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663599\", \"conversation\": {\"id\": \"0c4f05f4ce2d676a4a45626dcc569af5\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:00:00'), (11, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNUFCRDY1OUU3MzlFMzg2RkVCAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663599\", \"conversation\": {\"id\": \"0c4f05f4ce2d676a4a45626dcc569af5\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761663599\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:00:00'), (12, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNUFCRDY1OUU3MzlFMzg2RkVCAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663612\", \"conversation\": {\"id\": \"0c4f05f4ce2d676a4a45626dcc569af5\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:00:13'), (13, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjNDOUVCM0IxNzJCOTcyMUUyAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663676\", \"conversation\": {\"id\": \"8ce02ae18069834d0c8dae96a88634b6\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761663676\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:01:17'), (14, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjNDOUVCM0IxNzJCOTcyMUUyAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663677\", \"conversation\": {\"id\": \"8ce02ae18069834d0c8dae96a88634b6\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:01:17'), (15, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjNDOUVCM0IxNzJCOTcyMUUyAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663710\", \"conversation\": {\"id\": \"8ce02ae18069834d0c8dae96a88634b6\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:01:51'), (16, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTYyODQyQkMzOEE3MDdDMzU4AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663750\", \"conversation\": {\"id\": \"397bf81d6476c6904a5ec1d3e6bee1e6\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761663750\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:02:30'), (17, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTYyODQyQkMzOEE3MDdDMzU4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663750\", \"conversation\": {\"id\": \"397bf81d6476c6904a5ec1d3e6bee1e6\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:02:31'), (18, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTYyODQyQkMzOEE3MDdDMzU4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663750\", \"conversation\": {\"id\": \"397bf81d6476c6904a5ec1d3e6bee1e6\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:02:31'), (19, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTZEMDM5NUM3MkY5NUIzMDZDAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663771\", \"conversation\": {\"id\": \"2c653491de5e36e76e56d581ea21272f\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761663771\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:02:51'), (20, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTZEMDM5NUM3MkY5NUIzMDZDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663771\", \"conversation\": {\"id\": \"2c653491de5e36e76e56d581ea21272f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:02:51'), (21, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTZEMDM5NUM3MkY5NUIzMDZDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663771\", \"conversation\": {\"id\": \"2c653491de5e36e76e56d581ea21272f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:02:52'), (22, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTZEMDM5NUM3MkY5NUIzMDZDAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663783\", \"conversation\": {\"id\": \"2c653491de5e36e76e56d581ea21272f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:03:03'), (23, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTYyODQyQkMzOEE3MDdDMzU4AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761663783\", \"conversation\": {\"id\": \"397bf81d6476c6904a5ec1d3e6bee1e6\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:03:03'), (24, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSN0YzRjY3N0I1MTg4Q0JEN0QwAA==\", \"errors\": [{\"code\": 131049, \"href\": \"https://developers.facebook.com/docs/whatsapp/cloud-api/support/error-codes/\", \"title\": \"This message was not delivered to maintain healthy ecosystem engagement.\", \"message\": \"This message was not delivered to maintain healthy ecosystem engagement.\", \"error_data\": {\"details\": \"In order to maintain a healthy ecosystem engagement, the message failed to be delivered.\"}}], \"status\": \"failed\", \"timestamp\": \"1761664181\", \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:09:42'), (25, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNzMwOUJGMzU3OEQxQzRDMjFDAA==\", \"errors\": [{\"code\": 131049, \"href\": \"https://developers.facebook.com/docs/whatsapp/cloud-api/support/error-codes/\", \"title\": \"This message was not delivered to maintain healthy ecosystem engagement.\", \"message\": \"This message was not delivered to maintain healthy ecosystem engagement.\", \"error_data\": {\"details\": \"In order to maintain a healthy ecosystem engagement, the message failed to be delivered.\"}}], \"status\": \"failed\", \"timestamp\": \"1761664232\", \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:10:33'), (26, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSRUYyRTFEMTQ4MDQwRUExOTM5AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664358\", \"conversation\": {\"id\": \"7c8a16571b6bfca85962daaa215af937\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761664358\"}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:12:39'), (27, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSRUYyRTFEMTQ4MDQwRUExOTM5AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664358\", \"conversation\": {\"id\": \"7c8a16571b6bfca85962daaa215af937\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:12:39'), (28, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSQ0Y3QjY1MEFDOTMxNUJFQjFEAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664398\", \"conversation\": {\"id\": \"6ec2de7c66f2ef54bda079946ea8d4e5\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761664398\"}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:13:19'), (29, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSQ0Y3QjY1MEFDOTMxNUJFQjFEAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664399\", \"conversation\": {\"id\": \"6ec2de7c66f2ef54bda079946ea8d4e5\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:13:19'), (30, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSQ0Y3QjY1MEFDOTMxNUJFQjFEAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664399\", \"conversation\": {\"id\": \"6ec2de7c66f2ef54bda079946ea8d4e5\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:13:19'), (31, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSMjE1QjhEMEZBRjQ2NThDQjcwAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664622\", \"conversation\": {\"id\": \"f8bd477b6a5a3fbaf84cc323c22fce6d\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761664622\"}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:17:02'), (32, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYyOTk2ODM4FQIAERgSMjE1QjhEMEZBRjQ2NThDQjcwAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664623\", \"conversation\": {\"id\": \"f8bd477b6a5a3fbaf84cc323c22fce6d\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593962996838\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:17:03'), (33, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTkzREFGNTU3NTNBODFCODQ3AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664718\", \"conversation\": {\"id\": \"a5a26f9389b763a1c2854020bbec518b\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761664718\"}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:18:38'), (34, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593959224414\", \"profile\": {\"name\": \"Artech Solutions\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAEhggQTUzNDdBMzNBQTZBRDdBOUU3OEE0MTk1QzI3NEZGNDEA\", \"from\": \"593959224414\", \"text\": {\"body\": \"Gracias por comunicarte con Artech Solutions. ¿Cómo podemos ayudarte?\"}, \"type\": \"text\", \"timestamp\": \"1761664718\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:18:38'), (35, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTkzREFGNTU3NTNBODFCODQ3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664718\", \"conversation\": {\"id\": \"a5a26f9389b763a1c2854020bbec518b\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:18:38'), (36, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTkzREFGNTU3NTNBODFCODQ3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664718\", \"conversation\": {\"id\": \"a5a26f9389b763a1c2854020bbec518b\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:18:38'), (37, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTkzREFGNTU3NTNBODFCODQ3AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664727\", \"conversation\": {\"id\": \"a5a26f9389b763a1c2854020bbec518b\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:18:47'), (38, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSMTY4MTRENjlDMUFEQTREN0RCAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664750\", \"conversation\": {\"id\": \"4f88876e91b5b8ed5f83a3cb2040d501\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761664750\"}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:19:11'), (39, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSMTY4MTRENjlDMUFEQTREN0RCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664751\", \"conversation\": {\"id\": \"4f88876e91b5b8ed5f83a3cb2040d501\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:19:11'), (40, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSMTY4MTRENjlDMUFEQTREN0RCAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761664752\", \"conversation\": {\"id\": \"4f88876e91b5b8ed5f83a3cb2040d501\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-28 15:19:13'), (41, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRjcyQ0JERjc2NTM3NjQwRDcxAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761863515\", \"conversation\": {\"id\": \"13d0cf7001ecbeb6bafac421c0deab9f\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761863515\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-30 22:31:54'), (42, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRjcyQ0JERjc2NTM3NjQwRDcxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761863515\", \"conversation\": {\"id\": \"13d0cf7001ecbeb6bafac421c0deab9f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-30 22:31:56'), (43, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRjcyQ0JERjc2NTM3NjQwRDcxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761863515\", \"conversation\": {\"id\": \"13d0cf7001ecbeb6bafac421c0deab9f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-30 22:31:56'), (44, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRjcyQ0JERjc2NTM3NjQwRDcxAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761863523\", \"conversation\": {\"id\": \"13d0cf7001ecbeb6bafac421c0deab9f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-30 22:32:03'), (45, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQTIwMjRFOURBNjY0NTBCNjRCAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761881703\", \"conversation\": {\"id\": \"fb49b9c7eb5033b92f11861ae87dd7b1\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1761881703\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-31 03:35:03'), (46, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQTIwMjRFOURBNjY0NTBCNjRCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761881703\", \"conversation\": {\"id\": \"fb49b9c7eb5033b92f11861ae87dd7b1\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-31 03:35:04'), (47, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQTIwMjRFOURBNjY0NTBCNjRCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761881703\", \"conversation\": {\"id\": \"fb49b9c7eb5033b92f11861ae87dd7b1\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-31 03:35:04'), (48, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQTIwMjRFOURBNjY0NTBCNjRCAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1761881714\", \"conversation\": {\"id\": \"fb49b9c7eb5033b92f11861ae87dd7b1\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-31 03:35:14'), (49, '{\"entry\": [{\"id\": \"799342059122741\", \"time\": 1761948029, \"changes\": [{\"field\": \"message_template_status_update\", \"value\": {\"event\": \"APPROVED\", \"reason\": \"NONE\", \"message_template_id\": 842953218285409, \"message_template_name\": \"bienvenida_cuenta_activa\", \"message_template_language\": \"es\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-10-31 22:00:28'), (50, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRkYxRkQzOTk1ODI1NDgxNTYxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1762095919\", \"conversation\": {\"id\": \"c6a89edac04e8212460288de35595f54\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-02 15:05:19'), (51, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRkYxRkQzOTk1ODI1NDgxNTYxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1762095919\", \"conversation\": {\"id\": \"c6a89edac04e8212460288de35595f54\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-02 15:05:19'), (52, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRkYxRkQzOTk1ODI1NDgxNTYxAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1762095919\", \"conversation\": {\"id\": \"c6a89edac04e8212460288de35595f54\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1762095919\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-02 15:05:19'), (53, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRkYxRkQzOTk1ODI1NDgxNTYxAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1762095921\", \"conversation\": {\"id\": \"c6a89edac04e8212460288de35595f54\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-02 15:05:20'), (54, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNjJDRDY4MDJGRDlBMDdBNEY0AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763497207\", \"conversation\": {\"id\": \"580cfc34d81b7d05b8f3a2b1a7b30f1e\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763497207\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 20:20:07'), (55, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNjJDRDY4MDJGRDlBMDdBNEY0AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763497207\", \"conversation\": {\"id\": \"580cfc34d81b7d05b8f3a2b1a7b30f1e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 20:20:08'), (56, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNjJDRDY4MDJGRDlBMDdBNEY0AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763497207\", \"conversation\": {\"id\": \"580cfc34d81b7d05b8f3a2b1a7b30f1e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 20:20:08'), (57, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNjJDRDY4MDJGRDlBMDdBNEY0AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763497209\", \"conversation\": {\"id\": \"580cfc34d81b7d05b8f3a2b1a7b30f1e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 20:20:10'), (58, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUE1MTU1MkIzODk5Njc3OEU3AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504026\", \"conversation\": {\"id\": \"55b5d595b79ea474f053e47538dad951\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763504026\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:45'), (59, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUE1MTU1MkIzODk5Njc3OEU3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504026\", \"conversation\": {\"id\": \"55b5d595b79ea474f053e47538dad951\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:46'), (60, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUE1MTU1MkIzODk5Njc3OEU3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504026\", \"conversation\": {\"id\": \"55b5d595b79ea474f053e47538dad951\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:46'), (61, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAERgSRDhCMjUxNDhBMzgwRDNCQkE1AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504030\", \"conversation\": {\"id\": \"1598af4f217f779db1f6e441c8218b1b\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763504030\"}, \"recipient_id\": \"593968961298\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:50'), (62, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUE1MTU1MkIzODk5Njc3OEU3AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504031\", \"conversation\": {\"id\": \"55b5d595b79ea474f053e47538dad951\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:51'), (63, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAERgSRDhCMjUxNDhBMzgwRDNCQkE1AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504032\", \"conversation\": {\"id\": \"1598af4f217f779db1f6e441c8218b1b\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593968961298\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:51'), (64, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593968961298\", \"profile\": {\"name\": \"Big Datascience\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAEhggQTVDRDYwN0Y3RTNBOTNBNTJDOEEzNENFNTkzOEYwMTkA\", \"from\": \"593968961298\", \"text\": {\"body\": \"Gracias por comunicarte con Big Datascience. ¿Cómo podemos ayudarte? 😁\"}, \"type\": \"text\", \"timestamp\": \"1763504033\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:53'), (65, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTRDMDEzQUYzRjdCQUJCREEzAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504034\", \"conversation\": {\"id\": \"bd250e32d16dcf388abde7f60f24338e\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763504034\"}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:54'), (66, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593968961298\", \"profile\": {\"name\": \"Big Datascience\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAEhggQTUyNjVFRDlEODI3NzY4OEY0MzkxMzgzQzY1NTU2NTIA\", \"from\": \"593968961298\", \"text\": {\"body\": \"Gracias por tu mensaje. En este momento no podemos responder, pero lo haremos lo antes posible.\"}, \"type\": \"text\", \"timestamp\": \"1763504033\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:54'), (67, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTRDMDEzQUYzRjdCQUJCREEzAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504034\", \"conversation\": {\"id\": \"bd250e32d16dcf388abde7f60f24338e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:54'), (68, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593959224414\", \"profile\": {\"name\": \"Artech Solutions\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAEhggQTVGOTlCRDE5QjlGODNCMUJCNkZDOEUwRUE4MTcyMEEA\", \"from\": \"593959224414\", \"text\": {\"body\": \"Gracias por comunicarte con Artech Solutions. ¿Cómo podemos ayudarte?\"}, \"type\": \"text\", \"timestamp\": \"1763504036\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:13:56'), (69, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSOTRDMDEzQUYzRjdCQUJCREEzAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763504042\", \"conversation\": {\"id\": \"bd250e32d16dcf388abde7f60f24338e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 22:14:02'); INSERT INTO `webhooks_raw` (`id`, `payload`, `received_at`) VALUES (70, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkI2MUQ3RENEQjY4NDAyOTc4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763507775\", \"conversation\": {\"id\": \"9473d56600cbb0e028ee71fc1ae25f4e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 23:16:14'), (71, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkI2MUQ3RENEQjY4NDAyOTc4AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763507775\", \"conversation\": {\"id\": \"9473d56600cbb0e028ee71fc1ae25f4e\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763507775\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 23:16:15'), (72, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkI2MUQ3RENEQjY4NDAyOTc4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763507775\", \"conversation\": {\"id\": \"9473d56600cbb0e028ee71fc1ae25f4e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 23:16:15'), (73, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkI2MUQ3RENEQjY4NDAyOTc4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763507775\", \"conversation\": {\"id\": \"9473d56600cbb0e028ee71fc1ae25f4e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 23:16:15'), (74, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkI2MUQ3RENEQjY4NDAyOTc4AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763507777\", \"conversation\": {\"id\": \"9473d56600cbb0e028ee71fc1ae25f4e\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-18 23:16:17'), (75, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg3OTE3Njc4FQIAERgSMERGNDgyNjUyMkRDMTRERjE1AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763559338\", \"conversation\": {\"id\": \"de55f046f9d9f3123889d0e5c3a0eb36\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763559338\"}, \"recipient_id\": \"593987917678\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-19 13:35:39'), (76, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg3OTE3Njc4FQIAERgSMERGNDgyNjUyMkRDMTRERjE1AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763559339\", \"conversation\": {\"id\": \"de55f046f9d9f3123889d0e5c3a0eb36\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593987917678\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-19 13:35:40'), (77, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593987917678\", \"profile\": {\"name\": \"🍃🍃🍃🍃🍃🍂🍂🍃🌻🌻🌻\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTg3OTE3Njc4FQIAEhggQUMzMDE4OUVEQzMzNDRFODhBOTFFOTIyMTU4QTQ3NDMA\", \"from\": \"593987917678\", \"text\": {\"body\": \"Hola\"}, \"type\": \"text\", \"timestamp\": \"1763559433\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-19 13:37:13'), (78, '{\"entry\": [{\"id\": \"799342059122741\", \"time\": 1763580996, \"changes\": [{\"field\": \"message_template_status_update\", \"value\": {\"event\": \"APPROVED\", \"reason\": \"NONE\", \"message_template_id\": 2023334141734304, \"message_template_name\": \"facturacion_electronica_demo_v1\", \"message_template_category\": \"MARKETING\", \"message_template_language\": \"es_EC\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-19 19:36:37'), (79, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTQ1QjFFQ0Q1MUE3QzdCNTIxAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763751826\", \"conversation\": {\"id\": \"f5ebed65f0efe91ad5c451ef3f0d8079\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763751827\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:03:47'), (80, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTQ1QjFFQ0Q1MUE3QzdCNTIxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763751827\", \"conversation\": {\"id\": \"f5ebed65f0efe91ad5c451ef3f0d8079\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:03:48'), (81, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTZCRDkyM0IzQUEyRDZEOUFDAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763752232\", \"conversation\": {\"id\": \"6fc33a0d81b1de480021ae981f10075f\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763752232\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:10:33'), (82, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTZCRDkyM0IzQUEyRDZEOUFDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763752233\", \"conversation\": {\"id\": \"6fc33a0d81b1de480021ae981f10075f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:10:33'), (83, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTZCRDkyM0IzQUEyRDZEOUFDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763752233\", \"conversation\": {\"id\": \"6fc33a0d81b1de480021ae981f10075f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:10:33'), (84, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNTQ1QjFFQ0Q1MUE3QzdCNTIxAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763752251\", \"conversation\": {\"id\": \"f5ebed65f0efe91ad5c451ef3f0d8079\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:10:52'), (85, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTZCRDkyM0IzQUEyRDZEOUFDAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763752251\", \"conversation\": {\"id\": \"6fc33a0d81b1de480021ae981f10075f\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:10:52'), (86, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQ0RERjEyRUNCMkI3MTcyRUVFAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763753055\", \"conversation\": {\"id\": \"8336c960f00537cd403d29a717f301dc\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1763753055\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:24:15'), (87, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQ0RERjEyRUNCMkI3MTcyRUVFAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763753055\", \"conversation\": {\"id\": \"8336c960f00537cd403d29a717f301dc\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:24:16'), (88, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQ0RERjEyRUNCMkI3MTcyRUVFAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763753055\", \"conversation\": {\"id\": \"8336c960f00537cd403d29a717f301dc\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:24:16'), (89, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSQ0RERjEyRUNCMkI3MTcyRUVFAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763753061\", \"conversation\": {\"id\": \"8336c960f00537cd403d29a717f301dc\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-21 19:24:21'), (90, '{\"entry\": [{\"id\": \"799342059122741\", \"time\": 1763836206, \"changes\": [{\"field\": \"message_template_status_update\", \"value\": {\"event\": \"APPROVED\", \"reason\": \"NONE\", \"message_template_id\": 2023334141734304, \"message_template_name\": \"facturacion_electronica_demo_v1\", \"message_template_category\": \"MARKETING\", \"message_template_language\": \"es_EC\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-22 18:30:05'), (91, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzEwNjQxMDk4MjlGQzJDRUI0AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763950101\", \"conversation\": {\"id\": \"49988df5d1bbaee1f01be77e9441ac7a\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763950102\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:08:22'), (92, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzEwNjQxMDk4MjlGQzJDRUI0AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763950102\", \"conversation\": {\"id\": \"49988df5d1bbaee1f01be77e9441ac7a\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:08:22'), (93, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzEwNjQxMDk4MjlGQzJDRUI0AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763950102\", \"conversation\": {\"id\": \"49988df5d1bbaee1f01be77e9441ac7a\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:08:22'), (94, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzEwNjQxMDk4MjlGQzJDRUI0AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763950113\", \"conversation\": {\"id\": \"49988df5d1bbaee1f01be77e9441ac7a\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:08:33'), (95, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMDJDMzI1N0RFMDNCRUNCN0EzAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952605\", \"conversation\": {\"id\": \"7d61a42b9819b23c8052d9d995b8e8d4\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763952605\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:05'), (96, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMDJDMzI1N0RFMDNCRUNCN0EzAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952605\", \"conversation\": {\"id\": \"7d61a42b9819b23c8052d9d995b8e8d4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:05'), (97, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMDJDMzI1N0RFMDNCRUNCN0EzAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952605\", \"conversation\": {\"id\": \"7d61a42b9819b23c8052d9d995b8e8d4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:05'), (98, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMDJDMzI1N0RFMDNCRUNCN0EzAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952605\", \"conversation\": {\"id\": \"7d61a42b9819b23c8052d9d995b8e8d4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:05'), (99, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMDJDMzI1N0RFMDNCRUNCN0EzAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952615\", \"conversation\": {\"id\": \"7d61a42b9819b23c8052d9d995b8e8d4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:15'), (100, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSQjUzRTlENENGMTc5MDFFRkMzAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952651\", \"conversation\": {\"id\": \"077bb483b5fe863e0cf5c738dfa8acec\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763952651\"}, \"recipient_id\": \"593986664229\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:51'), (101, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSQjUzRTlENENGMTc5MDFFRkMzAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952651\", \"conversation\": {\"id\": \"077bb483b5fe863e0cf5c738dfa8acec\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593986664229\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:50:51'), (102, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg2NjY0MjI5FQIAERgSQjUzRTlENENGMTc5MDFFRkMzAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763952664\", \"conversation\": {\"id\": \"077bb483b5fe863e0cf5c738dfa8acec\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593986664229\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 02:51:04'), (103, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEUwNENEMDUzNjc2N0NFRDY4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953659\", \"conversation\": {\"id\": \"1c08c95a8d925bc4ed6b8bb37b4efa8c\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:38'), (104, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEUwNENEMDUzNjc2N0NFRDY4AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953658\", \"conversation\": {\"id\": \"1c08c95a8d925bc4ed6b8bb37b4efa8c\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763953658\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:38'), (105, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEUwNENEMDUzNjc2N0NFRDY4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953658\", \"conversation\": {\"id\": \"1c08c95a8d925bc4ed6b8bb37b4efa8c\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:39'), (106, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEUwNENEMDUzNjc2N0NFRDY4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953658\", \"conversation\": {\"id\": \"1c08c95a8d925bc4ed6b8bb37b4efa8c\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:39'), (107, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAERgSQ0U1NzcyRDJCNDAwQTcxRjBCAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953661\", \"conversation\": {\"id\": \"4a2600e44d3ded388fb192a075cd0627\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763953661\"}, \"recipient_id\": \"593968961298\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:41'), (108, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAERgSQ0U1NzcyRDJCNDAwQTcxRjBCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953663\", \"conversation\": {\"id\": \"4a2600e44d3ded388fb192a075cd0627\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593968961298\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:43'), (109, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSM0FCQTY2OEY0RjFGNEM5OEE4AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953664\", \"conversation\": {\"id\": \"e9746fd7da25adb6b0e60d45784276bb\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763953664\"}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:44'), (110, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593968961298\", \"profile\": {\"name\": \"Big Datascience\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTY4OTYxMjk4FQIAEhggQTVBNUE3MkFDQTg5NzY2RDMxNjg2MzgwQjZERDQ3OTEA\", \"from\": \"593968961298\", \"text\": {\"body\": \"Gracias por tu mensaje. En este momento no podemos responder, pero lo haremos lo antes posible.\"}, \"type\": \"text\", \"timestamp\": \"1763953664\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:44'), (111, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSM0FCQTY2OEY0RjFGNEM5OEE4AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953666\", \"conversation\": {\"id\": \"e9746fd7da25adb6b0e60d45784276bb\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:45'), (112, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEUwNENEMDUzNjc2N0NFRDY4AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953672\", \"conversation\": {\"id\": \"1c08c95a8d925bc4ed6b8bb37b4efa8c\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:07:52'), (113, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAERgSM0FCQTY2OEY0RjFGNEM5OEE4AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763953685\", \"conversation\": {\"id\": \"e9746fd7da25adb6b0e60d45784276bb\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593959224414\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:08:04'), (114, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTc5MDE0Njc4FQIAERgSNzEyMzhGMzMyNUE2NjUxMDZCAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954139\", \"conversation\": {\"id\": \"aceba4a9c6abef45b50503278ff2270d\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954139\"}, \"recipient_id\": \"593979014678\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:38'), (115, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTc5MDE0Njc4FQIAERgSNzEyMzhGMzMyNUE2NjUxMDZCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954143\", \"conversation\": {\"id\": \"aceba4a9c6abef45b50503278ff2270d\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593979014678\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:43'), (116, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4Nzk2NjQxFQIAERgSRTQ5QjA3MTM1RUE2Q0ZGQTE5AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954144\", \"conversation\": {\"id\": \"773afd32b36f9ce95448ee0a6f3a17e8\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954144\"}, \"recipient_id\": \"593998796641\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:44'), (117, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYxMzY3MjcyFQIAERgSOUZDRjQ3MTc3Q0Q2RThFODBBAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954146\", \"conversation\": {\"id\": \"4fba8411c1caeb1248367d1573f72f33\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954146\"}, \"recipient_id\": \"593961367272\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:46'), (118, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4Nzk2NjQxFQIAERgSRTQ5QjA3MTM1RUE2Q0ZGQTE5AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954146\", \"conversation\": {\"id\": \"773afd32b36f9ce95448ee0a6f3a17e8\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998796641\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:46'), (119, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYxMzY3MjcyFQIAERgSOUZDRjQ3MTc3Q0Q2RThFODBBAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954146\", \"conversation\": {\"id\": \"4fba8411c1caeb1248367d1573f72f33\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593961367272\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:46'), (120, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjEzMDQ2FQIAERgSNzU5MUU0Mzc5NzEzOTZEQjkxAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954149\", \"conversation\": {\"id\": \"bdc29e85e1eed6a23e56586d14cad9df\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954149\"}, \"recipient_id\": \"593998213046\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:49'), (121, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjEzMDQ2FQIAERgSNzU5MUU0Mzc5NzEzOTZEQjkxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954149\", \"conversation\": {\"id\": \"bdc29e85e1eed6a23e56586d14cad9df\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998213046\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:49'), (122, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTkwODYwNzIxFQIAERgSQjhFREE5MEI1NDFDQUYzN0IxAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954152\", \"conversation\": {\"id\": \"f2f4f3f4047815c1d735d0a5221636e0\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954152\"}, \"recipient_id\": \"593990860721\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:51'), (123, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk5NjgyMTQ3FQIAERgSNDdENDY0NDVENDY0QTk5NDBEAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954153\", \"conversation\": {\"id\": \"42c8fe7347c0a949decde7360e594be4\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954154\"}, \"recipient_id\": \"593999682147\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:53'), (124, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTkwODYwNzIxFQIAERgSQjhFREE5MEI1NDFDQUYzN0IxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954153\", \"conversation\": {\"id\": \"f2f4f3f4047815c1d735d0a5221636e0\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593990860721\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:53'), (125, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk5NjgyMTQ3FQIAERgSNDdENDY0NDVENDY0QTk5NDBEAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954155\", \"conversation\": {\"id\": \"42c8fe7347c0a949decde7360e594be4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593999682147\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:55'), (126, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTgxNTY1Mjc2FQIAERgSMTBCOUFGNTI2RDIyMDk5MjI5AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954157\", \"conversation\": {\"id\": \"2ee07cb2bb24055dd14514309315c919\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954158\"}, \"recipient_id\": \"593981565276\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:58'), (127, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTgxNTY1Mjc2FQIAERgSMTBCOUFGNTI2RDIyMDk5MjI5AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954159\", \"conversation\": {\"id\": \"2ee07cb2bb24055dd14514309315c919\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593981565276\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:15:59'), (128, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY3NjgzMjcxFQIAERgSMTM3RUZFMTI5OTc2QUJDQkI3AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954160\", \"conversation\": {\"id\": \"94cbd9fe9391abdfd142af9885a7eeed\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954160\"}, \"recipient_id\": \"593967683271\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:16:00'), (129, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY3NjgzMjcxFQIAERgSMTM3RUZFMTI5OTc2QUJDQkI3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954162\", \"conversation\": {\"id\": \"94cbd9fe9391abdfd142af9885a7eeed\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593967683271\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:16:02'), (130, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg1MDM4NDk0FQIAERgSNEJBNTdDODk0OTg2QjM5OENGAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954162\", \"conversation\": {\"id\": \"f7c1a99d9da82b71fcca596cd550cd0c\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1763954162\"}, \"recipient_id\": \"593985038494\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:16:02'), (131, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg1MDM4NDk0FQIAERgSNEJBNTdDODk0OTg2QjM5OENGAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954164\", \"conversation\": {\"id\": \"f7c1a99d9da82b71fcca596cd550cd0c\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593985038494\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:16:04'), (132, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTkwODYwNzIxFQIAERgSQjhFREE5MEI1NDFDQUYzN0IxAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954204\", \"conversation\": {\"id\": \"f2f4f3f4047815c1d735d0a5221636e0\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593990860721\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:16:43'), (133, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTY3NjgzMjcxFQIAERgSMTM3RUZFMTI5OTc2QUJDQkI3AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763954234\", \"conversation\": {\"id\": \"94cbd9fe9391abdfd142af9885a7eeed\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593967683271\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 03:17:13'), (134, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTc5MDE0Njc4FQIAERgSNzEyMzhGMzMyNUE2NjUxMDZCAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763959960\", \"conversation\": {\"id\": \"aceba4a9c6abef45b50503278ff2270d\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593979014678\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 04:52:41'), (135, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTgxNTY1Mjc2FQIAERgSMTBCOUFGNTI2RDIyMDk5MjI5AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763978175\", \"conversation\": {\"id\": \"2ee07cb2bb24055dd14514309315c919\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593981565276\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 09:56:16'), (136, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4Nzk2NjQxFQIAERgSRTQ5QjA3MTM1RUE2Q0ZGQTE5AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763979732\", \"conversation\": {\"id\": \"773afd32b36f9ce95448ee0a6f3a17e8\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998796641\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 10:22:13'), (137, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTg1MDM4NDk0FQIAERgSNEJBNTdDODk0OTg2QjM5OENGAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763980168\", \"conversation\": {\"id\": \"f7c1a99d9da82b71fcca596cd550cd0c\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593985038494\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 10:29:29'), (138, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTYxMzY3MjcyFQIAERgSOUZDRjQ3MTc3Q0Q2RThFODBBAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763983304\", \"conversation\": {\"id\": \"4fba8411c1caeb1248367d1573f72f33\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593961367272\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 11:21:45'); INSERT INTO `webhooks_raw` (`id`, `payload`, `received_at`) VALUES (139, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk5NjgyMTQ3FQIAERgSNDdENDY0NDVENDY0QTk5NDBEAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1763985455\", \"conversation\": {\"id\": \"42c8fe7347c0a949decde7360e594be4\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593999682147\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 11:57:36'), (140, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUVENUQ5NTQ3NjcwRENFNDdBAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764004717\", \"conversation\": {\"id\": \"6e2ae4cc7755be3904ba733479f62223\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1764004717\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 17:18:37'), (141, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUVENUQ5NTQ3NjcwRENFNDdBAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764004717\", \"conversation\": {\"id\": \"6e2ae4cc7755be3904ba733479f62223\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 17:18:37'), (142, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSRUVENUQ5NTQ3NjcwRENFNDdBAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764004723\", \"conversation\": {\"id\": \"6e2ae4cc7755be3904ba733479f62223\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-24 17:18:42'), (143, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSODE1ODk2QThEMkVFQzVERjNCAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081458\", \"conversation\": {\"id\": \"76bfa2fb21d5c71f9fa24881f9b17216\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1764081458\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:37:38'), (144, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSODE1ODk2QThEMkVFQzVERjNCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081458\", \"conversation\": {\"id\": \"76bfa2fb21d5c71f9fa24881f9b17216\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:37:39'), (145, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSODE1ODk2QThEMkVFQzVERjNCAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081458\", \"conversation\": {\"id\": \"76bfa2fb21d5c71f9fa24881f9b17216\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:37:39'), (146, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSODE1ODk2QThEMkVFQzVERjNCAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081462\", \"conversation\": {\"id\": \"76bfa2fb21d5c71f9fa24881f9b17216\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:37:42'), (147, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkY0MTY1RTRERTAxMUM3MzQyAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081536\", \"conversation\": {\"id\": \"8e5805eef620e72db17b2d8868f74312\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1764081536\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:38:56'), (148, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkY0MTY1RTRERTAxMUM3MzQyAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081537\", \"conversation\": {\"id\": \"8e5805eef620e72db17b2d8868f74312\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:38:57'), (149, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkY0MTY1RTRERTAxMUM3MzQyAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081537\", \"conversation\": {\"id\": \"8e5805eef620e72db17b2d8868f74312\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:38:57'), (150, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSNkY0MTY1RTRERTAxMUM3MzQyAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081648\", \"conversation\": {\"id\": \"8e5805eef620e72db17b2d8868f74312\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:40:48'), (151, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMkYzRjVCRTRCQUIzNzNGMzkxAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081833\", \"conversation\": {\"id\": \"29abc89f4de7edb3cf38685947ff28d0\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1764081833\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:43:53'), (152, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMkYzRjVCRTRCQUIzNzNGMzkxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081833\", \"conversation\": {\"id\": \"29abc89f4de7edb3cf38685947ff28d0\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:43:54'), (153, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMkYzRjVCRTRCQUIzNzNGMzkxAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081833\", \"conversation\": {\"id\": \"29abc89f4de7edb3cf38685947ff28d0\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:43:54'), (154, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMkYzRjVCRTRCQUIzNzNGMzkxAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764081979\", \"conversation\": {\"id\": \"29abc89f4de7edb3cf38685947ff28d0\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-25 14:46:20'), (155, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjAzOTZCM0FFQ0EyM0QyMTY0AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764173835\", \"conversation\": {\"id\": \"338b0910a89de3a77912c4bf4192dac2\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 16:17:16'), (156, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjAzOTZCM0FFQ0EyM0QyMTY0AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764173835\", \"conversation\": {\"id\": \"338b0910a89de3a77912c4bf4192dac2\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1764173835\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 16:17:16'), (157, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjAzOTZCM0FFQ0EyM0QyMTY0AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764173835\", \"conversation\": {\"id\": \"338b0910a89de3a77912c4bf4192dac2\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 16:17:16'), (158, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMjAzOTZCM0FFQ0EyM0QyMTY0AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764173837\", \"conversation\": {\"id\": \"338b0910a89de3a77912c4bf4192dac2\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 16:17:17'), (159, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzk5ODAxRjc1Q0Y5RTFDQ0UwAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764177020\", \"conversation\": {\"id\": \"4349e1bce45f4331f1682b630c79b4f2\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 17:10:20'), (160, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzk5ODAxRjc1Q0Y5RTFDQ0UwAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764177020\", \"conversation\": {\"id\": \"4349e1bce45f4331f1682b630c79b4f2\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 17:10:20'), (161, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzk5ODAxRjc1Q0Y5RTFDQ0UwAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764177020\", \"conversation\": {\"id\": \"4349e1bce45f4331f1682b630c79b4f2\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1764177020\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 17:10:20'), (162, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMzk5ODAxRjc1Q0Y5RTFDQ0UwAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764177028\", \"conversation\": {\"id\": \"4349e1bce45f4331f1682b630c79b4f2\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-26 17:10:29'), (163, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"contacts\": [{\"wa_id\": \"593959224414\", \"profile\": {\"name\": \"Artech Solutions\"}}], \"messages\": [{\"id\": \"wamid.HBgMNTkzOTU5MjI0NDE0FQIAEhggQTU2RkY1NEUyNDIzQzFDQzgxNUJDNzhGMEVBMkU2MDAA\", \"from\": \"593959224414\", \"type\": \"image\", \"image\": {\"id\": \"1581528200362668\", \"sha256\": \"OXd/W5Xj6ivaYJ2SGM2NC/ZRJ7UbYVzajFIR1FtAKjs=\", \"mime_type\": \"image/jpeg\"}, \"timestamp\": \"1764379176\"}], \"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 01:19:40'), (164, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEE2MzQwRDMzREJCNjcxNTc3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384772\", \"conversation\": {\"id\": \"0985dab197abaa6d0fd77caef0f55aa5\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:52:52'), (165, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEE2MzQwRDMzREJCNjcxNTc3AA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384771\", \"conversation\": {\"id\": \"0985dab197abaa6d0fd77caef0f55aa5\", \"origin\": {\"type\": \"utility\"}, \"expiration_timestamp\": \"1764384772\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:52:52'), (166, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEE2MzQwRDMzREJCNjcxNTc3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384772\", \"conversation\": {\"id\": \"0985dab197abaa6d0fd77caef0f55aa5\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:52:52'), (167, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEE2MzQwRDMzREJCNjcxNTc3AA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384772\", \"conversation\": {\"id\": \"0985dab197abaa6d0fd77caef0f55aa5\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:52:52'), (168, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSMEE2MzQwRDMzREJCNjcxNTc3AA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"utility\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384773\", \"conversation\": {\"id\": \"0985dab197abaa6d0fd77caef0f55aa5\", \"origin\": {\"type\": \"utility\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:52:53'), (169, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTY3N0IwRENCNUMxRjdEMkZDAA==\", \"status\": \"sent\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384806\", \"conversation\": {\"id\": \"67531aaf0408a14a50c22e4547094d63\", \"origin\": {\"type\": \"marketing\"}, \"expiration_timestamp\": \"1764384806\"}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:53:26'), (170, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTY3N0IwRENCNUMxRjdEMkZDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384806\", \"conversation\": {\"id\": \"67531aaf0408a14a50c22e4547094d63\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:53:27'), (171, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTY3N0IwRENCNUMxRjdEMkZDAA==\", \"status\": \"delivered\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384806\", \"conversation\": {\"id\": \"67531aaf0408a14a50c22e4547094d63\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:53:27'), (172, '{\"entry\": [{\"id\": \"799342059122741\", \"changes\": [{\"field\": \"messages\", \"value\": {\"metadata\": {\"phone_number_id\": \"817854531405693\", \"display_phone_number\": \"593981802659\"}, \"statuses\": [{\"id\": \"wamid.HBgMNTkzOTk4MjA1MDUzFQIAERgSOTY3N0IwRENCNUMxRjdEMkZDAA==\", \"status\": \"read\", \"pricing\": {\"type\": \"regular\", \"billable\": true, \"category\": \"marketing\", \"pricing_model\": \"PMP\"}, \"timestamp\": \"1764384808\", \"conversation\": {\"id\": \"67531aaf0408a14a50c22e4547094d63\", \"origin\": {\"type\": \"marketing\"}}, \"recipient_id\": \"593998205053\"}], \"messaging_product\": \"whatsapp\"}}]}], \"object\": \"whatsapp_business_account\"}', '2025-11-29 02:53:29'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `whatsapp_templates` -- CREATE TABLE `whatsapp_templates` ( `id` int NOT NULL, `template_id` varchar(50) NOT NULL, `name` varchar(100) NOT NULL, `status` enum('PENDING','APPROVED','REJECTED','PAUSED','DISABLED') NOT NULL, `category` enum('MARKETING','UTILITY','AUTHENTICATION','TRANSACTIONAL') NOT NULL, `language` varchar(10) DEFAULT 'es', `body_text` text NOT NULL, `variables` json DEFAULT NULL COMMENT 'Array de variables mapeadas: {"1":"nombre","2":"pedido"}', `variable_count` int DEFAULT '0' COMMENT 'Número total de variables en la plantilla', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `synced_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `components` json DEFAULT NULL COMMENT 'Estructura completa de los components de la plantilla (header, body, etc.)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Volcado de datos para la tabla `whatsapp_templates` -- INSERT INTO `whatsapp_templates` (`id`, `template_id`, `name`, `status`, `category`, `language`, `body_text`, `variables`, `variable_count`, `created_at`, `synced_at`, `components`) VALUES (9, 'mensaje_prueba', 'mensaje_prueba', 'APPROVED', 'MARKETING', 'es', 'Este es el espacio del texto', NULL, 0, '2025-10-30 22:31:02', '2025-11-24 02:27:41', '[{\"text\": \"Este es el encabezado\", \"type\": \"HEADER\", \"format\": \"TEXT\"}, {\"text\": \"Este es el espacio del texto\", \"type\": \"BODY\"}, {\"text\": \"Este es el pie de pagina\", \"type\": \"FOOTER\"}]'), (23, 'bienvenida_cuenta_activa', 'bienvenida_cuenta_activa', 'APPROVED', 'UTILITY', 'es', 'Hola {{1}}, ¡bienvenido(a) a Artech Solutions!\nTe confirmamos que tu cuenta asociada al correo {{2}} está activa y lista para usar.\nSi no reconoces este registro, contáctanos de inmediato.', NULL, 2, '2025-10-31 03:24:11', '2025-11-24 02:27:41', '[{\"text\": \"Finaliza la configuración de la cuenta\", \"type\": \"HEADER\", \"format\": \"TEXT\"}, {\"text\": \"Hola {{1}}, ¡bienvenido(a) a Artech Solutions!\\nTe confirmamos que tu cuenta asociada al correo {{2}} está activa y lista para usar.\\nSi no reconoces este registro, contáctanos de inmediato.\", \"type\": \"BODY\", \"example\": {\"body_text\": [[\"John\", \"andres@gmail.com\"]]}}]'), (25, 'hello_world', 'hello_world', 'APPROVED', 'UTILITY', 'en', 'Welcome and congratulations!! This message demonstrates your ability to send a WhatsApp message notification from the Cloud API, hosted by Meta. Thank you for taking the time to test with us.', NULL, 0, '2025-10-31 03:24:11', '2025-11-24 02:27:41', '[{\"text\": \"Hello World\", \"type\": \"HEADER\", \"format\": \"TEXT\"}, {\"text\": \"Welcome and congratulations!! This message demonstrates your ability to send a WhatsApp message notification from the Cloud API, hosted by Meta. Thank you for taking the time to test with us.\", \"type\": \"BODY\"}, {\"text\": \"WhatsApp Business Platform sample message\", \"type\": \"FOOTER\"}]'), (54, 'facturacion_electronica_demo_v1', 'facturacion_electronica_demo_v1', 'APPROVED', 'MARKETING', 'es_EC', 'Hola {{1}}👋\n\nImpulsa tu negocio con facturación electrónica 100% web (Ecuador):\n\n✅ SRI: Facturación electrónica\n🧾 POS integrado\n📦 Inventario\n👥 Multiempresa/usuarios\n📚 Código fuente + docs\n\nLicencia desde USD 200 + IVA o plan por suscripción con soporte.\n¿Te muestro una demo en vivo? 🎥\n\nPara dejar de recibir mensajes, responde STOP.', NULL, 1, '2025-11-21 17:24:47', '2025-11-24 02:27:41', '[{\"type\": \"HEADER\", \"format\": \"IMAGE\", \"example\": {\"header_handle\": [\"https://scontent.whatsapp.net/v/t61.29466-34/534427303_2023334145067637_5109513795388534222_n.png?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=tEszn9-xmHYQ7kNvwG5VEv0&_nc_oc=Adkvg1ofSK9DxXu66XLQdAI770jyCGJiRUNS7IU27muTDWe8xeWRqg8M84bP2aI3FKbqfhqcQ5UBtBsyb5O_rah2&_nc_zt=3&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&_nc_gid=y38UE_geOQB-qlqbopmHeQ&_nc_tpa=Q5bMBQEKa9v2dMeBTJGSdZw5jVrZuu6u6SGkI7Zn34kDyq6q0Ucw4ddpwkwlcsaA8x65TuIpi-zYv5sy1Q&oh=01_Q5Aa3AGqkX6nG-xRR01WK9L-a97RMDsh3UQzylzUjVAmHSZi0Q&oe=694B2B80\"]}}, {\"text\": \"Hola {{1}}👋\\n\\nImpulsa tu negocio con facturación electrónica 100% web (Ecuador):\\n\\n✅ SRI: Facturación electrónica\\n🧾 POS integrado\\n📦 Inventario\\n👥 Multiempresa/usuarios\\n📚 Código fuente + docs\\n\\nLicencia desde USD 200 + IVA o plan por suscripción con soporte.\\n¿Te muestro una demo en vivo? 🎥\\n\\nPara dejar de recibir mensajes, responde STOP.\", \"type\": \"BODY\", \"example\": {\"body_text\": [[\"Andres\"]]}}, {\"text\": \"Artech Solutions · Soporte y capacitación\", \"type\": \"FOOTER\"}, {\"type\": \"BUTTONS\", \"buttons\": [{\"url\": \"https://artechsolutions-ec.com/facturacion-electronica/?utm_source=wa&utm_medium=tpl&utm_campaign=fact_v2#demo\", \"text\": \"Solicitar demo\", \"type\": \"URL\"}]}]'); -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `billing_events` -- ALTER TABLE `billing_events` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniq_billing` (`message_id`); -- -- Indices de la tabla `crm_sessions` -- ALTER TABLE `crm_sessions` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indices de la tabla `crm_users` -- ALTER TABLE `crm_users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`); -- -- Indices de la tabla `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `wa_message_id` (`wa_message_id`); -- -- Indices de la tabla `message_status` -- ALTER TABLE `message_status` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniq_msg_status` (`message_id`,`status`,`ts`); -- -- Indices de la tabla `template_variable_mapping` -- ALTER TABLE `template_variable_mapping` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_mapping` (`template_id`,`variable_position`); -- -- Indices de la tabla `webhooks_raw` -- ALTER TABLE `webhooks_raw` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `whatsapp_templates` -- ALTER TABLE `whatsapp_templates` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `template_id` (`template_id`), ADD KEY `idx_status` (`status`), ADD KEY `idx_category` (`category`), ADD KEY `idx_name` (`name`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `billing_events` -- ALTER TABLE `billing_events` MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124; -- -- AUTO_INCREMENT de la tabla `crm_users` -- ALTER TABLE `crm_users` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT de la tabla `messages` -- ALTER TABLE `messages` MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT de la tabla `message_status` -- ALTER TABLE `message_status` MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133; -- -- AUTO_INCREMENT de la tabla `template_variable_mapping` -- ALTER TABLE `template_variable_mapping` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74; -- -- AUTO_INCREMENT de la tabla `webhooks_raw` -- ALTER TABLE `webhooks_raw` MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173; -- -- AUTO_INCREMENT de la tabla `whatsapp_templates` -- ALTER TABLE `whatsapp_templates` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74; -- -------------------------------------------------------- -- -- Estructura para la vista `vw_last_status` -- DROP TABLE IF EXISTS `vw_last_status`; CREATE ALGORITHM=UNDEFINED DEFINER=`artechso_useradmin`@`localhost` SQL SECURITY DEFINER VIEW `vw_last_status` AS SELECT `ms`.`message_id` AS `message_id`, substring_index(group_concat(`ms`.`status` order by `ms`.`ts` DESC separator ','),',',1) AS `last_status`, substring_index(group_concat(date_format(`ms`.`ts`,'%Y-%m-%d %H:%i:%s') order by `ms`.`ts` DESC separator ','),',',1) AS `last_status_at` FROM `message_status` AS `ms` GROUP BY `ms`.`message_id` ; -- -------------------------------------------------------- -- -- Estructura para la vista `vw_status_times` -- DROP TABLE IF EXISTS `vw_status_times`; CREATE ALGORITHM=UNDEFINED DEFINER=`artechso_useradmin`@`localhost` SQL SECURITY DEFINER VIEW `vw_status_times` AS SELECT `message_status`.`message_id` AS `message_id`, min((case when (`message_status`.`status` = 'sent') then `message_status`.`ts` end)) AS `sent_at`, min((case when (`message_status`.`status` = 'delivered') then `message_status`.`ts` end)) AS `delivered_at`, min((case when (`message_status`.`status` = 'read') then `message_status`.`ts` end)) AS `read_at`, min((case when (`message_status`.`status` = 'failed') then `message_status`.`ts` end)) AS `failed_at` FROM `message_status` GROUP BY `message_status`.`message_id` ; -- -- Restricciones para tablas volcadas -- -- -- Filtros para la tabla `billing_events` -- ALTER TABLE `billing_events` ADD CONSTRAINT `billing_events_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`); -- -- Filtros para la tabla `crm_sessions` -- ALTER TABLE `crm_sessions` ADD CONSTRAINT `crm_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `crm_users` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `message_status` -- ALTER TABLE `message_status` ADD CONSTRAINT `message_status_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`); -- -- Filtros para la tabla `template_variable_mapping` -- ALTER TABLE `template_variable_mapping` ADD CONSTRAINT `template_variable_mapping_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `whatsapp_templates` (`template_id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;