How can I query public facebook events by location/city?

facebook, facebook-graph-api

Solution

Updated 2014-07-02

You can't directly search the Facebook API for events near a location. Since originally giving this answer, the Graph API has made it harder to search for events.

The Elmcity script referenced by the OP does a simple search for a keyword in the event title. Try "Lancaster" for example. You'll get events that have the word Lancaster somewhere in their metadata.

Their query looks something like this:

 https://graph.facebook.com/search?q=lancaster&type=event

You can also search for a non-location based word in the title like "picnic" and the script returns events.

For the problem of actually finding events near a location, in the current iteration the "venue" field is only a string, so it has no relationship to any Facebook place. Running these query returns nothing:

https://graph.facebook.com/madisonsquaregarden/events
https://graph.facebook.com/108424279189115/events

So using a batched request isn't even a possibility.

According to the documentation FQL seems to be a better solution. In the event documentation, the `venue.name` column is indexable! Easy, right?

Wrong. When you run this FQL query to find events at some location like this:

 SELECT name, start_time, venue FROM event WHERE CONTAINS("madison square garden")

You find that `venue.name` isn't populated.

Trying any other variation like:

 SELECT name, start_time, venue FROM event WHERE venue.id = 108424279189115

Throws a "statement not indexable" error.

So while building a "Facebook Events Near Me" is the killer app, the only way that it seems possible is to search for common strings for events near you, get those events, then filter out irrelevant events from the result set.

Problem

Original source