OpenKIM Query

Examples
Basic usage Specifying SI units Retrieving multiple keys

A square-bracketed list containing the Test name. The following formats are accepted: ["CC_DDDDDDDDDDDD"], ["TestName__CC_DDDDDDDDDDDD"], ["CC_DDDDDDDDDDDD_VVV"], ["TestName__CC_DDDDDDDDDDDD_VVV"]. Generally, the three digit version extension (VVV) should be omitted so that the latest version of the Test will be queried on. For more on KIM IDs, refer to the Guide to KIM IDs.

Accepted formats are identical to those above and, similar to above, the three digit version extension should generally be omitted.

A square-bracketed, comma-separated list of quoted strings corresponding to standard elemental symbols (case sensitive). Test Results returned will be required to contain each element listed.

A square-bracketed list containing the property name. May be specified as either the short name of a Property Definition, e.g. structure-cubic-crystal-npt, or the full property ID, e.g. ["tag:staff@noreply.openkim.org,2014-04-15:property/structure-cubic-crystal-npt"]. Only the short name should generally be used so that the latest version of the Property Definition is queried on. See here for a current list of Property Definitions.

Ordered array of keys specified as a square-bracketed, comma-separated list of quoted strings. The order of the keys must correspond to the order of the entries in the 'Units' field below.

A square-bracketed, comma-separated list of quoted strings indicating the desired units that the value of each key should be returned in. The order of the entries in this list should correspond to the order of the entries in the 'Keys' field above. Valid strings for units are any of those recognized by the GNU units utility, or the special string "SI". Keys which are unitless must have a value of null (case-sensitive and unquoted).

Examples
Get all jobs that are currently running Get all Test Drivers in the database Get all fcc Al lattice constants and the Model that ran them
Longest running Test name and time Get a 10 line tail of the logs Get the lowest energy crystal structure for each Model using Al

Things you want true, as a dictionary of key value pairs, e.g. {"type": "td"} makes sure that all objects are test drivers.

Things you want back, as a dictionary of booleans, e.g. {"type":1, "path":1} returns just type and path (and '_id')

A JavaScript function that operates to on the map portion of map-reduce. For more information, check the docs

A JavaScript function that operates to on the reduce portion of map-reduce. For more information, check the docs

Database you want, valid options are [obj, data, job, log, agent]

Things you want sorted on, as a string, or a list with direction, e.g. "kimcode" sorts on kimcode, [["kimcode", -1]] gives reverse kimcode

How many you want, an integer, how it stops, leave empty for all

How many you want to skip, relevant if ordered

Things you want distinct, just a key, e.g. "type" would return distinct type fields. Note, this doesn't play well with others.

Reduce result to an array where the columns are ordered by this list i.e. ["meta.kimcode", "crystal-structure.a.source-value"]. Implies flatten.

Whether or not to flatten the keys in the dictionary

Return full database history. By default, only returns latest data

Return only count of number results created by query

Results

[
    {
        "log": "2021-08-31 15:55:58,337 - WARNING - pipeline.pipeline.gateway-0 - Received run request for 'EDIP_LAMMPS__MD_783584031339_000', but this item already exists in the mongo 'obj' database. Aborting."
    },
    {
        "log": "2021-08-31 15:55:58,321 - INFO - pipeline.pipeline.gateway-0 - Gateway ready, waiting for message..."
    },
    {
        "log": "2021-08-31 15:55:58,312 - INFO - pipeline.pipeline.gateway-0 - Initializing KIM Gateway"
    },
    {
        "log": "2021-08-24 22:56:59,519 - INFO - pipeline.mongodb - Inserting object EDIP_LAMMPS_LucasBertolusPizzagalli_2009_SiC__MO_634310164305_000"
    },
    {
        "log": "2021-08-24 22:56:59,103 - INFO - pipeline.rsync_tools - running rsync for files: ['/curators-to-pipeline-interface//approved/./mo/EDIP_LAMMPS_LucasBertolusPizzagalli_2009_SiC__MO_634310164305_000']"
    },
    {
        "log": "2021-08-24 22:56:59,074 - INFO - pipeline.pipeline.gateway-0 - Sending task 'pipeline.tasks.director_ispending' with contents ('EDIP_LAMMPS_LucasBertolusPizzagalli_2009_SiC__MO_634310164305_000',)"
    },
    {
        "log": "2021-08-24 17:55:09,352 - ERROR - pipeline.pipeline.director-0 - 'delete' had an exception\nOSError('Could not initialize KIMObject for \\'EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000\\': \"Directory \\'/disk2/director/repository/mo/EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000\\' not found\"',)\nTraceback (most recent call last):\n  File \"/disk2/director/openkim-pipeline/pipeline/kimobjects.py\", line 760, in kim_obj\n    kobj = cls(kim_code, *args, **kwargs)\n  File \"/disk2/director/openkim-pipeline/pipeline/kimobjects.py\", line 415, in __init__\n    super(Model,self).__init__(kim_code,*args,**kwargs)\n  File \"/disk2/director/openkim-pipeline/pipeline/kimobjects.py\", line 373, in __init__\n    super(Subject,self).__init__(kim_code,*args,**kwargs)\n  File \"/disk2/director/openkim-pipeline/pipeline/kimobjects.py\", line 124, in __init__\n    raise IOError(\"Directory %r not found\" % path)\nOSError: Directory '/disk2/director/repository/mo/EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000' not found\n\nDuring handling of the above exception, another exception occurred:\n\nTraceback (most recent call last):\n  File \"/disk2/director/openkim-pipeline/pipeline/tasks.py\", line 132, in _wrap\n    return getattr(self.obj, obj_func)(*args, **kwargs)\n  File \"/disk2/director/openkim-pipeline/pipeline/director.py\", line 478, in delete\n    kobj = kimobjects.kim_obj(kimid)\n  File \"/disk2/director/openkim-pipeline/pipeline/kimobjects.py\", line 762, in kim_obj\n    raise IOError(\"Could not initialize KIMObject for %r: %r\" % (kim_code, str(e)))\nOSError: Could not initialize KIMObject for 'EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000': \"Directory '/disk2/director/repository/mo/EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000' not found\""
    },
    {
        "log": "2021-08-24 17:55:07,733 - INFO - pipeline.director - Removing EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000 from Director database"
    },
    {
        "log": "2021-08-24 17:55:07,729 - INFO - pipeline.pipeline.director-0 - Deleting item 'EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000' from Director resources"
    },
    {
        "log": "2021-08-24 17:55:07,724 - INFO - pipeline.pipeline.director-0 - Director received deletion request for item 'EDIP_LAMMPS_LucasBertolusPizzagalli_2010_SiC__MO_634310164305_000' with approved=True"
    }
]

Query Link

https://query.openkim.org/raw?database=log&fields=%7B%22log%22%3A1%2C%22_id%22%3A0%7D&sort=%5B%5B%22_id%22%2C-1%5D%5D&limit=10

Curl

curl --data-urlencode 'database=log' --data-urlencode 'fields={"log":1,"_id":0}' --data-urlencode 'sort=[["_id",-1]]' --data-urlencode 'limit=10' https://query.openkim.org/api

GET

https://query.openkim.org/api?database=log&fields=%7B%22log%22%3A1%2C%22_id%22%3A0%7D&sort=%5B%5B%22_id%22%2C-1%5D%5D&limit=10

Python

result = requests.post("https://query.openkim.org/api",data={'database': 'log', 'fields': '{"log":1,"_id":0}', 'sort': '[["_id",-1]]', 'limit': '10'}).json()

d3

d3.json('https://query.openkim.org/api?database=log&fields=%7B%22log%22%3A1%2C%22_id%22%3A0%7D&sort=%5B%5B%22_id%22%2C-1%5D%5D&limit=10')

jQuery

$.post("https://query.openkim.org/api",{"database": "log", "fields": "{\"log\":1,\"_id\":0}", "sort": "[[\"_id\",-1]]", "limit": "10"});

pipeline.stdin.tpl

@< query({"database": "log", "fields": {"log": 1, "_id": 0}, "sort": [["_id", -1]], "limit": 10}) >@