I'd need some documentation.

[QED]

Dear sirs,

I'm currently using the ES5 Grid to perform some CRUD on a remote SQL server database. After some time spent to figure out which kind of data adapter to use I choose the WebApiAdaptor and a .ashx file as a backend.

What I’m asking you is where I can find some documentation on how the grid communicate with the backend, which kind of request sends, their meaning and so on. At the moment all I could do was intercept the payload sent in the POST request made by the grid and *try* to understand they meaning but it’s a time consuming task…

I searched your site but I could not find any useful documentation, if you could help me…

Thank you,

DOMENICO

[Hemanthkumar S]

Hi DOMENICO,

Greetings from Syncfusion support.

Query: where I can find some documentation on how the grid communicate with the backend, which kind of request sends, their meaning and so on

Based on the information you provided, it seems that you are inquiring about the process of fetching data from a WebApi Controller and binding it to a Grid control using the WebApiAdaptor of DataManager. We have already discussed the same in the below documentation which contains the procedure and sample. Please refer to the below documentation for more details.

Bind data to the Syncfusion Controls using WebApiAdaptor: https://ej2.syncfusion.com/aspnetcore/documentation/common/data-binding/webapi-service-binding

Creating API Controller: https://ej2.syncfusion.com/aspnetcore/documentation/common/data-binding/webapi-service-binding#creating-api-controller

Regards,

Hemanth Kumar S

[QED]

Thank you from your reply and the links provided, but I was (and I am still) looking for documentation abot the "verbs" or "commands" the grid SENDS to the endpoint.
As i said before, using   WebApiAdaptor I had to analyze all the json payload sent to endpoint and try to interpret them the best I could which is far less than you could tell me.

For example: I could easily understand these payloads

{
  "requiresCounts": true,
  "skip": 0,
  "take": 250
}
{
  "value": {
    "idrec": 7,
    "Ditta": "qed",
    "Chi": "zzzz",
    "Cosa": "ASSUME STAGE",
    "Data": "2016-07-15T22:00:00.000Z",
    "Note": "FANNO LORO",
    "Note2": "OK FONDAZIONE",
    "Note3": "",
    "UserIns": "",
    "TimeIns": "1899-12-30T23:00:00.000Z",
    "UserUpd": "",
    "TimeUpd": "2023-12-06T18:34:25.000Z"
  },
  "action": "update",
  "keyColumn": "idrec",
  "key": 7
}

but problems arose with filters, especially complex ones like this

{
  "requiresCounts": true,
  "where": [
    {
      "isComplex": true,
      "ignoreCase": true,
      "ignoreAccent": false,
      "condition": "and",
      "predicates": [
        {
          "isComplex": false,
          "field": "Ditta",
          "operator": "startswith",
          "value": "qe",
          "ignoreCase": true,
          "ignoreAccent": false
        },
        {
          "isComplex": false,
          "field": "Chi",
          "operator": "startswith",
          "value": "f",
          "ignoreCase": true,
          "ignoreAccent": false
        },
        {
          "isComplex": false,
          "field": "Cosa",
          "operator": "equal",
          "value": "OK",
          "ignoreCase": true,
          "ignoreAccent": false
        }
      ]
    }
  ],
  "skip": 0,
  "take": 250
}

SO, I'm asking if there is any kind of thorough documentation so that I can "feel safe" about my capabilities of undestandin how the the grid talk with the backend... 

[Hemanthkumar S]

Hi DOMENICO,

Query: documentation about the "verbs" or "commands" the grid SENDS to the endpoint. documentation so that I can "feel safe" about my capabilities of understanding how the the grid talk with the backend

Please refer to the documentation below, which provides information about the API sent to the server by the grid, including details about the actions for accessing data from the server.

https://ej2.syncfusion.com/javascript/documentation/api/data/query/

https://ej2.syncfusion.com/javascript/documentation/api/grid/predicateModel/

Regards,

Hemanth Kumar S