i am trying to add a dropdown data by calling a webservice

does anyone have some advice?

Hi Everyone, 

There is a sub process inside a main process, in which a web service (REST) is called but it is getting stuck due to operation timeout error (screenshot pasted). Our customer requested to bypass it if it is operation timeout so we checked that checkbox (Run current element in the background) in the subprocess. We thought that the main process now will not stop its execution even if the sub process stuck in the error state. But it is not and the main process is still stucking and not moving forward.

1. Following is the screenshot of the execution diagram of the main process where it got stuck at the subprocess - 

 

2. Following is the screenshot of the subprocess where the web service is called. 

3. Following is the screenshot of the error message - 

Can anyone please suggest how to handle this situation?

Thanks in advance.

Hi Community,

We have this requirement, where we need to receive a complex json object and then store it in our database as a string, without using DataContracts.

To achieve this we though about using the "object" type and then serialize it into a string using JsonConvert.SerializeObject method. 

	  [OperationContract]
	  [WebInvoke(Method = "POST", UriTemplate = "/store", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Bare, ResponseFormat = WebMessageFormat.Json)]
      public Response AddStore(object store) {
 
         Response response = new Response();
         response.MessageId = "1";
         response.Description = "Store Inserted!";
 
        string storeString = JsonConvert.SerializeObject(store, Formatting.Indented);
 
        var ins = new Insert(UserConnection)
        .Into("ImdStagingInArticle")
        .Set("ImdMessage", Column.Parameter(storeString))
        .Set("ImdStateId", Column.Parameter(new Guid("2d1dee23-058b-45fe-95a0-2e1612fc4261")));
 
        ins.Execute();
 
        return response;   
      }

However, the string is always empty. 

Since the json is to complex, the serializer cannot process the entire json data. 

We also tried to use WebOperationContext, but that doesn't work.

Can someone help us solve this issue? Did anyone have something similar?

Thank you.

Hey,

I have followed all the steps in Implement a custom web service that uses anonymous authentication | Creatio Academy

Note:  Using Local Creatio Env, Creation:Energy 8.2v

`UsrAnonymousConfigurationService` File
 

Error: Internal Server Error

why i get this error. i use update
... 0/odata/Contact(guid'123') to change number value

Hi everyone,

I’m working on a custom web service and tried integrating Npgsql. After encountering a "no namespace found" error, I took the following steps:

1. Added the Npgsql.dll file to the Tearsoft.web/bin directory.

2. Modified the web.config file with the following binding redirect:

   xml
    

3. <dependentAssembly>
       <assemblyIdentity name="Npgsql" publicKeyToken="5d8b90d52f46fda7" culture="neutral" />
       <bindingRedirect oldVersion="0.0.0.0-8.0.5.0" newVersion="8.0.5.0" />
   </dependentAssembly>
   

4. Restarted the IIS server.
5. Flushed Redis via the Clio CLI.

After these steps, I'm now facing the following error: Could not load file or assembly 'System.Data.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Screenshot attached for reference)

I've already checked assembly binding logging, but I’m unsure how to resolve this error. Any suggestions or help would be appreciated!
 

Additional Context:

• Working with PostgreSQL using Npgsql in the custom web service.
• I made changes to the web.config file after adding the Npgsql DLL.
  
  
  this is the current state for my local instance .
   

Thanks in advance!

Hi Creatio Community,

I am working on extending the existing implementation of the Execute method in the web service designer, which is part of a base package in Creatio. My goal is to modify the method to add additional functionality: specifically, I want to save the web service response as a record using an EntitySchemaQuery (ESQ), so that the response can be displayed in a custom section inside Creatio.

However, I am encountering a compilation error:

Error:
cannot convert from 'System.Collections.Generic.IEnumerable<Terrasoft.Configuration.ServiceSchemaParameter>' to 'System.Collections.Generic.IEnumerable<Terrasoft.Configuration.ServiceSchema.ServiceSchemaParameter>'

It appears that the system is having difficulty converting between two types that have the same name but are possibly from different namespaces. I am using ServiceSchemaParameter in my custom implementation, but the IServiceSchemaClient.Execute() method is expecting the parameter to be of a slightly different type.

Here’s an overview of my approach:

1. I've modified the Execute method to include an ESQ that logs the web service call and stores the response.
2. The issue arises when passing the parameters (of type List<ServiceSchemaParameter>) to the Execute method, where it's expecting IEnumerable<ServiceSchema.ServiceSchemaParameter>.
3. I believe the conflict is due to namespace ambiguity or mismatched types between base and custom implementations.
   
   My code: 
    

4. namespace Terrasoft.Configuration
   {
    
    
       using System;
       using System.Linq;
       using System.Collections.Generic;
       using System.Runtime.Serialization;
       using System.ServiceModel;
       using System.ServiceModel.Web;
       using System.ServiceModel.Activation;
       using Terrasoft.Core.Factories;
       using Terrasoft.Services;
       using Terrasoft.Web.Common;
       using Terrasoft.Core;
       using Terrasoft.Core.Entities;
       using Terrasoft.Configuration.ServiceSchema;
    
   	#region Class: CallServiceSchemaService
    
   	[ServiceContract]
   	[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
   	public class CallServiceSchemaService : BaseService
   	{
   		#region Methods: Public
    
   		[OperationContract]
   		[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,
   			ResponseFormat = WebMessageFormat.Json)]
   		public CallServiceSchemaResponse Execute(string serviceName, string methodName, List<ServiceSchemaParameter> parameters) {
   			if (parameters == null) {
   				parameters = new List<ServiceSchemaParameter>();
   			}
   			try {
   				UserConnection.DBSecurityEngine.CheckCanExecuteOperation("CanManageSolution");
    
   				// Getting the builder and client from the ClassFactory
   				var builder = ClassFactory.Get<IServiceSchemaParameterBuilder>();
   				var serviceSchemaClient = ClassFactory.Get<IServiceSchemaClient>();
    
   				// No need to cast, List<T> already implements IEnumerable<T>
   				var serviceResponse = serviceSchemaClient.Execute(UserConnection, serviceName, methodName, builder.Build(parameters.AsEnumerable()));
    
   				// Log the request and response
   				LogWebServiceCall(serviceName, methodName, parameters, serviceResponse);
    
   				return new CallServiceSchemaResponse(serviceResponse);
   			} catch (Exception e) {
   				return new CallServiceSchemaResponse(e);
   			}
   		}
    
   		#endregion
    
   		private void LogWebServiceCall(string serviceName, string methodName, List<ServiceSchemaParameter> parameters,
               IServiceClientResponse response = null, Exception error = null) {
               var entitySchema = UserConnection.EntitySchemaManager.GetInstanceByName("UsrWebServiceLog");
               var assignersEntity = entitySchema.CreateEntity(UserConnection);
               assignersEntity.SetDefColumnValues();
    
               assignersEntity.SetColumnValue("UsrServiceName", serviceName);
               assignersEntity.SetColumnValue("UsrMethodName", methodName);
               // Log additional columns if needed, as seen in your commented code
               assignersEntity.Save();
           }
    
   	}
    
   	#endregion
    
   	#region Class: CallServiceSchemaResponse
    
   	[DataContract(Name = "CallServiceSchemaResponse")]
   	public class CallServiceSchemaResponse : ConfigurationServiceResponse
   	{
   		#region Constructor: public
    
   		public CallServiceSchemaResponse(IServiceClientResponse serviceResponse) {
   			StatusCode = serviceResponse.StatusCode;
   			Success = serviceResponse.Success;
   			ResponseBody = serviceResponse.Body;
   			ResponseRawData = serviceResponse.RawDataResponse;
   			RequestBody = serviceResponse.RequestBody;
   			RequestRawData = serviceResponse.RawDataRequest;
   			ParameterValues = Newtonsoft.Json.JsonConvert.SerializeObject(serviceResponse.ParameterValues);
   		}
    
   		public CallServiceSchemaResponse(Exception e) : base(e) {}
    
   		#endregion
    
   		#region Properties: Public
    
   		[DataMember]
   		public int StatusCode;
    
   		[DataMember]
   		public string ParameterValues;
    
   		[DataMember]
   		public string RequestRawData;
    
   		[DataMember]
   		public string RequestBody;
    
   		[DataMember]
   		public string ResponseRawData;
    
   		[DataMember]
   		public string ResponseBody;
    
   		#endregion
   	}
    
   	#endregion
    
   	#region Class: ServiceSchemaParameter
    
   	[DataContract]
   	public class ServiceSchemaParameter
   	{
   		#region Properties: Internal
    
   		[DataMember(Name = "code")]
   		public string Code;
    
   		[DataMember(Name = "value")]
   		public object Value;
    
   		[DataMember(Name = "nested")]
   		public List<List<ServiceSchemaParameter>> NestedParameters;
    
   		#endregion
   	}
    
   	#endregion
   }
   

Request:
Could anyone guide me on how to properly resolve this type conversion issue? If there is a better way to manage the namespace or cast the types correctly, I would appreciate any advice or best practices to ensure compatibility between the types.

Thank you for your help!

Code Context:
CallServiceSchemaService.svc 
Service Designer Package

Looking forward to your suggestions and insights!

Hello. 

I'm doing an Web services to send a document to sign, the api request the Url of the document so I'm using the following link https:[creatio instance]/0/rest/FileService/GetFile/70ec5d9f-a55e-4f5c-8f59-30d2c5149c4a/ef68e95e-ef77-eddf-dfa8-685557ee4875

70ec5d9f-a55e-4f5c-8f59-30d2c5149c4a correspons to the  UId from the SysSchema table where the attachments are stored and the ef68e95e-ef77-eddf-dfa8-685557ee4875 is the Id of the attachment. This URL allows me to dowloand the document to my computer, so I know that is the right link but when I used it in the web service it says that there is no document. 

The json of the request is the following 

{
 
    "url_doc": {
 
        "url": "https://151929-crm-bundle.creatio.com/0/rest/FileService/GetFile/70ec5d9f-a55e-4f5c-8f59-30d2c5149c4a/ef68e95e-ef77-eddf-dfa8-685557ee4875",
 
        "name": "Contrato.pdf"
 
    },
 
    "stickers": [
 
        {
 
            "authority": "Vinculada a Correo Electronico por Liga",
 
            "stickerType": "line",
 
            "dataType": "email",
 
            "email":"laura@artica.digital",
 
            "data": "laura@artica.digital",
 
            "imageType": "stroke",
 
            "page": 0,
 
            "rect": {
 
                "lx":74.88173,
 
               "ly":312.32596,
 
               "tx":196.9875,
 
               "ty":373.37885
 
            }
 
        }
 
    ]
 
}

When I sent the request the response is 

{
    "error": "No document"
}

I had try this request with a Dropbox URL and works fine but I need to send the documents that are generated by the Word Reports. That why I'm trying to get the document from Creatio using the URL the API also gives me the option of sending the document using base64 but I dont know how to convert the file easly. 

Can you help me please to know what is happenig? 

Thank you

I am connecting a third-party API to Creatio, it delivers different types of data including this:
"user_id": [
60,
"Luismary Mendez"
]
In the parameters of the Creatio response I have set it as an Array Text and as an Object

But when I try to connect this variable to the process it does not display it in the list of possible result values.

The field is Vendedor: