Integration Your Way - (800) 235-7250
A new version of this product is available! [learn more]
RSSBus ADO.NET Provider for Facebook
Questions / Feedback?

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.


 
Copyright © 2014 RSSBus inc.
[x] close

Questions / Feedback?


Name:
Email:
Feedback: