Ajax or Json and Jquery
3 posters
Page 1 of 1
Ajax or Json and Jquery
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
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);
});
Re: Ajax or Json and Jquery
What exactly are you trying to do?
Lost Founder's Password |Forum's Utilities |Report a Forum |General Rules |FAQ |Tricks & Tips
You need one post to send a PM.
You need one post to send a PM.
When your topic has been solved, ensure you mark the topic solved.
Never post your email in public.
Re: Ajax or Json and Jquery
SLGray wrote:What exactly are you trying to do?
get data from Google Sheet
Re: Ajax or Json and Jquery
google allow external call ?
this is the first step to review
this is the first step to review
Ch@lo Valdez- Forumember
- Posts : 138
Reputation : 50
Language : spanish
Re: Ajax or Json and Jquery
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 ???
Re: Ajax or Json and Jquery
this way works
and you must read all this
https://developers.google.com/gdata/samples/spreadsheet_sample
- 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
Ch@lo Valdez- Forumember
- Posts : 138
Reputation : 50
Language : spanish
Re: Ajax or Json and Jquery
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
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
Similar topics
» AJAX CHAT
» help set ajax cookie
» Rss forum feed to json?
» How do I add FM Chat and ajax?
» AJAX Chat
» help set ajax cookie
» Rss forum feed to json?
» How do I add FM Chat and ajax?
» AJAX Chat
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum