Looking for Editor edit examples overriding ajax function
Looking for Editor edit examples overriding ajax function
morganrob
Posts: 18Questions: 7Answers: 2
Hi, I have existing web api's for updating that use a PUT that I have no access to modify to accept the Editor data format. The api is simple VS2015 web api 2 controller with actions using entity framework. Not using DataTables Editor .NET library.
I have a table: pickup primary key: pickupid
PUT http://localhost/api/pickups/2754244
{"pickupid":2754244,"run":"DAVE",...}
successfully updates my sqlserver table and returns
{"pickupid":2754244,"run":"DAVE",...}
Is there a template mechanism to reformat / manipulate the Editor's ajax call or will I have to do some json manipulation myself?
editor = new $.fn.dataTable.Editor({
ajax: function ( method, url, d, success, error ) {
var output = { data: [] };
if (d.action === 'edit') {
$.ajax({
type: 'PUT',
url: 'api/pickups/_id_' , // ** _id_ isn't populated in ajax call**
data: d, //** data sent is not simple json **
dataType: "json",
success: function (json) {
success(json);
},
error: function (xhr, error, thrown) {
error(xhr, error, thrown);
}
});
}
},
idSrc: 'pickupid',
table: "#workTable",
fields: [{
label: "Name:",
name: "pd_name"
}, {
label: "Run:",
name: "run"
}, {
label: "Notes:",
name: "notes"
}, {
label: "Description:",
name: "description"
}
]
});
Datatable code is fine and editor activates and makes a PUT call but clearly not with the dataformat my api demands
Thank you, Rob
This question has an accepted answers - jump to answer
Answers
This I'm afraid. Every system that doesn't conform to what Editor expects would need different manipulation which is why there is no generic example for it.
In your code above, you would modify the
jsonin between lines 10 and 11 before calling Editor'ssuccesscallback.This page documents what Editor expects and I'm happy to answer any questions you have about it!
Allan
I suspected as much.
So something along these lines, or is there a better/preferred technique?
Yes - I think that probably is the way to go about it.
There is another option with 1.6 - you could use Editor without an
ajaxoption which would result it it just editing the local table. Then use events such aspreSubmitto trigger your own Ajax request to the server.The only issue with that would be if validation fails - there would need to be some mechanism to let Editor know about that, which there isn't currently (not without chaining events).
Does that sound like it might be an option if I have a think about that?
Allan
I'm happy enough with the solution I have now, thanks
Great post!