{"__v":0,"_id":"5845ac222c0fc01900163600","category":{"project":"55faf11ba62ba1170021a9a7","version":"55faf11ba62ba1170021a9aa","_id":"58458b4fba4f1c0f009692bb","__v":0,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-12-05T15:44:15.650Z","from_sync":false,"order":6,"slug":"datasets-hub","title":"DATASETS HUB"},"parentDoc":null,"project":"55faf11ba62ba1170021a9a7","user":"5613e4f8fdd08f2b00437620","version":{"__v":35,"_id":"55faf11ba62ba1170021a9aa","project":"55faf11ba62ba1170021a9a7","createdAt":"2015-09-17T16:58:03.490Z","releaseDate":"2015-09-17T16:58:03.490Z","categories":["55faf11ca62ba1170021a9ab","55faf8f4d0e22017005b8272","55faf91aa62ba1170021a9b5","55faf929a8a7770d00c2c0bd","55faf932a8a7770d00c2c0bf","55faf94b17b9d00d00969f47","55faf958d0e22017005b8274","55faf95fa8a7770d00c2c0c0","55faf96917b9d00d00969f48","55faf970a8a7770d00c2c0c1","55faf98c825d5f19001fa3a6","55faf99aa62ba1170021a9b8","55faf99fa62ba1170021a9b9","55faf9aa17b9d00d00969f49","55faf9b6a8a7770d00c2c0c3","55faf9bda62ba1170021a9ba","5604570090ee490d00440551","5637e8b2fbe1c50d008cb078","5649bb624fa1460d00780add","5671974d1b6b730d008b4823","5671979d60c8e70d006c9760","568e8eef70ca1f0d0035808e","56d0a2081ecc471500f1795e","56d4a0adde40c70b00823ea3","56d96b03dd90610b00270849","56fbb83d8f21c817002af880","573c811bee2b3b2200422be1","576bc92afb62dd20001cda85","5771811e27a5c20e00030dcd","5785191af3a10c0e009b75b0","57bdf84d5d48411900cd8dc0","57ff5c5dc135231700aed806","5804caf792398f0f00e77521","58458b4fba4f1c0f009692bb","586d3c287c6b5b2300c05055"],"is_deprecated":false,"is_hidden":false,"is_beta":true,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-12-05T18:04:18.897Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"examples":{"codes":[]},"method":"post","results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":32,"body":"Use the following query to see all cases for which the age at diagnosis is between 10 and 50.\n\n\n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"POST /datasets/tcga/v0/query HTTP/1.1\\nHost: cgc-datasets-api.sbgenomics.com\\nX-SBG-Auth-Token: 7942f56901534434a054dafc3813bc96\",\n      \"language\": \"http\",\n      \"name\": \"Request\"\n    }\n  ]\n}\n[/block]\n\n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"{\\n   \\\"entity\\\":\\\"cases\\\",\\n   \\\"hasAgeAtDiagnosis\\\": {\\n       \\\"filter\\\": {\\n           \\\"gt\\\": 10,\\n           \\\"lt\\\": 50\\n       }\\n   }\\n}\",\n      \"language\": \"json\",\n      \"name\": \"Request body\"\n    }\n  ]\n}\n[/block]\nNote that the value of the metadata field `hasAgeAtDiagnosis` is a dictionary containing the key `filter`, whose value is a further dictionary with keys `gt` (greater than) and `lt` (less than) for the upper and lower bounds to filter by.\n[block:callout]\n{\n  \"type\": \"success\",\n  \"body\": \"You can use either integers or strings (like `\\\"10\\\"`) as the upper and lower bounds in `filter`, in the query above.\"\n}\n[/block]\n##Response body\nThe response shows the matching cases.\n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"{\\n  \\\"count\\\": 100,\\n  \\\"_embedded\\\": {\\n    \\\"cases\\\": [\\n      {\\n        \\\"_links\\\": {\\n          \\\"self\\\": {\\n            \\\"href\\\": \\\"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/029CE650-5E5A-4100-8596-CD94300E7EF5\\\"\\n          }\\n        },\\n        \\\"id\\\": \\\"029CE650-5E5A-4100-8596-CD94300E7EF5\\\",\\n        \\\"label\\\": \\\"029CE650-5E5A-4100-8596-CD94300E7EF5\\\"\\n      },\\n      {\\n        \\\"_links\\\": {\\n          \\\"self\\\": {\\n            \\\"href\\\": \\\"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/02B5012E-F7AC-4423-8978-0B2F5E50926E\\\"\\n          }\\n        },\\n        \\\"id\\\": \\\"02B5012E-F7AC-4423-8978-0B2F5E50926E\\\",\\n        \\\"label\\\": \\\"02B5012E-F7AC-4423-8978-0B2F5E50926E\\\"\\n      },\\n  \\n        <snip>\\n  \\n    ]\\n  }\\n}\",\n      \"language\": \"json\"\n    }\n  ]\n}\n[/block]\n\n[block:callout]\n{\n  \"type\": \"success\",\n  \"body\": \"For brevity, we have omitted part some of the returned cases.\"\n}\n[/block]\nFor each case matching the query, the following information is listed:\n  * Its `href`: this is a path that can be used to obtain full information about the sample. To see all information, issue a `GET` request to this path. See [Example query 1: Find samples connected to a case](doc:example-query-1-find-samples-connected-to-a-case) for details.\n  * Its TCGA `id`\n  * Its TCGA `label`","excerpt":"<a href=\"query-datasets\" style=\"color:#132c56\">QUERY DATASETS</a> > <a href=\"about-the-datasets-api\" style=\"color:#132c56\">About the Datasets API</a> > <a href=\"query-via-the-datasets-api\" style=\"color:#132c56\">Query via the Datasets API</a> > Example query 3: find cases with...","slug":"example-query-3-find-cases-with-given-age-at-diagnosis","type":"endpoint","title":"Example query 3: Find cases with given age at diagnosis"}

postExample query 3: Find cases with given age at diagnosis

<a href="query-datasets" style="color:#132c56">QUERY DATASETS</a> > <a href="about-the-datasets-api" style="color:#132c56">About the Datasets API</a> > <a href="query-via-the-datasets-api" style="color:#132c56">Query via the Datasets API</a> > Example query 3: find cases with...

Use the following query to see all cases for which the age at diagnosis is between 10 and 50. [block:code] { "codes": [ { "code": "POST /datasets/tcga/v0/query HTTP/1.1\nHost: cgc-datasets-api.sbgenomics.com\nX-SBG-Auth-Token: 7942f56901534434a054dafc3813bc96", "language": "http", "name": "Request" } ] } [/block] [block:code] { "codes": [ { "code": "{\n \"entity\":\"cases\",\n \"hasAgeAtDiagnosis\": {\n \"filter\": {\n \"gt\": 10,\n \"lt\": 50\n }\n }\n}", "language": "json", "name": "Request body" } ] } [/block] Note that the value of the metadata field `hasAgeAtDiagnosis` is a dictionary containing the key `filter`, whose value is a further dictionary with keys `gt` (greater than) and `lt` (less than) for the upper and lower bounds to filter by. [block:callout] { "type": "success", "body": "You can use either integers or strings (like `\"10\"`) as the upper and lower bounds in `filter`, in the query above." } [/block] ##Response body The response shows the matching cases. [block:code] { "codes": [ { "code": "{\n \"count\": 100,\n \"_embedded\": {\n \"cases\": [\n {\n \"_links\": {\n \"self\": {\n \"href\": \"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/029CE650-5E5A-4100-8596-CD94300E7EF5\"\n }\n },\n \"id\": \"029CE650-5E5A-4100-8596-CD94300E7EF5\",\n \"label\": \"029CE650-5E5A-4100-8596-CD94300E7EF5\"\n },\n {\n \"_links\": {\n \"self\": {\n \"href\": \"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/02B5012E-F7AC-4423-8978-0B2F5E50926E\"\n }\n },\n \"id\": \"02B5012E-F7AC-4423-8978-0B2F5E50926E\",\n \"label\": \"02B5012E-F7AC-4423-8978-0B2F5E50926E\"\n },\n \n <snip>\n \n ]\n }\n}", "language": "json" } ] } [/block] [block:callout] { "type": "success", "body": "For brevity, we have omitted part some of the returned cases." } [/block] For each case matching the query, the following information is listed: * Its `href`: this is a path that can be used to obtain full information about the sample. To see all information, issue a `GET` request to this path. See [Example query 1: Find samples connected to a case](doc:example-query-1-find-samples-connected-to-a-case) for details. * Its TCGA `id` * Its TCGA `label`