My company is moving our local servers out to the cloud and are currently building out apis so data in the dbs can be accessed only via REST / JSON - is there any way to continue using editor in this capacity?
Here is an example of Editor using REST interface.
Is this what you are looking for?
If you are asking about sending JSON data from the Editor, the last example in the ajax.data shows how.
The provided libraries are db agnostic, but they do assume an SQL database can be connected to. They doesn't currently allow for a custom API to be used.
If you don't have the ability to give the .NET libraries a direct connection to the database, but rather have to go through an API, you'd need to either call that API from the client-side (assuming it is accessible there - that's the way I would do it personally), or proxy it though something on the server-side if it can only be accessed from the server.
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.