Javascript JSONP YQL query

[thedavil]

Hi there,

I have put together some YQL code that works for RSS feeds, but I'm trying to get it to parse some HTML for me. I'm wondering what's wrong here:

This code works fine:

function buildListOfItems(data) {
	var items = data.query.results.item;
	var output = '';
	if (items && item.length) {
		var no_items=items.length;
		for(var i=0;i<no_items;i++){
			var title = items[i].title;
			var content = items[i].content;
			output += title + "-->" + content + "<br/>";	
		}
		return output;
	}else{
		alert('no data returned!');
	}
}

function theCallback(data)   { 
	$("#menuitems").html(buildListOfItems(data)); 
}

$.YQL = function(query, callback){  
	$.ajax({
			type: "GET",
			url: 'http://query.yahooapis.com/v1/public/yql?q=' + encodeURIComponent(query.toLowerCase()) + '&format=json&diagnostics=false&callback=?',
			success: callback,
			dataType: "jsonp"
	});
};


$(document).ready(function() {
   $.YQL("select * from feed where url='http://feeds.feedburner.com/t3kd?format=xml' limit 10", theCallback);
});

but if I change the YQL line to something like this:

$.YQL('select title,content from html where url="http://www.mywebsite.com/index.php?page=10" and xpath='//h3/a''', theCallback);

then I get 'no data returned'

However the query works fine in the YQL console, I wonder am I just not encoding the string right or missing a single quote vs double quote problem?

If anybody can help me I'd really appreciate it.
Thanks

[rnd me]

some APIs require an api key to work outside of the console...

[thedavil]

yes that was my first thought but is that definitely the case with their 'HTML' table ? There doesn't seem to be a list of what does and doesn't require the key?

[rnd me]

depends on the site. check it's robots.txt and crossdomain.xml file in the site's root folder.


also, you may have nested apos as quotes issues in the posted code; i see three apos in a row...

[thedavil]

Hi there,

It's a site I developed myself and I'm ashamed to admit (*blush*) - I haven't included either file in the root.

To be honest, I think I might have to start all over again with this code and learn more because I've now noticed that it's not even working in Google Chrome for the RSS query

$.YQL("select * from feed where url='http://feeds.feedburner.com/t3kd?format=xml' limit 10", theCallback);

but that still works fine in IE8. (strange).

any pointers at all would help but I'll probably have to learn some basics again as I must be doing something wrong.

Thanks again.