Freebase query to get alias using python

Question

How can I get list of alias from the query with the name in freebase using a python?

For example, this query

[{
  "name": "citigroup",
  "/common/topic/alias": []
}]

gives

{
  "result": [
    {
      "/common/topic/alias": [
        "Citigroup Inc.",
        "TRAVELERS GROUP INC",
        "CITIGROUP INC",
        "TRAVELERS INC",
        "Citi"
      ],
      "name": "Citigroup"
    },
    {
      "/common/topic/alias": [],
      "name": "Citigroup"
    }
  ]
}

I want a list

["Citigroup Inc.",
"TRAVELERS GROUP INC",
"CITIGROUP INC",
"TRAVELERS INC",
"Citi"]

I tried with

service_url = 'https://www.googleapis.com/freebase/v1/search'
query = {   "name": "citigroup", "/common/topic/alias": []}

params = [{ 'query': json.dumps(query), 'key': key, 'limit':5}]

url = service_url + '?' + urllib.urlencode(params)
response = json.loads(urllib.urlopen(url).read())

But the response does not produce anything... Any help will be greatly appreciated! Thanks

try changing the service url as 'https://www.googleapis.com/freebase/v1/mqlread' — Gunjan, Dec 11 '14 at 06:12

Gunjan · Accepted Answer · 2014-12-11T07:32:57.980

try this code

import urllib, json

service_url = 'https://www.googleapis.com/freebase/v1/mqlread'
query = [{ "name": "citigroup", "/common/topic/alias": []}]

params = { 'query': json.dumps(query), 'key': key, 'limit':5}

url = service_url + '?' + urllib.urlencode(params)
response = json.loads(urllib.urlopen(url).read())
print response

Basically the query should be asked in the list form as there are more than one result for this query and not into dictionary form.

Freebase query to get alias using python

1 Answers1

Linked