When do you want to get the data? Before the page loads or will you need to get it after it has loaded?
In either case you'll need something on the server that will access the web service, get the data, then write it out.
If you can do it before the page loads the easiest thing to do would be to have your server code just write out the data into the markup the same you have it hard coded in the example you posted.
If you need to do it after the page loads you'll need to use ajax to access the server side page that gets the data from the web service. The server side page can just return the json and then do you table initialization. something sort of like this:
- $.ajax({
- url: "serverSidePage.url",
- success: function(myData) {
- $('#myTable').handsontable({
- data: myData,
- minSpareRows: 1,
- contextMenu: true,
- readOnly: true,
- fixedColumnsLeft: 1
- });
- },
- dataType: "json"
- });
Dave