Hi Petrika,

This should be done directly in the code of the 3rd party endpoint to which the call is performed (in case we are discussing the 3rd party webservice call from the business process). Logs of the integration call on the Creatio side are accessible only via standard IIS logs. Or you can enable the process tracing to see the status of the call.

In case the webservice is stored in the Creatio configuration (standard anonymous or regular webservice) then you can either add a part of inserting a record to some specific table in Creatio (via InsertQuery class for example) and retrieve data from there.

Best regards,

Oscar

Thank you very much for your immediate response Oscar. I have got an idea now.  This is what i am trying to do. I have created a button in the Front-End (Get Sum Ws) which calls in the Back-End a basic web service that caculates the sum of the AmountHC in Details Rows.

This is the code in the back-end

namespace test1323.Files.cs
{
    [EntityEventListener(SchemaName = "PetrikaExpenseReport")]
    [ServiceContract]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
    class DemoService : BaseService
    {
 
        [OperationContract]
        [WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,
ResponseFormat = WebMessageFormat.Json)]
 
        public decimal GetErSumSq(string name) 
        {
 
            EntitySchemaQuery entity = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "PetrikaExpenseReport"); 
 
            entity.AddColumn("Id");
            entity.AddColumn("PetrikaTotalAmount");
            entity.AddColumn("PetrikaName");
            entity.PrimaryQueryColumn.IsVisible = true;                                                                   
 
            IEntitySchemaQueryFilterItem parentfilter =
            entity.CreateFilterWithParameters(FilterComparisonType.Equal,"PetrikaName",name);
            entity.Filters.Add(parentfilter);                                                                            
            EntityCollection records = entity.GetEntityCollection(UserConnection);                                      
            Guid parentId = records[0].GetTypedColumnValue<Guid>("Id");
 
           EntitySchemaQuery rows = new EntitySchemaQuery(UserConnection.EntitySchemaManager, 
           "PetrikaExpenseReportLines");
 
            rows.AddColumn("PetrikaAmountHC");
            rows.AddColumn("PetrikaAmountFC");
            rows.AddColumn("Id");
 
            IEntitySchemaQueryFilterItem childfilter =
            rows.CreateFilterWithParameters(FilterComparisonType.Equal, "PetrikaExpenseReport", parentId);
            rows.Filters.Add(childfilter);                                                                            
            EntityCollection lines = rows.GetEntityCollection(UserConnection);
 
            decimal sum = decimal.Zero;
 
            foreach (var r in lines) 
            {
                sum = sum + r.GetTypedColumnValue<decimal>("PetrikaAmountHC");
            }
            records[0].SetColumnValue("PetrikaTotalAmount", sum);                                             
            records[0].Save();
            return sum;
        }
}
}

I want to log in a separate file every communication (request , response time etc) with GetErSumSq.

Petrika,

Perfect, then additionally you can use the same approach with EntitySchemaQuery, but create record is some section and then use the standard "Export to excel" functionality to get the file with request calls. So each time something is calling the GetErSumSq method you can create a record in some separate section (for example called "Integration call" and add information like DateTime.Now (to get the date and time when the method was called and which value was returned (sum))). Also you can try looking into the HttpContext, HttpContextAccessor and AppConnection to see which information is available there that can be used to additionally log the method call.

Best regards,

Oscar

Hi Pratik, 



This is the know issue of the version. 

Our R&D team is working on this to be fixed in the future releases. 

There's a workaround to this issue. To implement it please create following request to support team (since your instance is cloud) :

1) set "false" to following keys in  Terrasoft.WebApp\web.config 

<add key="Feature-UseSeparatedOdataEntitiesDll" value="false" />

<add key="Feature-ODataEntitiesCompilationInSeparatedDll" value="false" />

if such keys don't exist, they can be added to  the block <appSettings>;

2) Generate source code for all schemas and compile all. 





Please note, that this fix is only applicable for 7.18.1. Please remove this tags from web.config when updating to newer versions of the application, as it will cause the Odata functionality to not work. 



You can also refer to this community post in your support request. 

Best regards,

Yurii

 

Hi Yurii,

It Worked, Thanks for the help. 

Hi. 

This solution is for version 7.18.1 only.

Hello Ibrahim,



You can integrate Creatio with the following external applications:

• the OneLogin SSO portal, used as a single sign-on point for all your services, including Creatio. Learn more about OneLogin integration in the article.
• the Active Directory Federation Services (ADFS) software component used for managing single sign-on for all system users. Learn more about Active Directory Federation Services integration in the article.
• the Just-In-Time User Provisioning (JIT UP) Single Sign-On, which alleviates the need to create accounts for each separate service and keep the user database up-to-date. Learn more about Just-In-Time User Provisioning integration in the article.
• the Lightweight Directory Access Protocol (LDAP), which enables access to the dedicated database used to store the credentials of users, machines, etc. Learn more about Lightweight Directory Access Protocol integration in the article.
• email providers by the IMAP/SMTP protocol. Learn more about email integration via the IMAP/SMTP protocol in the article.
• Google mail, calendar, and contacts. Learn more about integration with Google in the article.
• phone connectors, such as Webitel, Oktell, Asterisk, Cisco Finesse, TAPI, CallWay, Infinity, and Avaya.
• the MS Exchange and Microsoft 365 collaboration services. Learn more about MS Exchange and Microsoft 365 integration in the article.
  
  
  
  Best regards,
  
  Bogdan

Bhoobalan Palanivelu,

In which exact integration are you interested? 

Hello!

The integration was not officially released yet. It is being tested by our developers at the moment. Once all tests are fully completed we will update the documentation. 

Please let us know in case any further information is required. 

Best regards, 

Olga. 

Olga Avis,

Thanks much for the update!

Olga Avis,

By chance can we have any update for integrating AWS (S3) with Creatio as we have released 7.18.2, Please?

Olga Avis,

Can we have any update on the integration of AWS (S3) with Creatio, Please? 

Olga Avis,

We have the article updated for S3 integration in Creatio academy.

https://academy.creatio.com/docs/user/setup_and_administration/on_site_deployment/deployment_additional_setup/s3_file_storage_integration



Is this only for on-site?



How can we implement the same in cloud site?

Hi Yuriy,

In-built Creatio functionality allows integrating with Telegram and Facebook chats and the procedure is described here (I believe you used this article to integrate with Telegram in your case). You will need to study the implementation of the Telegram integration in the system (server code part, not the Creatio UI part) and check if the API of your site chat allows integrating it with 3rd party services.

Unfrotuantely there are no tutorials on the Academy on this particular topic since this is a server-side development using API services.

As for introducing the new tag - I will ask our community team to add one.

Best regards,

Oscar

Oscar Dylan,

Does this method require Creatio to be on-site? We have it in the cloud currently

Yuriy Konstantinov,

No, the endpoint where you chat logic is stored should be available for the cloud-based apps. If it has no firewalls and can send\receive requests\responses from the Internet then there is no difference if the app is located in the cloud or locally.

Best regards,

Oscar

Hi Pedro,

Maybe it's better to call the https://<instance>/0/rest/FileService/GetFile/7B332DB9-3993-4136-AC32-09353333CC7A/fileId for all the files and receive a response from the third party service? You need to call this link for each record from the DocumentFile table (filed should be modified for each time with an actual Id of a record from the DocumentFile table). Previously we didn't have such requests and we have no practical example of the logic deployment. The link above is a base link used to download attachments when clicking them on the "Attachments" detail so you can try calling it in the webservice.

Best regards,

Oscar

Hello Saswat, 

As of now, there is no Google Analytics Integration on a clean install of a standard Creatio product, also there are no similar integration marketplace applications as well. It can only be integrated with the help of the development process. In this respect, Google Analytics can be integrated through API as a separate, third-party application. Also, you can develop your personal web service to pull the data into Creatio or use OData protocol for this purpose. Please find the relevant articles on our Academy using the links below:

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

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

https://academy.creatio.com/docs/developer/architecture/development_in_…

Best regards,

Anastasiia

Hello!

7.17.0 release enables the possibility to add integration with Facebook lead generation forms. All you need to do is link a landing page record in Creatio with a Facebook business page and select one of the lead registration forms on it. As a result, each submission of the corresponding Facebook form will generate a new lead in Creatio. 

Furthermore, in the 7.17.0 version, customers can write private messages to your company page on Facebook or using the Facebook Messenger plug-in available on the website. You will be able to process all these messages in Creatio, they will be integrated on a customer page. 

More detailed information about these topics can be found in Academy articles: 

• Set up automatic lead registration from social networks
• Set up chat

Please, let us know in case any further information is required. 

Best regards, 

Olga.