Dear Ezequiel,

Please see the step-by-step instruction on how to correctly retrieve and work with web service collection result in business process Script Task. 



1. To start with, here are my test web service integration settings:











2. In the business process we will be retrieving needed data directly from the Web Service element. 

The main idea here is to address the results collection via "_Out" suffix. Please pay attention, that we apply suffix to the method's parameter and each variable taken from the collection.











 Regards,

Anastasia

AAlonso.29,

Hello.

Please find all of the images via the links below:

https://prnt.sc/m5x10n

https://prnt.sc/m5x0wj

https://prnt.sc/m5x2b5

https://prnt.sc/m5x2me

Best regards,

Matt

Hello Matt

I configured exactly the web service and the business process as in you screenshots but the following statement (My custom prefix is Rv instead of Usr)

var entities = Get<ICompositeObjectList<ICompositeObject>>("WebService1.RvArray_Out");

returns a null variable (entities is null).

The web service response is OK (I tried to show it on a page).

I also tried using this syntax:

var entities = Get<EntityCollection>("WebService1.RvArray_Out");

but the entities variable is still null.

Can you tell me what's wrong with my code?

Thank you very much

Massimiliano Mazzacurati,

It seems that webservice simply is not returning the desired array. To confident about this, you may create some test queries to the webservice in postman or fiddler (utilities for web development).  



However, you always can call the webservice in script task via c# code and then process the response from the webservice as you wish.

https://stackoverflow.com/questions/4015324/how-to-make-http-post-web-request



Best regards,

Alex

Hi,

I have a web service from which i fetching data like name, mobile number, email address. Response that is returned is an array. Now want to fetch email address and sent email to all the customers. I have attached the process diagram and task script :

Below is the script for fetching data from web service response: where can see console logs in creatio like values of name and email that have printed in the console.Writeline.

UsrParameter is the code of the response parameters. 

When i am sending simple response parameters like name and email script works without any error but when i send array as response i am getting error.

var entities = Get<ICompositeObjectList<ICompositeObject>>("WebService1.UsrParameter_Out");

foreach(var entity in entities){

    

     string name="";

     string email="";

     var isnameexist = entity.TryGetValue<string>("UsrName_Out", out name);

      throw new Exception(name);

    

     var isemailexist = entity.TryGetValue<string>("UsrEmail_Out", out email);

    throw new Exception(email);

    

     Console.WriteLine("name "+name);

      Console.WriteLine("email "+email);

     Console.WriteLine("isnameexist "+isnameexist);

      Console.WriteLine("isemailexist "+isemailexist);

    

}

return true;

Please help me solve this issue. I am new to creatio. I am struggling with script task element.

Thanks 

Nitin

Nitin,

Hello,

Try composing your approach with the one developed in the "Prepare Recipient Emails" script-task of the base "Send email to case group" business process:

The idea here is to form a list of recipients from a collection of the ESQ request result. You need to use your collection and develop a logic similar to the one developed in the script task.

Best regards,

Oscar

Oscar Dylan,

Thank you Oscar for reply 

Massimiliano Mazzacurati,

When we are fetching responses  from a web service,What is this "WebService1" in the double quotes? From where i can map this value?

Nitin,

here in advanced mode 

you can see the code for webservice and its parameters on 2nd tab

Dear Carlos,

To get the IMacrosInvokable interface, you have to add it first, by adding source code to the schema of your development package. Please, refer to the paragraph 'Creating the class which implements the IMacrosInvokable interface' of the guide. 

Apart from that you can use your own templates that are quite convenient as well. More details are in this article:

https://academy.bpmonline.com/documents/administration/7-13/how-create-…

Regards,

Dean

Dean Parrett,

The problem is that the interface IMacrosInvokable can not be found, so my source code doesn't compile.

Dear Carlos,

If you receive the error 'IMacrosInvokable' could not be found' that means that most likely you are not using the Service application. This guide and functionality are developed for Service applications only and the interface IMacrosInvokable' is developed in CaseService package of the IMacrosInvokable schema. It might me the reason for this error. Our R&D team is working on implementation of this functionality in different products, so you may expect it in the upcoming versions of the application.

Best regards,

Dean

Dean Parrett,

Ok, thank you.

Hello.

You can do it with the help of macros. First of all you need to create a template and select a desired macro source and then you can copy a part of the link without the record id like this and add a macro at the end of the link like this: http://test.bpmonline.com/0/Nui/ViewModule.aspx#CardModuleV2/AccountPag…]

That can be done without any additional configuration, you can also create an html link if you want (in order to hide the full link you will have to develop an html template block)

You can read more below:

https://academy.bpmonline.com/documents/administration/7-13/how-create-…

Best regards,

Matt

Thank's Matt, you solved my question

Could you please share the steps , I am unable to open this link . I also want to add a customised url link in my email body. 

Thanks

Shailey,

Hello,

Here is an example how I did it using "Accounts" section as an example (please refer to this screenshot http://prntscr.com/njtzkv). Please also note that I used account "Our company" as an example, but you can bind this process to a section if needed. Also please note that you need to build separate processes for different objects of the application. And here is my model of this process:

1) Create a "String" parameter in process parameters (you can read about it here https://academy.bpmonline.com/documents/technic-bpms/7-13/process-parameters). This parameter will be used to convert the ID of the record from "Accounts" object to "String" data type.

2) Add "Read data" element that will read all data from the object, from which the process should start (in my example it is "Accounts")

3) Create formula that will set the value of "http://o-drobina:8001/0/Nui/ViewModule.aspx#CardModuleV2/AccountPageV2/edit/"+[#Read data 1.First item of resulting collection.Id#].ToString()" for "Parameter 1" parameter. This value is formed as:

http://o-drobina:8001/0/Nui/ViewModule.aspx#CardModuleV2/AccountPageV2/edit/ ( which is standard link to the edit page of Account section record) + [#Read data 1.First item of resulting collection.Id#].ToString() (which is conversion of UID value read from "Read data" element to string). This conversion is needed, because the link should be text completely. And it will be used in "Send email" element in the next step.

4) In the "Send email" element please specify all needed parameters (To, from, CC etc.) and the email body should look like this http://prntscr.com/njtxoq.

As a result you will receive an email with link which can be used to redirect users to the needed record in the application http://prntscr.com/njtydz and http://prntscr.com/njtynp.

Best regards,

Oscar

Oscar Dylan,

Hi,

I tried doing what you suggested but get the link as a string and not as hyperlink.

How do I make it be a link?

I ended up creating a template message and there used the Link to object feature. (There you can also hind the full text and put different parameter for the view)

Hi,

Would still like to know how to get this work through the custom email and not template.

Thanks.

Anyone?

Dear Carlos,

you can use business rule which will fill and lock a certain field on a page if that is what you need. 

Angela Reyes,

I don't think that's it. I'm talking about column layout on details or sections and their sorting order.

Carlos Zaldivar Batista,

As for now there is no such functionality, but I'll submit a request to R&D team about this issue and suggest them to implement it. As a workaround you can inspect "column setup" button on a detail and add access right check or hide it for certain roles. 

Dear Carlos,

Unfortunately, there are no such pre-configured notifications, however you can install an application from our marketplace that will add a new detail 'Process' to the system, which will be tracking the statuses of your business processes.

After that you can make up a dashboard that will reflect the status of your business process by connecting it with that detail. Another option - you can create a new business process that will track this detail by 'failed' status.

For example, once your business process is failed you will receive an email notification. 

Here is the link to the application: 

https://marketplace.bpmonline.com/app/processes-log-view-bpmonline

Best regards,

Dean

The idea of creating a process that checks process log periodically seems ok, but it would mean that users are not notified about errors immediately. I tried to create a process that waits for SysProcessLog record creation or change of statuses to Error but it hasn't worked. It seems that inserts or updates to SysProcessLog table don't produce signals. Is there a workaround for that?

Dear Carlos,

Unfortunately, as for now the SysProcessLog table doesn't give the signal. The only option is to use the MarketPlace application a solution. Our system logic is still being developed and improved and most likely this functionality will be implemented in the upcoming system updates.

Best regards,

Dean

Dean Parrett,

Ok, thank you for the info.

Dear Sekhar,

Could you please provide the error message?

Anastasia

Dear Ezequiel,

This is quite complex development process. First of all you have to add a tracking links to your emails that will trigger and give the response once an email is opened.

Secondly, you will need to develop a web-service that will aggregate a response and record it with a timestamp in bpmonline. As far as I know there is no ready solution for it and it has to be implemented.

As a workaround for it,we can offer you to use the the marketing module of the application that has quite similar functionality available out of the box and there are no major adjustments required.

Best regards,

Dean

Dear Carlos, 

Thank you for your question.

Since the logic is executed on the back-end, the page has to  be reload for changes to display. However, there is an option to reload the data on the page automatically by adding a method 'this.reloadEntity();'  to your custom button handler method. As a result the page will be reloaded automatically by the system and changes will appear. 

Best regards, 

Dean

Dean Parrett,

Ok, thank you. I think that's what I was looking for.

Dear Carlos,

If a page you are displaying contains Feed it will be displayed on pre-configured element. 

Angela Reyes,

How to add that on a new page though?

Carlos Zaldivar Batista,

Feed tab can be inspected in BaseModulePageV2 from ESN package. To add Feed you'll need to transfer in you page schema diff: http://prntscr.com/lei5bx, add LocalizableStrings: http://prntscr.com/lei5ip and add all methods responsible for Feed tab functionality, like loadESNFeed, getSocialFeedSandboxId, initTabs, messages (http://prntscr.com/lei64z

) and ect. 

Hello,

I suppose, the same issue was discussed in this topic - https://community.bpmonline.com/questions/how-stop-redirection-new-orde…

You need to override 'onSaveButtonClick' method and set 'isSilent' parameter in order to stay on the page after save:

onSaveButtonClick: function() {

   if (this.get("IsProcessMode")) {

      this.save({ isSilent: true });

   } else {

      this.save();

   }

}

Tetiana Markova,

Hi Tetiana,

Thanks for the response. I have override the Save button in my child page as shown below but not successful. Can you please check and let me know what mistake I am doing?

Thanks,

Venkat.

Code:

==================================

{

                "operation": "insert",

                "name": "Save",

                "values": {

                    "itemType": 5,

                    "style": "green",

                    "caption": {

                        "bindTo": "Save"

                    },

                    "click": {

                        "bindTo": "onSaveButtonClick"

                    },

                    "enabled": {

                        "bindTo": "canEntityBeOperated"

                    },

                    "classes": {

                        "textClass": [

                            "actions-button-margin-right"

                        ]

                    }

                },

                "parentName": "LeftContainer",

                "propertyName": "items",

                "index": 5

            }

==============================

onSaveButtonClick: function() {

                 if (this.get("IsProcessMode")) {

                     this.save({ isSilent: true });

                 }

                 else{

                     this.save();

                 }

            }

Let's try another approach by overriding save() method for your child edit page:

  methods: {

            save: function(config) {

                if (config) {

                    config.isSilent = true;

                }

                else {

                    config = {

                        isSilent: true

                    };

                }

                this.callParent([config]);

            }

        },

Tetiana Markova,

Thanks a lot. That worked like a gem.. Thanks Again..