Hi community,

I’m working on a custom web service in Creatio that connects to an external PostgreSQL database deployed on Neon. My goal is to query data from this external database, acting like a custom ORM. However, I’m running into an issue with using the Npgsql package inside Creatio’s source code.

I’ve added the necessary references, but I keep getting the following error:

The type or namespace name 'Npgsql' could not be found (are you missing a using directive or an assembly reference?)

I’ve already added the Npgsql.dll to the Terrasoft.web/bin folder and modified the web.config to include a binding redirect for Npgsql. After restarting the IIS server and flushing Redis, I now get a 'System.Data.Common' assembly error.

Here’s the code I’m using:

using Npgsql;
using System;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.ServiceModel.Activation;
using System.Data;
using System.Collections.Generic;
using Terrasoft.Core;
using Terrasoft.Web.Common;
 
namespace Terrasoft.Configuration
{
    [ServiceContract]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
    public class PostgresService : BaseService
    {
        private string connectionString;
 
        public PostgresService()
        {
            // PostgreSQL connection string
            connectionString = "Host=your_host;Port=5432;Database=your_database;Username=your_username;Password=your_password";
        }
 
        [OperationContract]
        [WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json,
            BodyStyle = WebMessageBodyStyle.Wrapped, UriTemplate = "GetData")]
        public List<Dictionary<string, object>> GetData()
        {
            var result = new List<Dictionary<string, object>>();
            try
            {
                using (var connection = new NpgsqlConnection(connectionString))
                {
                    connection.Open();
                    string sql = "SELECT * FROM users LIMIT 100";
 
                    using (var cmd = new NpgsqlCommand(sql, connection))
                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var row = new Dictionary<string, object>();
                            for (int i = 0; i < reader.FieldCount; i++)
                            {
                                row.Add(reader.GetName(i), reader.GetValue(i));
                            }
                            result.Add(row);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception($"Error retrieving data: {ex.Message}");
            }
 
            return result;
        }
 
 
 
    }
}

Hello Creatio Community,

I am working on a project where I need to either replace or override an existing Creatio web service with a custom implementation. Specifically, I want to extend or modify the functionality of a base Creatio web service (e.g., CallServiceSchemaService) to fit my business requirements.

Here’s what I want to achieve:

• Create a custom web service in a separate package without affecting the existing functionality of the base service.
• Either extend the existing service (if possible) or completely replace it with my custom implementation.
• I want to customize the behavior of how service requests and responses are handled, while ensuring that all references to the original service use my new service.

Questions:

1. What is the best approach to achieve this in Creatio? Should I extend or replace the service, and what are the steps to do so?
2. How can I ensure that the system references my custom service in place of the base service without breaking existing functionality?
3. Are there any best practices or limitations I should keep in mind when implementing custom web services in Creatio?

I would appreciate any guidance, examples, or documentation that can help me with this process.

Thank you!

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!

Hi All, I have setup a web service in Creatio that is working fine when I send parameters with data.

Sometimes I gonna call thie web service without all the parameters on the query, just one or more, it will depends on othe step before.

Is there a way to have a web service set up in Creatio with all parameters, but only make the call using the parameters that are not null?

Hello,

I am trying to automate the gathering of data using some business process that perform API calls to one of our client private APIs. I have defined the WebServices with no problem like the one from this example:

And sending the test request with a valid API Key and Authorization token works perfectly. However, if I try to group all of this inside a business process I get an error that I don't know how to solve. This is the business process:

And the error that I get exactly on the web service call is this one:

The full error message states:

Terrasoft.Common.UnsupportedTypeException: Type "System.Collections.Generic.List`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" is not supported.

 

I have done some tests and I can confirm that the error only appears when I try to use a the valid Authorization token retrieved previously, and if I set any other value in that Web Service parameter I don't get the error but obviously the call fails because I am using and incorrect token.

The length of the token is 299 characters and as it is an authorization token, it must be preceded by the word "Bearer", so the full value that I am passing to that parameter is "Bearer " with a total length of 306 characters. I also tested using some random strings of length 500+ and the error doesn't show up, so it is not related to a limit of the parameter length. I also checked that the token I am passing is 'correct', i.e. no breaklines, weird characters (not UTF-8) or anything that could cause problems with the encoding of the string.

Therefore, I guess it is something related to the way Creatio builds the API request from inside the process, that is not the same as doing from a test request inside the Web Service...

Your help is highly appreciated.

Regards.

Hi,

I'm trying to pass the result of below "json" (in script task),

var schema = UserConnection.EntitySchemaManager.GetInstanceByName("Account");

    var entity = schema.CreateEntity(UserConnection);

    entity.FetchFromDB(id);

    json = Terrasoft.Core.Entities.Entity.SerializeToJson(entity);

to a process parameter and that process parameter needs to be passed to web service element as an request object. Since, the structure of "json" variable might vary, how to send this to a process parameter and eventually to web service element?

Any suggestions would be appreciated. Thanks.

Hello team,

I have exposed an endpoint, but keep recieveing the 404 (Endpoint not found) when i call it from postman.

I have followed: https://academy.creatio.com/docs/developer/getting_started/develop_appl…

Is there any other prior configurations that need to be done in order to recieve a status 200?

Thank you

Sasori

Hi,

I have begun playing with the web service integration capabilities within a process to send a message to a Teams channel. Obviously many use cases exist for having a message sent to a Team channel.

I have been able to successfully send a message to a channel, however I am having issues in managing the formatting of the message, so a clear title, and message body structure can be provided. Has anyone got any integration working with Teams that would be prepared to share how the web service, variables etc. are configured to allow formatted messages to be sent?

Thanks in advance.

Hi all

I have created a web service that accepts values from a third party server. Next, I need to transfer one value from the request to the section field.

Question:

How do I call my finished web service in C#?

Hello all,

I am trying to enable access for a portal user to trigger a service within Creatio. I'm following the steps as listed in this academy page but when I try to declare _baseService and publish, I receive an error saying that GlbInterviewService is "'GlbInterviewService' is a namespace but is used like a type"

namespace Terrasoft.Configuration.KeenGlbInterviewService
{
	using System;
	using System.IO;
	using System.Collections.Specialized;
	using System.Globalization;
	using System.Runtime;
	using System.Runtime.Serialization;
	using System.ServiceModel;
	using System.ServiceModel.Web;
	using System.ServiceModel.Activation;
	using System.Threading;
	using System.Threading.Tasks;
	using System.Web;
	using Terrasoft.Core;
	using Terrasoft.Core.Factories;
	using Terrasoft.Web.Common;
    using Terrasoft.Web.Common.ServiceRouting;
 
	#region Class: KeenGlbInterviewService
 
	[DefaultServiceRoute, SspServiceRoute]
	[ServiceContract]
	[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
	public class KeenGlbInterviewService : BaseService
	{
 
		#region Methods: Public
		private static readonly GlbInterviewService _baseService = new GlbInterviewService();
 
		[OperationContract]
		[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
		public InterviewServiceResponse Start(InterviewServiceRequest request)
		{
			return _baseService.Start(request); 
		}
 
		[OperationContract]
		[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
		public InterviewServiceResponse Complete(InterviewServiceRequest request)
		{
			return _baseService.Complete(request);
		}
 
		#endregion
 
	}
 
	#endregion
 
	#region DataContract
 
	[DataContract]
	public class InterviewServiceResponse : ConfigurationServiceResponse
	{
		[DataMember(Name = "isSuccess")]
		public bool IsSuccess {get; set;}
	}
 
	[DataContract]
	public class InterviewServiceRequest
	{
		[DataMember(Name = "interviewId")]
		public Guid InterviewId { get; set; }
	}
 
	#endregion
 
}

From what I can tell I've set everything up exactly as the article says but I still receive the error. Though they declare _baseService the same way. Any suggestions as to what I could be doing wrong?