Hi Raz,

First of all you need to check the application logs and see the actual server error that is received upon calling the Products object via OData. Secondly you need to check if there are no errors with any of the "Products" objects in the system configurations (maybe the system asks to update the database structure for any "Product" object in any package or source code update is required). Also try publishing all the replaced "Product" objects in configurations.

Best regards,

Oscar

Oscar Dylan,

Hi Oscar,

I didn't understand your answer at all.

I will elaborate:

1. The error 500 occurs even when querying the product section.

2. Which application logs? the application runs in the cloud.

3. what do you mean by "errors with any of the products objects"? again, the issue occurs even when querying the section.

Thanks,

Raz

Oscar Dylan,

Hi Oscar,

I have a new update on the issue.

I don't know what happen, but now the Get Request works, the Post request for creating a new product works too.

But, Once I enter the product in the system and "Close" button changes to "Save". It looks like something in the creation of the product didn't finish correctly.

Can you point me to what to check?

Thanks,

Raz

Raz Guille Rosman,

Hi Raz,

Regarding your remarks:

1) "1. The error 500 occurs even when querying the product section." - I did understand that and that's why asked you to go to system configurations and check if any of the "Products" objects has "Database update is required" or "Source code update is required" error flag. The situation you described looks like the issue with an object in configurations and that's why it had to be checked.

2) "2. Which application logs? the application runs in the cloud." - you should've mentioned that the application is running in the cloud. You can contact us directly at support@creatio.com to get the application logs if needed. If this was an onsite app the logs could be found at C:\Windows\Temp\Creatio folder in the machine where the IIS-server is deployed.

3) "what do you mean by "errors with any of the products objects?" - again, the issue occurs even when querying the section." - I meant the actual error on the object, something like this:

And yes I understood that you received the error when performing OData requests and everything is simple: if there is a problem with an object OData requests to this object can fail.

As for your last remark that the button becomes "Close", but not "Save": it means that there was some modification on the page that should be saved. It can be rather the method on the product page that wasn't executed (or was executed) completely or you've clicked on some field when the page was opened. No error here.

Best regards,

Oscar

Oscar Dylan,

H Oscar,

Thank you very much for your very detailed response.

1. The error 500 stopped, I don't know why. It just stopped and both the get and post requests are working correctly.

2. Thanks for the explanation. I'll keep that in mind for the next time.

3. I checked and there are no processes or other js code that runs in the background for a new record.

Do you have an idea where to start looking?

Thanks,

Raz

Hi Raz,

For this kind of requests OData has Butch. 

Please follow the link to check the details of how to work with it: 

https://academy.creatio.com/docs/developer/integrations_and_api/data_se…

Best Regards, 

Bogdan L.

Bogdan Lesyk,

Hi Bogdan,

Thank you for your response and article.

I didn't understand how the batch requests solves my scenaro.

I'll elaborate:

I have a woocommerce website that needs to update creatio every time there is a new order.

The woocommerce json looks like this:

{

 "id": 1234,

"status": "ABC",

"Line_Items": [ {"prod_id":1111,"quantity":10},{"prod_id":2222,"quantity":20}],

"Order_Lines": [],

"Coupon_LInes": []

}

As you can see one Json includes all the order data.

In Creatio for each array, like Line_Items, Order_Lines and etc, we have a detail connected to the order section.

Is there a way to use the ODATA Web services mechanism in such a way that the woocommerce website can update all the relevant sections and details?

Thanks,

Raz

Hi Raz, 

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

{

 "id": 1234,

"status": "ABC",

"Line_Items": [ {"prod_id":1111,"quantity":10},{"prod_id":2222,"quantity":20}],

"Order_Lines": [],

"Coupon_LInes": []

}

Most likely this code will not work, because Line_Items, Order_Lines and etc. will be perceived by the system like "field". 

You may create one order, in response you will get it's "Id" and then with using batch you may add  couple records in your details.

Best Regards, 

Bogdan L.

Bogdan Lesyk,

Thank you for your response

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:

https://o_drobina.tscrm.com/0/odata/SysLocalizableValue?$filter=SysSchema/Id%20eq%206404D801-E280-418A-A77C-D02B98271499

You will get an array of values where three key columns are "Key", "Value" and "SysCultureId" columns (by the way you can also include the "SysCultureId" column to the request filter). After that you can process with the data received.

Best regards,

Oscar

Jerome, 

In addition to Oscar's response, another way is to do a POST to:

/0/DataService/json/SyncReply/RuntimeEntitySchemaRequest/

And include the object name in the body, the body will look like this for the account object:

{"Name": "Account"}

You'll get back a list of all properties for the object including the captions in all defined translations.

Ryan

Oscar Dylan,

Thanks a lot, I used this:

/0/odata/SysLocalizableValue?$select=key,value&$expand=SysSchema($select=Id,Name),SysCulture($select=Id,Name)&$filter=SysSchema/Name eq 'Case' and SysCulture/Name eq 'fr-fr'

Hello Uriel,

Once authenticated normally, you can do a POST to the following (it's DataService, but when you authenticate for OData it will also work for DataService, even if you're using OData for the other requests):

/0/DataService/json/SyncReply/RuntimeEntitySchemaRequest

Include the following payload in the request:

{"uId":"25d7c1ab-1de0-4501-b402-02e0e5a72d6e"}

Where the uId included is the UId for the entity (you can get this from SysSchema or VwSysSchemaInWorkspace where ExtendParent = false). You'll get back a json payload with details for all columns, including the "isRequired" value for the column.

Ryan

Ryan Farley,

Thank you! Have a nice weekend.

Ryan Farley,

Hello,

I need to update, using odata, a record in Creatio, but there are one or more fields that are required to be completed, on the Creatio side (Form_Page) that are not completed and I get error when updating those records using odata.

Is there any way to skip the required field rules (fields not related to the integration) and get the object update using odata?

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. 

Dennis Hudson,

Is that something I have access to through the development console?

Heather,

If you have an on-site application you can find the web config file in the installation files. If you have a cloud application, you can request this information from the support team (support@creatio.com).

Heather,

 Did you manage to connect using Odata?

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 than the total number of records, all records will be returned. For example: 

ContactCollection?$top=100000

Will return 100,000 contacts, or if less exist, all will be returned. Meaning if only 9000 contacts exist, all will be returned. 

You can also page the results, which is a better option in many/most cases. You can page the results by using $top along with $skip. For example, to page 100 records at a time, the first request would be:

ContactCollection?$top=100

Then the next request would be:

ContactCollection?$top=100&$skip=100

to get the next 100 records. Then the next would be:

ContactCollection?$top=100&$skip=200

You would keep incrementing the $skip by the number used for $top with each request to get the next page of results.

Ryan

Ryan Farley,

Neither DataService nor Odata will return over 20,000 records

Ryan Farley,

Hi Ryan,

After exscuting this code below



XDocument xmlDoc = XDocument.Load(dataResponse.GetResponseStream());



I noticed there is a descendant "link" which value of attribute "rel" is "next", is that the link for next page?

Kirill Krylov CPA,

Thanks Kirill, I figured there was a hard limit somewhere and 20,000 makes sense as I've seen that limit with reads in processes as well - never tried loading more than 20,000 via OData/DataService, not a good idea - Paging is always the way to go!

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):

https://creatioaddress/0/ServiceModel/EntityDataService.svc/ContactCollection(guid'00000000-0000-0000-0000-000000000000')

Also, even though the docs specify a PUT for updates, it will also accept a PATCH (which is what I usually use)

Ryan

Hi Ryan,

I don't understand why my PUT calls work fine today without any modification on my side.

Here's the URL:

https://urltocreatio/0/ServiceModel/EntityDataService.svc/UsrExternalisationCollection(guid'b83bedb1-ad72-4c6a-9965-88677a13dfe1')

I see with my support team if they have modified something.

Thank you for the answer, have a nice day.

Nicolas

=>>>>

I had the problem one more time.

it was because i didn't compile the database new elements before to try my oData access

Dear Muhammad,

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

Best regards,

Norton

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.

According to the <edmx:DataServices /> element in the metadata, the bpm'online OData implementation is version 3.0, however, I've found that it doesn't always match up to the 3.0 spec (I'm not sure if that's the version that bpm'online officially claims their OData API implements). I don't really have any answers as to what is or isn't implemented. As Alina mentioned, toupper does work.

However, also worth pointing out, by default bpm'online OData string filters aren't case sensitive anyway. Using "Name eq 'Our company'" and "Name eq 'OuR COMpAnY'" both return the same record with the name "Our company". 

Ryan

Thanks. I have changed it to toupper and its working.

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 you filter by UsrEmirates/Id. For example, as if I would like to select orders with certain opportunitites, I would filter by Opportunity/Id

Hope you find it helpful,

Anastasia