I try to get data from below link , it 's in HTML format . I try to use Ajax or Json but do not work

please help

something looks like this

Code:



var url = "https://docs.google.com/spreadsheets/d/1zoNeQHv3hx-y2T30zGYmsdjNVGlcSQl0Dh2FGe_CDLk/gviz/tq?tqx=out:html&tq=select+sum(B)+pivot(C)"

$.getJSON( url, function( data ) {
    console.log(data);
});



What exactly are you trying to do?

SLGray wrote:What exactly are you trying to do?

get data from Google Sheet

google allow external call ?

this is the first step to review

Ch@lo Valdez wrote:google allow external call ?

this is the first step to review

I am not sure about that, I read last year post , it works .. looks like this

Code:


    $.ajax({
                url:url,
                type: 'GET',
                success: function(data) { console.log(data); },
                error: function(error) { console.log(error.statusText); }
        });



but I try it failed, either I do something wrong OR Google does not allow anymore ???

this way works

Code:


var url = 'https://spreadsheets.google.com/feeds/list/o13394135408524254648.240766968415752635/od6/public/values?alt=json-in-script&callback=?';
jQuery.getJSON(url).success(function(data) {
    console.log('ok'+ data);
    a = data
}).error(function(message) {
    console.error('error' + message);
}).complete(function() {
    console.log('completed!');
});


and you must read all this

https://developers.google.com/gdata/samples/spreadsheet_sample

Thanks Ch@lo Valdez

I know that one works but if you have a sheet with BIG data such as 1000 rows, it 's a heavy loading and slow

If we can use SQL query to filter out what records we need