Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Social Media Adapters - Integrating Facebook Data in to Reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Social Media Adapters - Integrating Facebook Data in to Reports
 Login/Join
 
Gold member
posted
Hi All,

I'm a newbie to Webfocus. For one of my projects we are trying to do a POC for Integrating facebook data in to WF reports using the existing social media adapter. I was able to successfully create the Application at developers.facebook.com, get the access token along with expiration, configure the adapter with Appid, App secret and create synonyms.

Now i'm trying to generate a report using users.mas synonym by giving my userid in the code as default, but i keep on encountering the following error.

(FOC45540) Facebook Request got error. Response Status : 400
(FOC45541) : OAuth "Facebook Platform" "invalid_request" "(#12) fql is
(FOC45541) : deprecated for versions v2.1 and
(FOC45541) : higher"
(FOC45541) : higher"
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

After some research on google and stack overflow i realized that the issue was with API mismatch between adapter and the facebook app.My facebook application is using v2.8 API and i am guessing WF adapter is using v2.0 or lower which has been made unavailable on Aug 2016.
Facebook API version log

Did anyone else encounter the same problem?. Is there anyway that i can update the adapter to meet v2.8 API? or can i down grade my facebook app to 2.2 or lower? Can someone help me with this issue?

Thanks,
tomatosauce

This message has been edited. Last edited by: <Emily McAllister>,


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
 
Posts: 52 | Location: BOWL OF PASTA | Registered: October 13, 2016Report This Post
Expert
posted Hide Post
Haven't tried this, but was hoping to, more for interests sake.

Have you asked Techsupport yet ?

If its an API version issue, Techsupport is probably the only place for answers.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
OK. Here's the story.
The metadata, report examples, and DataMigrator flows where based on v2.0 of the Facebook API.
These examples get loaded as part of Create Synonym of the 7706M/81M Reporting Server.
In v2.0, the FQL API and Graph API were used.

As of August 2016, v2.0 of the Facebook API expired.
Facebook discontinued the FQL API after v2.0.
Meaning, v2.1 of the Facebook API, the FQL API no longer exists.

Facebook is now on v2.8 of the Facebook API.

So, in the 7707/8201 Reporting Server, which should be out soon, Create Synonym has new examples that support v2.8 of the Facebook API.

I would suggest opening up a Hottrack Case and supply the version of the Facebook API that was created in the Facebook Development environment.
 
Posts: 229 | Location: New York | Registered: July 27, 2004Report This Post
Gold member
posted Hide Post
Thanks Efrem. Will do that


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
 
Posts: 52 | Location: BOWL OF PASTA | Registered: October 13, 2016Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Social Media Adapters - Integrating Facebook Data in to Reports

Copyright © 1996-2020 Information Builders