Время создания
Filters

Hi Team,

Can we connect Creatio database to our applications directly?

Like 0

Like

1 comments

Are you referring to connecting directly to the database via code in Creatio? If so see here: https://customerfx.com/article/executing-direct-sql-statements-in-a-process-or-configuration-web-service-in-creatio-formerly-bpmonline/

If you're referring to using a tool to connect and view the database directly, not really possible. However, you can execute SQL statements remotely using Clio/Clio Explorer: See here https://customerfx.com/article/how-to-install-clio-explorer-for-creatio/

Ryan

Show all comments
JWT
Business Process
API
Sales_Creatio_enterprise_edition
8.0

I have an integration I'm setting up against a companys API sandbox environment. They have an authentication endpoint where I send my basic auth credentials as a JSON body parameter. In the response I receive a JSON web token and this request also works in Creatio via Test request.

However, subsequently when making requests with the web service against the API to extract company information for example, how do I attach the JWT Bearer as part of the Web service call?

I understand that first I would need to save the retrieved token from the auth call in a process parameter likely, but in the GET request for companies in the Web service API call, I dont see room to attach the access token anywhere as a header or anything.

Or am I suppose to set it up using the Authentication settings in the Web service, if so could anyone explain how to set it up as a ClientID and Secret are not revelant here:

Like 0

Like

0 comments
Show all comments


core-base.js?v=-1083758368:772 user: Default_user/1B4B9325-66CC-DF11-9B2A-001D60E938C6
file: http://localhost/D1DEV/core/hash/Terrasoft/amd//loginModule.js?v=-10837…
line: 757
column: 7
message: Uncaught Terrasoft.UnauthorizedException:

   
       Could not load file or assembly 'NLog.Web' or one of its dependencies. The system cannot find the file specified.
       
       
        body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
        p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
        b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
        H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
        H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
        pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt}
        .marker {font-weight: bold; color: black;text-decoration: none;}
        .version {color: gray;}
        .error {margin-bottom: 10px;}
        .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:pointer; }
        @media screen and (max-width: 639px) {
         pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; }
        }
        @media screen and (max-width: 479px) {
         pre { width: 280px; }
        }
       
   

   

           Server Error in '/D1DEV/ServiceModel' Application.

           

Could not load file or assembly 'NLog.Web' or one of its dependencies. The system cannot find the file specified.

           

            Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

           

            Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'NLog.Web' or one of its dependencies. The system cannot find the file specified.

           Source Error:

           
             
                 
                     

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.                      

                 
             
           

           

           Assembly Load Trace: The following information can be helpful to determine why the assembly 'NLog.Web' could not be loaded.

           
             
                 
                     

<pre>
 
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
</pre>                      

                 
             
           

           

           Stack Trace:

           
             
                 
                     

<pre>
 
[FileNotFoundException: Could not load file or assembly &#39;NLog.Web&#39; or one of its dependencies. The system cannot find the file specified.]
   System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type) +0
   System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark&amp; stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName) +96
   System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) +65
   System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) +62
   System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) +50
 
[ConfigurationErrorsException: Could not load file or assembly &#39;NLog.Web&#39; or one of its dependencies. The system cannot find the file specified.]
   System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) +572
   System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, Boolean checkAptcaBit) +31
   System.Web.Configuration.Common.ModulesEntry.SecureGetType(String typeName, String propertyName, ConfigurationElement configElement) +59
   System.Web.Configuration.Common.ModulesEntry..ctor(String name, String typeName, String propertyName, ConfigurationElement configElement) +59
   System.Web.HttpApplication.BuildIntegratedModuleCollection(List`1 moduleList) +221
   System.Web.HttpApplication.GetModuleCollection(IntPtr appContext) +1103
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +122
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +173
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +255
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +347
 
[HttpException (0x80004005): Could not load file or assembly &#39;NLog.Web&#39; or one of its dependencies. The system cannot find the file specified.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +552
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +122
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +732
</pre>                      

                 
             
           

           

           

           Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.9316.0

           

   

date: Thu Oct 09 2025 12:04:04 GMT+0700 (Western Indonesia Time)
stack: undefined

in the devtools said like that

Like 0

Like

1 comments

Hello,

This error indicates a problem with the binaries (either the NLOG.Web library is missing or is corrupted). Please download new binaries and redeploy the site. 

This error may also indicate that the user running the application pool does not have access to this file (it is recommended to grant that user full access to the folder where the application is located), for example:

Also, please check that the path for the internal application is specified correctly. For example, the user may have specified "C:\Site_Name\Terrasoft.WebApp" instead of "C:\Site_Name\Terrasoft.WebApp\Terrasoft.Configuration."

Make sure the user running the application has full access rights in IIS.

Show all comments

Hi Team, I am trying to integrate my application with Creatio OAuth 2.0 using( Grant type - authorization code). 

I created a URL with right client_id and redirect_uri 

https://xxxx-demo.creatio.com/0/connect/authorize?client_id=xxxxxx&redirect_uri=https://my_redirect_uri&response_type=code&scope=Test&state=1a4741d705c02f0c8f6e00d68e38ec7f

 

When I click the above link, it takes uses to username/password page, then to consent page. Once the user accepts the consent page info, it gives the below error, "Integration setup error"(See screenshot).

 

One thing that's not clear is scope. I have currently set it to the "Name"(Test) field that we specify in the Settings->OAuth 2.0 Integrated Application. I even tried using various other scopes as "offline_access" based on the below doc(https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…) , but it doesn't make any difference. 

Like 0

Like

0 comments
Show all comments

I have an API call that when I manually pass in the authorization code "Bearer ey..." into the parameter, it works. I also set up the OAuth 2.0 in the integration, and am logging in successfully.

How can I pass the authorization token from a login to the integration? It's already set up to run offline.

Like 0

Like

0 comments
Show all comments