Error posting new content in Grid (OData)

[Erick]

Hello,

Please look at the following code snip:

<SfGrid ID="DetailProgramsGrid" @ref="@DetailProgramsGrid" TValue="CustomerLoyaltyPrograms" AllowResizing="true" AllowSorting="true" AllowReordering="true"

Toolbar="@DetailProgramsTool"

Query="@(new Query().AddParams("$expand","customerloyaltyprogrampointsprogramnavigation").AddParams("$filter",$"customerloyaltyprogramsperson eq {selectedPersonId}"))">

<GridPageSettings PageSize="5"></GridPageSettings>

<GridEvents OnActionBegin="ActionBeginProgramsDetailHandler" RowSelected="DetailProgramsRowSelectHandler" TValue="CustomerLoyaltyPrograms"></GridEvents>

<SfDataManager Url=@($"{apiURL}/customerloyaltyprograms") Adaptor="Adaptors.ODataV4Adaptor" CrossDomain="true"></SfDataManager>

When I try to add a record, the OData API responds with the following error:

message: "The query specified in the URI is not valid. The requested resource is not a collection. Query options $filter, $orderby, $count, $skip, and $top can be applied only on collections."

I see that the POST request made from the Grid is including the $expand and $filter params. Is this se source of the error? Is there any way not to send this two params in the POST request?

I tested in postman without the $expand and $filter params and it works ok.

Thanks,

erick

[Jeevakanth Palaniappan]

Hi Erick, 

We have checked the reported issue and we suspect that the issue is due to binding $expand and $filter in the Addparams method of Query class. Instead we suggest you to use the Expand and Where method of Query class to resolve this issue. Please refer the below code snippet. 

<SfGrid ID="DetailProgramsGrid" @ref="@DetailProgramsGrid" 

Query="@(new Query().Expand(new List<string>() {"Id"}).Where("Id", "equal", 1))"> 

     <GridPageSettings PageSize="5"></GridPageSettings> 

     <GridEvents OnActionBegin="ActionBeginProgramsDetailHandler"RowSelected="DetailProgramsRowSelectHandler" > 

    </GridEvents> 

.. 

.. 

</SfGrid> 

Also refer our UG documentation on complex binding for your reference 

https://blazor.syncfusion.com/documentation/datagrid/columns/#complex-data-binding  

Kindly get back to us if you have any other concerns.  

Regards, 

Jeevakanth SP. 

[Erick]

Works Great. Thank you very much.

[Rahul Narayanasamy]

Hi Erick, 

 

Thanks for the update. 

 

We are happy to hear that the provided solution was helpful to resolve your problem. 

 

Please get back to us if you need further assistance. 

 

Regards, 

Rahul