### Report List Response Structure Source: https://technisupport.atlassian.net/wiki/spaces/SMDUE/pages/2859696129 Example of a successful JSON response when retrieving the list of generated reports. ```json { "status": "OK", "code": "OMO001", "message": "El listado de reporte_generado ha sido obtenido exitosamente.", "fullMessage": "OMO001 - El listado de reporte_generado ha sido obtenido exitosamente.", "statusResult": true, "result": [ { "id": 83, "nombre": "Base de Clientes", "link_descarga": "/reports/BasedeClientes_1743775050.json", "tipo_reporte": 24, "reporte_programado_id": null, "tipo_generacion": 0, "estado": "GENERADO", "config_reporte": { "features": [], "workspace": 1, "fecha_desde": "2025-03-01 00:00:00", "fecha_hasta": "2025-03-31 23:59:59", "filter_field": "created_at", "assigned_users": [], "ignore_validation": true }, "descargado": 1, "habilitado": true, "created_at": "2025-04-04 08:57:28", "updated_at": "2025-04-11 17:08:32", "deleted_at": null, "created_by": 44, "updated_by": 8, "deleted_by": null, "workspace_id": 1 } ] } ``` -------------------------------- ### Report Data Response Structure Source: https://technisupport.atlassian.net/wiki/spaces/SMDUE/pages/2859696129 Example of the JSON response structure containing report headers and data records. ```json { "header": [ "NRO. CASO", "CAMPAÑA", "DESCRIPCION CASO", "TIPO CASO", "ESTADO CASO", "FECHA CREACION CASO", "FECHA CIERRE CASO", "USUARIO CIERRE CASO", "TIPO CANAL ORIGEN CASO", "TIPO DOCUMENTO", "NRO. DOCUMENTO", "PRIMER APELLIDO", "SEGUNDO APELLIDO", "PRIMER NOMBRE", "SEGUNDO NOMBRE", "ETIQUETA CLIENTE", "NRO. CUENTA", "TELEFONO", "CORREO ELECTRONICO", "OBSERVACIONES GESTION", "FECHA GESTION", "USUARIO GESTION", "GRABACIONES", "CUMPLIO SLA" ], "data": [], "name": "REPORTE DE GESTIONES" } ``` -------------------------------- ### Billing Data Response Structure Source: https://technisupport.atlassian.net/wiki/spaces/SMDUE/pages/2467004526 Example of the JSON response returned upon a successful 200 status code request. ```json { "status": "OK", "code": 200, "message": "El reporte de facturación se ha obtenido exitosamente", "fullMessage": "200 - El reporte de facturación se ha obtenido exitosamente", "statusResult": true, "result": { "startDate": "2024-07-01", "endDate": "2024-07-01", "instance": "SAGICCTEST L10", "instance_url": "https://sagicctestl10.sagicc.co", "users": [ { "id": 80681, "billing_instancia_id": 80681, "user_id": 4, "nombre": "Joohn Wick", "email": "jwick@sagicc.co", "roles": "administrador,agente", "canales": 3, "campanas": 2, "tipos_canales": 3, "dias_creado": 654, "habilitado": 1, "creado": "2022-09-16 11:37:55", "actualizado": "2024-06-28 10:51:34", "eliminado": null, "created_at": "2024-07-02T05:30:08.000000Z", "updated_at": "2024-07-02T05:30:08.000000Z", "instancia_id": 79, "fecha": "2024-07-01" }, {...}, {...}, {...} ], "items": [ { "fecha": "July", "tipo_item": "INBOUND_WHATSAPP_MESSAGE", "cantidad": "102.00" }, {...0} ] } } ``` -------------------------------- ### Retrieve Billing Data Endpoint Source: https://technisupport.atlassian.net/wiki/spaces/SMDUE/pages/2467004526 Use this GET request to fetch billing information for a specific date range and grouping interval. ```http https://{{sagicc_instance_url}}/api/billing/get-billing-data?startDate=2024-07-01&endDate=2024-07-31&groupBy=month ``` -------------------------------- ### Retrieve List of Generated Reports Source: https://technisupport.atlassian.net/wiki/spaces/SMDUE/pages/2859696129 Use this GET request to fetch a list of reports. Modify the query parameters to filter by status, date, or report type. ```http https://{{sagicc_instance_url}}/api/table/reporte_generado?type=normal&conditions=(estado="GENERATED" AND created_at > "2025-01-01" AND tipo_reporte=24)&page=1&sizePerPage=50&sortName=id&sortOrder=desc&enabled=true ```