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 mongodb aggregation pipeline. Use $sort, $limit, $skip, and $distinct aggregation pipeline stages instead of entering in their respective fields below if using aggregate(). 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": "2023-06-05 16:33:16,171 - INFO - pipeline.pipeline.gateway-0 - Sending task 'pipeline.tasks.director_result' with contents {'job': ['EquilibriumCrystalStructure_A2B_mP12_11_4e_2e_OTi__TE_471124954540_000', 'MEAM_LAMMPS_ZhangTrinkle_2016_TiO__MO_612732924171_002'], 'jobid': 'TE_471124954540_000-and-MO_612732924171_002-1683685972', 'uuid': 'TE_471124954540_000-and-MO_612732924171_002-1683685972-er', 'result_type': 'er', 'status': 'approved', 'prompting_child': None, 'prompting_parent': None, 'prompting_function': 'run', 'priority': 1000000}"
    },
    {
        "log": "2023-06-05 16:33:16,168 - ERROR - pipeline.mongodb - Already have TE_471124954540_000-and-MO_612732924171_002-1683685972-er"
    },
    {
        "log": "2023-06-05 16:33:16,114 - INFO - pipeline.mongodb - Inserting result or error TE_471124954540_000-and-MO_612732924171_002-1683685972-er "
    },
    {
        "log": "2023-06-05 16:33:16,100 - INFO - pipeline.rsync_tools - Touching flag file, upload complete for 'TE_471124954540_000-and-MO_612732924171_002-1683685972-er'"
    },
    {
        "log": "2023-06-05 16:33:16,096 - INFO - pipeline.rsync_tools - ssh_touch_done cmd: ssh -F /home/gateway-user1/.ssh/config-gateway rsync-to-shared-repository \"touch /repo/home/.//pipeline/test-result-uploads/incoming//approved/./er/TE_471124954540_000-and-MO_612732924171_002-1683685972-er/upload_complete.txt\" >> /disk2/gateway/openkim-pipeline/logs/ssh.log 2>&1"
    },
    {
        "log": "2023-06-05 16:33:16,093 - INFO - pipeline.rsync_tools - ssh_touch_done remote_file: /repo/home/.//pipeline/test-result-uploads/incoming//approved/./er/TE_471124954540_000-and-MO_612732924171_002-1683685972-er/upload_complete.txt"
    },
    {
        "log": "2023-06-05 16:33:16,032 - INFO - pipeline.rsync_tools - running rsync for files: ['er/TE_471124954540_000-and-MO_612732924171_002-1683685972-er']"
    },
    {
        "log": "2023-06-05 16:33:16,022 - INFO - pipeline.pipeline.gateway-0 - Processing jobid TE_471124954540_000-and-MO_612732924171_002-1683685972 with result type er"
    },
    {
        "log": "2023-06-05 16:33:16,004 - INFO - pipeline.pipeline.gateway-0 - Sending task 'pipeline.tasks.director_result' with contents {'job': ['EquilibriumCrystalStructure_A_mC16_12_2ij_O__TE_263342662941_000', 'Sim_LAMMPS_SMTBQ_SallesPolitanoAmzallag_2016_TiO__SM_349577644423_000'], 'jobid': 'TE_263342662941_000-and-SM_349577644423_000-1683307372', 'uuid': 'TE_263342662941_000-and-SM_349577644423_000-1683307372-er', 'result_type': 'er', 'status': 'approved', 'prompting_child': None, 'prompting_parent': None, 'prompting_function': 'run', 'priority': 1000000}"
    },
    {
        "log": "2023-06-05 16:33:16,000 - ERROR - pipeline.mongodb - Already have TE_263342662941_000-and-SM_349577644423_000-1683307372-er"
    }
]

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}) >@