Discussions on Developing Applications

Create the table that you want with the right filters and right columns displayed, then click on the little gear icon on the top and select "Download as a file."

Don't forget that the Terms of Service require attribution back to Metaweb/Freebase.

Not sure what you mean about the heirarchical vs relational, but the database isn't either really.  If you're talking about the information displayed on a topic page in Label: Value form, you can get all that to come out in table views as well with the appropriate amount fiddling about the the table settings (click Edit View and add additional types/columns).

For data that's missing, feel free to add it if you've got a good source that's license compatible. 

More recently I was told that there are no write quotas enforced at all on the sandbox currently.

Also, the snapshot process starts in the morning so anything that is desired for the week's snapshot should be written to the production server by 6 am PDT.  The resulting snapshot will usually be live between 4 pm and 6 pm PDT (GMT-8)

for example.

lets say i have a base called Base

Base has a type called Base Type (id is base_type)

and Base Type has a property called Type Property (id is type_property)

I know how to search for Base Type, but i dont know how to search for Type Property.

So maybe i do a search and write "hello", i want to search to find all Type Property in my base that have a value "hello"

Does this make sense? How can i do that? 

OK, first off, are you using our "search" API (/api/service/search) or our "mqlread" API (/api/service/mqlread)?  It sounds like you probably want to be using mqlread, so if that's not what you're doing, it should be.

 mqlread will return the results of any MQL query.  MQL is our query language used to query our whole database, including metadata about the database.  You can learn about MQL in our MQL Reference Guide and experiment with queries using our Query Editor.

It sounds like you're interested in queries to do with the structure of your types, properties, etc.  That is, rather than asking questions like "Show me all people born in California whose profession is lawyer" you're asking for things like "Show me the names of all the properties on Person".  If that's what you're doing, you might like to look at our Schema Introspection Cookbook, which gives some recipes for queries of that kind.

for some reason i cant see your full reply.

But anyway im using the search api 

ok now i can see the full reply.

thank you...i'll look into that :) 

,one more question,

with the search api, you can search part of the name. for example if i wanna seach for the music album "hello how are you", i can type hello and it will find it.

Im assuming that with mql read i wont be able to do that? i will have to write the whole album name, right? 

thanks philg, that was a great help :)

what i've managed to do is print out the value of the properties of a certain type.

Just a question though.

Say i have a type called Type, which has two properties : prop1 and prop2.

And then i've made a topic called MyTopic.

So i did a mql read to get the values of prop1 and prop2.

But how do i get that little description that goes at the start of the topic?

I know that its "article" under type /common/topic. But if my query is getting the properties, then the type is /MyBase/MyType, meaning i cant get that description. 

Will i have to do two seperate queries? or is there a way of combing the two?

Cheers 

Your excellent question here (and also on the Query Builder page) might already be answered in the archives of the App developers mail list (linked to on the App page). In fact I know the question about getting the description was answered recently on one of our two mail lists.

Thanks for the pointer gmackenz.  I was searching for the wrong terms and getting zero results.  You pointed me in the right direction:

http://www.freebase.com/api/trans/raw/guid/9202a8c04000641f80000000001170a3
http://www.freebase.com/api/trans/blurb/guid/9202a8c04000641f80000000001170a3
http://www.freebase.com/api/trans/blurb/guid/9202a8c04000641f800000000038e04d?maxlength=300

As discussed in detail here 

http://markmail.org/message/fot76nyzeprvsgly#query:+page:1+mid:hkzgwbs6pbznui4w+state:results
http://markmail.org/message/fot76nyzeprvsgly#query:freebase.com%20API%2Ftrans+page:1+mid:balofou7axzv53vr+state:results

Thanks,
biosopher 

Sports is a "domain category", which has a list of domains (via a property). Sports/Basketball (id: /Basketball) is a domain, and when you say a "list of categories" in that domain, you're referring to the types in that domain. So, the query to look up types in a specific domain by id /Basketball is:

{
  "query" : [
    {
      "id" : "/basketball",
      "type" : "/type/domain",
      "types" : [
        {
          "id" : null,
          "name" : null,
          "type" : "/type/type"
        }
      ]
    }
  ]
}