How to access added collection from oData web result?

We have a backend service that executes a query utilizing ODataOptions and returns a result set back as the client would expect, supporting an oData like structure (see below).  

example_result_2.png

When binding to a SfGrid using the ODataV4Adapter DataManager & Url property, everything works great.  The items from the "value" property bind without error.  If you look a bit closer, there is an extra collection being returned called "columns".  Our service injects this additional collection to provide more detail to the items being returned (see below).  

example_result.png

Our question is, how can we access the data on the client side?  Since we bind directly to a Url, we don't have access to the result set directly.  What would be the best way to gain access?

Thanks,

-JV



1 Reply

MS Monisha Saravanan Syncfusion Team May 27, 2022 01:45 PM UTC

Hi Jeff,


Greetings from Syncfusion support.


We have checked your query and we suspect that you need to access the inserted records in ODataV4 Adaptor. If so we would like to inform that for every CRUD operation ActionBegin and Action complete events will be triggered. You can get the inserted records detail at event args. Kindly check the attached UG for your reference.


Reference: https://blazor.syncfusion.com/documentation/datagrid/events#onactionbegin

https://blazor.syncfusion.com/documentation/datagrid/events#onactioncomplete


Also we suspect that you are facing issue with the columns collection. kindly share the below details to validate the issue further from our end.


  1. Share us the entire Grid code snippet and with the SfDataManager details.
  2. Share us the video demonstration of the issue along with replication procedure.
  3. If possible share us the simple issue reproduceable sample.


The above-requested details will be very helpful for us to validate the reported query at our end and provide the solution as early as possible.


Regards,

Monisha


Loader.
Up arrow icon