Introduction
The connector for Facebook provides developers easy access to Facebook data, including Events, Groups, Pages, Places, Posts, and more.
Connection String
To connect to Facebook, most tables require user authentication as well as application authentication. Facebook uses the OAuth standard to authenticate users. In addition to the connection string parameters, the Callback URL also should be specified for this connector. Set the OAuth Properties (OAuth Client ID and OAuth Client Secret). Set the CallBack URL also for this connector. Once the Callback URL is set the OAuthAccessToken will be generated in the connection string when you verify the connection using the Verify Connection option.
Connection String Parameters
| Parameter | Description |
|---|---|
OAuthClientId |
Set this to the App Id in your app settings. |
OAuthClientSecret |
Set this to the App Secret in your app settings. |
OAuthAccessToken |
The access token for connecting using OAuth. |
CallbackURL |
Set this to the Site URL in your app settings |
Connecting to Facebook
Facebook uses the OAuth authentication standard. OAuth requires the authenticating user to interact with Facebook using the browser. To Connect to Facebook and obtain the OAuth credentials-
- Login to https://developers.facebook.com and select sign up, top right.
- Once the sign up process has been completed, click Add Product.
- Next section asks for your authentication call back URL. You can find the value you need to place, underneath the connection string box in your Loome Integrate tab.
- Create an Analytics type API.
- In the dashboard of your app, copy the App ID and App Secret. These correspond to the OAuth Client Id and OAuth Client Secret on your connection string.
Data Migrations
To check for the Data Migrations-
Add a new connection in Loome Integrate as shown.
- Go to Tasks and click on Connections.
- Add a new connection using the Add New Connection option.
- Choose ExcelFiles Connector from the available connector options.
Using the connection string parameters created, verify the connection using the Verify Connection option in Loome Integrate.
After clicking Verify Connection the OAuth Tokens are generated in the connection string. You will be taken to the following Window. Choose the account, and give access by clicking on allow. You will be displayed with authorization successful window.
Once the connection is verified, insert the connection using the Insert option.
Create a job using the Add a Job option in Loome Integrate. Add a data migration task to the job.
Create a new task by right clicking job list and then the Add a New Task option. If you want to edit an existing task use the Edit Task option.
Choose a Data Migration Task.
Choose the source and the destination for the migration of data. Name the task.
Choose the Tables or the data that need to be migrated from the source to the destination. You can choose to copy all tables from the source by checking the Copy All Tables checkbox. Save the task.
Execute the job. Check for results and the details of the data migrated in Execution History.
Data Model
The Facebook Connector Converts Facebook APIs as relational Tables, Views, and Stored Procedures. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
Tables
Below describes the available tables in Active Directory.
| Name | Description |
|---|---|
Comments |
Create, update, delete, and query the Comments for a Target. Comments may also be inserted based on a Target or deleted based on Id. |
Likes |
Create, delete, and query the Likes for a Target. Alternatively, lists Pages that the specified User or Page Likes. Authentication is required to use this table. |
Milestones |
Create, update, delete, and query a list of Milestones for the given Page. Milestones may only be inserted, updated, or deleted when authenticating as the target Page. |
Posts |
Create, delete, and query the Posts for a Target based on either the Target or Id. Posts can also be inserted based on a Target, or deleted based on Id. This table requires authentication. |
Users |
Query Users by SearchTerms or Id. |
Views
Views are similar to tables in the way that data is represented; however, views do not support updates.
| Name | Description |
|---|---|
AdAccounts |
Query the Ad Accounts available for a User. Accessing Ad Account information requires the ads_read permission. |
AdCreatives |
Query information about an Ad Creative or the Ad Creatives on a specific Ad Account, Ad Set, or Ad. Accessing Ad Creative information requires the ads_read permission. |
AdInsights |
Query an Ad Report. Accessing Ad Report information requires the ads_read permission. |
AdInsightsActions |
Query an Ad Report. Accessing Ad Report information requires the ads_read permission. |
Ads |
Query information about an Ad or the Ads in a specific Ad Set, Campaign, or Ad Account. Accessing Ad Information requires the ads_read permission. |
AdScheduledReports |
Query the Scheduled Reports for a given Ad Account. Accessing Scheduled Report information requires the ads_read permission. |
AdSets |
Query information about an Ad Set or the Ad Sets on a specific Campaign or Ad Account. Accessing Ad Set information requires the ads_read permission. |
Albums |
Query Albums associated with a Target. Accessing Album information typically requires the user_photos permission. |
Applications |
Retrieve data about the Application specified by the Id. |
AuthorizedAdAccounts |
Ad Accounts authorized to run ads for your business on a specified app. This view requires that you have at least one business configured for your user id. |
Books |
Query the Books a User is interested in. Accessing Book information typically requires the user_books permissions. |
Campaigns |
Query information about a Campaign or the Campaigns on a specific Ad Account. Accessing Campaign information requires the ads_read permission. |
Events |
Query the Events for a Target based on either the Target or SearchTerms. May require the user_events permission. |
Friends |
Query Friends of the authenticated User or Target User. Requires the user_friends permission. A Target may be specified to request Friend information for, but Friends may only be retrieved for the authenticated User or Friends of the authenticated User that use the same Facebook app. |
Games |
Query the Games a User is interested in. Accessing Game information may require the user_likes and user_interests permissions. |
GroupMemberships |
Query the Groups based on the supplied GroupId. Groups may require the user_groups permission. |
Groups |
Query the Groups based on the supplied SearchTerms, Id, or Target. Groups may require the user_groups permission. |
InsightsByConsumptionType |
Allows retrieval of insights by consumption type. |
InsightsByFeedbackType |
Allows retrieval of insights by feedback type. |
InsightsByLikeSourceType |
Allows retrieval of insights by like source type. |
InsightsByPaidStatus |
Allows retrieval of insights by paid status. |
InsightsByReactionTotals |
Allows retrieval of insights by like source type. |
InsightsByStoryType |
Allows retrieval of insights by like story type. |
InsightsByTabType |
Allows retrieval of insights by tab type. |
LeadValues |
Query information about a lead. Accessing Lead Information requires the ads_read permission. |
Movies |
Query the Movies a User is interested in. Accessing Movie information requires the user_likes and user_interests permissions. |
Music |
Query the Music a User is interested in. Accessing Music requires the user_likes and user_interests permissions. |
Pages |
Query the Pages based on the supplied SearchTerms or Id. |
Permissions |
Query the Permissions the User has granted the current application. |
Photos |
Query Photos associated with a Target. Accessing Photo information typically requires the user_photos permission. |
Places |
Query the Places based on the supplied SearchTerms or Id. Places are stored as Pages in Facebook. |
ScheduledReportRuns |
Query a list of the recently completed runs of a given Scheduled Report. Accessing Scheduled Report information requires the ads_read permission. |
SimpleInsights |
Allows the retrieval of simple insights with a single value in the response. |
SimpleVideoInsights |
Allows the retrieval of simple video insights with a single value in the response. |
TaggedBy |
Query information about Posts, Statuses, Photos, and other entities that have tagged the User or Page. This view is a derivative of the Wall connection where only entries that have tagged the Target User or Page will be returned. In general it is only available for Pages. |
Television |
Query the TV shows a User is interested in. Accessing Television information may require the user_likes and user_interested permissions. |
VideoInsightsByActionType |
Allows the retrieval of video insights by story action type. |
VideoInsightsByDistributionType |
Allows the retrieval of video insights by distribution type. |
VideoInsightsByReactionType |
Allows the retrieval of video insights by reaction type. |
Videos |
Query Videos from a Target. Normally requires the user_videos permission. |
Wall |
Query Posts from the Wall of a Target. |