Hi George,
Thanks for contacting Syncfusion support.
We have validated the provided information and we suggest you to use custom data binding for grid to achieve your requirement. By default, while using custom data binding then it triggered the dataStateChange event for every grid actions(such as filter, page etc.,) and for CRUD operation dataSourceChanged event will trigger. In that event arguments we have send the corresponding action details(like skip, take, filter field, value, sort direction, added records, changed records etc.,) based on that you can form the query and perform the actions in your service and return data as result and count object.
Please refer the below help documentation and screenshot for more information.
Regards,
Thavasianand S.