Question

display values in odata

Hi All. 
Is there a way to pass a display value in odata rather then the GUID for the lookup values? 
 

Like 0

Like

1 comments

Hello Yuriy,
 

Let's try to do this on the example of the Contact object using the OData protocol version 4.0.

For the Contact object, in our case, the displayed value is the Full Name column (Code of the column Name).

displayed value

Name column
 

Let's take as an example the record of one contact by UId

https://1303997-demo.creatio.com/0/odata/Contact(51e3822e-0944-45bc-98b6-8a171802df84)

OData response by UId

Our task is to get this contact record by searching the Name column with the value Andrew Wayne.
 

If you look at the official examples of requests to the Creatio app via OData, the query will best suit our needs 


https://1303997-demo.creatio.com/0/odata/Contact?$filter=Name%20eq%20%27Andrew%20Wayne%27

This is the result we got

filter

I hope I understood you correctly and was able to provide a comprehensive answer.

 

I wish you a good day!

 

Show all comments