Answers

• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  August 2022

  The lack of response from the server is what is causing the error message (empty is not valid JSON).

  A 400 error is a "Bad request" so perhaps the server isn't expecting that kind of POST? Or perhaps you need a CSRF token in the request or something? Do the server's error logs show anything?

  Allan
• erald23 Posts: 4Questions: 1Answers: 0

  August 2022

  Hi @allan
  Thanks for your reply, I have attached the code I am using.
  I would appreciate any help.

  $(function () {
      // Define Datatable
      var editor = new $.fn.dataTable.Editor({
          ajax: {
              create: {
                  type: 'POST',
                  url: '/TaskMasters/Create'
              },
              edit: {
                  type: 'PUT',
                  url: '/TaskMasters/Edit/{id}'
              },
              remove: {
                  type: 'DELETE',
                  url: '/TaskMasters/Delete/{id}'
              }
          },
          table: "#tblTasks",
          idSrc: 'Id',
          fields: [
              {
                  label: "Id",
                  name: "Id"
              },
              {
                  label: "TaskName",
                  name: "TaskName"
              },
            
          ]
      });
  
      // Activate an inline edit on click of a table cell
      $('#tblTasks').on('click', 'tbody td.row-edit', function (e) {
          editor.inline(table.cells(this.parentNode, '*').nodes(), {
              submitTrigger: this,
              submitHtml: '<i class="fa fa-play"/>'
          });
      });
  
      // Delete row
      $('#tblTasks').on('click', 'tbody td.row-remove', function (e) {
          editor.remove(this.parentNode, {
              title: 'Delete record',
              message: 'Are you sure you wish to delete this record?',
              buttons: 'Delete'
          });
      });
  
      var table = $('#tblTasks').DataTable({
          dom: "Bfrtip",
          serverSide: true,
          processing: true,
          ajax: {
              url: '/TaskMasters/Data',
              type: "POST"
          },
          columns: [
             
              { data: "TaskName", title: "TaskName" },
            
              {
                  data: null,
                  defaultContent: '<i class="fa fa-pencil"/>',
                  className: 'row-edit dt-center',
                  orderable: false
              },
              {
                  data: null,
                  defaultContent: '<i class="fa fa-trash"/>',
                  className: 'row-remove dt-center',
                  orderable: false
              },
          ],
          select: true,
          buttons: [
              { extend: "create", editor: editor },
              { extend: "edit", editor: editor },
              { extend: "remove", editor: editor }
          ]
      });
  
  });
  
  
• kthorngren Posts: 21,144Questions: 26Answers: 4,918

  August 2022

  As Allan mentioned you will need to start with looking at your server logs to determine why the server is responding with the 400 error. The client side code won't help troubleshoot the server error.

  Kevin
• erald23 Posts: 4Questions: 1Answers: 0

  August 2022

  Hi @allan and @kthorngren
  Can you elaborate a bit more on this part
  "Or perhaps you need a CSRF token in the request or something?"
  Do I need a CSRF token to make the POST call using datatable editor,
  Note: with regular datatable I don't have any issues but I want to use datatable editor for its features.
  Also could you please give any recommendations on where should I look for the server logs, I tried developer mode and couldn't find any.
  Thanks in advance
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  August 2022

  Do I need a CSRF token to make the POST call using datatable editor

  DataTables doesn't require it, but if you are using a framework such as Larvel, then you might.

  Also could you please give any recommendations on where should I look for the server logs, I tried developer mode and couldn't find any.

  /var/logs is the normal place in a Linux server. On Windows? IIS manager will have an option for it.

  I don't actually know what system you are running it on, or what the http server is?

  But overall, logs can be configured to be anywhere, so you'd need to refer to the configuration and documentation for your server stack.

  Allan
• erald23 Posts: 4Questions: 1Answers: 0

  August 2022

  @allan
  I am using datatable editor within an asp.net core MVC application and all I am trying to do is simple CRUDs operations and some inline edits using datatable editor.
  also, we have this application published in azure web services, and behave the same as I use it locally!
  My system is Windows 10 Pro 64-bit.
  Thanks in advance.
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  August 2022

  I'm afraid I'm no expert in hosting web applications on window - however, I'm certain they will have server logs somewhere. Finding out where that 400 error is coming from is key!

  Allan