Geek Answers Handbook

Define the Object_ID of the URL to be used with Open Open Graph

I am trying to learn how to use the Open Open Graph API and ask a question about how to determine the object_id of my site. I need this object_id so that I can make other requests, for example, I want to get a list of users who like my site for a certain period of time.

Based on other issues related to Stackoverflow, I saw that I should be able to run this request in order to get object_id

select id from object_url where url in ('www.bubbasgameroom.com', 'bubbasgameroom.com')

When I run this query, it returns with an empty result. When I run the following query, I see that my page has been liked 21 times

select total_count from link_stat where url in ('www.bubbasgameroom.com', 'bubbasgameroom.com')

What am I missing here? Any help would be greatly appreciated. Thank!

+5
source share
1 answer

Most likely it urlshould be identical to the meta tag og:urlif it is used on your website. Also you need to add a part http://for its work. For example, this would work:

SELECT url,site,id 
FROM object_url 
WHERE url IN ( 
    'http://developers.facebook.com',
    'http://www.imdb.com/'
)

Result:

[
  {
    "url": "http://developers.facebook.com",
    "site": "developers.facebook.com",
    "id": 113167538713703
  },
  {
    "url": "http://www.imdb.com/",
    "site": "www.imdb.com",
    "id": 6903354771
  }
]

But this is not so:

SELECT url,site,id 
FROM object_url 
WHERE url IN ( 
    'developers.facebook.com',
    'www.imdb.com/'
)
+8
source

More articles:


All Articles