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 team,

I have identified the issue. It was caused by the lookup 'Blacklist of email addresses and domains for case registration', where certain domains or email addresses get blacklisted under specific conditions. If you encounter a similar issue, be sure to check this lookup.

I would guess Open AI ? I Think there is other option at the moment anyways, or is there ?

You could probably ask it? 😂 Actually, the Academy docs discussing data privacy about Creatio AI mention it is using Azure OpenAI services, which is just REST services to facilitate working with OpenAI. See https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/ai-tools/copilot/data-privacy

Ryan

I asked, the reply was:
 

I am an advanced language model designed to assist users within the Creatio platform. My primary task is to help with daily operations, provide contextual responses, and execute various skills to enhance productivity. How can I assist you today?

I asked if it was using the OpenAI engine:

I am powered by an advanced language model designed to assist users within the Creatio platform. My primary focus is to help with tasks and operations specific to Creatio. How can I assist you today?

Currently cannot be done with business rules on the page (they can't use data from related objects). Only way to accomplish this is to handle the change of the product lookup, retrieve the values from the selected product and then set on the page. Otherwise, you could use a process, but that won't update the values until saved. 

Ryan

i m trying to build Freedom UI pages without coding...
so i used for the moment the help you provided me here:
https://community.creatio.com/questions/depending-interface-behavior-no…

Find the lookup named "Object-specific form page interface in the Freedom and Classic UI shell". In that lookup, add an entry for OpportunityProductInterest and for Freedom UI shell select Classic. Then log out and back in again. This will tell the system that if a user is using the Freedom UI shell, to use the classic page for Opportunity products.

Ryan

Wonderful, thank you Ryan

Check the start of the process (select the green start where the process begins) and make sure it does not have the "run in background" option checked. 

I've checked that, and it's not checked. I did some further analysis, and the record is created and i can open it, it only doesn't want to open during the process flow. Furthermore, if I run the process under my colleague's credentials, the record does open. So, one would think it's a permission problem, although we both have the same permissions, we both have the system administrator role, and i can open the record 'manually'...

Hi Michael!

Unfortunately, currently this is not possible with the out-of-the-box solution. 
If you want to display a certain image for the record, for example company logo for the account record, you can use an Image component.

You can also consider using the following marketplace solution: https://marketplace.creatio.com/app/banza-files-extended-creatio?check_logged_in=1

I hope this helps! If you have any further questions or need assistance, feel free to reach out.

You can see an example of embedding an IFRAME and setting the src of the IFRAME dynamically here: https://customerfx.com/article/embedding-an-iframe-on-a-creatio-freedom-ui-page/

However, an IFRAME cant just display data from an API. An IFRAME simply embeds another page, it would be the responsibility of the page you're embedding to retrieve and display the API data. 

You could however, use a similar approach to the article for creating an IFRAME and just have that component retrieve the API data and render out HTML as needed. Alternatively, you could create a full Angular component that retrieves and displays the API data, which is likely a better route anyway. See https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/front-end-development/freedom-ui/remote-module/implement-a-remote-module/overview 

As for CORS restrictions, that would be something imposed (or not) by the API, not Creatio.

Ryan

According to the post below, it could be that you need to possibly modify the permissions of the folders under Terrasoft.WebApp. See https://community.creatio.com/questions/error-logging-local-deployment-creatio

Ryan

Ryan Farley,

Still getting the same error, i think that is different case maybe

System.Exception: Library e_sqlite3 not found\r\nplat: win\r\nsuffix: DLL\r\npossibilities (3):\r\n

Ryan Farley,

Ahmad Bagus Ariyanto,

Tomasz Sawicki,

Greetings!
 

The error you're encountering is related to your system being unable to find or load the e_sqlite3 library. This can be caused by several reasons. Please note that this issue is not related to the Creatio system itself but rather to a Microsoft component.

This article might help you: Microsoft.Data.Sqlite library 'e_sqlite3' not found:

https://stackoverflow.com/questions/65750542/microsoft-data-sqlite-library-e-sqlite3-not-found
 

Below are a few steps that may help resolve the issue (please note that these are general recommendations, and since the issue is related to Microsoft components 
https://www.nuget.org/packages, you might also find assistance on forums or by contacting Microsoft support):

1. Make sure the e_sqlite3 library is present.
 

2. Install or update the SQLitePCLRaw.bundle_e_sqlite3 package. You can do this via the NuGet Package Manager using the following command: 
 

Install-Package SQLitePCLRaw.bundle_e_sqlite3

https://www.nuget.org/packages/SQLitePCLRaw.bundle_e_sqlite3/
 

3. Ensure that your target platform is compatible with the library. For example, if you're building for x86, make sure you’re using the correct version of the library (x86 or x64).
 

Installing or updating the package via command line (cmd):

1. Open the command prompt:  
On Windows, press Win + R, type cmd, and press Enter.

2. Navigate to your project directory: Use the cd command to change to the folder where your project is located. 

For example, cd path\to\your\project

3. Install or update the package: If you have NuGet CLI installed, you can run: 

nuget install SQLitePCLRaw.bundle_e_sqlite3 

However, if you're using .NET Core or .NET 5/6/7, it’s recommended to use the dotnet CLI instead: 

dotnet add package SQLitePCLRaw.bundle_e_sqlite3 

This command will automatically add the package to your project and update the .csprojfile.

Example commands:
 

1. Navigate to your project directory:
 cd C:\Projects\MyApp

2. Install the package: dotnet add package SQLitePCLRaw.bundle_e_sqlite3

After successful execution, dotnet will download and install the package. If everything goes well, you’ll see a message confirming the package has been added to your project.

Regards,
Orkhan

Hello,

Thank you for your request. Unfortunately, it is not possible to change this behavior using custom methods.
 

As a workaround, you can achieve this using development methods.

To achieve this you can to implement custom handlers for two requests:

1. When saving changes in the detail list (crt.SaveRecordsRequest)

First, execute the default logic for saving the detail records.

Then, trigger crt.SaveRecordRequest to ensure that the master record is also saved.
 

Be careful not to confuse the requests—crt.SaveRecordsRequest is for saving multiple records, while crt.SaveRecordRequest is for a single record.
 

2. When deleting records from the detail list (crt.HandleModelEventRequest)

Execute the default logic first.

Then, check if request.modelEvent.type === 'delete'.

If it is a delete operation, trigger crt.SaveRecordRequest to save the master record as well.