?
Solved

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

Posted on 2014-11-04
6
Medium Priority
?
710 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 40

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 40

Accepted Solution

by:
lcohan earned 1500 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

752 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