Hello community,

 

I want to add data inside a section with the OData interface. I've already checked the documentation at https://documenter.getpostman.com/view/10204500/SztHX5Qb?version=latest and https://academy.creatio.com/docs/developer/integrations_and_api/data_se… but I have the following problem:



I am using a simple Python script to make the API requests in these steps:

 

1. Authenticate in the website using the Authentication method

This works nice using the credentials as payload inside the request.

 

2. Extract the cookie returned inside the header response.

From the test I've made, I need to extract the cookie parts UserName, BPMCSRF, .ASPXAUTH, BPMLOADER and append all of them inside a "Cookie" header like this example:

 

"Cookie: BPMLOADER=; UserType=General; UserName=; .ASPXAUTH=; BPMCSRF=;"

 

Everywhere I've checked inside the documentation it says that it is enough using a header called BPMCSRF with that value from the Set-Cookie response header, but in my case it fails using that value and I have to build the Cookie myself with the different values specified above.

 

3. Perform a POST request to a section like https://mycreatio.com/0/odata/Case

Here the request fails and I get an error 403 - Forbidden with the following message:

 

403 - Forbidden: Access is denied.

You do not have permission to view this directory or page using the credentials that you supplied.

 

And I don't understand why Creatio returns that error, because if I try doing a GET request to the same URL it returns the full list without any problem, but performing a POST request using the same cookie structure inside the headers doesn't return the expected inserted register.

 

Thanks in advance in for your help.

 

Regards.

Like 0

Like

3 comments

Just to clarify, in theory the issue is not related to user permissions as I have tried to insert registers with multiple users (one of them being Supervisor) and in multiple sections, but I always get the same error.

 

P.D. I am using OData 4

Hello Alejandro!

 

For correct requests, you need to use all cookies not "only a part". Also "BPMCSRF" must be used in cookies and as a separate parameter in the header as mentioned in the example here Creatio API (getpostman.com).

Please try and test it with the corresponding changes.

Hello Kyrylo,

 

Thank you very much for your help. In my case the problem was only with that "BPMCSRF" header that I was not building properly, for the cookie values that I have to pass inside the "Cookie" header I tried passing ALL the values extracted from the response header "Set-Cookie" but it didn't let me authenticate, so the solution that works for me is creating a cookie manually with only the values  UserName, UserType, BPMCSRF, .ASPXAUTH, BPMLOADER that I mentioned before.

 

The POST requests are working flawlessly now. I will try now to upload files using OData following the documentation and I would highly appreciate if you are able to help me again if I have trouble.

 

Thank you very much.

Show all comments

Hi all,

 

I have a client who uses an unlimited multi-line text field in a detail and they would like to be able to see Line-breaks in the tile view of said detail.

 

Detail page view





Detail tile view

Is this possible?

Nb. We are using version 8 of creatio and the Freedom shell but the not Freedom pages.

Like 2

Like

2 comments
Best reply

Hello,



Unfortunately, it is impossible to implement line breaks in the tile view of a detail with basic tools. However, you can try to accomplish this task with the help of development.



A task has already been registered in our R&D team to consider and implement such a feature in future releases. Thank you for helping us to improve our product.

Hello,



Unfortunately, it is impossible to implement line breaks in the tile view of a detail with basic tools. However, you can try to accomplish this task with the help of development.



A task has already been registered in our R&D team to consider and implement such a feature in future releases. Thank you for helping us to improve our product.

+1 priority for this feature

Show all comments

Hi all, 

 

Many users have started to experience a random error where all Creatio tabs suddenly shut down. I've had it reported across users in different offices, so I know it's not a local issue. Creatio also seems to be the only website where this happens. 



Wondering if anyone else has experienced this or if there is something in our configuration that's causing it.  



This is just one of the error codes that have been reported, but there have been a few. 



Thanks

Harry

 

 

 

Like 1

Like

11 comments

I've been getting that too. I assume this is on Freedom UI pages? I definitely have seen this with Freedom UI pages (never on classic UI pages)

I seem to get this mostly on the Freedom UI Accounts_FormPage (on occasion, not consistently every time). It only seems to happen in Chrome, I've never noticed it when using Safari. I get this often in my own Creatio system, although no other users have reported it to me, so I was thinking it was something weird with my browser or browser extensions or something. 

For some reason I feel like I've seen it less lately, so wondering if 8.0.10 fixed something? My system was recently upgraded to 8.0.10 so could be related. I guess now, knowing that it's not just my browser, I'll start keeping track of when it happens.

Ryan

Thanks Ryan, we're definitely seeing it across quite a few users. 



Our instance is entirely running with Freedom UI pages, and doesn't seem to be consistent to one particular page. From my research it's possibly something to do with the browser memory of freedom UI pages, and chrome being overloaded. 



Be interesting to see if others are experiencing the same. Creatio support are not aware of any issue.

Hi all, we are experiencing this too, again with Freedom pages.  We've also seen this happen with Chrome with other systems where there is a richer UI...seems the browser just runs out of memory.

Hi All, 



Has anyone found a solution to this yet? I'm receiving more cases every day.



Thanks

Harry

Harry,

I've been getting this more and more. Do you know if Creatio is aware of the issue? Have you created any support cases for this yet?

Ryan

Hi Ryan, 



Yes, I've created a case and followed up today. It's very tricky to get hold of a HAR file from our users, but have attempted to give as much information as possible. 



Hopefully there is a fix. I saw that you are also experiencing it on 8.1, so I guess no luck of this going with the update. 



Harry

Bump! 



Anyone figured this one out yet? Struggling to get any help on finding the root cause of this issue. 



Thanks

Harry!

We got a response from support that said the following: 

The error can be reproduced not only in Creatio, but on any website.

It is related to the update of Chrome to version 117+. For our part, we have prepared a fix, necessary update (8.0.10, 8.1.0, 8.1.1).

In the meantime, users experiencing this behavior should use Safari/Firefox browsers.

It sounds like they've identified the cause and have a fix, but I don't yet know which version that fix will be available or if it's something they can add to existing systems - I'm finding out.

Ryan

Thanks Ryan, I received the same reply. I've asked if that means they can apply the fix. 



I was receiving it non-stop today, yet I just updated chrome to the version below a few hours ago and I have not had any errors since. Hopefully this is a fix! 



Version 119.0.6045.159 (Official Build) (arm64)

Harry,

Great news Harry. I was also told by support that they have a fix for the issue - in case the Chrome update doesn't solve it, Creatio's fix should and it hopefully wont be happening any longer. 

Thanks Ryan. 



Yes, looks to be good now - glad we got there eventually!

Show all comments

Does anyone know a way of using an exponential value in a formula in a business process? The C# forums say to use Math.Pow(base number, exponent number) but I get an error that "No applicable method "Pow" exists in type "Math" when using that in a business process formula. 

 

The use case is that there's a a 2% annual escalator based on the warranty years of a certain product. So the formula would be (base price)*1.02^(years of warranty)

Like 0

Like

1 comments

 

Hello Andriana,

In order to use the static “Math” class in C# code you should add the “System” namespace to the file:

using System;

If the issue still exists, please provide us with a source code of the module and the error message. It will help us to analyze the issue in more details.

Additionally, please find more information about the “Math” class in the article by the link below:

https://learn.microsoft.com/en-us/dotnet/api/system.math?view=net-7.0 

Best regards, Anhelina!

Show all comments

Hello everyone,



I created two new folders entitled:

"CCU Trigger Emails"

"CFG Trigger Emails"



I am trying to place the emails in the attached snapshot to the above-mentioned folders but no matter which folder I click on, they all show up. Is there a way to better sort these out? Thanks in advance. 



Lucas

Like 0

Like

1 comments

Hello community,

 

I have an issue when compile.

Version Creatio: 8.0.10.4735

How can i fix this?

Like 1

Like

1 comments

Hi Maksym, 



Seem like the issue is not related to this exact environment but rather to the server that runs the Creatio instance. 

This problem has already been discussed on StackOverflow. There are multiple reasons for this problem which are discussed in the linked topic. 

Also, a possible reason is that the .NetCore SDK 2.2 and/or 3.1 is not installed and the server is not connected to the internet or it has no access to nuget.org.



Best regards,

Yuri. 

Show all comments

Hello community,

 

I want to get the attached files information from a given case inside my environment. As the primary section containing the information is case, I know that I can retrieve the case information from 

 

https://mycreatio.com/0/odata/Case

 

And the attached files can be extracted from 

 

https://mycreatio.com/0/odata/CaseFile

 

Where each element from the response has the format:

{
  "Id": "7bb283a4-2f30-7193-37f3-79c8465ceda4",
  "Name": "<value>",
  "CreatedOn": "<value>",
  "CreatedById": "<value>",
  "ModifiedOn": "<value>",
  "ModifiedById": "<value>",
  "ProcessListeners": 0,
  ...
  "Size": <value>,
  "CaseId": "<value>",
  "IsNeedToNotify": true,
  "SysFileStorageId": "<value>",
  "FileGroupId": "<value>",
  "Tag": "<value>"
},

As you may see there is a field "CaseId" which is used to link the file object to the case object.

 

The problem I have is that I want to get the list of files from a case only by the Case Id. I've tried many different approaches using the OData standard syntax like:

 

'">https://mycreatio.com/0/odata/CaseFile?$filter=CaseId eq '<value>'

 

But I always get an error when trying to access the resource. In the previous example, the error I get is related to the field data type. Creatio yells because the CaseId field is of type Guid but in the comparison I am using a string.

 

By the way, changing the query to:

 

'">https://mycreatio.com/0/odata/CaseFile?$filter=CaseId eq guid'<value>'

 

or

 

'">https://mycreatio.com/0/odata/CaseFile?$filter=CaseId eq <value>

 

Doesn't fix the issue.

 

Can you please help me with this query that I am struggling to do?

 

Regards

Like 0

Like

1 comments
Best reply

Rather than using CaseId, use Case/Id:

https://mycreatio.com/0/odata/CaseFile?$filter=Case/Id eq idvalue

Ryan

Rather than using CaseId, use Case/Id:

https://mycreatio.com/0/odata/CaseFile?$filter=Case/Id eq idvalue

Ryan

Show all comments

Hi Team,

 

The query is related to viewing records in the mobile application. By default, when we open a section in the Creatio mobile app, the listing page is empty, with a note to search for specific conditions to display records.

 

 

Is there an option to set a default folder from the already available saved folders for the section in the web app to be used as the default folder/condition for listing records as soon as the section is opened in the mobile application? Later, if users wish to change the filter, they can do so by selecting a different folder instead of viewing empty records in the list. For example, is it possible to display records for which the user has access? How can this be achieved? Are there any code samples available if code needs to be written, and if it's a configuration, how can we configure it for the mobile app?"

 

Thanks for the help in advance!

 

Regards,

Mayan

Like 0

Like

4 comments

Hello,

 

Please feel free to use the resolution from this article:  https://community.creatio.com/articles/setting-filter-mobile-application

Also, in case you want the assignee to be "current user" you may be interested in this answer: https://community.creatio.com/questions/get-current-user-contact-mobile

 

Thanks Bogdan,

 

If I log in to an instance as a regular user and not as a supervisor in web isntancce, by default, it lists all the records in a section for which the user has access, irrespective of whether they are the owner or assignee. This happens because the user has access, and the user's name is not available in any of the fields in the record, such as the owner field or assignee field. The record is shown because the user has access to it.

 

The same functionality needs to be achieved in the mobile app. However, here, we need to add a filter condition. For the scenario described above, we need to specify a reference field. If we set the owner field to the current user, it will list only the records where the user's name is linked to the owner field. But what about the records that the user has access to but does not own? How do we achieve this in the mobile application?

Thanks Bogdan, but can you help for the below scenario:

 

If I log in to an instance as a regular user and not as a supervisor, by default, it lists all the records in a section for which the user has access, irrespective of whether they are the owner or assignee. This happens because the user has access, and the user's name is not available in any of the fields in the record, such as the owner field or assignee field. The record is shown because the user has access to it.

 

The same functionality needs to be achieved in the mobile app. However, here, we need to add a filter condition. For the scenario described above, we need to specify a reference field. If we set the owner field to the current user, it will list only the records where the user's name is linked to the owner field. But what about the records that the user has access to but does not own? How do we achieve this in the mobile application?

 

Regards,

Mayan

Hello Mayan,

You can use this method to display all data:

Enter link [NameOfYourWebSite] .creatio.com/0/Features, search for UseMobileSearchOnlyInSections on this page. Uncheck all the boxes as you see in the image:

At this stage you can see all records in the mobile app.

Next you can use an article from Bogdan’s link to add filters if needed. Also I can recommend you one No-code way of filtering:

  1. System designer -> Mobile application wizard -> Needed workplace
  2. Find needed page (for example Order) and set the default filter. It will be impossible to get data in a mobile app which does not match the criteria of this filter

Best regards, Anhelina!

Show all comments

Hi community,

I created a business process that inserts a new OpportunityProductInterest for a specific product into a specific Opportunity.

The insert process element step copies the Product.Notes column to the OpportunityProductInterest.Notes column.

Product.Notes is a localizable text column and its value is localized to English and Italian.

If the BP is saved using a user localized in English, everything works fine, while if I make changes to the BP using a user localized in Italian, the BP does not work.

The expected result is the OpportunityProductInterest.Notes filled with the value Product.Notes, but in the wrong scenario the column is assigned the empty string.

 

What do you suggest me?

thank you in advance

Like 0

Like

1 comments

Hi,

I founded the solution.

The OpportunityProductInterest.Notes field was not a text localized, then the BP didn't work correctly.

I change the field as localized text and everything is fine now.

 

Show all comments

Hi Team,

 

We have a query regarding users having permissions to creating email templates in the Message Template section rather than admin creating email templates

 

Currently, only administrators have the ability to create email templates, select macro sources, and add macros while creating templates. However, the enquiry is whether the sales team would have the capability to create their own email templates for future use when communicating with customers rather than reaching out to admin for creating the email templates.

 

Is there a specific permission or access level that can be granted to normal users, specifically those in the sales team with a sales team license, which would allow them to create, save, and utilize their own email templates within the system? This would streamline our communication processes and empower our sales team to personalize their interactions with customers more effectively.

 

For now they are getting the below error while trying to create a email template :

Thanks for the help in advance!

 

Regards,

Mayan

 

Like 0

Like

1 comments

Hello,

for resolving this specific error you would need to give permission for operation by the code "CanManageLookups" in Operation permissions view in System designer. Not sure if users need more permissions to create templates but if its the only error occuring that could resolve it

Show all comments