How to retrieve cases with the specific StatusId from BpmOnline Service API's CaseCollection? 

I use the OData to extract the data. I need to get cases with the specific status from the CaseCollection. To do this I use the following Http-request:

https://company.bpmonline.com/0/ServiceModel/EntityDataService.svc/Case… eq guid'7e9f1204-f46b-1410-fb9a-0050ba5d6c38'.

But I recieve the "404 ERROR

1

Элемент коллекции с именем StatusId не найден " (The element  StatusId is not found").



But if I do https://company.bpmonline.com/0/ServiceModel/EntityDataService.svc/Case…;

it responses with 200 OK.



How to retrieve cases with the specific StatusId from CaseCollection? 

Like 0

Like

1 comments

Hello Timur,



The Status column in the Case table is the foreign key for CaseStatus table. Therefore, the correct syntax is the next: [Name_of_joinable_table / Name_of_column_for_linking_of_joinable_table].

In your example it will be: https://ticketland.bpmonline.com/0/ServiceModel/EntityDataService.svc/C… eq guid'7e9f1204-f46b-1410-fb9a-0050ba5d6c38'.

Show all comments