I have installed the Identity server locally and set up oAuth on Creatio -screenshot attached-

I generate a token from the identity server like this 


Then use the token to authenticate OData like this 

and as you can see it is returning 401, I made sure the user has roles that make it able to read the data but still

Hi Team,

I am seeing some compilation error in the configuration tab after working on oData. Below is the screenshot for your reference:

Below are the error message descriptions for your reference:

Could not copy "obj\Release\Terrasoft.Configuration.ODataEntities.dll" to "bin\Terrasoft.Configuration.ODataEntities.dll". Exceeded retry count of 10. Failed. The file is locked by: "IIS Worker Process (24568)"

Unable to copy file "obj\Release\Terrasoft.Configuration.ODataEntities.dll" to "bin\Terrasoft.Configuration.ODataEntities.dll". The process cannot access the file 'C:\Academy\Builds\D1_Dev\Terrasoft.WebApp\Terrasoft.Configuration\bin\Terrasoft.Configuration.ODataEntities.dll' because it is being used by another process.

Can anyhow let me know how to fix these issue?

Thanks!

Hi Creatio community,

Where are the logs of batch query calls stored in Creatio? I need to implement a notification logic that triggers every time a batch query is processed in Creatio.

Kind regards

Hello,

I was trying to Create a random SQL View in Creatio Cloud and wanted to check if I can access it's records through Creatio Odata API. I followed below steps.

    1. Created  below simple SQL view in Creatio to display account and their annual revenue. 
    

IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UsrVwAcctRevenuesT]'))
            DROP VIEW [dbo].[UsrVwAcctRevenuesT]
            GO 
            CREATE VIEW [dbo].[UsrVwAcctRevenuesT] AS
            SELECT Account.Id AS UsrId, AccountAnnualRevenue.Name AS UsrRevenue
            FROM Account  LEFT OUTER JOIN AccountAnnualRevenue  ON 
            Account.AnnualRevenueId = AccountAnnualRevenue.Id
            GO
   

    
    2.  I created new object in Creatio with same name (UsrVwAcctRevenuesT) as that of my SQL view with columns as "UsrId" (GUID datatype) and  "UsrRevenue" (TEXT data type with 50 chars) and kept same title.

    3. I marked above object as "Represents Structure of Database View" and set Id as "UsrId"
    
    4. Saved, published and compiled above new object.
 

But now when I tried to access it from Creatio Cloud through odata using below URL, 
https:///0/odata/UsrVwAcctRevenuesT
 

I am getting below error.

{"error":{"code":"","message":"An error has occurred.","innererror":{"message":"The 'ObjectContent`1' type failed to serialize the response body for content type 'application/json; odata.metadata=minimal'.","type":"","stacktrace":"","internalexception":{"message":"42P01: relation \"public.UsrVwAcctRevenuesT\" does not exist","type":"","stacktrace":""}}}}

Am I missing anything ?

Thanks.

 

I am trying to get contact collection data from creatio using OData 4. 

In my account, I have tons of contact data, but somehow API gives empty error.

Is it something related to permission access related issue?

@Community, please help to solve this issue

Hello,

we want to use cloud version of PowerBI, that's why we cannot use addon from marketplace (https://marketplace.creatio.com/app/microsoft-power-bi-connector-creatio)

As I see, PowerBI has option to get data via OData Feed.

But basic authorization doesn't work there (the same in Excel, for example). Do you have any experience how to achive that?

Thank you!

I am looking to filter an odata request within power automate to return only records where the modifiedon date is greater than a specified value. I have thus far tried the following without success:

$filter=ModifiedOn%20gt%20datetime'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message": "The query specified in the URI is not valid. Unrecognized 'Edm.String' literal 'datetime'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetime'2023-05-23T00:00:00.0000000Z''.", "innererror": { "message": "Unrecognized 'Edm.String' literal 'datetime'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetime'2023-05-23T00:00:00.0000000Z''.", "type": "", "stacktrace": "" } } }

$filter=ModifiedOn%20gt%20cast('2023-05-23T00:00:00.0000000Z','Edm.DateTimeOffset')

{ "error": { "code": "", "message": "The query specified in the URI is not valid. The binary operator GreaterThan is not defined for the types 'System.Nullable`1[System.DateTime]' and 'System.Object'.", "innererror": { "message": "The binary operator GreaterThan is not defined for the types 'System.Nullable`1[System.DateTime]' and 'System.Object'.", "type": "", "stacktrace": "" } } }

$filter=ModifiedOn%20gt%20'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message": "The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThan'.", "innererror": { "message": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThan'.", "type": "", "stacktrace": "" } } }

$filter=ModifiedOn%20gt%20datetimeoffset'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message": "The query specified in the URI is not valid. Unrecognized 'Edm.String' literal 'datetimeoffset'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetimeoffset'2023-05-23T00:00:00.0000000Z''.", "innererror": { "message": "Unrecognized 'Edm.String' literal 'datetimeoffset'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetimeoffset'2023-05-23T00:00:00.0000000Z''.", "type": "", "stacktrace": "" } } }

Any suggestions for how to achieve this would be much appreciated. Thanks.

Dear community, 

I have seen a wonderful example to post XML data to ODATA Service with POST method. I am looking into ODATA service with GET method. I am really need of it as my management is eagerly looking at me. please send the example as soon as you can.

Thanking you,

Inayatullla

Hello.

How to attach a phone call to a contact and lead using odata3 or odata4?

Also is there a list of collection names?

I am trying to find the api list of this crm, I find the postman collection also, but unable to generate the access token