Query Link
https://query.openkim.org/raw?database=data&aggregate=%5B%7B%27%24match%27+%3A+%0D%0A++++++++%7B%27%24and%27%3A+%5B%0D%0A++++++++++++%7B%27property-id%27%3A+%27tag%3Astaff%40noreply.openkim.org%2C2014-04-15%3Aproperty%2Fcohesive-potential-energy-cubic-crystal%27%7D%2C%0D%0A++++++++++++%7B%27species.source-value%27%3A+%27Al%27%7D%2C%0D%0A++++++++++++%7B%27meta.type%27%3A+%27tr%27%7D%5D%7D%7D%2C%0D%0A%7B%27%24project%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C%0D%0A++++++++++++%27short-name.source-value%27%3A+1%2C+%0D%0A++++++++++++%27a.source-value%27%3A+1%2C%0D%0A++++++++++++%27cohesive-potential-energy.source-value%27%3A+1%7D%7D%2C%0D%0A%7B%27%24sort%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C+%27cohesive-potential-energy.source-value%27%3A+-1%7D+%7D%2C%0D%0A%7B%27%24group%27%3A+%7B%27_id%27%3A+%7B%27model%27%3A+%27%24meta.subject.kimcode%27%7D%2C%0D%0A++++++++++++%27name%27%3A+%7B%27%24first%27%3A+%27%24short-name.source-value%27%7D%2C%0D%0A++++++++++++%27a%27%3A+%7B%27%24first%27%3A+%27%24a.source-value%27%7D%2C%0D%0A++++++++++++%27energy%27%3A+%7B%27%24first%27%3A+%27%24cohesive-potential-energy.source-value%27%7D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%5D
Curl
curl --data-urlencode 'database=data' --data-urlencode 'aggregate=%5B%7B%27%24match%27+%3A+%0D%0A++++++++%7B%27%24and%27%3A+%5B%0D%0A++++++++++++%7B%27property-id%27%3A+%27tag%3Astaff%40noreply.openkim.org%2C2014-04-15%3Aproperty%2Fcohesive-potential-energy-cubic-crystal%27%7D%2C%0D%0A++++++++++++%7B%27species.source-value%27%3A+%27Al%27%7D%2C%0D%0A++++++++++++%7B%27meta.type%27%3A+%27tr%27%7D%5D%7D%7D%2C%0D%0A%7B%27%24project%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C%0D%0A++++++++++++%27short-name.source-value%27%3A+1%2C+%0D%0A++++++++++++%27a.source-value%27%3A+1%2C%0D%0A++++++++++++%27cohesive-potential-energy.source-value%27%3A+1%7D%7D%2C%0D%0A%7B%27%24sort%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C+%27cohesive-potential-energy.source-value%27%3A+-1%7D+%7D%2C%0D%0A%7B%27%24group%27%3A+%7B%27_id%27%3A+%7B%27model%27%3A+%27%24meta.subject.kimcode%27%7D%2C%0D%0A++++++++++++%27name%27%3A+%7B%27%24first%27%3A+%27%24short-name.source-value%27%7D%2C%0D%0A++++++++++++%27a%27%3A+%7B%27%24first%27%3A+%27%24a.source-value%27%7D%2C%0D%0A++++++++++++%27energy%27%3A+%7B%27%24first%27%3A+%27%24cohesive-potential-energy.source-value%27%7D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%5D' https://query.openkim.org/api
GET
https://query.openkim.org/api?database=data&aggregate=%5B%7B%27%24match%27+%3A+%0D%0A++++++++%7B%27%24and%27%3A+%5B%0D%0A++++++++++++%7B%27property-id%27%3A+%27tag%3Astaff%40noreply.openkim.org%2C2014-04-15%3Aproperty%2Fcohesive-potential-energy-cubic-crystal%27%7D%2C%0D%0A++++++++++++%7B%27species.source-value%27%3A+%27Al%27%7D%2C%0D%0A++++++++++++%7B%27meta.type%27%3A+%27tr%27%7D%5D%7D%7D%2C%0D%0A%7B%27%24project%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C%0D%0A++++++++++++%27short-name.source-value%27%3A+1%2C+%0D%0A++++++++++++%27a.source-value%27%3A+1%2C%0D%0A++++++++++++%27cohesive-potential-energy.source-value%27%3A+1%7D%7D%2C%0D%0A%7B%27%24sort%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C+%27cohesive-potential-energy.source-value%27%3A+-1%7D+%7D%2C%0D%0A%7B%27%24group%27%3A+%7B%27_id%27%3A+%7B%27model%27%3A+%27%24meta.subject.kimcode%27%7D%2C%0D%0A++++++++++++%27name%27%3A+%7B%27%24first%27%3A+%27%24short-name.source-value%27%7D%2C%0D%0A++++++++++++%27a%27%3A+%7B%27%24first%27%3A+%27%24a.source-value%27%7D%2C%0D%0A++++++++++++%27energy%27%3A+%7B%27%24first%27%3A+%27%24cohesive-potential-energy.source-value%27%7D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%5D
Python
result = requests.post("https://query.openkim.org/api",data={'database': 'data', 'aggregate': '[{"$match" : \r\n {"$and": [\r\n {"property-id": "tag:staff@noreply.openkim.org,2014-04-15:property/cohesive-potential-energy-cubic-crystal"},\r\n {"species.source-value": "Al"},\r\n {"meta.type": "tr"}]}},\r\n{"$project": {"meta.subject.kimcode": 1,\r\n "short-name.source-value": 1, \r\n "a.source-value": 1,\r\n "cohesive-potential-energy.source-value": 1}},\r\n{"$sort": {"meta.subject.kimcode": 1, "cohesive-potential-energy.source-value": -1} },\r\n{"$group": {"_id": {"model": "$meta.subject.kimcode"},\r\n "name": {"$first": "$short-name.source-value"},\r\n "a": {"$first": "$a.source-value"},\r\n "energy": {"$first": "$cohesive-potential-energy.source-value"}\r\n }\r\n }\r\n]'}).json()
d3
d3.json('https://query.openkim.org/api?database=data&aggregate=%5B%7B%27%24match%27+%3A+%0D%0A++++++++%7B%27%24and%27%3A+%5B%0D%0A++++++++++++%7B%27property-id%27%3A+%27tag%3Astaff%40noreply.openkim.org%2C2014-04-15%3Aproperty%2Fcohesive-potential-energy-cubic-crystal%27%7D%2C%0D%0A++++++++++++%7B%27species.source-value%27%3A+%27Al%27%7D%2C%0D%0A++++++++++++%7B%27meta.type%27%3A+%27tr%27%7D%5D%7D%7D%2C%0D%0A%7B%27%24project%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C%0D%0A++++++++++++%27short-name.source-value%27%3A+1%2C+%0D%0A++++++++++++%27a.source-value%27%3A+1%2C%0D%0A++++++++++++%27cohesive-potential-energy.source-value%27%3A+1%7D%7D%2C%0D%0A%7B%27%24sort%27%3A+%7B%27meta.subject.kimcode%27%3A+1%2C+%27cohesive-potential-energy.source-value%27%3A+-1%7D+%7D%2C%0D%0A%7B%27%24group%27%3A+%7B%27_id%27%3A+%7B%27model%27%3A+%27%24meta.subject.kimcode%27%7D%2C%0D%0A++++++++++++%27name%27%3A+%7B%27%24first%27%3A+%27%24short-name.source-value%27%7D%2C%0D%0A++++++++++++%27a%27%3A+%7B%27%24first%27%3A+%27%24a.source-value%27%7D%2C%0D%0A++++++++++++%27energy%27%3A+%7B%27%24first%27%3A+%27%24cohesive-potential-energy.source-value%27%7D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%5D')
jQuery
$.post("https://query.openkim.org/api",{"database": "data", "aggregate": "[{\"$match\" : \r\n {\"$and\": [\r\n {\"property-id\": \"tag:staff@noreply.openkim.org,2014-04-15:property/cohesive-potential-energy-cubic-crystal\"},\r\n {\"species.source-value\": \"Al\"},\r\n {\"meta.type\": \"tr\"}]}},\r\n{\"$project\": {\"meta.subject.kimcode\": 1,\r\n \"short-name.source-value\": 1, \r\n \"a.source-value\": 1,\r\n \"cohesive-potential-energy.source-value\": 1}},\r\n{\"$sort\": {\"meta.subject.kimcode\": 1, \"cohesive-potential-energy.source-value\": -1} },\r\n{\"$group\": {\"_id\": {\"model\": \"$meta.subject.kimcode\"},\r\n \"name\": {\"$first\": \"$short-name.source-value\"},\r\n \"a\": {\"$first\": \"$a.source-value\"},\r\n \"energy\": {\"$first\": \"$cohesive-potential-energy.source-value\"}\r\n }\r\n }\r\n]"});
pipeline.stdin.tpl
@< query({"database": "data", "aggregate": [{"$match": {"$and": [{"property-id": "tag:staff@noreply.openkim.org,2014-04-15:property/cohesive-potential-energy-cubic-crystal"}, {"species.source-value": "Al"}, {"meta.type": "tr"}]}}, {"$project": {"meta.subject.kimcode": 1, "short-name.source-value": 1, "a.source-value": 1, "cohesive-potential-energy.source-value": 1}}, {"$sort": {"meta.subject.kimcode": 1, "cohesive-potential-energy.source-value": -1}}, {"$group": {"_id": {"model": "$meta.subject.kimcode"}, "name": {"$first": "$short-name.source-value"}, "a": {"$first": "$a.source-value"}, "energy": {"$first": "$cohesive-potential-energy.source-value"}}}]}) >@