Parent Previous Next

Facebook Source

The "Facebook Source" is used to extract data such as your user profile, status updates, friends, "likes", and comments within an SSIS package. See the Social OAuth Connection Manager page to learn more about setting up this component's connection manager.

Important Note

Facebook is available for SQL versions 2012 and higher.

 Connection Manager - In this field, users can create a new connection manager or select a pre-existing one.

 Api End Points - In this field, users select the endpoint they wish to connect to (such as User Profile or User Groups.) Selecting an endpoint will auto-populate that field's parameters and commonly used Output Columns

 API Query - This field defines the query to be used in the API. Although several end points have been pre-configured, users can type in or paste custom calls that are not included with the component. These calls can be found by clicking the View Api Document link and adding the reference to the end of the API Query (example: https://graph.facebook.com/{user-id}/groups).

 Root Json Path - Because Facebook returns the raw data in Json format, users will need to define the root path when creating custom queries.

 Query Parameters - User-defined parameters (such as id) based on the API query. Parameters can be set dynamically by entering the variable name (example: <@User::ScreenName>.)  

 Output Columns - In this window, users can add and remove columns and define their name, token path (defined within the raw data), data type, length, precision, scale, and code page.  


 Preview Data - Pressing this button will return the results and raw data based on the user-defined settings.

 Results - In this window, users can see a preview of the first few rows of data based on their configuration.

 Raw Data - This window displays the Json data in raw form. Developers can use this to help determine root and token paths.


Using the Facebook Source - https://pragmaticworks.wistia.com/medias/axntonuovb