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.

Hello!
I recommend checking the application logs for error details. Based on them, we can decide on the next steps.

Have you installed clio api (cliogate) in the instance? That is a requirement to execute SQL using clio. 

If not, in VSCode click the clio explorer main menu button (see https://share.customerfx.com/v1uGwpWw) and select "Install clio api" to install the clio API package into the system. 

Also, make sure you've installed .NET 8 - Also, install the clio command line as well from that same menu. 

You can follow the complete setup steps here: https://customerfx.com/article/how-to-install-clio-explorer-for-creatio/

Ryan

It would likely work to use requests with the correct scopes set for message exchange like how sandbox worked, but I've not really tried to implement that across different pages. It might also work to just use Javascript's built-in Broadcast Channel API for that as well. It exists for purposes like this, messaging between different contexts. See details here: https://developer.mozilla.org/en-US/docs/Web/API/Broadcast_Channel_API

Ryan

Hello,

To fix this, you need to generate code for all schemas and then compile the site.

The main reason for this behavior is that the file system mode (fileDesignMode) is enabled.

Hi Tushar,

If you are currently utilizing the Customer FX guide, you may be experiencing an iFrame display anomaly similar to one I recently encountered.

To address this issue and ensure the iFrame renders in full screen, I implemented an update to the iFrame module.

Specifically, the following code modification resolves the problem:

this._frameConfig.style = (this._frameConfig.style || "") + "height:" + this.frameConfig.height + ";width:" + this.frameConfig.width + ";";

This adjustment guarantees the style property is properly initialized before the height and width values are appended, thereby rectifying the display discrepancy.

Please let me know if you require further clarification or assistance.

PS: 8.2.2 has new iFrame component : Iframe. You can now embed external content using the new crt.IFrame component.

Hello, 

You seem to be mixing things between classic pages and Freedom UI pages. The page you're customizing appears to be a Freedom UI page, which does not support adding methods. The code you've added would work for classic pages, but not on Freedom UI pages. 

Instead, this is done via request handlers on Freedom UI pages. See this link for overriding the save request on a Freedom UI page: https://customerfx.com/article/adding-code-to-the-save-event-of-a-creatio-freedom-ui-page/

Ryan

Also, as a side note, the code you have in the getActiveCount won't work since ESQ is asynchronous (so the return will happen before the query returns any results), additionally, the results of the query of an ESQ are passed in via a callback function passed as a parameter to getEntityCollection, not returned as a result of calling getEntityCollection.

For a Freedom UI page, I'd use a model load instead of the ESQ since you can await the result, rather than use a callback function. See https://customerfx.com/article/querying-data-using-filter-conditions-via-the-model-class-equivalent-to-enityschemaquery-in-a-creatio-freedom-ui-page/

Ryan

Hi Ryan,

I have added this code in handler, still it's not works for me. Please address, what i missed here.

Revathi,

Can you provide more details by what isn't working?

Hello.

We recommend consulting our GitHub community, where you can find discussions, troubleshooting tips, and potential solutions from other users and developers.
Creatio Marketplace GitHub

Best regards,
Antonii.