Hi Joao,

This is my QAction:

using System;
using System.Collections.Generic;
using System.Net;
using Newtonsoft.Json.Linq;
using Skyline.DataMiner.Scripting;

public class TimeoutWebClient : WebClient
{
public int Timeout { get; set; }

public TimeoutWebClient(int timeout)
{
Timeout = timeout;
}

protected override WebRequest GetWebRequest(Uri address)
{
var request = base.GetWebRequest(address);
if (request != null)
{
request.Timeout = Timeout;
if (request is HttpWebRequest httpRequest)
{
httpRequest.ReadWriteTimeout = Timeout;
}
}
return request;
}
}

public class QAction
{
public static void Run(SLProtocol protocol)
{
try
{
string ip = protocol.GetParameter(15) as string; // Cambia si usas otro PID
string token = protocol.GetParameter(Parameter.token) as string;
if (string.IsNullOrEmpty(ip))
{
protocol.Log("IP vacía", LogType.Error);
return;
}

string url = $"http://{ip}/api/v1/system/information/status";
var client = new TimeoutWebClient(180000);
client.Headers[HttpRequestHeader.ContentType] = "application/json";
client.Headers.Add("token", token);

protocol.Log($"Solicitando {url}", LogType.DebugInfo);
string json = client.DownloadString(url);
protocol.Log("Respuesta recibida", LogType.DebugInfo);

// Parsear JSON
var obj = JObject.Parse(json);

// Limpiar tabla antes de insertar
object clearResult = protocol.ClearAllKeys(1300);
int clearCode = Convert.ToInt32(clearResult);
if (clearCode == 0 || clearCode == -1)
protocol.Log("Tabla 1300 limpiada correctamente.", LogType.DebugInfo);
else
protocol.Log($"Error limpiando tabla 1300, código: {clearCode}", LogType.Error);

var keys = new List<object>(); // clave primaria
var names = new List<object>(); // columna 1301
var statuses = new List<object>(); // columna 1302

foreach (var property in obj.Properties())
{
string moduleName = property.Name;
string status = property.Value["Status"]?.ToString() ?? "Unknown";

protocol.Log($"Servicio: {moduleName} – Estado: {status}", LogType.DebugInfo);

keys.Add(moduleName);
names.Add(moduleName);
statuses.Add(status);
}

// Preparar parámetros para NotifyProtocol
object[] columnInfo = new object[]
{
Parameter.Servicetable.tablePid,
Parameter.Modulestable.Pid.modulestablename,
Parameter.Modulestable.Pid.modulestablestatus,

};

object[] columnValues = new object[]
{
keys.ToArray(),
names.ToArray(),
statuses.ToArray(),
};

protocol.NotifyProtocol(220, columnInfo, columnValues);
protocol.Log("Tabla 1300 actualizada correctamente", LogType.Information);
}
catch (WebException ex)
{
protocol.Log("WebException: " + ex.Message, LogType.Error);
}
catch (Exception ex)
{
protocol.Log("Exception: " + ex.Message, LogType.Error);
}
}
}