Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Facebook - Getting status updates from Page (not user) using FQL

Is there a way of getting status updates from a Page (not from a users page , but a business page) using FQL , documentation for the 'page' table doesn't contain anything ?

So my query would theoretically be:

SELECT status FROM page WHERE page_id = MYPAGEID

although that obviously doesn;t work , and :

SELECT message FROM status WHERE uid = MYPAGEID

just returns NULL.

The page is public , and all security permissions are off .

Any ideas? I can't see any reason as to why Facebook wouldn't allow this ?

Ive used

https://graph.facebook.com/MYPAGEID/feed

but ideally I'd like to return XML to integrate it into a feed.

Thanks.

like image 280
BobFlemming Avatar asked Jan 28 '26 17:01

BobFlemming


1 Answers

You need to query the stream table:

SELECT message FROM stream WHERE source_id=PAGE_ID

OR:

SELECT message FROM stream WHERE source_id=PAGE_ID AND actor_id=PAGE_ID

If you only want to retrieve the feeds made by the page!

like image 121
ifaour Avatar answered Jan 31 '26 09:01

ifaour



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!