Stored Procedures
Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
Facebook Adapter Stored Procedures
Name | Description |
CreateInsightSchema | Creates a schema file for an insight. |
GetOAuthAccessToken | Gets an authentication token from Facebook. |
GetOAuthAuthorizationURL | Gets an AuthURL from Facebook. You will request the auth token from this URL. |
RefreshOAuthAccessToken | Refreshes the OAuth token. |
UploadPhoto | Post a photo to a user, page, album or event. |
UploadVideo | Post a video to a user, page, group or event. |