Hi Federico,

As far as I know, there is no direct way to call this type of web service from a client side, however, there is a small trick you can do. You can configure a business-process to run your service and on the client side, you can run this process.

Also, I will registrate your suggestion to our R&D team, thank you for giving us ideas to improve.

That service is being called from BaseOrderPage. In that schema there is a function that calls it named "initializePredefinedPriceList" (the actual service being called is defined in "getPriceListServiceConfig")

Ryan

Ryan Farley,

Thanks, Ryan!



Hopefully, this Base Order page is allowed in Replacing View model. It can override the getPriceListServiceConfig calling method and define a custom web service to filter the products with custom parameters.





BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

Yes, you should have no issue creating a replacing schema for BaseOrderPage and then override the methods as needed.

Ryan

Ryan Farley,



Thanks!

When the (+) is clicked in Product detail (in the order section) it opens a Product List page though the detail is editable. Where is the code for add record icon and it's not available in "OrderProductDetailV2" ? and how does this product list page is opened (ProductSelectionSchema).



Step 1: Which client schema page has this add event?

Step 2: How does the Account & Price List filter is applied to Product List page.





Insight on the Schema's name and the place where the code triggering the corresponding action will be helpful.





BR,

BHoobalan Palanivelu.

Bhoobalan Palanivelu,

Hello Bhoobalan

Please do you have a suggestion on how to implement the Product Catalog that appears in the order Section, for opportunity Products in Opportunity section. Your suggestions are much appreciated !

Found the answer for this mentioned issue, Please refer to the code below. Using IProcessExecutor, this can be simply achieved in the 8.0 version.

/* The custom namespace. */

namespace Terrasoft.Configuration.WSO2WSConfirmationServiceNamespace

{

    using System;

    using System.ServiceModel;

    using System.Collections.Generic;

    using System.ServiceModel.Web;

    using System.ServiceModel.Activation;

    using Terrasoft.Core;

    using Terrasoft.Web.Common;

    using Terrasoft.Core.Entities;

    using Terrasoft.Core.Entities.Events;

    using Terrasoft.Core.Process;

    using Terrasoft.Core.Process.Configuration;

    [ServiceContract]

    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]

    public class WSO2WSConfirmationService : BaseService

    {

        /* The link to the UserConnection instance required to access the database. */

        private SystemUserConnection _systemUserConnection;

        private SystemUserConnection SystemUserConnection

        {

            get

            {

                return _systemUserConnection ?? (_systemUserConnection = (SystemUserConnection)AppConnection.SystemUserConnection);

            }

        }

        /* The method that returns the confirmation of buttons. */

        [OperationContract]

        [WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,

        ResponseFormat = WebMessageFormat.Json)]

        public string ConfirmationService(string guid, bool status)

        {

            try

            {

                new Guid(guid);

                string result = "Guid is missing";

                if (!string.IsNullOrEmpty(guid))

                {

                    if (status == false)

                    {

                        {

                            // getting  IProcessExecutor

                            IProcessExecutor processExecutor = SystemUserConnection.ProcessEngine.ProcessExecutor;

                            // List of input parameters

                            var inputParameters = new Dictionary<string, string>

                            {

                                ["ConfirmationId"] = guid.ToString(),

                            };

                            //code of the process

                            string processSchemaName = "WSO2Process_3c0d24aCustom1";

                            //execute the process

                            ProcessDescriptor processDescriptor = processExecutor.Execute(processSchemaName, inputParameters);

                            //return processDescriptor;

                        }

                        

                        result = "Response posting is cancelled, You can close this tab";

                    }

                    else

                    {

                        result = "WSO2 endpoint intergration is pending";

                    }

                }

                return result;

            }

            catch (Exception ex)

            {

                return "GUID error - " + ex.Message; 

            }

            

        }

    }

}

Thanks

I've performed the same setup (additionally to the code you've shared, registered the service as anonymous) and sent the following request in Postman:

As you can see the result is correct so the issue is somewhere in the request you send or in the service settings. You need to double-check them.

Dear Jonathan,

Unfortunately, there is no OOB functionality for transferring data sets (IsArray type) to web service parameters by not the 'Read data" element.

 We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.  

Best regards,

Bogdan

Bogdan,

I have this situation when setting up the Web Service :

When i call the WebService process element, the field automatically fills like this :

And with this element, it is impossible to send an array of strings like set in the webservice request parameter isn't it ?

If we have a JSON like :

"Assistant": [

{

"string": "hello world"

}

]

Where the "string" value is set in "Sélectionner la valeur" on the screenshot above. So there is really no way of sending an array of strings, really ?

When I test the request directly from the WebService section, I can just add lines to the array and manually setting values into it. Isn't there a way to do it automatically ?

Let me ask the question in a different way, how could I send an array of strings via the "Read data" element of the business process ?

Many thanks,

Jonathan

Jonathan Quendoz,

If the request parameter is a collection (the “Is array” checkbox is selected in the properties of the parameter at the web service record), the nested collection parameters will be displayed under the collection name in the process element parameters (Fig. 3). For example, Creatio “batch query” service can insert several records (e.g. contacts) to Creatio. To do this, the service would require information to write into the fields of each inserted record (e.g. contact names and types). In this case, you can pass the values as a request parameter of an array type, where “Name” and “Type” will be nested parameters and each instance of the collection would represent data for a separate contact record.

The values of collection parameters of one [ Call web service ] process element can be mapped to the nested parameters of another collection of a [ Read data ] or [ Call web service ] process element.

The parameters of the collection of process elements can be mapped to the process parameter of the “Collection of values” data type.

Please refer to the article here.

Best regards,

Bogdan

Jonathan Quendoz,

Hi! How are you? I'm running on the same problem. Did you find a solution? Appreciate it.

Regards

Uriel Nusenbaum,

Hi Uriel ! 

Unfortunately, I did not found a solution to this problem. 

I asked to the WebService supplier to adjust their webservice to have an array of structure of strings as json paramater instead of just an array of strings.

At the moment, I think that besides calling a WebService via C# in back-end, it is not possible to send an array of strings as parameter. It should really be reworked from Creatio.

You can only send an array of a structure of strings via a sequentiel sub-process.

Please, if you have any questions about this, do not hesitate.

Best regards,

Jonathan

Good day. Have there been any new solutions to this problem in recent versions?

Hi Jonathan, 

Please add the next using -     

     using Terrasoft.Common;   

on the top of the page(if you didn't have this one). 

Then in the part of the code when you are trying to retrieve the age:

if (name.IsNullOrEmpty())

{

return 0;

}

else

{

return age;

}

Best Regards, 

Bogdan L.

Hi Jonathan,

Usually you use dataReader to get the value from your select query. What you can do is:

bool hasRecord = false;
using (DBExecutor executor = UserConnection.EnsureDBConnection()) {
using (IDataReader dataReader = select.ExecuteReader(executor)) {
  while (dataReader.Read()) {
    hasRecord  = true;
  }
 }
}
if(hasrecord){
  return age
}else{
  return 0
}

Or you can just set the default value of the age =0. Therefore if the dataReader does not return any record, the default value age (0) will be returned.



regards,

Cheng Gong

Bogdan Lesyk,

Thanks for your answer. It helped a lot !

Cheng Gong,

Your answer is really perfect ! Thanks a lot, i'll definitely save this snippet of code for my future implementations.

Regards,

Jonathan

Hi Jonathan,

When you create a custom detail for a custom section there is always some column that is used for connection. Let's take your example with noteworthy events of contacts. The table that represents noteworthy events of contacts in the database is called ContactAnniversary and if you perform a SELECT query to it:

SELECT TOP 1 * FROM ContactAnniversary --MS SQL
SELECT * FROM "ContactAnniversary" LIMIT 1 --PostgreSQL

You will see that the column that is used for connecting the "Contact" table and  the "ContactAnniversary" table is "ContactId":

So you need to use this column as a reference.

As for the custom section - when you add some detail to the custom section you also specify some column to connect detail and the section. This is also described here (see "Add an existing detail to a record page" paragraph and step 6.(c-d)). And the "Where detail column" field contains the column that connects your detail with your section and it should be used as a connection in your webservice.

Best regards,

Oscar

Oscar Dylan,

Hey, thanks a lot for your useful answer. By the way, how can you query this foreign key column ? 

For example :

var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "ContactAnniversary");

var contactColForeignId = esq.AddColumn("ContactId");

Doesn't work because, I think, that is doesn't recognize it as a real "column" in the "ContactAnniversary" object. How can I fetch this foreign ID in a C# code and then saying that the Foreign Id of the "ContactAnniversary" object must correspond to the Id of the "Contact" ?

Thanks a lot for your help Oscar ! :)

Jonathan Quendoz,

You shouldn't use an Id suffix for the column name. Esq uses an actual column name from the object (which is "Contact"). So you need to use:

var contactColForeignId = esq.AddColumn("Contact");

And then it will find the column correctly.

Best regards,

Oscar

Oscar Dylan,

Thanks for your answer, now I encounter another problem :

Let me take another example :

var result = " ";

var esqAnniversary = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "ContactAnniversary");

var esqContact = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Contact");

var esqColId = esqAnniversary .AddColumn("Id");

var esqColForeignId = esqAnniversary .AddColumn("Contact.Id");

var esqContactColId = esqContact.AddColumn("Id");

var esqContactColName = esqContact.AddColumn("Name");

Then I initialize an entity collection :

var entites = esq.GetEntityCollection(UserConnection);

How can I query, through a filter, both the esq ?

Like :

First I filter through the Contact I want :

var esqFilterContact = esqContact.CreateFilterWithParameters(FilterComparisonType.Equal, esqContactColName.Name, parameter);

var esqFilterId = esqAnniversary.CreateFilterWithParameters(FilterComparisonType.Equal, esqColForeignId.Name, esqContactColId.Name);

So I take only the detail corresponding to the name of the contact in parameter ?

How can I do a query like this ? My example doesn't work, can you help me troubleshooting this ?

Hopefully you can understand my problem and help me through this !

Best regards,

Jonathan

Hi Robert, 

Usually such operations is performed by using OData: 

https://academy.creatio.com/docs/developer/integrations_and_api/data_se…

https://documenter.getpostman.com/view/10204500/SztHX5Qb?version=latest

Please also check out this articles to find some useful tips: 

[Call web service] process element -

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

API Keys - 

https://swagger.io/docs/specification/authentication/api-keys/

Regards, 

Bogdan L.

Hi Bogdan,

thanks for the answer!

However, that's not quite what I was looking for ;)

I know of OData and how to use it. Unfortunately, the 3rd party service doesn't support it.

What I'm looking for is actually a way to add custom headers to HTTP requests when calling external web services via business processes.

I know I could use a script task and program it myself, but I was wondering if it also worked when using the standard web service integration.

Thanks,

Robert

Robert Pordes,

Actually we don't have practical examples of such implementation. 

So in this case as you said you may use a script task to achieve required result. 

Probably the link of how to Run business process via web-service will be also useful for you:

https://academy.creatio.com/docs/developer/front-end_development/creati…

Thank you! 

Regards, 

Bogdan L.

Hi Raz,

For this kind of requests OData has Butch. 

Please follow the link to check the details of how to work with it: 

https://academy.creatio.com/docs/developer/integrations_and_api/data_se…

Best Regards, 

Bogdan L.

Bogdan Lesyk,

Hi Bogdan,

Thank you for your response and article.

I didn't understand how the batch requests solves my scenaro.

I'll elaborate:

I have a woocommerce website that needs to update creatio every time there is a new order.

The woocommerce json looks like this:

{

 "id": 1234,

"status": "ABC",

"Line_Items": [ {"prod_id":1111,"quantity":10},{"prod_id":2222,"quantity":20}],

"Order_Lines": [],

"Coupon_LInes": []

}

As you can see one Json includes all the order data.

In Creatio for each array, like Line_Items, Order_Lines and etc, we have a detail connected to the order section.

Is there a way to use the ODATA Web services mechanism in such a way that the woocommerce website can update all the relevant sections and details?

Thanks,

Raz

Hi Raz, 

Unfortunately we don't have practical examples of such implementation.

{

 "id": 1234,

"status": "ABC",

"Line_Items": [ {"prod_id":1111,"quantity":10},{"prod_id":2222,"quantity":20}],

"Order_Lines": [],

"Coupon_LInes": []

}

Most likely this code will not work, because Line_Items, Order_Lines and etc. will be perceived by the system like "field". 

You may create one order, in response you will get it's "Id" and then with using batch you may add  couple records in your details.

Best Regards, 

Bogdan L.

Bogdan Lesyk,

Thank you for your response