-- 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

START TRANSACTION;



--
-- 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 `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 `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 `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`
--

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`
--

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;

