Geek Answers Handbook

Seek Help Watching YQL Movies

I used the document API for documents without documents until it was pulled a few days ago, so I'm looking for another way to get a local movie show (ideally theater). I found this thread about YQL datatables on SO, and the last post looked really promising. I just can't figure out how to request data to return local movies and shows. I tried the "SELECT * from movies.showtimes where location = 'myzip" options without success. Any ideas?

+2
source share
1 answer

select * from movies.showtimes

Get a list of all the movies. Then:

 select * from movies.showtimes with location='myzip' and name='one of the movies'

You can also do

 select * from movies.showtimes with location='myzip' and name in whatever

No list by location, unfortunately

+1
source

More articles:


All Articles