Hello,

In order to process the collection inside a collection, you need to do the following:

1) In the process, create a new parameter and add values to it from the web server response:

2) In your script task, you need to proceed this parameter and get values from it.

Dmytro Vovchenko,

Thanks for the information shared.

We were able to achieve processing the multiple nested collection through the below script and insert the Parent/Child collection sequentially.

List<object> deliveryItem = new List<object>();
List<object> lineItem = new List<object>();
var serviceOut = Get<ICompositeObjectList<ICompositeObject>>("Output");
 
foreach(ICompositeObject chall in serviceOut){
	if(chall.TryGetValue<ICompositeObjectList<ICompositeObject>>("Challan" , out ICompositeObjectList<ICompositeObject> curChallan)){
		foreach(ICompositeObject _challan1 in curChallan){
				curChallan1.TryGetValue<string>("Driver_contact_no" , out string Driver_contact_no); 
				deliveryItem.Add(Driver_contact_no);
 
				if(_challan1.TryGetValue<ICompositeObjectList<ICompositeObject>>("Lines" , out ICompositeObjectList<ICompositeObject> curLines)){
					foreach(ICompositeObject _Lines1 in curLines){
							_Lines1.TryGetValue<decimal>("Secondary_quantity_ctn" , out decimal Secondary_quantity_ctn); 
							lineItem.Add(Secondary_quantity_ctn);
				}	
			}
		}
	}
}

Also, we can utilize this without performing the Step 1 of Creating Nested Parameter Collection in Parameters of Business Process. Since the Web-Service already has the response parameter of same. But the parameter name from Webservice is always with a suffix _OUT





Iteration of Composite object collection is done through by following the Type<> in below Interface

ICompositeObjectList<TObject>

Interface ICompositeObject

 

BR,

Bhoobalan Palanivelu.

Dear Antoine, 

It's impossible to implement using basic application logic.

During single business process execution, it is possible only to upload files to a single object at once.

Hello, thank you for your answer.

I am not trying to upload multiple files.

I just want to ba able to add object references to an object collection parameter.

Let's say it like this:

- When you read Data from Creatio, if using filter others than ID, you get a collection of object. Which is stored into a "collection" variable.

-Now I have a collection, let say I read another object of the same type with anoter filter, I want to add that object to the above existing collection. How can I do that?

Thank you 

The code should look something like this:

// create collection/list or get from param
var list = new CompositeObjectList<CompositeObject>();
 
// create item and add to collection/list
var item = new CompositeObject();
item["SomeProperty"] = "Some value";
item["SomeOtherProperty"] = "Some value, etc";
list.Add(item);
 
// now set list in param
Set<CompositeObjectList<CompositeObject>>("MyCollectionParamName", list);

See https://customerfx.com/article/working-with-collection-parameters-in-a-…

Ryan 

Hi Bhoobalan, 

You are welcome to check a suitable solution by the link below: 

https://community.creatio.com/questions/use-script-task-update-column-r…

Get<ICompositeObjectList<ICompositeObject>> parameter should work for a collection of objects.

Regards,

Anastasiia

Anastasiia Markina,



Thanks. 

 

Hi,

I'm need to find the smallest price of a list of products. 

I get the list using the Read data element with the read collection of records mode.

In the script task I want to loop through all products and save the price if smaller than minPrice.

I created a process parameter with a type of Collection of records called: ProductsList and the value is set to the read element I mentioned above.

I have issue working with the collection.

I get the collection with the following script:

var productsList = Get<ICompositeObjectList<ICompositeObject>>("ProductsList");

foreach (var product in productsList)

{

      int price = ??????

       if (price<min)

            {

               min = price;

             }

}

I don't know how to continue on the foreach, how to get the price of the product.

I tried product.GetTypedColumnValue<int>("price"); 

but it doesn't work.

Can you please help me with this?

Thanks, 

Chani

I tried the following and it worked.

         if (item.TryGetValue<int>("UsrIntProductAcademicYear", out int value))

         {

             if(value<min);

             min=value;

         }