Hello, 

below is the instruction to File management API for your referrence: 

https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/8.1/back-end-development/api-for-file-management/overview

Thank you for reaching out!

Hello!

Creatio does not officially support Qlik. The only way to integrate Qlik with Creatio is by using the Creatio OData or REST API.

As an alternative, we can recommend using Power BI marketplace addon: https://marketplace.creatio.com/app/microsoft-power-bi-desktop-connector-creatio

Have a nice day!

We have heavily invested in Qlik as our BI tool (and have hundreds of users).  Our task is to connect finance data with the sales data we have in Creatio.
We have an IT team that can set up the connection so I assume they are familiar with connectors like REST API, but would you recommend using ODate over REST API ?

Given your extensive investment in Qlik and the need to integrate it with data from Creatio, we recommend using Creatio’s REST API over OData for this integration.

While both options are available, the REST API offers several key advantages:

1) Better performance: REST is more efficient and lightweight, especially when handling large datasets.

2) Greater flexibility: you can define exactly what data is needed and apply filtering or transformations before it's sent to Qlik.

3) While OData comes with various preconfigured options, REST allows you to easily customize the requests

OData can be used for basic, read-only access, but it's generally more rigid and less performant — especially when dealing with high-volume analytics scenarios like yours.

Have a nice day!

Hi.   

(I'm not the dev that's going to do this, but ...) 

If we create an OData connection with Qlik,  are there already some methods in place so that Qlik automatically sees all data and tables in Creatio?  Or do we need to build out methods to see specific data?

Or, perhaps it's worth buying a Creatio OData connector that has all this built out already?  (If there is such a thing)

Thanks
Rob

Actually, the better question around how the BI (in my case Qlik) works with the data --

When we build out the OData datasource that Qlik will connect to, we need to specify each table that should be "available" to Qlik, true?  (There is no "include all tables" I assume.)
Ideally, we want all data from all tables, then in Qlik we will do the filtering of which data is needed on each report.

Or am I way off here?  

Greetings!
 

There are a few options:

Log directly inside the handler — meaning you implement the logging yourself.

Log via a Script Task into a custom database table.

Log by sending data to an external web service.

Unfortunately, we don’t have any built-in methods for this — everything needs to be implemented by the developers of the service (i.e., the API side).

In order to display the result of the API call on the widget you will have to create the custom widget and implement the API call for retrieving necessary data in its source code. The key from Global area that will be used for calling the API you can send to your custom widget as a parameter. Also in custom widget configuration you will have to define "items" list that will represent the structure of the data you want to display. When the API call returns the result you will have to parse it and map to the corresponding columns in widget ViewModel.

You can find the detailed explanation and the example of custom widget implementation in the following article
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/8.1/platform-customization/classic-ui/dashboard-widgets/examples/add-a-dashboard-widget

Hi thanks 

Widget is more of data view (list / form) 
Page will not have any backend data connected

Currently it's not possible to display API call result in List component on the page.

If you want to display API call result on the page you can add the custom attributes to your page, save the parsed response there and then bind the attributes to the labels on the page to make it visible.

Here is the example of the attribute:

viewModelConfigDiff: /**SCHEMA_VIEW_MODEL_CONFIG_DIFF*/[
...
	{
		"operation": "merge",
		"path": ["attributes"],
		"values": {
			"MyAttrubute": { "value": "" }
		}
	}
]/**SCHEMA_VIEW_MODEL_CONFIG_DIFF*/

and how you can set its value using the response from API call:

handlers: /**SCHEMA_HANDLERS*/[
	{
		request: "crt.HandleViewModelResumeRequest",
		handler: async (request, next) => {
			await next?.handle(request);       
			const url = 'https://open.er-api.com/v6/latest/USD';
			fetch(url).then(response => {
   				if (!response.ok) {
					return Promise.reject('Failed to load data: ' + response.statusText);
				}
 				return response.json();
			}).then(data => {
				request.$context.MyAttrubute = 'Rates: '+ JSON.stringify(data.rates);
			}).catch(error => {
				console.error('Error:', error);
			});
		}
	}
]/**SCHEMA_HANDLERS*/

Also you can find some useful information in these articles:

https://customerfx.com/article/using-custom-attributes-on-a-creatio-freedom-ui-page/

https://customerfx.com/article/binding-data-to-labels-on-a-page-in-crea…

THANKS -- wish there is way to invoke a business process with UI page value passed as parameters 

One question for the above method with handler the API call will be made from the client end -- wanted it to be done from server end (this way we can whitelist creatio iP range and only allow calls from those servers only)

Hi Raí,

The GetBigData and GetBigTopData functions were created as a workaround for the limitation of 20k records imposed by OData when attempting to download table data. The actual function used for data retrieval is GetData.


These functions enable you to download a snapshot of the table, bypassing the 20k record restriction. However, it's still necessary to apply a filter that ensures fewer than 20k records are retrieved in the process.

As a solution, we recommend using a regular database backup. After obtaining a copy of the database, you can restore it locally and configure Power BI to connect to this local DB copy. This approach will be much faster, more convenient, and ultimately easier for you.

Regarding the "credential error", I'd recommend you delete all connections from "Data source settings" menu. It might reset all previously entered credentials.

Hello again,

I just found a different community post:

https://community.creatio.com/questions/get-error-403-denied-when-uploading-file-filepiservice

After following the steps explained by @Ryan Farley I was able to upload files properly. My problem was that I was missing the following request headers:

• Content-Range = bytes 0-{size in bytes - 1}/{size in bytes}
• Content-Type = "application/octet-stream"

Thank you very much!

Glad you found the older post and have it working now!

Hello,

If your approval is created using a business process, you can trigger the business process using the ProcessEngineService.svc service https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…

Hello,

Creating operations on a large number of columns and data, which could be time-consuming, may lead to performance problems in the future. Please try to avoid big batch operations so as not to face the situation of 100% server CPU utilization.

As a workaround:

1. You may create a custom Web service and pass the needed data to it.
2. Create a business process that proceeds with needed data modifications

Hello,
It's necessary to contact Consimple to address this functionality. 
Consimple messenger connector for Creatio | Creatio Marketplace

It is already in the system with simple, do you know how I can configure it now, I have not found documentation

Hello,

We kindly recommend contacting the developer of the marketplace application at office@consimple.com. They will be able to provide you with detailed insights about the mechanism.

Hello, 

The error you encountered, according to the analysis, was caused by the fact that the OData protocol takes some time to initialize. During this time, requests via the protocol may return an error. However, within 5 minutes of the request, the system successfully initialized the protocol.

Best regards, 
Orkhan