Answers

• kthorngren Posts: 21,726Questions: 26Answers: 5,027

  February 2018 edited February 2018

  It doesn't look like your data is in a valid JSON format. It looks like this:

  {
      "result": {
          "count": "37859",
          "event": {
              "date": "-300",
              "description": "Pilgrims travel to the healing temples of Asclepieion to be cured of their ills. After a ritual purification the followers bring offerings or sacrifices.",
              "lang": "en",
              "category1": "By place",
              "category2": "Greece",
              "granularity": "year"
          },
          "event": {
              "date": "-300",
              "description": "Pyrrhus, the King of Epirus, is taken as a hostage to Egypt after the Battle of Ipsus and makes a diplomatic marriage with the princess Antigone, daughter of Ptolemy and Berenice.",
              "lang": "en",
              "category1": "By place",
              "category2": "Egypt",
              "granularity": "year"
          },
  .....
  

  You events object should be in an array. I think it should look more like this:

  {
      "result": {
          "count": "37859",
                [
          "event": {
              "date": "-300",
              "description": "Pilgrims travel to the healing temples of Asclepieion to be cured of their ills. After a ritual purification the followers bring offerings or sacrifices.",
              "lang": "en",
              "category1": "By place",
              "category2": "Greece",
              "granularity": "year"
          },
          "event": {
              "date": "-300",
              "description": "Pyrrhus, the King of Epirus, is taken as a hostage to Egypt after the Battle of Ipsus and makes a diplomatic marriage with the princess Antigone, daughter of Ptolemy and Berenice.",
              "lang": "en",
              "category1": "By place",
              "category2": "Egypt",
              "granularity": "year"
          },
  .....
             ]
        }
  }
  

  Please see this doc for more details regarding the Datatables data formats that are supported:
  https://datatables.net/manual/data/

  This is an example of nested objects, which you have:
  https://datatables.net/examples/ajax/objects_subarrays.html

  Look at the Ajax tab for the example data response.

  Once you get the events into an array then you need to update your Datatables config. Datatables, by default, expects the table data in an objected named data. Your data is in an object called results. You will need to use ajax.dataSrc to change the the data source to the results object.

  Next you will need to change your column config. Datatables doesn't have an events option. To get the data from the events object you will need to configure Datatables similar to the above example. You will use columns.data to define your columns.

  I think you will need something like this:

          $('#data-table').DataTable({
              "ajax"     :     {
                       "url": ""http://www.vizgr.org/historical-events/search.php?format=json&begin_date=-3000000&end_date=20151231&lang=en",
                       "dataSrc": "result"
               },
              "columns": [
                  {"data": "event.date"},
                  {"data": "event.description"},
                  {"data": "event.lang"},
                  {"data": "event.category1"},
                  {"data": "event.category2"},
                  {"data": "event.granularity"}
              ]
          });
  

  The above should load your data once you get the events object into an array.

  Kevin
• lahirulls Posts: 2Questions: 1Answers: 0

  February 2018

  Thanks for the information it looks like i need to parse the JSON first.