Focal Point
[SOLVED]Social Media Adapters - Integrating Facebook Data in to Reports

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5217032486

October 14, 2016, 12:08 PM
tomatosauce
[SOLVED]Social Media Adapters - Integrating Facebook Data in to Reports
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
October 16, 2016, 04:59 PM
Waz
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!

October 20, 2016, 11:07 AM
Efrem
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.
October 21, 2016, 02:56 PM
tomatosauce
Thanks Efrem. Will do that


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs