collection | Community Creatio

Question

11:31 Sep 16, 2019

I have been struggling very much with handling collection type response parameters in web services.

When response parameters are or normal type they are very easy to handle in the business processes. Here we are able to handle them as parameters on the Call web service process element. And use these in the process right away.

When there is a Collection which is returned, this is very different. Now the Call web service element parameter is of type Collection of Objects with attributes.

It seems to me that this parameter-type is very difficult to handle in the business process. I can't seem to find documentation in the Academy about how to extract and loop through the contents of the Collection of Objects with attributes.

What I have found in the academy is this article about setting up the Web service.
https://academy.bpmonline.com/documents/administration/7-14/adding-resp…

What I need to learn is how to handle them in bpm'online business processes.
Is there something about this in the Academy?
Is writing source code the only option? It's difficult to debug.

Bookmark this

3 comments

Norton Lingard

18:05 Sep 16, 2019

Dear Julius,

Unfortunately, it is impossible to handle parameters that have the “collection of object” type without using the source code.

Therefore, in this case we recommend using “ScriptTask” element for both calling the web-service and processing the results of call.

For more detailed assistance, please contact technical support.

Best regards,

Norton

Julius

09:20 Sep 17, 2019

Norton Lingard, Thank you. Is there anything like this in the academy? Because there is a special bpm'online syntax to go by in the source-code.

Norton Lingard

17:00 Sep 17, 2019

Dear Julius,

The service call in a "Script task” business process element can be implemented via native C#. Please find a lot of examples on how to do that in Google. For example, several links below:

https://stackoverflow.com/questions/9620278/how-do-i-make-calls-to-a-rest-api-using-c

https://code-maze.com/different-ways-consume-restful-api-csharp/

Please note that it is possible to use the native C# collections instead of working with the the special bpmonline collections.

Best regards,

Norton

Show all comments

Question

Filter OpportunityFileCollection by Opportunity using ODATA

Radu Pop

14:04 Dec 18, 2018

Hi,

I'm trying to get a list of OpportunityFile associated with an OpportunityId and it's seems it's not possible using ODATA.

1. If I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… I'm getting a "Not Implemented" exception

&lt;error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"&gt;
&lt;script/&gt;
&lt;code&gt;4&lt;/code&gt;
&lt;message xml:lang=""&gt;Not Implemented&lt;/message&gt;
&lt;innererror&gt;
&lt;message&gt;Not Implemented&lt;/message&gt;
&lt;type&gt;System.Data.Services.DataServiceException&lt;/type&gt;
&lt;stacktrace&gt;
at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
 at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService, IODataResponseMessage responseMessage)
 at System.Data.Services.DataService`1.HandleRequest()
&lt;/stacktrace&gt;
&lt;internalexception&gt;
&lt;message&gt;Method 'SelectMany' not supported&lt;/message&gt;
&lt;type&gt;System.NotSupportedException&lt;/type&gt;
&lt;stacktrace&gt;
at Terrasoft.Core.Entities.EntityQueryProvider.VisitMethodCall(MethodCallExpression node)
 at Terrasoft.Core.Entities.EntityQueryProvider.Build(Expression expression)
 at Terrasoft.Core.Entities.EntityQueryProvider.LoadEntityCollection(Expression expression)
 at Terrasoft.Core.Entities.EntityQueryProvider.ExecuteEnumerable(Type elementType, Expression expression)
 at Terrasoft.Core.Entities.EntityQuery`1.GetEnumerator()
 at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
&lt;/stacktrace&gt;
&lt;/internalexception&gt;
&lt;/innererror&gt;
&lt;/error&gt;

2. If I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… eq guid'e14b9eb7-99ff-43a6-bf26-a60b23b3ec12') I'm getting the following exception:

&lt;error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"&gt;
&lt;script/&gt;
&lt;code&gt;1&lt;/code&gt;
&lt;message xml:lang=""&gt;Collection item with name OpportunityId not found.&lt;/message&gt;
&lt;innererror&gt;
&lt;message&gt;Collection item with name OpportunityId not found.&lt;/message&gt;
&lt;type&gt;Terrasoft.Common.ItemNotFoundException&lt;/type&gt;
&lt;stacktrace&gt;
at Terrasoft.Core.Entities.EntitySchema.GetSchemaColumnByPath(String columnPath)
 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateExpression(Expression node)
 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateSimpleFilter(BinaryExpression binary)
 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateFilter(Expression node)
 at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.BuildBlock(MethodCallExpression node)
 at Terrasoft.Core.Entities.EntityQueryProvider.VisitMethodCall(MethodCallExpression node)
 at Terrasoft.Core.Entities.EntityQueryProvider.Build(Expression expression)
 at Terrasoft.Core.Entities.EntityQueryProvider.LoadEntityCollection(Expression expression)
 at Terrasoft.Core.Entities.EntityQueryProvider.ExecuteEnumerable(Type elementType, Expression expression)
 at Terrasoft.Core.Entities.EntityQuery`1.GetEnumerator()
 at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
 at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService, IODataResponseMessage responseMessage)
 at System.Data.Services.DataService`1.HandleRequest()
&lt;/stacktrace&gt;
&lt;/innererror&gt;
&lt;/error&gt;

3. Also, if I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… eq guid'b3427cc4-3b20-4c16-8d2a-058ada7e7631') I'm getting a different error.

&lt;error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"&gt;
&lt;script/&gt;
&lt;code&gt;4&lt;/code&gt;
&lt;message xml:lang=""&gt;Syntax error at position 1.&lt;/message&gt;
&lt;innererror&gt;
&lt;message&gt;Syntax error at position 1.&lt;/message&gt;
&lt;type&gt;System.Data.Services.DataServiceException&lt;/type&gt;
&lt;stacktrace&gt;
at System.Data.Services.Parsing.ExpressionLexer.ValidateToken(TokenId t)
 at System.Data.Services.Parsing.ExpressionLexer.ReadDottedIdentifier(Boolean allowEndWithDotStar)
 at System.Data.Services.RequestQueryProcessor.ReadExpandOrSelect(String value, Boolean select, IDataService dataService)
 at System.Data.Services.RequestQueryProcessor.ProcessSelect()
 at System.Data.Services.RequestQueryProcessor.ProcessQuery()
 at System.Data.Services.RequestQueryProcessor.ProcessQuery(IDataService service, RequestDescription description)
 at System.Data.Services.RequestUriProcessor.ProcessRequestUri(Uri absoluteRequestUri, IDataService service, Boolean internalQuery)
 at System.Data.Services.DataService`1.HandleRequest()
&lt;/stacktrace&gt;
&lt;/innererror&gt;
&lt;/error&gt;

It seems the filtering is not working on associated collection entities. Do you have any ideas?

Regards,

Radu

Bookmark this

1 comments

Anastasia Botezat

13:14 Dec 19, 2018

Dear Radu,

Please see the example below. Draw your attention to the column OpportunityId syntax - Opportunity/Id

http://localhost:8006/0/ServiceModel/EntityDataService.svc/OpportunityF… = Opportunity/Id eq guid'410006e1-ca4e-4502-a9ec-e54d922d2c00'

Regards,

Anastasia

Show all comments

Question

Use Collection parameter in script task

Federico Buffa

22:12 Dec 06, 2017

Hello community!

I need get in a bussines process a collection parameter and then use that in a script task into a foreach. Any example about that?

Regards,

Bookmark this

5 comments

Lily Johnson

20:19 Dec 07, 2017

Dear Federico,

Please check the instructions on how to work with collections within [Read data element]. This will help you to implement your own process.

Algorithm of the work with a collection from Read data:

1.Disable the formula validator in business process designer. You can open the console and execute the following script for that:
var featureCode = "UseProcessFormulaServerValidation";
require(["FeatureServiceRequest"], function() {
var featureRequest = Ext.create("Terrasoft.FeatureServiceRequest", {code: featureCode});
featureRequest.updateFeatureState({
forAllUsers: true,
state: Terrasoft.FeatureState.DISABLED // ENABLED
}, ()=>console.log("Done"));
});

2. In [Read data] element go to extended options and tick:
Read first = true
Number of records to read = 100 //Number of records available in a collection.

3. Create a process parameter with EntityCollection type and map it to the resulting collection of [Read data]. This parameter does not exist out of the box, but you can create it manually.
Example:
[#MyRead.Resulting collection#]
* MyRead – [Read data] element header.
* Resulting Collection - added manually

4. Assign a process parameter to a new variable in ScriptTask. Here is the example how to process the collection:
EntityCollection entities = Get("MyEntity");
var result = new Collection();
foreach(Entity entity in entities) {
var cityName = entity.GetTypedColumnValue("Id");
string temp = cityName.ToString();
result.Add(temp);
}

string displayValue = result.ConcatIfNotEmpty(",");
Set("MyResult", displayValue);
return true;

MyRead – reading datat in any element.
MyEntity process parameter with EntityCollection type. Parameter value= [#MyRead.Resulting collection#]
MyResult - string parameter. You can store record IDs from the collection. Then this parameter is shown on the auto generated page for the testing purposes.

Best regards,

Lily

Riddhi Jadeja

10:59 Feb 10, 2020

Lily Johnson,

Hello,

I tried the above script task as below:

EntityCollection entities = Get("MyEntity");
var result = new Collection();
foreach(Entity entity in entities) {
var productName = entity.GetTypedColumnValue("Name");
string temp = productName.ToString();
result.Add(temp);
}
string displayValue = result.ConcatIfNotEmpty(",");
Set("UsrLatestOrderProduct", displayValue);
return true;

But, here I'm getting below errors:

Sarthak Jain

07:16 Apr 16, 2020

Lily Johnson,

Hello,

Can you elaborate on how Auto-Generated Page works upon this case?

Many Thanks

Roman Brown

15:26 May 04, 2020

Riddhi Jadeja,

As we can see from the screenshots you have provided - GetTypedColumnValue is used incorrectly.
GetTypedColumnValue("Name") is used without specified type of this field.
It should be GetTypedColumnValue<string>("Name")

Kind regards,
Roman

Roman Brown

15:28 May 04, 2020

Sarthak Jain,

Can you please specify your question with more details?
How exactly Auto-Generated Page will be related to the discussed case?

Thank you in advance,
Roman

Show all comments

Subscribe to collection