Facebook Connector returns #NULL! errors

Hi, I have built a social media dashboard using the social connectors of SEOtools. Since a week or 2, the Facebook connector shows the #NULL! error for 'like_count', 'comment_count', 'click_count', 'share_count' and 'total_count'. (I have the Pro version installed v.5.1.4)
Is this something that can be fixed? Thanks!

Unfortunately, FB has updated their API and individual like/comment/share requests are not available. You can use the following to get the aggregate of the aforementioned variables:

=JsonPathOnUrl(CONCATENATE("http://graph.facebook.com/?id=";A2);"share.share_count")

Where A2 is the cell with the URL.

2 Likes

Thanks for your reply. Unfortunately, the formula returns blank cell..... I will research this some more.

Did you try replacing the ";" characters with ","?

I did :smile:
My formula: =JsonPathOnUrl(CONCATENATE("http://graph.facebook.com/?id=",A126),"share.share_count")

Weird, what happens when you visit the following URL in a browser?

http://graph.facebook.com/?id=http://www.notified.com

Does it give you a Json response?

See attachment screenshot

Weird, did you try Concat instead of Concatenate?

What happens if you try: =JsonPathOnUrl("http://graph.facebook.com/?id=http://www.notified.com","share.share_count")

=JsonPathOnUrl(CONCAT("http://graph.facebook.com/?id=",A126),"share.share_count")
returns a #VALUE! error

=JsonPathOnUrl("http://graph.facebook.com/?id=http://www.notified.com","share.share_count")
returns '5' So that works! For facebook shares.... but can JSON generate the likes of a fb page?

Sorry I just got somewhat comfortable with the XPath syntax, JSON is new for me :open_mouth:

Json can generate the likes count and any value that is available in the Json page. Unfortunately, Facebook has removed the like count of external URL:s.

I've made a new connector that replaces some of the previous functionality:

(Put the Facebook.xml in your connectors folder and restart Excel)

1 Like

Or just get the latest beta Looking for SeoTools 6.0 beta testers! (updated 2016-11-03)

Thanks Niels, I will download it and give it a try.

Hi guys, does anyone have a link to an announcement or article that refers to this Facebook API change? I've looked but can't find anything.

Also - does "shares" now encompass all engagements (shares, reactions etc)?

Thanks!

They announced it with an error message: :cry:

I think share = number of times it's been shared on facebook. I don't think Facebook is sharing like for urls anymore.

"Shares" are equal to the sum of shares, likes, and comments. I've compared the new share value to my earlier extractions of the individual values and they are equal.

1 Like