I have an object called ItalVinculacion, and inside it I have to read the content of ItalProduct, which is also an object, and obtain the values ​​of ItalEjeAplicacion and Type, which are objects within the product.

This is my code:

var autoId = Get<Guid>("IdAuto"); // ID del auto en ItalAutosNormalizados
var IdProduct = Get<Guid>("IdProduct"); // ID del producto de la nueva vinculación
var IdAxis = Get<Guid>("IdAxis"); 
var IdSubFamily = Get<Guid>("IdSubFamily"); 
 
if (IdProduct == Guid.Empty) {
    return false;
}
 
// Buscar vinculaciones existentes con el mismo auto
var vinculacionEsq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "ItalVinculacion");
vinculacionEsq.AddColumn("Id");
vinculacionEsq.AddColumn("ItalPriority");
 
// Acceder a las columnas del objeto relacionado ItalProduct usando alias
var ejeAplicacionColumn = vinculacionEsq.AddColumn("ItalProduct.ItalEjeAplicacion");
ejeAplicacionColumn.Name = "ItalEjeAplicacion";
 
var typeColumn = vinculacionEsq.AddColumn("ItalProduct.Type");
typeColumn.Name = "Type";
 
vinculacionEsq.Filters.Add(vinculacionEsq.CreateFilterWithParameters(FilterComparisonType.Equal, "ItalFleetID", autoId));
 
var existingVinculaciones = vinculacionEsq.GetEntityCollection(UserConnection);
int maxPriority = 0;
bool isDuplicateFound = false;
 
foreach (var vinculation in existingVinculaciones) {
    var existingEjeAplicacion = vinculation.GetTypedColumnValue<Guid>("ItalEjeAplicacion");
    var existingType = vinculation.GetTypedColumnValue<Guid>("Type");
 
    // Comparar GUIDs correctamente
    if (existingEjeAplicacion.Equals(IdAxis) && existingType.Equals(IdSubFamily)) {
        isDuplicateFound = true;
        var existingPriority = vinculation.GetTypedColumnValue<int>("ItalPriority");
 
        if (existingPriority == 0) {
            vinculation.SetColumnValue("ItalPriority", 1);
            Set("ItalPriority", 2);
        } else {
            Set("ItalPriority", existingPriority + 1);
            vinculation.SetColumnValue("ItalPriority", existingPriority + 1);
        }
 
        vinculation.Save();
        break; // Salir del bucle si se encuentra un duplicado
    }
 
    maxPriority = Math.Max(maxPriority, vinculation.GetTypedColumnValue<int>("ItalPriority"));
}
 
// Si no se encontró un duplicado, establece la prioridad de la nueva vinculación
if (!isDuplicateFound) {
    Set("ItalPriority", maxPriority + 1);
}
 
return true;

And this is the error:

Terrasoft.Common.ItemNotFoundException: Value "ItalProduct.ItalEjeAplicacion" was not found.

Hi Team,



We are using an OOTB Webservice section to call the (GET) REST API endpoint and the response collection is captured in the "Response Parameter" of that web service. The response has a nested collection of data.

 

We are currently using the Script task to read the response data of a web service. Now it is required to get into the nested data set further and any insight on this would be helpful.



STEP 1: Web service Response

STEP 2: Script task to read web service response

var deliveries = Get<ICompositeObjectList<ICompositeObject>>("WebService1.Output_Out");
foreach(var delivery in deliveries){
//Delivery is again a nested data
//need to loop through the delivery (has parent record info and array of child record details)
}
 

Webservice Output:

{
   "output":[
      {
         "challan":[
            {
               "delivery_number":"DEL-251-253423",
               "delivery_id":1151109,
               "lines":[
                  {
                     "order_number":2011010049349,
                     "item_code":"RT3060-002GRL",
                     "grade":"A"
                  },
                  {
                     "order_number":2011010049359,
                     "item_code":"RT3062-002GRL",
                     "grade":"A"
                  }
               ]
            },
            {
               "delivery_number":"DEL-251-253430",
               "delivery_id":1151109,
               "lines":[
                  {
                     "order_number":2011010049369,
                     "item_code":"RT3060-002GRL",
                     "grade":"B"
                  },
                  {
                     "order_number":2011010049379,
                     "item_code":"RT3062-002GRL",
                     "grade":"B"
                  }
               ]
            }
         ]
      }
   ]
}

Need to traverse through the nested collection and one of the properties in the collection of values is array too {like section record information & Child record information} and then insert them into CRM table (Parent and child). Insight for processing this data set would be helpful.

Best Regards,

Bhoobalan Palanivelu.

Hi,

I have a business process where I need to read the read element values in a script task.

When the read element is set to "read a collection of records" I'm using the following code:

var AccountsData = Get>("ReadDataUserTask12.ResultCompositeObjectList");

var AccountData = AccountsData.First();

var AccountAddress="";

AccountData.TryGetValue("Address", out AccountAddress);

What change do I need to do when the read element is set to "read the first record"?

Thanks,

Raz

Hello,

I am trying to implement a web-service integration that provides a collection of fields as a response, and adding it to an auto-generated page to show the results. Can someone guide me how I can implement this functionality to grab fields from a collection and show them as separate individual fields?

I have a business process that reads a collection of data.

Two of the fields that are being read are datetime fields.

Because the read data process reads many rows, I'm reading those rows in a script task and using the following code:

var ProductLines = Get>("ReadDataUserTask1.ResultCompositeObjectList");

    foreach(var ProductLine in ProductLines) {

It's very important to understand that inside the foreach loop I'M NOT TRYING TO GET THE DATETIME FIELDS, BUT OTHER STRING TYPE FIELDS.

Once I run the process I get the following error message:

Terrasoft.Common.UnsupportedTypeException: Type "System.TimeSpan, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" is not supported.

   at Terrasoft.Common.CompositeObject.Add(String key, Object value)

   at Terrasoft.Common.CompositeObjectListUtilities.Transform(ICompositeObject source, IReadOnlyDictionary`2 keyMap)

   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()

   at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)

   at Terrasoft.Common.CompositeObjectListUtilities.Transform[T](IEnumerable`1 source, IReadOnlyDictionary`2 keyMap)

   at Terrasoft.Core.Process.Configuration.ReadDataUserTask.FillResultCompositeObjectList(IProcessParametersMetaInfo schemaElement, EntityCollection entityCollection)

   at Terrasoft.Core.Process.Configuration.ReadDataUserTask.InternalExecute(ProcessExecutingContext context)

   at Terrasoft.Core.Process.ProcessActivity.ExecuteElement(ProcessExecutingContext context)

   at Terrasoft.Core.Process.ProcessActivity.ExecuteItem(ProcessExecutingContext context)

   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

I'm looking forward to having your assistance with the issue.

Best Regards,

Raz

I have a question about working with record collection from read data element.

My case is to take all tasks planned for the next hour and send email to them owners. 

I’d like to ask if it is possible to get a task ID, one by one, base on the collection, then read the necessary data from the task and send an email to the owner. (like in schema below)