how to get whole JSON data from webservice at once?

how to get whole JSON data from webservice at once?

I'm trying to get JSON data from my webservice to display it in a data grid editor (developed with jquery) called Handsontable ( http://handsontable.com/ )

Basically my JSON looks like this:

  1. [
  2.     ["", "2012", "2013", "2014(YTD)"],
  3.     ["Ferrari", 1460089088.3900001, 1637243070.99, 283566771.55000001],
  4.     ["Alfa Romeo", 1199141138.1900001, 1224624821.1500001, 192307335.49000001],
  5. ]

What i want to do is passing the whole json from webservice to initialize the variable called myData in my html file at once. I mean without using loops etc - the simples way since i'm very inexperienced in jQuery and i'm little bit confused after all those different things i read on the internet.

Below you can download and/or see my html code:


  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  5. <link rel="stylesheet" type="text/css" href="/css/result-light.css">

  7. <script src="http://warpech.github.io/jquery-handsontable/lib/jquery.min.js"></script>
  8. <script src="http://warpech.github.io/jquery-handsontable/dist/jquery.handsontable.full.js"></script>
  9. <link rel="stylesheet" media="screen" href="http://warpech.github.io/jquery-handsontable/dist/jquery.handsontable.full.css">
  10. <link rel="stylesheet" media="screen" href="http://warpech.github.io/jquery-handsontable/demo/css/samples.css?20140401">
  12. <style type="text/css">
  13.      body {background: white; margin: 20px;}
  14.      h2 {margin: 20px 0;}
  15. </style>
  17. <script type='text/javascript'>
  18. $(document).ready(function () {
  19.       var myData = ( [
  20.       ["", "2012", "2013", "2014(YTD)"],
  21.       ["Ferrari", 1460089088.3900001, 1637243070.99, 283566771.55000001],
  22.       ["Alfa Romeo", 1199138.1900001, 1224821.1500001, 1923335.49000001],
  23. ]);
  24.   
  25. $('#myTable').handsontable({
  26.      data: myData,
  27.      minSpareRows: 1,
  28.      //colHeaders: true,
  29.      contextMenu: true,
  30.      readOnly: true,
  31.      fixedColumnsLeft: 1
  32. });
  33. });
  34. </script>
  35. </head>

  37. <body>
  38. <div id="myTable" class="handsontable" style="width: 400px; margin-left:auto; margin-right:auto; background-color:silver"></div>
  39. </body>
  40. </html>