Solved

Using SSIS to connect to the Facebook API to load data to a SQL Server db.

Posted on 2014-11-04
6
556 Views
Last Modified: 2016-02-11
Hi There,
Has anyone experience in using SSIS when connecting to the Facebook API?
I have very little experience in this, but I'm I've been trying to follow some websites.
One website directed me to a RSSBusFacebookConnectionManager add in for SSIS -
I tried using this - but ive been getting some errors about my connections.
However this is only a trial version.

what I would really like to do is use the Script Task tool so that will call facebook api using SSIS.

Has anyone does this before/ if so could you give me some guild lines on what steps I should take please?
Thank you!!
P
0
Comment
Question by:Putoch
  • 4
  • 2
6 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 40424016
Which one are you using? "RSSBus ADO.NET Provider for Facebook"?
Regardless of trial/full the connection must work - can you post the error you are getting? Remember to scratch any confidential info if any.
Do you have the token and properly configured the connection string in Connection Manager as described below?

http://www.rssbus.com/kb/help/RBS1-A/pg_connectionr.rst
0
 

Author Comment

by:Putoch
ID: 40424175
Hi there, I downloaded the RSSBus SSIS Components For Facebook Provider V2.

so I setup the configuration, to look at one app only, rather than our whole company.
So I added the app id, the secret id, got the access token, and added the callback url (I used our canvas page)*

*Under the settings of the app, I could not see anywhere that reflected the word 'callback url'
this is why I used the canvas page url. But I noticed the app domain that was in our settings are different to the url used for our canvas page url
Also the canvas url was different to the canvas page url. Does this all matter?

The error I am getting back now is about an active access token.
I don't understand this, as I only ran the command to get the access token.

(replacing actual id with XX)
https://graph.facebook.com/oauth/access_token?client_id=XXXXXXXXXXXXXXXXXXX&client_secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX&grant_type=client_credentials

Thank you.
Facebook-oauth.png
Error-Message.png
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 40424248
"The error I am getting back now is about an active access token. "

I assume you copy/paste the token in the Connection Manager right? I have sometimes issues due to the Clipboard copy as Unicode or UTF8 char then when paste garbage will mess up the actual string - please try paste in a pure text first then take the token from there and put it in connection manager.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:Putoch
ID: 40424584
Ok, thank you, I took your advice and redid that. It seems that the token access I had copied was a little off. But the new error message I am receiving is a little different.
I think it may have something to do with the call back URL.
 
I'm not sure exactly what URL is a ''Call back url''
There is no website url on my facebook app settings for me to copy
the only urls' available are
the domain url
the canvas page
the canvas url
Page tab url
Secure page tab url

I'm unsure what to use, Would you have any advice?
Error-2.png
0
 

Author Comment

by:Putoch
ID: 40424638
Just to add, there was no platform for website on my app settings.
I wonder is this an issue?
Only for Canvas page,
iOS
Android,
Page Tab

Do I need a website platform?
What URL would I have to add there, since the app is based on Facebook and mobile devices only
Thank you
0
 

Author Comment

by:Putoch
ID: 40439035
i create a new platform and appid for auth purposes only
but instead of using the app token access key I used the client token
this seemed to work for now.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Read about why website design really matters in today's demanding market.
Before we dive into the marketing strategies involved with creating an effective homepage, it’s crucial that EE members know what a homepage is. In essence, a homepage is the introductory, or default page, of a website that typically highlights the …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now