Answers

• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  June 2019

  First please try to use Markdown formatting to format your code snippets.

  Looks like your server JSON structure is different than what you see at the browser? The structure you receive at the browser is what you are interested in when setting the ajax.dataSrc.

  The primary problem (and likely the cause of the error) is that you have the columns definition inside the ajax option. Your code should look more like this:

          $('#table1').DataTable({
              "ajax": {
                  "url": "http://localhost:3000/mydata",
                  "type": "GET",
                  "dataSrc": "mydata",
              },
              "columns": [{
                      data: "MyID"
                  },
                  {
                      data: "MyType"
                  }
              ]
          });
  

  Your ajax.dataSrc will either be "mydata" or "" depending on the structure of the received JSON.

  Kevin
• DW71 Posts: 4Questions: 2Answers: 0

  June 2019

  Hi Kevin,
  thanks. The trick was indeed your hint with the columns outside the ajax structure.
  Now it works.
  Many thanks. You made my day

  Case closed

  Dirk

          $(document).ready(function() {
                      $('#table1').DataTable({
                          "ajax": {
                              "url": "http://localhost:3000/mydata",
                              "type": "GET",
                              "dataSrc": "",
                          },
                          "columns": [{
                                  data: "MyID"
                              },
                              {
                                  data: "MyType"
                              }
                          ]
                      });
              });