Events
Retrieves the events for a target based on either the Target or SearchTerms. May require an access token, user_events, or friends_events permission depending on the privacy settings of the event.
Table Specific Information
Events in Facebook are events created by a user or page that mark a specific date when something will take place. Events may be queried by Target, Id, or by SearchTerms.
Select
When selecting events, a Target may be specified. The Target represents a user or page who has created events. By default, this will be the currently authenticated user. For example, to retrieve events associated with a user:
SELECT * FROM Events WHERE Target = 'UserId'
Alternatively, you can specify the SearchTerms to search all events on Facebook. For example:
SELECT * FROM Events WHERE SearchTerms = 'facebook'
If you know the Event Id, you may also just specify the Id to get information about the specific event. For example:
SELECT * FROM Events WHERE Id = 'EventId'
Insert
To insert an Event, you will need to specify the Name and StartTime of the event. For instance:
INSERT INTO Events (Name, StartTime) VALUES ('My New Event', '1/1/2012 1:00:00 AM')
By default, events will be added to the currently authenticated user's events. To add an event to a page, specify the Page Id as the target. For example:
INSERT INTO Events (Name, StartTime, Target) VALUES ('My New Event', '1/1/2012 1:00:00 AM', 'PageId')
Update
Events may be updated by issuing an UPDATE statement and specifying the Id of the event.
Delete
Events may be deleted by issuing a DELETE statment and specifying the Id of the event. Please note that Facebook only allows events created by your app to be deleted using your app.
Columns
| Name | Type | Description | ReadOnly |
| ID [KEY] | String |
The id of the event. | False |
| Searchterms | String |
The terms used to search the post if searching posts. | False |
| Target | String |
The id or username of the target you are retriving events for or are posting events to. This may be a page or a user. | False |
| Name | String |
The name of the event. | False |
| StartTime | Datetime |
The start time of the event. | False |
| EndTime | Datetime |
The end time of the event. | False |
| Description | String |
The description of the event. | False |
| Location | String |
The location of the event, if specified. | False |
| OwnerId | String |
The id of the user that created the event. | True |
| OwnerName | String |
The name of the user that created the event. | True |
| OwnerCategory | String |
Category of the owner, if available. | True |
| VenueId | String |
The id of the location for the event. | True |
| VenueStreet | String |
The street address of the event. | True |
| VenueCity | String |
The the city for the event. | True |
| VenueState | String |
The the state for the event. | True |
| VenueCountry | String |
The the country for the event. | True |
| VenueZip | String |
The the zip code of the event. | True |
| VenueLatitude | String |
The latitude of the event. | True |
| VenueLongitude | String |
The longitude of the event. | True |
| TimeGranularity | String |
The granularity of the posted time. | True |
| GmtOffset | Integer |
The number of minutes offset from GMT. | True |
| RSVPStatus | String |
Status of the currently logged in user for the event. The allowed values are noreply, invited, attending, maybe, declined. | True |
| UpdatedTime | Datetime |
When the event was last updated. | True |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the Where section.
| Name | Type | Description | |
| rows@next | String |
This is used to page through multiple pages of results and should not be set manually. |