Answers

• Rpiechura Posts: 98Questions: 3Answers: 14

  May 2014

  So I'll give you what I did to do this with the forewarning that it is written in 1.9.4 syntax so you'll have to do some translation to the new stuff. http://datatables.net/reference/option/ajax should help you with that.

  fnServerData: function (sSource, aoData, fnCallback, oSettings){
      oSettings.jqXHR = $.ajax({
          dataType: 'json',
          url: sSource,
          accepts: "application/json",
          headers: {
               Accept: "application/json"
          },
          success: function (json) {
              // Code to execute when the ajax comes back.
          }
      }
  }
  

  fnServerData is an initialization option when creating the datatable, and according to the documentation found http://legacy.datatables.net/usage/callbacks it takes those parameters. I do a bit more prep work before the request that is application specific and I do a whole lot of application specific stuff when the request comes back, but hopefully that gives you an idea of where to start looking.
• bodrick Posts: 3Questions: 1Answers: 0

  June 2014

  Unfortunately this isn't quite what I was looking for. If I already have data in my datatable, I would like to extract it and convert it to json so I can submit it as part of an existing request. From reading the docs you should be able to get this data from the data object on the table, which does indeed contain the data I'm looking for, but I can't seem to figure out how to get just the data and not the rest of the api along with it, JSON.stringify I assume is trying to convert everything and hence the circular reference part.
• Rpiechura Posts: 98Questions: 3Answers: 14

  June 2014 edited June 2014

  I think you may be looking for http://datatables.net/reference/option/ajax.dataSrc. It's a way to tell the table to look at a specific object in the data instead of the default.
• bodrick Posts: 3Questions: 1Answers: 0

  June 2014

  So I finally figured it out myself, to just get the data out of a datatable I just had to do a $.each on the rows().data() and append any items to my object that I'm passing to my ajax call.
• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  June 2014 Answer ✓

  My issue is when I try to get the data from the table either by using DataTable().data() or DataTable().rows().data() when I try to convert this into JSON using JSON.stringify() I get a TypeError converting circular structure to JSON.

  I suspect the issue is that you are trying to JSON encode a DataTables API instance. What you probably want to do is call the toArray() method. Example: http://live.datatables.net/gowobin/1/edit

  Allan