Studio Creatio | Community Creatio

Studio_Creatio

7.17

16:18 Jul 07, 2021

Hi community

I tried to download a picture contact using odata using this end-point {{BaseURI}}/0/odata/Contact({{ContactId}})/ContactPhoto

but I receive HTTP 204 response.

The contact has a picture attached

What I'm doing wrong?

5 comments

Oleg Drobina

16:31 Jul 07, 2021

Hi Stefano,

Please specify if you are trying to get the photo from the contact or post the photo to the contact. It's not clear from the description of the question.

Best regards,

Oscar

Stefano Bassoli

16:40 Jul 07, 2021

Oscar Dylan,

I'm trying to download the picture

Oleg Drobina

17:55 Jul 07, 2021

Stefano Bassoli,

what you need to do is to call /0/odata/SysImage({Id here})/Data endpoint. And Id should be received from the "PhotoId" column value received when calling 0/odata/Contact({{ContactId}}). Here is an example for accounts from my local app:

1) Retrieve PhotoId from the contact:

2) Call this endpoint:

http://r_rak_n:3269/0/odata/SysImage(199f4e47-985b-41ee-91c5-dec7e4f45a5e)/Data

199f4e47-985b-41ee-91c5-dec7e4f45a5e - is the PhotoId from step 1.

Best regards,

Oscar

Stefano Bassoli

06:29 Jul 08, 2021

Oscar Dylan,

Thank you very much!

Carlos Soto

21:13 May 18, 2025

In a production enviroment this endpoint doesn't work?

Show all comments

delete records

Studio_Creatio

7.17

Getting timeout error when deleting records in any of the section

Fulgen Ninofranco

15:19 Jul 05, 2021

Hi Community,

Why am I getting timeout error when deleting records in any of the section. How can I fix it? Thank you so much

2 comments

Oleg Drobina

15:50 Jul 05, 2021

Hi Fulgen,

This screenshot gives no information on the actual reason for the problem unfortunately.

What you need to do is:

1) If this is a local app - check the WebSockets settings in the app (this article will be useful). This is the most probable reason why records cannot be deleted in any section as you state. Also check if the "WebSocket" feature is enabled in the IIS-server Windows features.

2) Check the MultiDeleteQueue table and which messages do you receive there (no matter which instance cloud or on-site you have).

3) Check the application logs via C:\Windows\Temp folder (if this on-site .NET Framework app or Logs folder in the root binary files if this is a .NET Core app). If this is a cloud-based app you can approach us at support@creatio.com and we will provide you with the logs needed.

Best regards,

Oscar

Fulgen Ninofranco

16:23 Jul 05, 2021

Oscar Dylan,

Hi Oscar

Delete is very slow then it will pop up this generic error message "

Error occurred during the deletion of data. Please contact system administrator." Then after you refresh the section page for Example Account section, the record was already deleted.

Show all comments

oData

NavigationProperty

Studio_Creatio

expand NavigationProperty Odata

Moheman

13:01 Jul 05, 2021

Hi,

I need to get a list of accounts with their accountAddress as a list ,

and I Have this NavigationProperty in account Entity

how I can wite the query to join account and account address using "AccountAddressCollectionByAccount" NavigationProperty

Thanks

1 comments

Best reply

Oleg Drobina

13:25 Jul 07, 2021

Hi Moheman,

OData cannot perform such an operation in one action if calling /0/odata/Account endpoint. You can retrieve data from related entities (that are specified in lookup columns), but not from details. Or you need to perform OData request to AccountAddress collection and retrieve data on the related accounts there in the following manner:

https://o_drobina.tscrm.com/0/odata/AccountAddress?$expand=Account

Best regards,

Oscar

Oleg Drobina

13:25 Jul 07, 2021

Hi Moheman,

https://o_drobina.tscrm.com/0/odata/AccountAddress?$expand=Account

Best regards,

Oscar

Show all comments

Studio_Creatio

7.17

Format date Field at Email template

Carlos Alberto Arce Ortuño

07:27 Jul 03, 2021

Hi everyone

can i use FormatDate sentences at email template?

1 comments

dean parrett

17:14 Jul 09, 2021

Hi Carlos,

Unfortunately no, formatting doesn't work for macros in the templates. It will be available in some future application versions.

Regards,

Dean

Show all comments

Studio_Creatio

7.17

setup timeout for external request

Carlos Alberto Arce Ortuño

19:02 Jul 02, 2021

Hi everyone

Can i increase the timeout ? for an external request :

	var request_user = WebRequest.Create(XMLUrl) as HttpWebRequest;
	request_user.Credentials = new System.Net.NetworkCredential(XMLUserParameter, XMLPasswordParameter);
	var response_user = request_user.GetResponse();

is an XML file 40mb, it will be increase the size ,

Some times the request works but not ever

if i can, what i should to change it

4 comments

Best reply

Ryan Farley

20:30 Jul 02, 2021

Hello Carlos,

In your code sample you posted, you're using a HttpWebRequest for the call to the external service. For WebRequest, you can set the timeout like this:

var request_user = WebRequest.Create(XMLUrl) as HttpWebRequest;
request_user.Timeout = 500000; // set timeout here
request_user.Credentials = new System.Net.NetworkCredential(XMLUserParameter, XMLPasswordParameter);
var response_user = request_user.GetResponse();

Note, the Timeout property is in milliseconds - I believe the default is 100000 ms, or 100 seconds)

Ryan

Ryan Farley

20:30 Jul 02, 2021

Hello Carlos,

In your code sample you posted, you're using a HttpWebRequest for the call to the external service. For WebRequest, you can set the timeout like this:

var request_user = WebRequest.Create(XMLUrl) as HttpWebRequest;
request_user.Timeout = 500000; // set timeout here
request_user.Credentials = new System.Net.NetworkCredential(XMLUserParameter, XMLPasswordParameter);
var response_user = request_user.GetResponse();

Note, the Timeout property is in milliseconds - I believe the default is 100000 ms, or 100 seconds)

Ryan

Carlos Alberto Arce Ortuño

06:06 Jul 03, 2021

thanks Ryan Farley,

So i don't need to configure anything in the iis or .config files?

Bogdan Lesyk

10:22 Jul 05, 2021

Carlos Alberto Arce Ortuño,

Yes, please follow Ryan's answer it should work properly.

Best Regards,

Bogdan L.

Bogdan Lesyk

10:24 Jul 05, 2021

Ryan Farley,

That's amazing!

Thanks for your reply!

Regards,

Bogdan L.

Show all comments

#import

#excelimport

#data

Studio_Creatio

7.17

Can be Check Data before import while comparing it with existing data

Braj Raj singh Kushwaha

10:54 Jul 01, 2021

Hi Team

Just want to know can compare data before upload from existing data over the system

As we could see a lot of typing(Human) mistakes and each time a new record is created

And data over the system is of on use as no access is given

the process gets stuck as they could find relevant data

is there something by which we can change/compare data before uploading as per system data

Thank You

1 comments

dean parrett

13:49 Jul 01, 2021

Hello,

You can run the duplicate search after each import to find potential duplicates. Additionally you can select the fields under which the records will be considered as duplicates (item 4 of the guide https://academy.creatio.com/docs/user/platform_basics/business_data/exc…)

So the idea is if I import a contact with name Dean, the existing contact with the name Dean will be updated with data from file and no duplicates will be created.

Regards,

Dean

Show all comments

dashboard

Filters

Studio_Creatio

7.17

How to create dashboard filters?

Fransetya Alfi Syahrin

09:35 Jun 30, 2021

Hi Everyone,

I want to show the filter field always like this, do you guys have any solution?

3 comments

Tetiana Bakai

13:52 Jun 30, 2021

Hello,

Regarding your first filter on the picture - once filter for Class of Business is added to the section, the assigned value would be fixed despite of jumping to other sections in Creatio, since it is stored in SysProfileData table.

In order to add your second quick filter to the [Premium Register] section, you should create a replacing schema of the [Premium Register] section and add your quick filter which will filter records by Policy Number.

You can find useful information regarding adding quick filters to the section on this link https://academy.creatio.com/docs/developer/elements_and_components/basi…

Best Regards,

Tetiana Bakai

Fransetya Alfi Syahrin

10:08 Jul 05, 2021

Tetiana Bakai,

do you have idea for quick filter for string type?

Oleg Drobina

11:26 Jul 06, 2021

Fransetya Alfi Syahrin,

Please provide the business task that is followed by creating such a functionality? To activate a string type filter two buttons should be pressed:

1) "Filter" context menu

2) "Add filter" button

Also why can't you create a dynamic folder in case you need to access some filtered data on a regular basis?

If you need to develop such functionality you need to look at the showSimpleFilterEdit function and its call in the CustomFilterViewModelV2. We don't have a ready solution and you need to develop it on your own.

Best regards,

Oscar

Show all comments

filter

lookup

Studio_Creatio

7.17

How can I filter a lookup type "Selection window" with ESQ?

Tiago Martins Pierine

22:20 Jun 25, 2021

Hi community,

Is it possible to filter a Lookup field type "Selection window" with a ESQ query? I need to use a ESQ query with some logical operators to filter the result of the lookup window.

I Know how to do that with lookup field type "List" but it not works with lookup type "Selection window".

Thanks,

Tiago Pierine

3 comments

Best reply

Ryan Farley

00:21 Jun 26, 2021

Hello Tiago,

I have an article on that topic here https://customerfx.com/article/filtering-lookups-in-creatio-formerly-bp…

Hope this helps,

Ryan

Ryan Farley

00:21 Jun 26, 2021

Hello Tiago,

I have an article on that topic here https://customerfx.com/article/filtering-lookups-in-creatio-formerly-bp…

Hope this helps,

Ryan

Tetiana Bakai

19:04 Jun 28, 2021

Hi Tiago,

Ryan's link indeed contains a good example for filtering lookups in Creatio. Please perform few tests using the article provided above.

Best regards,

Tatiana

Tiago Martins Pierine

05:00 Jun 30, 2021

Hi Ryan,

Your suggestion worked perfectly, thank you very much.

Show all comments

process

Studio_Creatio

7.17

Bad request

Tomasz Branicki

12:38 Jun 17, 2021

Running compleateExecution on PreConfigured page i get an error

2021-06-17 11:18:07,964 [366] ERROR ZARZĄDZANIE NT\SYSTEM Terrasoft.Web.Common.ServiceModel.ErrorHandler HandleError - AssemblyQualifiedServiceName = [Terrasoft.Core.ServiceModel.ProcessEngineService, Terrasoft.Core.ServiceModel, Version=7.17.2.1728, Culture=neutral, PublicKeyToken=edaadfbc3b0bb879]

System.NullReferenceException: Object reference not set to an instance of an object.

at Terrasoft.Core.ServiceModel.ProcessEngineService.GetSchemaParameterValues(UserConnection userConnection, BaseProcessSchemaElement baseSchemaElement, IEnumerable`1 completeParameters)

at Terrasoft.Core.ServiceModel.ProcessEngineService.CompleteExecuting(CompleteExecutingRequest request)

at SyncInvokeCompleteExecuting(Object , Object[] , Object[] )

at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

2021-06-17 11:18:26,697 [358] ERROR ZARZĄDZANIE NT\SYSTEM Terrasoft.Web.Common.ServiceModel.ErrorHandler ProvideFault - Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an object.

at Terrasoft.Core.ServiceModel.ProcessEngineService.GetSchemaParameterValues(UserConnection userConnection, BaseProcessSchemaElement baseSchemaElement, IEnumerable`1 completeParameters)

at Terrasoft.Core.ServiceModel.ProcessEngineService.CompleteExecuting(CompleteExecutingRequest request)

at SyncInvokeCompleteExecuting(Object , Object[] , Object[] )

at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

2021-06-17 11:18:26,697 [358] ERROR ZARZĄDZANIE NT\SYSTEM Terrasoft.WebApp.FileWebEventProvider RaiseInternal - Date: 17.06.2021 11:18:26

Date (UTC): 17.06.2021 09:18:26

Exception Message: Object reference not set to an instance of an object.

Exception Type: System.ServiceModel.FaultException`1[System.NullReferenceException]

Exception Source:

Exception Stack Trace:

SessionID: zl3nd5bqp5z5fgexzrdibnle

Request URL: /0/ServiceModel/ProcessEngineService.svc/CompleteExecuting

Request Path: /0/ServiceModel/ProcessEngineService.svc/CompleteExecuting

Request UrlReferrer: http://localhost:81/0/Nui/ViewModule.aspx

Request Type: POST

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.106 Safari/537.36

User Host Address: ::1

User: Supervisor

Is Authenticated: True

Authentication Type: Forms

Is Secure Connection: False

Application Version: 7.17.2.1728

Application Path: C:\Creatio_7_17\Terrasoft.WebApp\

Application Virtual Path: /0

Application Trust Level: Full

Machine Name: DCG-249

Is Local: True

Process ID: 15220

Process Name: w3wp.exe

Process Account Name: ZARZĄDZANIE NT\SYSTEM

Thread Account Name: ZARZĄDZANIE NT\SYSTEM

OS Version: Microsoft Windows NT 10.0.19042.0

Net Framework Version: 4.0.30319.42000

DBExecutor Type: MSSqlExecutor

the request is:

{collectExecutionData: true, processElementUId: "05ea0041-ae68-4465-a0d0-c7582ab6c03f"}

URL

http://localhost:81/0/ServiceModel/ProcessEngineService.svc/CompleteExe….

Any ideas?

Regards

Tomek

1 comments

Ivanna Yatsura

18:12 Jun 24, 2021

Dear Tomasz,

Could you please elaborate more on after what actions do you receive this error?

Thank you in advance.

Best Regards,

Ivanna Yatsura

Show all comments

Studio_Creatio

How to create a business process for a reminder email to go out automatically?

Andie Mathos

23:32 Jun 15, 2021

I am currently trying to create a business process that will send a reminder email out every 48 hours if a client has not filled in a specific section (Legal Business Name) in their client portal. I have it set to read the case info and then form data and after that I have it set to 'Read the first record in the selection', the appropriate section chosen, and then filter records by 'Legal Business Name is not filled in'. From there I know I will need two flows - one to go to terminate if it is filled in and one to go to the reminder email, the repeat, and then the terminate once filled in. How do I format these two flows? Do I have the appropriate thing selected (read the first record in the selection)? Is there something more I am missing?

1 comments

Yurii Sokil

13:13 Jun 16, 2021

Andie,

Let's say your ReadData element is called "ReadCase"

To fulfill your task you need to create a default flow with the email being sent to the client.

The second flow should be a conditional flow leading to Terminate , with the condition being:

[#ReadCase.First item of resulting collection.Id#] == Guid.Empty

It means that there were no records meeting that condition.

Best regards,

Yurii.

Show all comments

Subscribe to Studio Creatio