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

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
PutochAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
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
PutochAuthor Commented:
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
lcohanDatabase AnalystCommented:
"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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

PutochAuthor Commented:
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
PutochAuthor Commented:
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
PutochAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.