It seems that any indexes (unique or otherwise) created in Creatio config are created to ignore case. This is not good from a data perspective, and prevents actual uniqueness checking in cases where the case of the characters matter. We need to be able to configure unique indexes to be case sensitive - I think ideally this would be the default option and you could check a checkbox in the config to ignore case if required, but certainly you should be able to generate normal database unique indexes which are case sensitive.
Clio new release provides improved way to integrate data exchange between third party systems and Creatio. We simplified ATF.Repository usage in external dotnet projects. Details described in this article
You can inspect the Account address detail as an example of integration with OpenStreetMaps in the system and Field Force application as an example of maps functionality on mobile apps.
I am trying to figure out, how do we connect Creatio directly to another (webapp's/app) SQL database which is not the Creatio one, without needing to pass through an API.
If we keep it simple, Pipedrive, they are able to provide SQL connections through Zapier, with triggers on both sides (if a change in Pipedrive --> add a column in the other SQL db OR if column added in SQL DB, do x action in Pipedrive). https://zapier.com/apps/pipedrive/integrations/sql-server
How do we replicate such direct (bi-directional) integration with Creatio and another sql db without the need for the other web app to expose or call an API ?
I am looking to integrate the Google Meet with Creatio but there is no marketplace app available as of now. So is there any other work around to achieve this.
Theoretically, it can be achieved via development, and here is the link to our API - it can probably help you.
And we have already registered a request for the responsible R&D team to research the possibility of implementation of this solution for the future releases of Creatio application.
Help set up CREATIO integration with an external web resource using the CREATIO API. To begin with, which url to use for POST Authentication to the CREATIO API
You can do that by adding the desired web services in the "Web services" section in the system settings. Then you can create a business process that will call those API, receive the information from them, store it in the system creating new records (You can create a new object and store the information inside, which will be basically storing information inside an SQL table) , or just keep it as parameters inside the same business process, and then send it again to another web service.
I would suggest you reading our academy instructions regarding business processes and web services to understand how you can combine them:
I have to use Odata of Creatio environment from Postman using OAuth 2.0 authentication. For that, I have followed a Tech hour session of Creatio Trainers.
Thank you! This message is usually returned in case you are not authenticated. Did you use UserName and UserPassword as a ClientId and ClientSecret and used Basic Auth? And also are you passing a form-data grant_type key in the headers and also using the identity service URL as an endpoint to send request?