Skip to content

Instantly share code, notes, and snippets.

@d6veteran
Created December 20, 2010 23:09
Show Gist options
  • Save d6veteran/749192 to your computer and use it in GitHub Desktop.
Save d6veteran/749192 to your computer and use it in GitHub Desktop.
Getting Spiel Des Jahres Winners
query = [{
"type": "/games/game",
"id": None,
"name": None,
"!/award/award_honor/honored_for": {
"award": {
"id": "/en/spiel_des_jahres"
},
"year": {
"value": None,
"limit": 1
},
"limit": 1
},
"sort": "-!/award/award_honor/honored_for.year.value"
}]
@d6veteran
Copy link
Author

Result:

{
  "code":          "/api/status/ok",
  "result": [
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2009"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/36218",
      "name": "Dominion",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2008"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/34585",
      "name": "Keltis",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2007"
        }
      },
      "id":   "/en/zooloretto",
      "name": "Zooloretto",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2006"
        }
      },
      "id":   "/en/thurn_and_taxis",
      "name": "Thurn and Taxis",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2005"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/13308",
      "name": "Niagara",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2004"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/9209",
      "name": "Ticket to Ride",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2003"
        }
      },
      "id":   "/m/059ntv",
      "name": "Alhambra",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2002"
        }
      },
      "id":   "/en/villa_paletti",
      "name": "Villa Paletti",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2001"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/822",
      "name": "Carcassonne",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "2000"
        }
      },
      "id":   "/en/torres",
      "name": "Torres",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "1999"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/54",
      "name": "Tikal",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "1998"
        }
      },
      "id":   "/en/elfenland",
      "name": "Elfenland",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "1997"
        }
      },
      "id":   "/user/pak21/boardgamegeek/boardgame/256",
      "name": "Mississippi Queen",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "1996"
        }
      },
      "id":   "/en/el_grande",
      "name": "El Grande",
      "type": "/games/game"
    },
    {
      "!/award/award_honor/honored_for": {
        "award": {
          "id": "/en/spiel_des_jahres"
        },
        "year": {
          "value": "1995"
        }
      },
      "id":   "/en/settlers_of_catan",
      "name": "Settlers of Catan",
      "type": "/games/game"
    }
  ],
  "status":        "200 OK",
  "transaction_id": "cache;cache03.p01.sjc1:8101;2010-12-20T22:28:04Z;0019"
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment