Overview

In Integrator social network connectors provide businesses with instant API connectivity, allowing them to easily integrate the social networking services with other applications. Organizations can authorize their apps to publish directly to social networks, have access to social consumer information, and easily interface with the social media platforms.

The following social networks are natively supported in Integrator:

To connect to the social networks that are not currently on the list, use generic http connector. Read more about working with web services.

Facebook

Connecting to Facebook

Create Facebook app

Create Facebook connection

Create Facebook app

By creating Facebook app you are enabling access to the Facebook Graph API. Facebook app is not an actual "application", it is just a set of credentials and access rights, linked to your Facebook account.

Each application has an unique ID and and a Secret that can be used to obtain an access token, which will be later used to access Facebook Graph API. When creating Facebook connection in Integrator, user is required to login with actual Facebook credentials (user name and password), but they are never stored in the Integrator's database. Instead, we are storing access token, linked to the particular app ID and a Secret.

Important: Integrator includes built-in Facebook app, which provides a very limited access to the Facebook Graph API. You must create an app if your want your Facebook connection to have an access to the following rights: user_posts, user_managed_groups, user_about_me, user_actions.news, user_tagged_places, user_relationships, user_birthday, user_events, user_website, user_relationship_details, user_photos, user_hometown, user_likes, publish_actions, read_custom_friendlists, user_location.

Important: if you choose to create your own app, in most cases you will need a new app for each Facebook account you are going to be accessing using Integrator's Facebook connector.

To create Facebook app:

Step 1. Logout from your personal Facebook account.

Step 2. Go to https://developers.facebook.com/ and login with the account your are going to be creating connection to.

Step 3. Click Add New App under My Apps menu in the top right corner of the screen.

Step 4. In the popup window enter app Display Name and Contact Email. Pass security check.

Step 5. Select Facebook Login under Select Product and click Set Up button.

select product

Step 6. Click Web link in the next window.

web

Step 7. Enter Site URL in the next window and click Save button.

Important: this is very important to understand what you are going to be entering as a Site URL:

site url

Step 8. Important: at this point you can copy and paste App ID and App Secret. You will be using them to create Facebook connection in Integrator.

facebook app id and secret

Step 9. Go to Settings->Basic in the left navigational bar and enter actual domain name in App Domains field. Click Save Changes button.

Important: this is very important to understand what you are going to be entering as a App Domains:

domain settings

Step 10. Enter https://etlworks.com/docs/privacy-policy/ in the Privacy Policy URL field and click Save Changes button. Note: you can enter your own privacy policy URL.

facebook privacy

Step 11. Go to App Review in the left navigational bar and slide Make App Public to the Yes position. Select Category and click Confirm button.

facebook public app

Step 12. If you want this app to access accounts other than the account you used in the step 2, follow Facebook app submission process. Otherwise - skip this step.

You are done. You can always access you application by opening https://developers.facebook.com/, login using designated Facebook account, and selecting app from the My Apps menu.

facebook apps

Create Facebook connection

Step 1. Start creating Facebook connection by opening Connections window, clicking the + button and typing in facebook in the search box:

facebook connections

Step 2. Depending you whether you are going to be polling data from Facebook Graph API or posting to Facebook select either Facebook Feed or Facebook Update connection.

Step 3. Enter Authentication parameters. Click Test Connection button to verify that credentials are working.

facebook authentication parameters

To revoke access token click Logout from Facebook button.

facebook logout

Important: an access token is granted for approximately 60 days. Once it expires the integration flows with this particular connection will stop working. The access token will be displayed as expired and user will need to Login with Facebook again to receive a new one.

facebook expired

Step 4. Continue by entering connection parameters, unique for each type of the connection.

Facebook Feed connection

Facebook Feed connection is used to pull data from the Facebook Graph API.

Common parameters

Filter

facebook feed connection

Facebook Update connection

Facebook Update connection is used to post to the Facebook and delete data from Facebook.

Common parameters

Post parameters

Additional parameters

Publishing status update and privacy settings

facebook update connection

Step 5. Continue by entering optional auto retry parameters.

Step 6. Click Save to save the connection.

Pulling data from Facebook

Step 1. Create Facebook Feed connection, which will be used as a source (FROM).

Step 2. Create destination (TO) connection and (if needed) format.

Step 3. Start creating flow by opening Flow Builder window, clicking the + button and typing in extract data from well known API in the search box:

extract from API

Step 4. Select flow type based on what is going to be a destination. For example, Extract data from well known API, create file.

Step 5. Select connection, created in step 1 as a source (FROM) and connection/format, created in step 2 as a destination (TO). Set FROM and TO fields.

facebook to file

Step 6. Continue by setting parameters and defining mapping.

Posting to Facebook

Step 1. Create Facebook Update connection.

Step 2. Start creating flow by opening Flow Builder window, clicking the + button and typing in facebook in the search box. Select Update Facebook flow type.

update facebook flow

Step 3. Continue by selecting connection, created in step 1 as a Facebook Update connection.

update facebook flow parameters

Step 4. Optionally, define message text in the Parameters tab. Message can contain {tokens}, which will be substituted at runtime.

facebook message

Deleting data from Facebook

Step 1. Create Facebook Update connection. When configuring connection select one of the delete... actions. Enter ID. Most of the delete actions require ID: User ID, Post ID, etc.

Step 2. Start creating flow by opening Flow Builder window, clicking the + button and typing in delete files in the search box. Select Delete Files flow type.

delete files

Step 3. Add transformation and select connection created in step 1 as a source connection.

Twitter

Connecting to Twitter

Create Twitter app

Create Twitter connection

Create Twitter app

By creating Twitter app you are enabling access to the Twitter API. Twitter app is not an actual "application", it is just a set of credentials and access rights, linked to your Twitter account.

We never store actual Twitter credentials (screen name and password) in the Integrator's database. Instead, we are storing keys and tokens, assigned to the Twitter app.

Important: in most cases you will need a new app for each Twitter account you are going to be accessing using Integrator's Twitter connector.

To create Twitter app:

Step 1. Logout from your personal Twitter account.

Step 2. Go to https://apps.twitter.com/app/new and login with the account your are going to be creating connection to.

Step 3. Enter required parameters, Accept Development Agreement and click Create your Twitter application button.

Important: use fully qualified URL, used to login into the Integrator, for the Web Site field. For example, if you are accessing Integrator hosted by Etlworks, enter https://integrator.etlworks.com or https://your_company_name.etlworks.com.

twitter app

Step 4. Under the Keys and Access Tokens (in some cases Application Management) go to Token Actions and click Create my access token button.

twitter create token

Step 5. Go to Permissions tab and configure application permissions. Click Update Settings button. If requested, you can use https://etlworks.com/docs/privacy-policy/ as a privacy policy URL.

twitter permissions

Step 5. Important: go back to Keys and Access Tokens tab and copy and paste Consumer Key (API Key), Consumer Secret (API Secret), Access Token, and Access Token Secret. You will be using them to create a Twitter connection in Integrator.

twitter tokens

You are done. You can always access you application by opening https://apps.twitter.com, login using designated Twitter account, and selecting app from the list.

twitter apps

Create Twitter connection

Step 1. Start creating Twitter connection by opening Connections window, clicking the + button and typing in twitter in the search box:

twitter connections

Step 2. Depending you whether you are going to be polling data from Twitter Graph API or posting to Twitter select either Twitter Feed or Twitter Update connection.

Step 3. Enter Authentication parameters. Click Test Connection button to verify that credentials are working.

twitter authentication parameters

Step 4. Continue by entering connection parameters, unique for each type of the connection.

Twitter Feed connection

Twitter Feed connection is used to pull data from the Twitter API.

Common Parameters

Filter

twitter feed connection

Twitter Update connection

Twitter Update connection is used to post to Twitter and delete data from Twitter.

Post parameters

Additional parameters

twitter update connection

Step 5. Continue by entering optional auto retry parameters.

Step 6. Click Save to save the connection.

Pulling data from Twitter

Step 1. Create Twitter Feed connection, which will be used as a source (FROM).

Step 2. Create destination (TO) connection and (if needed) format.

Step 3. Start creating flow by opening Flow Builder window, clicking the + button and typing in extract data from well known API in the search box:

extract from API

Step 4. Select flow type based on what is going to be a destination. For example, Extract data from well known API, create file.

Step 5. Select connection, created in step 1 as a source (FROM) and connection/format, created in step 2 as a destination (TO). Set FROM and TO fields.

twitter to file

Step 6. Continue by setting parameters and defining mapping.

Posting to Twitter

Step 1. Create Twitter Update connection.

Step 2. Start creating flow by opening Flow Builder window, clicking the + button and typing in twitter in the search box. Select Update Twitter flow type.

update twitter flow

Step 3. Continue by selecting connection, created in step 1 as a Twitter Update connection.

update twitter flow parameters

Step 4. Optionally, define message text in the Parameters tab. Message can contain {tokens}, which will be substituted at runtime.

twitter message

Deleting data from Twitter

Step 1. Create Twitter Update connection. When configuring connection select one of the delete... actions. Enter ID. Most of the delete actions require ID: User ID, Tweet ID, etc.

Step 2. Start creating flow by opening Flow Builder window, clicking the + button and typing in delete files in the search box. Select Delete Files flow type.

delete files

Step 3. Add transformation and select connection created in step 1 as a source connection.

Exploring data in social networks

It possible to explore (visualize) data in the social networks using Explorer add-on.

The social network connection must a feed connection, such as Twitter Feed connection, Facebook Feed connection, etc.

Browsing data returned by API endpoints

Use Explorer to visualize data in the social networks. Data can be displayed in the grid/form and raw (original) format.

Running SQL queries

Learn how to write and execute SQL queries against social network connections in Explorer.

Other use cases

Saving data returned by API into the file

In Integrator it is possible to save unmodified response from the request to the social network endpoint to the file.

Automating status update in multiple social networks

Step 1. Create update connections for multiple networks, for example Twitter Update connection and Facebook Update connection.

Step 2. Use {tokens} for message, picture URL, etc.

Step 3. Create JavaScript flow which will be setting tokens, using technique described here.

Step 4. Create update flows, such as posting to Twitter and posting to Facebook, using connections created in step 1.

Step 5. Created nested flow, which combines flows, created in steps 3 and 4 (in that order).