Social Networks Overview

In Integrator, the social network connectors provide businesses with instant API connectivity, allowing them to easily integrate 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 social media platforms.

The following social networks are natively supported in Integrator:

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

Facebook

Connecting to Facebook

Create a Facebook app

Create a Facebook connection

Create a Facebook app

By creating a Facebook app, you are enabling access to Facebook's Graph API. A 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 a unique ID and and a Secret that can be used to obtain an access token, which will later be used to access Facebook's Graph API. When creating a Facebook connection in Integrator, the user is required to log in with their actual Facebook credentials (user name and password), but those are never stored in Integrator's database. Instead, it stores an Access token, linked to a particular App ID and a Secret.

Important: Integrator includes a built-in Facebook app which provides very limited access to Facebook's Graph API. You must create an app if you want your Facebook connection to have 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, while using Integrator's Facebook connector.

To create a Facebook app:

Step 1. Log out from your personal Facebook account.

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

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

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

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

select product

Step 6. Click the Web link in the next window.

web

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

Important: it 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 a Facebook connection in Integrator.

facebook app id and secret

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

Important: it is very important to understand what you are going to be entering for App Domains:

domain settings

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

facebook privacy

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

facebook public app

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

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

facebook apps

Create a Facebook connection

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

facebook connections

Step 2. Depending upon whether you are going to be pulling data from Facebook's Graph API or posting to Facebook, select either the Facebook Feed or the Facebook Update connection.

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

facebook authentication parameters

To revoke the access token, click the 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 the user will need to Login with Facebook again to receive a new one.

facebook expired

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

Facebook Feed connection

A Facebook Feed connection is used to pull data from Facebook's Graph API.

Common parameters

Filter

facebook feed connection

Facebook Update connection

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

Common parameters

Post parameters

Additional parameters

Publishing status update and privacy settings

facebook update connection

Step 5. optionally, continue by entering the auto-retry parameters.

Step 6. Click Save to save the connection.

Pulling data from Facebook

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

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

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

extract from API

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

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

facebook to file

Step 6. Continue by setting the parameters and defining the mapping.

Posting to Facebook

Step 1. Create a Facebook Update connection.

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

update facebook flow

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

update facebook flow parameters

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

facebook message

Deleting data from Facebook

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

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

delete files

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

Twitter

Connecting to Twitter

Create Twitter app

Create a Twitter connection

Create a Twitter app

By creating a Twitter app you are enabling access to the Twitter API. A 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 the actual Twitter credentials (screen name and password) in Integrator's database. Instead, we storing keys and tokens, which have been 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 a Twitter app:

Step 1. Log out from your personal Twitter account.

Step 2. Go to https://apps.twitter.com/app/new and log in with the account you want to create a connection to.

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

Important: use a fully qualified URL, the one you would use to log in to Integrator, for the Web Site field. For example, if you are accessing Integrator, hosted by Etlworks, enter https://app.etlworks.com or https://your_company_name.etlworks.com.

twitter app

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

twitter creates token

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

twitter permissions

Step 6. Important: go back to the Keys and Access Tokens tab, then copy and paste the 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 your application by opening https://apps.twitter.com, logging in using the designated Twitter account, and selecting the app from a list.

twitter apps

Create a Twitter connection

Step 1. Start creating a Twitter connection by opening the Connections window, clicking the + button and typingtwitter into the search box:

twitter connections

Step 2. Depending on whether you are going to be pulling data from Twitter's Graph API or posting to Twitter, select either the Twitter Feed or the Twitter Update connection.

Step 3. Enter the Authentication parameters. Then click the Test Connection button to verify that the credentials are working.

twitter authentication parameters

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

Twitter Feed connection

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

Common Parameters

Filter

twitter feed connection

Twitter Update connection

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

Post parameters

Additional parameters

twitter update connection

Step 5. Optionally, continue by entering the auto-retry parameters.

Step 6. Click Save to save the connection.

Pulling data from Twitter

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

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

Step 3. Start creating a Twitter connection by opening the Connections window, clicking the + button and typing extract data from well-known API into the search box:

extract from API

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

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

twitter to file

Step 6. Continue by setting the parameters and defining the mapping.

Posting to Twitter

Step 1. Create a Twitter Update connection.

Step 2. Start creating a Twitter connection by opening the Connections window, clicking the + button and typing twitter into the search box. Select the Update Twitter flow type.

update twitter flow

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

update twitter flow parameters

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

twitter message

Deleting data from Twitter

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

Step 2. Start creating a Twitter connection by opening the Connections window, clicking the + button and typing delete files into the search box. Select the Delete Files flow type.

delete files

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

Exploring data in social networks

It's possible to visually explore (visualize) data in social networks using an Explorer add-on.

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

Browsing data returned by API endpoints

Use Explorer to visualize data in social networks. Data can be displayed in a grid/form or in the 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 the API into a file

In Integrator, it is possible to save an unmodified response (from the request to the social network endpoint) to a file.

Automating a status update in multiple social networks

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

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

Step 3. Create a JavaScript flow which will set tokens, using the technique described here.

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

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