Freebase
Start typing to get some suggestions
  • Explore
  • Use
  • Help
  • Developers

        Discussions on Query Builder

        Query Builder » Discuss

        Start a New Discussion

        Discussion will be posted in:

        • Query Builder

        Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

        • General Support,
        • Developer Support
        1.  

          Performing a bulk match of guids to wikipedia/en_ids

          also posted to
          • Getting and Contributing Information
          3 posts, latest post: biosopher, Jun 16, 2008
          Link to discussion
          1. biosopher
            Jun 16, 2008
            biosopher says:

            I have one hundred wikipedia/en_ids that I want to get the corresponding Freebase guids for.  I could do this one at a time but hoped there was a way to perform a bulk lookup

             

            {

              "/common/topic/article" : [

                {

                  "guid" : null

                }

              ],

              "key" : [

                {

                  "namespace" : "/wikipedia/en_id",

                  "value" : "426702"

                }

              ],

              "name" : null

            }

            Thanks,
            Biosopher

            1. willmoffat Metaweb Staff
              Jun 16, 2008
              willmoffat says:

              At the very least you can reduce network latency by using the queries parameter to execute multiple queries per http request. See the examples on the mqlread page.

            2. biosopher
              Jun 16, 2008
              biosopher says:

              Thanks Willmoffat,


              For anyone looking for a similar solution, here is the answer:

               

              http://www.freebase.com/api/service/mqlread?queries={"q0":{"query":[{"/common/topic/article" : [{"guid" : null}],"key" : [{"namespace":"/wikipedia/en_id","value":"426702"}]}]}, "q1":{"query":[{"/common/topic/article" : [{"guid" : null}],"key" : [{"namespace":"/wikipedia/en_id","value":"38252"}]}]}}


              You can simply keep adding more queries to your URL up to the limit of the URL string length.  Technically...the URL definition does not require a length limit but most servers have a limit around 256-500 chars typically.

              Cheers,
              Biosopher

               

          Discussion is posted in:

          • close Query Builder
          • close Getting and Contributing Information

          Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

          • General Support,
          • Developer Support
        2.  

          How to get article descriptions

          also posted to
          • Getting and Contributing Information
          2 posts, latest post: gmackenz, Jun 11, 2008
          Link to discussion
          1. biosopher
            Jun 10, 2008
            biosopher says:

            I expected this to be simple but couldn't find any info on the site/web.

             How do I get the description for a specific article.  E.g. this simple query gets the name for an article but how do I get the description as well?

             {
              "id" : "/guid/9202a8c04000641f800000000023907a",
              "name" : "San Quentin"
            }

             

            Thanks,
            Biosopher 

            1. gmackenz Metaweb Staff
              Jun 11, 2008
              gmackenz says:

              See here for a similar question/response...Here's the help section involved with the Trans service, you want section 4.8. Fetching Content with trans

          Discussion is posted in:

          • close Query Builder
          • close Getting and Contributing Information

          Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

          • General Support,
          • Developer Support
        3.  

          Migrated Feature Requests

          also posted to
          • Getting and Contributing Information
          1 post, latest post: jdouglas, Sep 14, 2007
          Link to discussion
          1. jdouglas Metaweb Staff
            Sep 14, 2007
            jdouglas says:

            [NOTE: These were originally posted to the Feature Requests property that is no longer displayed.]

            Sort=

            Limit=

          Discussion is posted in:

          • close Query Builder
          • close Getting and Contributing Information

          Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

          • General Support,
          • Developer Support
        4.  

          Query Builder UI

          also posted to
          • Getting and Contributing Information
          2 posts, latest post: will, Feb 14, 2007
          Link to discussion
          1. colin Metaweb Staff
            Feb 12, 2007
            colin says:
            Here's an example of a slick query builder UI:

            http://www.openiris.org/screenshots/atct_album_image?b_start=12
            1. will
              Feb 14, 2007
              will says:

              can we actually make links in discussion posts? like: http://www.openiris.org/screenshots/atct_album_image?b_start=12 .

          Discussion is posted in:

          • close Query Builder
          • close Getting and Contributing Information

          Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

          • General Support,
          • Developer Support

        Search Discussions

        Related Discussions

        • Getting and Contributing Information
        ©2010  Metaweb
        • Page History
        • RDF
        • Feedback
        • Attribution Policy
        • Terms of Service
        • About Us
        • Jobs
        • Freebase Blog
        Freebase contains information on:
        • Arts & Entertainment
        • Products & Services
        • Science & Technology
        • Society
        • Special Interests
        • Sports
        • Time & Space
        Dev Tools
        Refresh cache | Query Editor | Normal view | Explore | Explore2 | Admin view | View transaction log | Suggest transaction log | Client transaction log | hide (F8) | debug-level
        TID(s):
        Controller: 0.393s
        Template: 0.086s
        Cost: br=8.0, cc=0.312, ch=0.0, cm=0.0, cm+h=0.0, cr=0.0, cs=20.0, cw=16.0, dr=8250.0, dt=0.699, dw=0.0, gqr=0.0, in=3993.0, ir=9213.0, iw=0.0, mcs=0.0, mcu=0.084, mr=16.0, nivcsw=76.0, nreqs=20.0, nvcsw=50.0, pf=0.0, pr=0.0, stime=0.008, te=0.039, tf=0.333, tg=0.323, tm=0.413, tr=0.035, ts=0.0, tu=0.032, utime=0.304, va=11612.0