Geek Answers Handbook

Get list of events belonging to facebook page

Does anyone know how I can get a list of events belonging to (created) on a Facebook page?

It seems that I can use the "graph api" to create a list of events that the entity attends . I also looked at FQL, but it seems that the where clause is an indexable field (and, of course, the identifier is the only indexable field).

For bonus points, we could do this without any authentication. (Although I have come to terms with the fact that I will probably need at least a constant access_token.)

If anyone knows how to do this, I will be forever grateful.

+7
facebook
source share
5 answers

Authentication is required to access FQL data, so forget about those “bonus points”.

This will require some processing after the query because, as you said, the FQL WHERE only considers indexed fields, and the owner.id field owner.id not indexable. Thus, we first start by defining events when the user is a “member” and uploads owner information for these events.

 SELECT id, name, owner.id FROM event WHERE id IN (SELECT eid FROM event_member WHERE uid = XXX)

When the query returns a dataset, we must manually check the rows where owner.id is uid .

+5
source share

It looks like you need to query the event_member table first using uid

http://developers.facebook.com/docs/reference/fql/event_member

and then, as soon as you get event information, you can query the event table in which eid is indexed http://developers.facebook.com/docs/reference/fql/event

and I'm sure you can use the first as a subquery of the second query, for example var query = FB.Data.query("select name from event where eid in (select eid from event_member where uid = {0})", user_id);

+1
source share

It makes it

select eid from event where creator = ". $ facebookPageId." and eid in (select eid from event_member, where uid = ". $ facebookPageId.") ORDER BY start_time DESC

+1
source share

This link has a good tutorial on FB events and many more in C #.

http://blog.impact-works.com/2011/07/

But it uses the created dll. But once you get the idea from the blog, you can use Facebook's C # Sdk to develop what you want to develop.

And all this data is valid for you, IFF, which you develop in C # my friend.

0
source share

use this request to receive

https://graph.facebook.com/ 'your facebook page id' / events? access_token = 'your application token' & limit = 'number of desired events "& after = 1 & fields = owner, name, description, cover, ID

first you have to create a facebook application and get its “application token”

In the files column, you can specify event information using the names in the facebook API https://developers.facebook.com/docs/graph-api/reference/event/

0
source share

More articles:


All Articles