Hello everyone! I need help accessing data from the rows of a table in my element, in order to validate whether a record already exists. I tried using methos like GetParameter, but without success(keep getting "-1" as return, even if the information in the table is correct).
With the code bellow i can access the "primaryKey" column because it is a DisplayKey in my table and validate it, but JobID is not a key item, but need to be unique. How can i do it?
P.S.:The column "Instance ID" which is generated by DataMiner is the PK in my table.
P.S. 2: The while condition will be defined after i have a way to validate the info.
Element element = engine.FindElement("MP API Interface");
var requestBody = JsonConvert.DeserializeObject<JobData>(requestData.RawBody);
string primaryKey = $"{requestBody.WorkOrderId}/{requestBody.ServiceDefinitionName}/{requestBody.ServiceDefinitionGroup}";
string jobID = "";
do{
jobID = Guid.NewGuid().ToString();
string [] primaryKeys = element.GetTableDisplayKeys(7000);
if(primaryKeys.Contains(primaryKey)){
{engine.GenerateInformation("Registry found");}
else
{engine.GenerateInformation("New Registry");}
} while()
Thank you all in advance for your attention!