event_member
Description
Contains the list of attendees for an event in FQL and can be queried by user or by event.
Columns
| Name | Description |
|---|---|
eid | The ID of the event being queried. |
inviter id | The user ID of the person who invited the user in the uid field. |
inviter_type string | The type of the object in the inviter field. Allowed values are: 'page' or 'user' |
rsvp_status string | The reply status of the user for the event being queried. There are four possible return values: attending, unsure, declined, and not_replied. |
start_time string | An ISO-8601 string representing the starting date and (optionally) time of the event being queried. This is particularly useful as a WHERE filter to speed up your query when querying for one or more user's events. But it cannot be used when querying for users invited to a particular event. Note - before the 'Events Timezone' migration, this field was a timestamp. See 'Events Timezone Migration Note' above for more information. |
uid | The user ID of the user for the event being queried. |
Examples
- SELECT ... FROM event_member WHERE uid = A
- SELECT ... FROM event_member WHERE eid = A
- SELECT ... FROM event_member WHERE eid = A AND uid = B
Note: Additional filters on other columns can be specified but they may make the query less efficient.
Permissions
To read the event_member table you need
- A generic
access_tokenfor public events (those whose privacy is set to OPEN) - The
user_eventspermission for non-public events or to see all events a user is attending - The
friends_eventspermission for non-public events of the user's friends or to see all events your app's user's friends are attending