Hi,

I have a strange behavior when working with postman and ODATA webservices.

I'm trying to get the data from "Product" section and keep getting an Error 500 message.

The link that I'm using is "https://domain.creatio.com/0/odata/Product"

In Addition, It's important to keep in mind the following:

1...MoreLess

Like 0

Like

5 comments

Hi Raz,

First of all you need to check the application logs and see the actual server error that is received upon calling the Product...MoreLess

Show all comments (4)

Hi,

Does the ODATA Web services mechanism supports collections?

meaning, using a post request with a json that includes arrays?

Thanks,

Raz

Like 0

Like

4 comments
Best reply

Hi Raz, 

Unfortunately we don't have practical examples of such implementation.

{

 "id": 1234,

"status": "ABC",

"Line_Items": [...MoreLess

Show all comments (3)

Hi all,

Is there any way throught odata (or via a webservice) to retrieve for a given table, the translations of all columns ?

And if not, is it possible a server side ?

Like 0

Like

3 comments

Hello Jerome,

Here is an example of the odata request endpoint that gets all the localizable values for all the columns of the "Account" object:

...

MoreLess

Show all comments (2)

We are developing an external application to Creatio with integration via oData.

We need to know how to obtain with odata the required fields of a schema, for example contact and the data type of each field.

Thank you!

Regards

Like 0

Like

3 comments
Best reply

Hello Uriel,

Once authenticated normally, you can do a POST to the following (it's DataService, but when you authenticate for OData it will...MoreLess

Show all comments (2)

We have a PowerBI report connecting to Creatio through OData, with a data source refresh every day at 7am MST. Every single day, it fails with this message.

---------------------------------------------------------------------------------------------------------------

Failure details: The last refresh...MoreLess

Like 0

Like

4 comments

Dear Heather, 

Please make sure that the flag LogSessionForSessionLessRequest is set to false in web.config in the root folder in installation files of your site. 

Show all comments (3)

Hi Community,

https://academy.creatio.com/documents/technic-sdk/7-15/working-creatio-objects-over-odata-protocol-using-http-request

As per Academy,  "Records are returned by pages, 40 records per page. If a request is supposed to return more than 40 records, the reception of the next page must be ensured to reach the end of the current page.". How can I execute automatically and get the data from next page? Any idea? Thanks.  

Like 0

Like

4 comments

Hello Fulgen,

The $top query parameter can be used to indicate how many records to return. While 40 is the default, if you use a value larger...MoreLess

Show all comments (3)

Dear mates,

I m building an external form which must insert/update an object collection with oData.

GET - POST and DELETE works fine

But if i want to update (PUT), i ve got the following error: the item is not found

{"error":{"code":"1","message":{"lang":"","value":"L'\u00e9l\u00e9ment UsrExternalisation...MoreLess

Like 0

Like

2 comments

What does the URL look like that you're doing the PUT on? It needs to look like this (but obviously with the record Id instead of an empty Guid):

...

MoreLess

Show all comments (1)

Hi,

I need Users to get registered as Creatio Portal User and get authenticate on my own website where I currently showing some data from Creatio CRM using Odata service.

Is it possible through Odata service or else please suggest easiest way?

Any help will be highly appreciable

Regards

Like 0

Like

1 comments

Dear Muhammad,

Could you please provide more details on that you want to achieve?

Best regards,

Norton

Show all comments

Hi

I'm using bpm'online OData service to filter the account collection.

It looks like that the tolower function is not supported.

I'm using bpm'online 7.14.

http://localhost:7004/0/ServiceModel/EntityDataService.svc/AccountCollection?$top=20&$filter=substringof('test',tolower(Name))&$inlinecount=allpages

Any idea how to add tolower function to the supported functions list.

Thank you

Mohamed

Like 0

Like

3 comments

Unfortunately, bpm'online doesn't support the tolower function of work with the OData protocol strings. However, it's possible to use the toupper function instead.

Show all comments (2)

Hi Community,

Currently I am not able to filter record using ODATA for my lookup field, I am getting object reference error. Below is my request string.

UsrEmiratesId is the lookup field

"UsrAreaCollection?$top=1000&$filter=UsrEmiratesId eq guid'" + emirateId + "'&select=Id, Name, UsrEmiratesId"

But when I filter the record using Id which the PK column, request is successful, what is wrong with this lookup field why it is not working

Like 0

Like

1 comments

Dear Fulgen,

The possible reason for an error could be in syntax of lookup in the request. Please try to modify the request string, so that...MoreLess

Show all comments