A new open table for YQL that makes some of the most useful features of the Foursquare API easily accessible. The other APIs can be quickly implemented based on the work so far. They are zipped here: foursquare.zip
- User detail: use "http://disavian.no-ip.info/hacku/foursquare.user.xml" as foursquare.user; select * from foursquare.user where username="(your email address or phone number)" and password="(your password)"
- Friends: use: "http://disavian.no-ip.info/hacku/hacksquare.friends.xml" as foursquare.friends; select * from foursquare.friends where username="(your email address or phone number)" and password="(your password)"
- Venues: use "http://disavian.no-ip.info/hacku/foursquare.venues.xml" as foursquare.venues; select * from foursquare.venues where geolat="33.7772869" and geolong="-84.3976068" ategories: use "http://disavian.no-ip.info/hacku/foursquare.categories.xml" as foursquare.categories; select * from foursquare.categories
- Venue details: use "http://disavian.no-ip.info/hacku/foursquare.venue.xml" as foursquare.venue; select * from foursquare.venue where vid="125694"
- Categories list: use "http://disavian.no-ip.info/hacku/foursquare.categories.xml" as foursquare.categories; select * from foursquare.categories
- Add venue: use "http://disavian.no-ip.info/hacku/foursquare.addvenue.xml" as foursquare.addvenue; select * from foursquare.addvenue where name="Place Name" and username="(your email address or phone number)" and password="(your password)"
- Propose venue edit: use "http://disavian.no-ip.info/hacku/foursquare.proposeedit.xml" as foursquare.proposeedit; select * from foursquare.proposeedit where vid="125694" and name="Georgia Tech College of Computing" and username="(your email address or phone number)" and password="(your password)"
- Nearby tips: (not implemented)
- Add tip/to-do: (not implemented)
- Mark tip as to-do: (not implemented)
- Mark tip as done: (not implemented)
- Pending friend requests: (not implemented)
- Approve friend request: (not implemented)
- Deny friend request: (not implemented)
- Send friend request: (not implemented)
- Find friends by name: (not implemented)
- Find friends by phone: (not implemented)
- Find friends by using a Twitter name: (not implemented)
- Set pings: (not implemented)
- Test: (not implemented)
- Checkin (check in somewhere): use "http://disavian.no-ip.info/hacku/foursquare.checkin.xml" as foursquare.checkin; select * from foursquare.checkin where shout="Testing Foursquare YQL Open Table" and username="(your email address or phone number)" and password="(your password)"
note: checkin requires at least one of vid, venue, or shout - Checkins (list of a user's friends' checkins): use "http://disavian.no-ip.info/hacku/foursquare.checkins.xml" as foursquare.checkins; select * from foursquare.checkins where geolat="33.7772869" and geolong="-84.3976068" and username="(your email address or phone number)" and password="(your password)"
- History (list of a user's checkins): use "http://disavian.no-ip.info/hacku/foursquare.history.xml" as foursquare.history; select * from foursquare.history where username="(your email address or phone number)" and password="(your password)"