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.

string name = string.Empty;
string email = string.Empty;
Guid RecordId = Guid.Empty;
 
/**
 * This approach should not be used in production
 * Please create process parameters and set values with standard tools (i.e. Formula)
 * ReadDataUserTask1 is the Code of "Read One Contact" element
 */
var re = context.Process.FindFlowElementByName("ReadDataUserTask1").GetPropertyValue("ResultEntity");
 
if (re.TryGetPropertyValue("Email", out object _email))
{
	email = _email.ToString();
}
 
if (re.TryGetPropertyValue("Name", out object _name))
{
	name = _name.ToString();
}
 
if (re.TryGetPropertyValue("Id", out object _id))
{
	if(Guid.TryParse(_id.ToString(), out Guid Id))
	{
		RecordId = Id;
	}
}
 
//Set values to process parameters
Set<string>("Name", name);
Set<string>("Email", email);
Set<Guid>("RecordId", RecordId);
 
return true;

Kirill Krylov CPA,

Hi Kirill,

I don't understand you code.

So if shouldn't use this code in production.

what should I do?

I don't manage to get the values from ResultEntry.

Thanks,

Raz

Kirill Krylov CPA,

Your code is exactly what I need if I don't want to use "get a set of records" and if I don't what to use the "Formula" process element.

Why not to use it in production?

I think it depends. If the quantity of fields you need is static and will not change, you can just read individual values and point them to specific fields. If it is a variable, its more complex. 

I am limited in coding, so I would do this as a detail rather than fields. You would have to code something special, I think, to get a variable quantity of fields to display. But with a detail, it will scale with the number of records you want to show. You can also change the detail to an "Editable Detail" if you want the user to edit the values inline. You can either have the detail show the actual records for direct editing, or you can setup a sort of temporary object for the detail that you read and write to that then you can use later.

Hi Reid,

Thank you for your answer. I do get your point and even I was thinking along the same lines.

The issue that I am facing right now, is when I'm trying to call a web-service in the business process, using the "Call web-service" element, the response of that web-service is a collection of objects, and any element (Auto-generated Page/Pre-configured page/etc) that I add after this web-service element, does not take that collection of objects at all. It only takes the "Response body" as the value. And when I map the individual values somehow, they do not reflect the results as desired, because they can't just pick one value out of a collection of values randomly, and hence the fields show blank in the result.

So I'm just trying to figure out if this out-of-the-box functionality works only for individual fields or for collection of objects also. 

Hi Raz, 

Could you please provide a full script-task code you use so we will be able to test it at our end?

Regards,

Anastasiia

Dear Paulina,

The task you described can be implemented via the process, but it will require some additional development. When the process reads tasks and sends an email script task should be used since send email element cannot work with collections. An example of such a script task can be found in process Send email to case contact. Also, similar task but without development is described in this post: https://community.creatio.com/questions/sending-email-collection-records-if-reorder-date-record-equals-current-date. If you want to send separate emails for task owners I would recommend adding tags to records to distinct processed tasks. 

Best regards,

Angela

Angela Reyes,

Thank you Angela. I will try to work with tags to avoid the development

BR Paulina

I have also been successful in using the new upcoming functionality that was tested in the 7.16.1 release to feed a collection into a subprocess. If the email is relatively simple and the variables are limited, you can send a collection to a simple subprocess that sends an email to the contact list in the collection but generating a new process for each item in the collection. But for more complex emails, creating a loop like the tag example is your best bet. Also, you can use tags, or you can create a boolean in the section to loop through that can be turned on and off.