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.
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.
We've this situation where we need to send all the attachments that are linked to Documents, including the byte[] data, to a SOAP based service.
We have two solutions in order to implement this:
To send the attachments we could simply convert the byte[] data to base64 string and send it within the body of the SOAP message. Some of the files are more than 10MB, so this is not the best solution.
The other solution is to use the MTOM message encoder, to send the attachments in multiple parts.
We have two questions:
What are the best ways to send multiple attachments through SOAP based requests?
If we choose to send the attachments using MTOM, how can we implement this?
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.
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:
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:
I have a business requirement to integrate one creatio system to another. Can anyone help me with the steps required to implement this, if such an integration is possible at all?
I have a business requirement to integrate one Creatio system to another Creatio system. Can anyone help me with the steps required to implement this, if such an integration is possible at all?
We have a use case where Creatio co-exists with a legacy application which is SQL heavy - A lot of logic is written using SQL Stored procedures. There are certain custom objects on Creatio that needs to be populated and read by the legacy app on a weekly basis. Integration via APIs is not an option (owing to all the business logic being already available in Stored procedures). Using Excel Import/Export is also not an option.
We are considering an ongoing ETL via SQL where a stored procedure is used to directly write/read info from Creatio's custom tables. Assume that the Legacy application has a good understanding of the schema and relationships and transformation/mapping to/from Creatio tables is not an issue.
Pls comment on the following -
1. Is this feasible? - In my view, this should definitely be feasible as at the end of the day, It is an SQL DB. Any data read out of Creatio's DB does not disturb the state of the data in the DB. Any data modified (correctly) in the DB should reflect correctly in the Creatio application. Can you confirm?
2. Is this recommended? - Apart from ease of use and need for SQL development, Are there any reasons from a Creatio product/architecture stand point why this might not be recommended? The load on the WebServer is a negligible factor as these SQL import/export will only be done during low usage periods weekly.
Can you please check this Marketplace add-on, I believe it can help you with your business task.
But still, if you decide to use your approach, then:
1. Yes, that is feasible. The data will be available in the Application but you need to understand that if you miss to insert something, the data might be corrupted. Also, this kind if data transfer won't trigger BP as this will be considered to be direct data insert into the DB.
2. I can not say that this approach is recommended but it is possible. And again, you need to perform a lot of testing before real data transfer just not to lose data.
Can you please check this Marketplace add-on, I believe it can help you with your business task.
But still, if you decide to use your approach, then:
1. Yes, that is feasible. The data will be available in the Application but you need to understand that if you miss to insert something, the data might be corrupted. Also, this kind if data transfer won't trigger BP as this will be considered to be direct data insert into the DB.
2. I can not say that this approach is recommended but it is possible. And again, you need to perform a lot of testing before real data transfer just not to lose data.
Yes, We did consider the plugin. But our use case needs to migrate data from a few custom SQL databases and on an ongoing ETL for 2 weeks. Also, We mostly have custom objects on Creatio and it is not a typical Creatio CRM that we are building.
#1 Yes, I understand that this won't trigger BPs. We are only doing this as a 1 time migration activity as our client is migrating an existing custom application to Creatio.
We have workflows & business logic configured at the Application layer (Via business processes, entity event listeners & incoming API integrations). However, we need to transfer some data into our Database only via direct SQL. Is there any way at all of triggering application level logic on some Database level triggers?
I can think of a few round about/hacky ways of achieving this. Want some input wrt support for DB to Application layer execution flow from a Creatio product stand point and any clean ways of doing this.
We have workflows & business logic configured at the Application layer (Via business processes, entity event listeners & incoming API integrations). However, we need to transfer some data into our Database only via direct SQL. Is there any way at all of triggering application level logic on some Database level triggers?
I can think of a few round about/hacky ways of achieving this. Want some input wrt support for DB to Application layer execution flow from a Creatio product stand point and any clean ways of doing this.
In case you need to interact with the database directly you need to use either stored procedures or triggers that could trigger additional actions upon some actions on the application level. This will be the easiest way to achieve your target.
I was referring to use cases like the following - When a SQL Trigger gets activated, Run a business process at the Application layer. There is no direct way to do this I would presume?
Also, the dbExecutor class will help perform operations unidirectionally from the Application layer to the DB layer. I don't think something like this is available - When a trigger runs at the DB layer, it is available as an Event to catch or subscribe to at the Application layer. Is this right?
A very distant example would be something like this -
You can call stored procedure using dbExecutor, but not visa versa (trigger calls a process). You can use another approach: insert data to the database and then call the process manually for all the records by their CreatedOn date value. As a result data will be inserted to the system and processed by a business process.
Thank you Oscar for your response. Yes, the final approach you have suggested is one of the ways I also thought about. It is still round about and non optimal. Appreciate your answer nevertheless.
