=== NORDEN Dental - Brevo Sync Service ===
Date: 2026-06-17
CSV File: /home/clinicasnorden/dentalink.clinicasnorden.cl/csv/brevo.csv
Starting sync process...
Reading CSV data...
Parsing CSV file: /home/clinicasnorden/dentalink.clinicasnorden.cl/csv/brevo.csv
Successfully parsed 21 valid records
Found 21 valid records in CSV
Looking for 'ExtractorLFi' folder...
API response code: 200
Response sample: {"folders":[{"id":45,"name":"ExtractorLFi","uniqueSubscribers":0,"totalSubscribers":0,"totalBlacklisted":0},{"id":46,"name":"ExtractorLFi","uniqueSubscribers":0,"totalSubscribers":0,"totalBlacklisted":0},{"id":43,"name":"Open Rate","uniqueSubscribers":0,"totalSubscribers":0,"totalBlacklisted":0},{"id":41,"name":"TEST BLANQ","uniqueSubscribers":0,"totalSubscribers":0,"totalBlacklisted":0},{"id":39,"name":"Actualización B2B abril","uniqueSubscribers":0,"totalSubscribers":0,"totalBlacklisted":0},{...
Found 'ExtractorLFi' folder with ID: 45
API response code: 200
Response sample: {"lists":[{"id":49,"name":"B2B Blanq","folderId":41,"uniqueSubscribers":1450,"totalBlacklisted":0,"totalSubscribers":0},{"id":48,"name":"DENTALINK","folderId":46,"uniqueSubscribers":0,"totalBlacklisted":0,"totalSubscribers":0},{"id":47,"name":"DENTALINK","folderId":45,"uniqueSubscribers":243,"totalBlacklisted":0,"totalSubscribers":0},{"id":44,"name":"Open Rate H+D","folderId":43,"uniqueSubscribers":3910,"totalBlacklisted":0,"totalSubscribers":0},{"id":42,"name":"TEST BLANQ","folderId":41,"unique...
Found existing DENTALINK list with ID: 47
Using DENTALINK list in ExtractorLFi folder (ID: 47)
Importing contacts to Brevo using batch import...
Processing 21 contacts for import
API response code: 200
Response sample: {"id":2219,"email":"wilhem1712@gmail.com","emailBlacklisted":false,"smsBlacklisted":false,"whatsappBlacklisted":false,"createdAt":"2025-02-06T16:24:35.392-03:00","modifiedAt":"2026-05-20T08:31:02.656-04:00","listIds":[8,12,20,34],"attributes":{"APELLIDOS":"García Marcano","ESPECIALIDAD_ULTRTMT":"Urgencia Adulto","ESTADO_ULTIMA_CITA":"Anulado por pcte. via email","FECHADENACIMIENTO":"1991-01-11","ID_PACIENTE":"70115878","MES_CUMPLEANOS":"1","NOMBRE":"Wilhem Guillermo","PACIENTE_SEXO":"M","RUT":"...
Contact wilhem1712@gmail.com attributes:
HORA_INICIO: NOT SET
PACIENTE_COMUNA: NOT SET
PACIENTE_CIUDAD: NOT SET
API response code: 200
Response sample: {"id":1140,"email":"alejafierro.rioseco@gmail.com","emailBlacklisted":false,"smsBlacklisted":false,"whatsappBlacklisted":false,"createdAt":"2025-02-06T16:24:35.388-03:00","modifiedAt":"2026-05-08T14:21:35.975-04:00","listIds":[8,10,34],"attributes":{"APELLIDOS":"Fierro Rioseco","DIRECCION":"AVDA. LOS PRESIDENTES","ESPECIALIDAD_ULTRTMT":"Urgencia Adulto","ESTADO_ULTIMA_CITA":"Atendido","FECHADENACIMIENTO":"1968-01-13","FECHA_ULTIMA_CITA":"2025-11-07","HORA_ULTIMA_CITA":"12:15:00","ID_PACIENTE":"3...
API response code: 200
Response sample: {"id":19397,"email":"nicolas.onetto@gmail.com","emailBlacklisted":false,"smsBlacklisted":false,"whatsappBlacklisted":false,"createdAt":"2025-02-06T16:24:43.235-03:00","modifiedAt":"2026-05-08T14:21:45.755-04:00","listIds":[8,10,15,34],"attributes":{"APELLIDOS":"Onetto del Pino","CIUDAD":"0","DIRECCION":"0","ESPECIALIDAD_ULTRTMT":"Urgencia Adulto","ESTADO_ULTIMA_CITA":"Anulado por pcte. via email","FECHADENACIMIENTO":"1984-10-30","FECHA_ULTIMA_CITA":"2026-06-11","HORA_ULTIMA_CITA":"16:00:00","ID_...
Contact nicolas.onetto@gmail.com attributes:
HORA_INICIO: NOT SET
PACIENTE_COMUNA: NOT SET
PACIENTE_CIUDAD: NOT SET
After filtering, importing 21 contacts
Processing batch 1 of 1 (21 contacts)
Sending import request for batch 1
Request payload: {
"jsonBody": [
{
"email": "wilhem1712@gmail.com",
"attributes": {
"EMAIL": "wilhem1712@gmail.com",
"NOMBRE": "Wilhem Guillermo",
"APELLIDOS": "Garc\u00eda Marcano",
"FECHADENACIMIENTO": "11\/01\/1991",
"RUT": "26377974-6",
"ULTIMA_ACTUALIZACION": "2026-06-11 08:52:14",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "70115878",
"FECHA_ULTIMA_CITA": "02\/06\/2026",
"HORA_ULTIMA_CITA": "16:15:00",
"NOMBRE_PACIENTE": "Wilhem Guillermo Garc\u00eda Marcano",
"ESTADO_ULTIMA_CITA": "Anulado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Francisco Lopetegui",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "13\/12\/2023",
"FECHA_HORA": "02\/06\/2026 16:15"
}
},
{
"email": "pmendezmgn@gmail.com",
"attributes": {
"EMAIL": "pmendezmgn@gmail.com",
"NOMBRE": "Paul",
"APELLIDOS": "Mendez Gonzalez",
"FECHADENACIMIENTO": "07\/10\/1961",
"RUT": "8863444-6",
"ULTIMA_ACTUALIZACION": "2026-06-11 15:03:07",
"ULTIMA_COMUNA": "Pe\u00f1alolen",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "70124667",
"FECHA_ULTIMA_CITA": "05\/06\/2026",
"HORA_ULTIMA_CITA": "12:30:00",
"NOMBRE_PACIENTE": "Paul Mendez Gonzalez",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Exodoncias - Implantes - Protesis Sobre Implantes Carga Inmediata",
"ULTIMO_DENTISTA": "Valentina Gutierrez Pi\u00f1a",
"ULTIMA_SUCURSAL": "Pe\u00f1alol\u00e9n",
"PACIENTE_FECHA_AFILIACION": "31\/07\/2025",
"FECHA_HORA": "05\/06\/2026 12:30"
}
},
{
"email": "colivares.quero@gmail.com",
"attributes": {
"EMAIL": "colivares.quero@gmail.com",
"NOMBRE": "Cecilia",
"APELLIDOS": "Olivares Quero",
"FECHADENACIMIENTO": "15\/03\/1978",
"RUT": "13456474-1",
"ULTIMA_ACTUALIZACION": "2026-06-11 17:24:22",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70106786",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "12:00:00",
"NOMBRE_PACIENTE": "Cecilia Olivares Quero",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Incrustaci\u00f3n 3.6",
"ULTIMO_DENTISTA": "Valentina Gutierrez Pi\u00f1a",
"ULTIMA_SUCURSAL": "Pe\u00f1alol\u00e9n",
"PACIENTE_FECHA_AFILIACION": "02\/12\/2022",
"FECHA_HORA": "12\/06\/2026 12:00"
}
},
{
"email": "cf.rubioo@gmail.com",
"attributes": {
"EMAIL": "cf.rubioo@gmail.com",
"NOMBRE": "Catalina",
"APELLIDOS": "Fuentes Rubio",
"FECHADENACIMIENTO": "25\/12\/1997",
"RUT": "19748410-1",
"ULTIMA_ACTUALIZACION": "2026-06-11 19:43:37",
"ULTIMA_COMUNA": "Las Condes",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70083944",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "10:45:00",
"NOMBRE_PACIENTE": "Catalina Fuentes Rubio",
"ESTADO_ULTIMA_CITA": "Anulado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Francisco Lopetegui",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "17\/05\/2021",
"FECHA_HORA": "12\/06\/2026 10:45"
}
},
{
"email": "marianelalp27@gmail.com",
"attributes": {
"EMAIL": "marianelalp27@gmail.com",
"NOMBRE": "Marianela",
"APELLIDOS": "Loayza Perez",
"FECHADENACIMIENTO": "27\/03\/1989",
"RUT": "27519251-1",
"ULTIMA_ACTUALIZACION": "2026-06-11 13:03:36",
"ULTIMA_COMUNA": "Las Condes",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70128660",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "11:45:00",
"NOMBRE_PACIENTE": "Marianela Loayza Perez",
"ESTADO_ULTIMA_CITA": "Anulado",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Maria De Los Angeles Bascu\u00f1an Ya\u00f1ez",
"ULTIMA_SUCURSAL": "El Golf",
"PACIENTE_FECHA_AFILIACION": "28\/05\/2026",
"FECHA_HORA": "12\/06\/2026 11:45"
}
},
{
"email": "pilarihs@gmail.com",
"attributes": {
"EMAIL": "pilarihs@gmail.com",
"NOMBRE": "Pilar",
"APELLIDOS": "Henriquez Salazar",
"FECHADENACIMIENTO": "04\/12\/1983",
"RUT": "15665402-7",
"ULTIMA_ACTUALIZACION": "2026-06-11 09:20:12",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70118205",
"FECHA_ULTIMA_CITA": "13\/06\/2026",
"HORA_ULTIMA_CITA": "11:15:00",
"NOMBRE_PACIENTE": "Pilar Henriquez Salazar",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Veronica Astorga Winkler",
"ULTIMA_SUCURSAL": "El Golf",
"PACIENTE_FECHA_AFILIACION": "07\/05\/2024",
"FECHA_HORA": "13\/06\/2026 11:15"
}
},
{
"email": "gavalosguerra@gmail.com",
"attributes": {
"EMAIL": "gavalosguerra@gmail.com",
"NOMBRE": "Germ\u00e1n",
"APELLIDOS": "Avalos Guerra",
"FECHADENACIMIENTO": "11\/11\/1983",
"RUT": "15740281-1",
"ULTIMA_ACTUALIZACION": "2026-06-11 15:01:23",
"ULTIMA_COMUNA": "Las Condes",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "70116068",
"FECHA_ULTIMA_CITA": "13\/06\/2026",
"HORA_ULTIMA_CITA": "09:15:00",
"NOMBRE_PACIENTE": "Germ\u00e1n Avalos Guerra",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Reevaluaci\u00f3n",
"ULTIMO_DENTISTA": "Veronica Astorga Winkler",
"ULTIMA_SUCURSAL": "El Golf",
"PACIENTE_FECHA_AFILIACION": "28\/12\/2023",
"FECHA_HORA": "13\/06\/2026 09:15"
}
},
{
"email": "nespinoza200@gmail.com",
"attributes": {
"EMAIL": "nespinoza200@gmail.com",
"NOMBRE": "Margarita Victoria",
"APELLIDOS": "Espinoza Araya",
"FECHADENACIMIENTO": "04\/12\/2016",
"RUT": "25588080-2",
"ULTIMA_ACTUALIZACION": "2026-06-11 17:55:33",
"ULTIMA_CIUDAD": "Santiago",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70057783",
"FECHA_ULTIMA_CITA": "29\/05\/2026",
"HORA_ULTIMA_CITA": "17:15:00",
"NOMBRE_PACIENTE": "Margarita Victoria Espinoza Araya",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Soledad Bochetti",
"ULTIMA_SUCURSAL": "Ciudad Empresarial",
"PACIENTE_FECHA_AFILIACION": "24\/07\/2019",
"FECHA_HORA": "29\/05\/2026 17:15"
}
},
{
"email": "ignacioandres.larapalma@gmail.com",
"attributes": {
"EMAIL": "ignacioandres.larapalma@gmail.com",
"NOMBRE": "Ignacio Andres",
"APELLIDOS": "Lara Palma",
"FECHADENACIMIENTO": "30\/07\/1986",
"RUT": "16544212-1",
"ULTIMA_ACTUALIZACION": "2026-06-11 19:01:43",
"ULTIMA_COMUNA": "Quilicura",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "70084554",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "10:30:00",
"NOMBRE_PACIENTE": "Ignacio Andres Lara Palma",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Finalizaci\u00f3n",
"ULTIMO_DENTISTA": "Claudia Vieyra",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "01\/06\/2021",
"FECHA_HORA": "12\/06\/2026 10:30"
}
},
{
"email": "angela.c.perez.a@gmail.com",
"attributes": {
"EMAIL": "angela.c.perez.a@gmail.com",
"NOMBRE": "Angela",
"APELLIDOS": "Perez Astete",
"FECHADENACIMIENTO": "27\/12\/1984",
"RUT": "15991951-K",
"ULTIMA_ACTUALIZACION": "2026-06-11 17:55:13",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70079524",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "14:15:00",
"NOMBRE_PACIENTE": "Angela Perez Astete",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Sebastian Araneda Acu\u00f1a",
"ULTIMA_SUCURSAL": "Pe\u00f1alol\u00e9n",
"PACIENTE_FECHA_AFILIACION": "05\/01\/2021",
"FECHA_HORA": "12\/06\/2026 14:15"
}
},
{
"email": "alejafierro.rioseco@gmail.com",
"attributes": {
"EMAIL": "alejafierro.rioseco@gmail.com",
"NOMBRE": "Alonso",
"APELLIDOS": "Orellana Fierro",
"FECHADENACIMIENTO": "16\/10\/2004",
"RUT": "21684703-2",
"ULTIMA_ACTUALIZACION": "2026-06-11 18:09:37",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "40010644",
"FECHA_ULTIMA_CITA": "08\/06\/2026",
"HORA_ULTIMA_CITA": "16:30:00",
"NOMBRE_PACIENTE": "Alonso Orellana Fierro",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Consulta + Rx",
"ULTIMO_DENTISTA": "Martin Sanchez Varela",
"ULTIMA_SUCURSAL": "Pe\u00f1alol\u00e9n",
"PACIENTE_FECHA_AFILIACION": "04\/05\/2014",
"FECHA_HORA": "08\/06\/2026 16:30"
}
},
{
"email": "cami.rebolledo.15@gmail.com",
"attributes": {
"EMAIL": "cami.rebolledo.15@gmail.com",
"NOMBRE": "Camila",
"APELLIDOS": "Rebolledo Palacios",
"FECHADENACIMIENTO": "15\/09\/2004",
"RUT": "21663311-3",
"ULTIMA_ACTUALIZACION": "2026-06-11 23:30:47",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70075593",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "10:00:00",
"NOMBRE_PACIENTE": "Camila Rebolledo Palacios",
"ESTADO_ULTIMA_CITA": "Anulado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Natalia Peralta Alsua",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "20\/09\/2020",
"FECHA_HORA": "12\/06\/2026 10:00"
}
},
{
"email": "pspaolap@gmail.com",
"attributes": {
"EMAIL": "pspaolap@gmail.com",
"NOMBRE": "Rafaela",
"APELLIDOS": "Widmer Perez",
"FECHADENACIMIENTO": "04\/08\/2012",
"RUT": "24026389-0",
"ULTIMA_ACTUALIZACION": "2026-06-11 09:40:40",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70039616",
"FECHA_ULTIMA_CITA": "13\/06\/2026",
"HORA_ULTIMA_CITA": "13:15:00",
"NOMBRE_PACIENTE": "Rafaela Widmer Perez",
"ESTADO_ULTIMA_CITA": "Anulado",
"ULTIMO_TRATAMIENTO": "Controles",
"ULTIMO_DENTISTA": "Valentina Gallardo Sanzana",
"ULTIMA_SUCURSAL": "Pe\u00f1alol\u00e9n",
"PACIENTE_FECHA_AFILIACION": "20\/08\/2018",
"FECHA_HORA": "13\/06\/2026 13:15"
}
},
{
"email": "tmarin@ich.cl",
"attributes": {
"EMAIL": "tmarin@ich.cl",
"NOMBRE": "Teresa",
"APELLIDOS": "Marin Mart\u00ednez",
"FECHADENACIMIENTO": "01\/07\/1970",
"RUT": "11644517-4",
"ULTIMA_ACTUALIZACION": "2026-06-11 08:49:23",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70047581",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "08:30:00",
"NOMBRE_PACIENTE": "Teresa Marin Mart\u00ednez",
"ESTADO_ULTIMA_CITA": "Anulado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Cyber (pack Prevenci\u00f3n Adulto)",
"ULTIMO_DENTISTA": "Natalia Peralta Alsua",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "06\/02\/2019",
"FECHA_HORA": "12\/06\/2026 08:30"
}
},
{
"email": "nayade.castro@barcelliconsultores.com",
"attributes": {
"EMAIL": "nayade.castro@barcelliconsultores.com",
"NOMBRE": "Nayade",
"APELLIDOS": "Castro Barcelli",
"FECHADENACIMIENTO": "24\/05\/1968",
"RUT": "10756455-1",
"ULTIMA_ACTUALIZACION": "2026-06-11 15:52:24",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70107161",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "18:15:00",
"NOMBRE_PACIENTE": "Nayade Castro Barcelli",
"ESTADO_ULTIMA_CITA": "Anulado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Diego Mu\u00f1oz Urzua",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "16\/12\/2022",
"FECHA_HORA": "12\/06\/2026 18:15"
}
},
{
"email": "jarka.m.farias@gmail.com",
"attributes": {
"EMAIL": "jarka.m.farias@gmail.com",
"NOMBRE": "Jarka",
"APELLIDOS": "Saavedra Farias",
"FECHADENACIMIENTO": "02\/01\/1973",
"RUT": "12506807-3",
"ULTIMA_ACTUALIZACION": "2026-06-11 12:51:22",
"ULTIMA_CIUDAD": "Santiago",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70089058",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "15:00:00",
"NOMBRE_PACIENTE": "Jarka Saavedra Farias",
"ESTADO_ULTIMA_CITA": "Anulado",
"ULTIMO_TRATAMIENTO": "Blanqueamiento",
"ULTIMO_DENTISTA": "Nicole Lubascher",
"ULTIMA_SUCURSAL": "El Golf",
"PACIENTE_FECHA_AFILIACION": "10\/10\/2021",
"FECHA_HORA": "12\/06\/2026 15:00"
}
},
{
"email": "elysepulvedabriones@gmail.com",
"attributes": {
"EMAIL": "elysepulvedabriones@gmail.com",
"NOMBRE": "Elizabeth",
"APELLIDOS": "Sepulveda Briones",
"FECHADENACIMIENTO": "18\/11\/1974",
"RUT": "12874873-3",
"ULTIMA_ACTUALIZACION": "2026-06-11 13:08:28",
"ULTIMA_CIUDAD": "Santiago",
"ULTIMA_COMUNA": "No Informado",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70010863",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "09:00:00",
"NOMBRE_PACIENTE": "Elizabeth Sepulveda Briones",
"ESTADO_ULTIMA_CITA": "Anulado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Gabriela Quaassdorff",
"ULTIMA_SUCURSAL": "Costanera",
"PACIENTE_FECHA_AFILIACION": "29\/08\/2016",
"FECHA_HORA": "12\/06\/2026 09:00"
}
},
{
"email": "gabrielzabner@gmail.com",
"attributes": {
"EMAIL": "gabrielzabner@gmail.com",
"NOMBRE": "Gabriel",
"APELLIDOS": "Zabner Rodriguez",
"FECHADENACIMIENTO": "17\/07\/1985",
"RUT": "16097426-5",
"ULTIMA_ACTUALIZACION": "2026-06-11 12:28:26",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "70002936",
"FECHA_ULTIMA_CITA": "21\/08\/2026",
"HORA_ULTIMA_CITA": "18:00:00",
"NOMBRE_PACIENTE": "Gabriel Zabner Rodriguez",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Curaprox",
"ULTIMO_DENTISTA": "Gabriel Dalmazzo",
"ULTIMA_SUCURSAL": "La Reina",
"PACIENTE_FECHA_AFILIACION": "28\/01\/2016",
"FECHA_HORA": "21\/08\/2026 18:00"
}
},
{
"email": "fergenskowski@gmail.com",
"attributes": {
"EMAIL": "fergenskowski@gmail.com",
"NOMBRE": "Fernanda",
"APELLIDOS": "Barrientos Genskowski",
"FECHADENACIMIENTO": "05\/03\/2001",
"RUT": "20723877-5",
"ULTIMA_ACTUALIZACION": "2026-06-11 09:35:31",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70123900",
"FECHA_ULTIMA_CITA": "05\/02\/2026",
"HORA_ULTIMA_CITA": "10:00:00",
"NOMBRE_PACIENTE": "Fernanda Barrientos Genskowski",
"ESTADO_ULTIMA_CITA": "Confirmado Por Whatsapp Bot",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Nicole Lubascher",
"ULTIMA_SUCURSAL": "El Golf",
"PACIENTE_FECHA_AFILIACION": "12\/06\/2025",
"FECHA_HORA": "05\/02\/2026 10:00"
}
},
{
"email": "catalina.unda.munoz@gmail.com",
"attributes": {
"EMAIL": "catalina.unda.munoz@gmail.com",
"NOMBRE": "Catalina",
"APELLIDOS": "Unda Mu\u00f1oz",
"FECHADENACIMIENTO": "15\/02\/2005",
"RUT": "21775434-8",
"ULTIMA_ACTUALIZACION": "2026-06-11 19:25:49",
"ULTIMA_COMUNA": "Pe\u00f1alol\u00e9n",
"PACIENTE_SEXO": "F",
"ID_PACIENTE": "70113778",
"FECHA_ULTIMA_CITA": "12\/06\/2026",
"HORA_ULTIMA_CITA": "17:00:00",
"NOMBRE_PACIENTE": "Catalina Unda Mu\u00f1oz",
"ESTADO_ULTIMA_CITA": "Anulado",
"ULTIMO_TRATAMIENTO": "Evluacion",
"ULTIMO_DENTISTA": "Valentina Gutierrez Pi\u00f1a",
"ULTIMA_SUCURSAL": "Pe\u00f1alol\u00e9n",
"PACIENTE_FECHA_AFILIACION": "24\/08\/2023",
"FECHA_HORA": "12\/06\/2026 17:00"
}
},
{
"email": "nicolas.onetto@gmail.com",
"attributes": {
"EMAIL": "nicolas.onetto@gmail.com",
"NOMBRE": "Nicolas",
"APELLIDOS": "Onetto Del Pino",
"FECHADENACIMIENTO": "01\/01\/1990",
"RUT": "15838481-7",
"ULTIMA_ACTUALIZACION": "2026-06-11 08:59:14",
"ULTIMA_CIUDAD": "Santiago",
"ULTIMA_COMUNA": "Las Condes",
"PACIENTE_SEXO": "M",
"ID_PACIENTE": "70120051",
"FECHA_ULTIMA_CITA": "11\/06\/2026",
"HORA_ULTIMA_CITA": "16:00:00",
"NOMBRE_PACIENTE": "Nicolas Onetto Del Pino",
"ESTADO_ULTIMA_CITA": "Anulado",
"ULTIMO_TRATAMIENTO": "Nuevo Plan De Tratamiento",
"ULTIMO_DENTISTA": "Javiera Smith Ruiz",
"ULTIMA_SUCURSAL": "El Golf",
"PACIENTE_FECHA_AFILIACION": "25\/08\/2024",
"FECHA_HORA": "11\/06\/2026 16:00"
}
}
],
"listIds": [
47
],
"updateExistingContacts": true,
"emptyContactsAttributes": false
}
API response code: 202
Response sample: {"processId":2179}
Batch 1 imported successfully. Process ID: 2179
All batches processed. Total contacts imported: 21
Sincronización completada exitosamente:
Total de contactos importados: 21
Contactos omitidos (cancelados/rebotes): 0
ID de la lista DENTALINK: 47
Tiempo de ejecución: 4.75 segundos
2026-06-17 09:47:52 SERVER -> CLIENT: 220-power83.powerhost.cl ESMTP Exim 4.99.4 #2 Wed, 17 Jun 2026 05:47:52 -0400 220-We do not authorize the use of this system to transport unsolicited, 220 and/or bulk e-mail.
2026-06-17 09:47:52 CLIENT -> SERVER: EHLO www.dentalink.clinicasnorden.cl
2026-06-17 09:47:52 SERVER -> CLIENT: 250-power83.powerhost.cl Hello www.dentalink.clinicasnorden.cl [200.73.115.83]250-SIZE 52428800250-LIMITS MAILMAX=1000 RCPTMAX=50000250-8BITMIME250-PIPELINING250-PIPECONNECT250-AUTH PLAIN LOGIN250 HELP
2026-06-17 09:47:52 CLIENT -> SERVER: AUTH LOGIN
2026-06-17 09:47:52 SERVER -> CLIENT: 334 VXNlcm5hbWU6
2026-06-17 09:47:52 CLIENT -> SERVER: [credentials hidden]
2026-06-17 09:47:52 SERVER -> CLIENT: 334 UGFzc3dvcmQ6
2026-06-17 09:47:52 CLIENT -> SERVER: [credentials hidden]
2026-06-17 09:47:52 SERVER -> CLIENT: 235 Authentication succeeded
2026-06-17 09:47:52 CLIENT -> SERVER: MAIL FROM:<dentalink@clinicasnorden.cl>
2026-06-17 09:47:52 SERVER -> CLIENT: 250 OK
2026-06-17 09:47:52 CLIENT -> SERVER: RCPT TO:<crm@lfi.la>
2026-06-17 09:47:52 SERVER -> CLIENT: 250 Accepted
2026-06-17 09:47:52 CLIENT -> SERVER: RCPT TO:<ibai.fernandez@lfi.cl>
2026-06-17 09:47:52 SERVER -> CLIENT: 250 Accepted
2026-06-17 09:47:52 CLIENT -> SERVER: RCPT TO:<jesica.perez@lfi.la>
2026-06-17 09:47:52 SERVER -> CLIENT: 250 Accepted
2026-06-17 09:47:52 CLIENT -> SERVER: DATA
2026-06-17 09:47:52 SERVER -> CLIENT: 354 Enter message, ending with "." on a line by itself
2026-06-17 09:47:52 CLIENT -> SERVER: Date: Wed, 17 Jun 2026 05:47:52 -0400
2026-06-17 09:47:52 CLIENT -> SERVER: To: crm@lfi.la, ibai.fernandez@lfi.cl, jesica.perez@lfi.la
2026-06-17 09:47:52 CLIENT -> SERVER: From: Extractor de NORDEN <dentalink@clinicasnorden.cl>
2026-06-17 09:47:52 CLIENT -> SERVER: Subject: =?UTF-8?Q?NORDEN_Dental_Care:_Informe_de_Sincronizaci=C3=B3n_Brevo_-_2026-06-17?=
2026-06-17 09:47:52 CLIENT -> SERVER: Message-ID: <3YG1FcLakPcg5xHnrKtJrO7Hq4f7rRawMwnWTDHRjoo@www.dentalink.clinicasnorden.cl>
2026-06-17 09:47:52 CLIENT -> SERVER: X-Mailer: PHPMailer 6.9.2 (https://github.com/PHPMailer/PHPMailer)
2026-06-17 09:47:52 CLIENT -> SERVER: MIME-Version: 1.0
2026-06-17 09:47:52 CLIENT -> SERVER: Content-Type: text/html; charset=UTF-8
2026-06-17 09:47:52 CLIENT -> SERVER: Content-Transfer-Encoding: 8bit
2026-06-17 09:47:52 CLIENT -> SERVER:
2026-06-17 09:47:52 CLIENT -> SERVER: <style>
2026-06-17 09:47:52 CLIENT -> SERVER: .container { font-family: Arial, sans-serif; max-width: 800px; margin: 0 auto; padding: 20px; }
2026-06-17 09:47:52 CLIENT -> SERVER: .header { margin-bottom: 30px; }
2026-06-17 09:47:52 CLIENT -> SERVER: .section { margin-bottom: 25px; }
2026-06-17 09:47:52 CLIENT -> SERVER: .success { color: #28a745; }
2026-06-17 09:47:52 CLIENT -> SERVER: .error { color: #dc3545; }
2026-06-17 09:47:52 CLIENT -> SERVER: .warning { color: #ffc107; }
2026-06-17 09:47:52 CLIENT -> SERVER: .info { color: #17a2b8; }
2026-06-17 09:47:52 CLIENT -> SERVER: .docs-note { background: #f8f9fa; padding: 15px; border-left: 4px solid #17a2b8; margin: 20px 0; }
2026-06-17 09:47:52 CLIENT -> SERVER: .error-note { background: #f8d7da; padding: 15px; border-left: 4px solid #dc3545; margin: 20px 0; }
2026-06-17 09:47:52 CLIENT -> SERVER: .stats { background: #f8f9fa; padding: 15px; margin: 10px 0; }
2026-06-17 09:47:52 CLIENT -> SERVER: ul { margin: 10px 0; padding-left: 20px; }
2026-06-17 09:47:52 CLIENT -> SERVER: li { margin: 5px 0; }
2026-06-17 09:47:52 CLIENT -> SERVER: pre { background: #f8f9fa; padding: 10px; overflow: auto; }
2026-06-17 09:47:52 CLIENT -> SERVER: .download-button {
2026-06-17 09:47:52 CLIENT -> SERVER: display: inline-block;
2026-06-17 09:47:52 CLIENT -> SERVER: padding: 10px 15px;
2026-06-17 09:47:52 CLIENT -> SERVER: background-color: #007bff;
2026-06-17 09:47:52 CLIENT -> SERVER: color: white;
2026-06-17 09:47:52 CLIENT -> SERVER: text-decoration: none;
2026-06-17 09:47:52 CLIENT -> SERVER: border-radius: 4px;
2026-06-17 09:47:52 CLIENT -> SERVER: margin: 10px 0;
2026-06-17 09:47:52 CLIENT -> SERVER: font-weight: bold;
2026-06-17 09:47:52 CLIENT -> SERVER: }
2026-06-17 09:47:52 CLIENT -> SERVER: .download-button:hover {
2026-06-17 09:47:52 CLIENT -> SERVER: background-color: #0056b3;
2026-06-17 09:47:52 CLIENT -> SERVER: }
2026-06-17 09:47:52 CLIENT -> SERVER: </style><div class='container'>
2026-06-17 09:47:52 CLIENT -> SERVER: <h2>NORDEN: Informe de Sincronización con Brevo - 2026-06-17</h2>
2026-06-17 09:47:52 CLIENT -> SERVER:
2026-06-17 09:47:52 CLIENT -> SERVER: <div class='docs-note'>
2026-06-17 09:47:52 CLIENT -> SERVER: <p><strong>NORDEN Dental Care - Sincronización con Brevo</strong><br><br>
2026-06-17 09:47:52 CLIENT -> SERVER: Proceso de envío de contactos extraídos a la plataforma Brevo.</p><p><strong>Archivo CSV procesado:</strong> brevo.csv</p></div><div class='section'>
2026-06-17 09:47:52 CLIENT -> SERVER: <h3>Estadísticas de Sincronización</h3>
2026-06-17 09:47:52 CLIENT -> SERVER: <div class='stats'>
2026-06-17 09:47:52 CLIENT -> SERVER: <ul><li>Fecha de sincronización: 2026-06-17</li><li>Total de contactos importados: 21</li><li>Skipped unsubscribed: 0</li><li>Skipped contacts: 0</li><li>Nombre de la lista: DENTALINK</li><li>ID de la lista: 47</li><li>Archivo CSV procesado: brevo.csv</li><li>Tamaño del archivo: 9.33 KB</li><li>Tiempo de ejecución: 4.75 segundos</li><li>Auto create attributes: Disabled (not required)</li></ul>
2026-06-17 09:47:52 CLIENT -> SERVER: </div>
2026-06-17 09:47:52 CLIENT -> SERVER: </div><div class='section info'>
2026-06-17 09:47:52 CLIENT -> SERVER: <p><strong>Nota:</strong> Este es un informe (interno de LFi) automatizado del Servicio de Sincronización con Brevo.</p>
2026-06-17 09:47:52 CLIENT -> SERVER: <p>Proceso ejecutado desde: /home/clinicasnorden/dentalink.clinicasnorden.cl/brevo-sync/</p>
2026-06-17 09:47:52 CLIENT -> SERVER: <p>Hora de ejecución: 05:47:52</p>
2026-06-17 09:47:52 CLIENT -> SERVER: <br><br>
2026-06-17 09:47:52 CLIENT -> SERVER: <p>
2026-06-17 09:47:52 CLIENT -> SERVER: v.1.0.0 | Mail MKT & Automatización
2026-06-17 09:47:52 CLIENT -> SERVER: </p>
2026-06-17 09:47:52 CLIENT -> SERVER: </div>
2026-06-17 09:47:52 CLIENT -> SERVER: </div>
2026-06-17 09:47:52 CLIENT -> SERVER:
2026-06-17 09:47:52 CLIENT -> SERVER: .
2026-06-17 09:47:54 SERVER -> CLIENT: 250 OK id=1wZmsE-000000007pC-4423
2026-06-17 09:47:54 CLIENT -> SERVER: QUIT
2026-06-17 09:47:54 SERVER -> CLIENT: 221 power83.powerhost.cl closing connection
Email report sent successfully
=== Brevo sync service completed ===