Grid does not display data from the WebApi source

Question

Hello,I'm trying to display Grid entries with WebAPI, but I do not like it.The Api Web interface works properly, as seen on the attached screenshot, the data is downloaded but the Grid does not appear.Please help.Sincerely,PatrikAttachment: Grid_WebAPI_e279c868.zip

Venkatesh Ayothi Raman · Answer

Hi Patrik, 

Thanks for using Syncfusion products. 

We went through your screenshot that you have shared with us and you are just returning the JSON data from WebAPI service. Since WebAPI adaptor, we need to return the response from server side as an object. In that Object has two properties named as following Items and count. Here, Items should have a value of  JSON data and count has a value of total records count in Database. Please refer to the following code example and Screenshot, 
Code example: 




  public object Get() 
        { 
            var queryString = HttpContext.Current.Request.QueryString; 
            int skip = Convert.ToInt32(queryString["$skip"]); 
            int take = Convert.ToInt32(queryString["$top"]); 
            var data = OrdersDetails.GetAllRecords(); 
            return new { Items = data.Skip(skip).Take(take), Count = data.Count() }; 
        } 

Screenshot: 
  

We have also prepared a sample for your convenience which can be download from following link, 
Sample:http://www.syncfusion.com/downloads/support/directtrac/general/ze/F137066_sample692591212 


Help documentation: https://ej2.syncfusion.com/16.1.32/aspnet/documentation/grid/databinding.html?syntax=razor#web-api 


Regards, 
Venkatesh Ayothiraman.

Patrik Volka · Answer

Work fine!Thank you

Venkatesh Ayothi Raman · Answer

Hi Patrik, 

Thanks for the feedback. 

We are very happy to hear your requirement is achieved. 
  
Regards, 
Venkatesh Ayothiraman.