JMP 社区您好，
我需要根据唯一标识符从人类蛋白质图谱公共网站检索生物信息。
到目前为止，我可以使用下面的简单代码轻松地从网站检索和解析 JSON 文件。
Names DEfault to Here (1);
ID = "ENSG00000108691";
HTM_c = "https://www.proteinatlas.org/XXX.json";
HTM_str = Substitute (HTM_c, "XXX", ID);
request = New HTTP Request (URL (HTM_str), Method ("Get"));
temp = request << send ();
js_par = Parse JSON (temp);
当我尝试仅收集 JSON 文档的选定部分时，就会出现问题（请参阅附件）：
1) 命令“js_par << Get Keys”仅检索顶级密钥，而“子密钥”不可用
2）命令“js_par << Get Values”返回的不是实际值，而是数据“容器”的格式
因此，如何分解 JSON 文档以检索特定的键和值？
任何提示都会受到欢迎。
谢谢。
最好的，
TS
查看 json 导入向导是否满足您的需要。 有几种方法可以攻击它； JSL 解决方案可能看起来像
dt = open("z:/ENSG00000108691.json",guess("huge", stack(1)),jsonwizard(0));
将 0 更改为 1 以查看向导对话框。
该文件似乎有 8 条记录，其中包含最佳猜测选择。 如果这不符合您的期望，您可能想通过 GUI 手动选择您想要的内容，但我不确定您除了删除不需要的列之外还能做更多的事情。
（文件->打开，选择.json扩展名，使用预览选择数据，打开。）
json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json (and XML) dialogs are almost identical.json（和 XML）对话框几乎相同。
实际上，重新格式化后（Visual Studio 代码有效），使用 stack(0) 并获取 1 行可能更有意义。 每列都是该列的属性列表（我猜测）。同义词列有 8 种可能性。 蛋白质类别有 5 种可能性。 它们不应该像第一个示例所示那样在行上对齐，我猜这不是我们想要的。
如果您需要，该表将具有表达式列，而不是带有分隔符的字符列：
[
{
"Gene": "CCL2",
"Gene synonym": [
"GDCF-2",
"HC11",
"MCAF",
"MCP-1",
"MCP1",
"MGC9434",
"SCYA2",
"SMC-CF"
],
"Ensembl": "ENSG00000108691",
"Gene description": "C-C motif chemokine ligand 2",
"Uniprot": [
"P13500"
],
"Chromosome": "17",
"Position": "34255274-34257208",
"Protein class": [
"Cancer-related genes",
"Candidate cardiovascular disease genes",
"Human disease related genes",
"Plasma proteins",
"Predicted secreted proteins"
],
"Biological process": [
"Chemotaxis",
"Inflammatory response"
],
"Molecular function": [
"Cytokine"
],
"Disease involvement": [
"Cancer-related genes"
],
"Evidence": "Evidence at protein level",
"HPA evidence": "Evidence at protein level",
"UniProt evidence": "Evidence at protein level",
"NeXtProt evidence": "Evidence at protein level",
"RNA tissue specificity": "Tissue enhanced",
"RNA tissue distribution": "Detected in all",
"RNA tissue specificity score": null,
"RNA tissue specific nTPM": {
"urinary bladder": "726.7"
},
"RNA single cell type specificity": "Cell type enhanced",
"RNA single cell type distribution": "Detected in many",
"RNA single cell type specificity score": null,
"RNA single cell type specific nTPM": {
"Ductal cells": "2990.5",
"Exocrine glandular cells": "1242.1",
"Pancreatic endocrine cells": "1696.3",
"Secretory cells": "2061.7",
"Smooth muscle cells": "1284.8"
},
"RNA cancer specificity": "Low cancer specificity",
"RNA cancer distribution": "Detected in all",
"RNA cancer specificity score": null,
"RNA cancer specific FPKM": null,
"RNA brain regional specificity": "Low region specificity",
"RNA brain regional distribution": "Detected in all",
"RNA brain regional specificity score": null,
"RNA brain regional specific nTPM": null,
"RNA blood cell specificity": "Group enriched",
"RNA blood cell distribution": "Detected in some",
"RNA blood cell specificity score": "6",
"RNA blood cell specific nTPM": {
"classical monocyte": "7.6",
"eosinophil": "3.1"
},
"RNA blood lineage specificity": "Group enriched",
"RNA blood lineage distribution": "Detected in many",
"RNA blood lineage specificity score": "6",
"RNA blood lineage specific nTPM": {
"granulocytes": "3.1",
"monocytes": "7.6"
},
"RNA cell line specificity": "Low cancer specificity",
"RNA cell line distribution": "Detected in many",
"RNA cell line specificity score": null,
"RNA cell line specific nTPM": null,
"RNA tissue cell type enrichment": [
"Pancreas - Ductal cells"
],
"RNA mouse brain regional specificity": "Low region specificity",
"RNA mouse brain regional distribution": "Detected in some",
"RNA mouse brain regional specificity score": null,
"RNA mouse brain regional specific nTPM": null,
"RNA pig brain regional specificity": "Group enriched",
"RNA pig brain regional distribution": "Detected in all",
"RNA pig brain regional specificity score": "4",
"RNA pig brain regional specific nTPM": {
"midbrain": "13.1",
"spinal cord": "52.4"
},
"Antibody": [
"CAB013676",
"HPA019163"
],
"Reliability (IH)": "Approved",
"Reliability (Mouse Brain)": null,
"Reliability (IF)": "Approved",
"Subcellular location": [
"Golgi apparatus",
"Vesicles"
],
"Secretome location": "Secreted to blood",
"Secretome function": "Chemokine",
"CCD Protein": "NA",
"CCD Transcript": "NA",
"Blood concentration - Conc. blood IM [pg\/L]": 323000,
"Blood concentration - Conc. blood MS [pg\/L]": null,
"Blood expression cluster": null,
"Tissue expression cluster": "Cluster 7: Adipose tissue - Mixed function",
"Brain expression cluster": "Cluster 12: Non-specific - Vasculature",
"Cell line expression cluster": "Cluster 49: HMC-1 - Innate immune response",
"Single cell expression cluster": "Cluster 48: Smooth muscle cells - Signal transduction",
"Interactions": 4,
"Subcellular main location": [
"Golgi apparatus"
],
"Subcellular additional location": [
"Vesicles"
],
"Antibody RRID": {
"CAB013676": null,
"HPA019163": "AB_1846179"
},
"Pathology prognostics - Breast cancer": {
"prognostic type": "favorable",
"is_prognostic": false,
"p_val": "6.43e-2"
},
"Pathology prognostics - Cervical cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "4.14e-2"
},
"Pathology prognostics - Colorectal cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "4.78e-2"
},
"Pathology prognostics - Endometrial cancer": {
"prognostic type": "favorable",
"is_prognostic": false,
"p_val": "5.57e-2"
},
"Pathology prognostics - Glioma": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "2.37e-3"
},
"Pathology prognostics - Head and neck cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "8.64e-2"
},
"Pathology prognostics - Liver cancer": {
"prognostic type": "favorable",
"is_prognostic": false,
"p_val": "2.78e-2"
},
"Pathology prognostics - Lung cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "7.53e-2"
},
"Pathology prognostics - Melanoma": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "2.90e-1"
},
"Pathology prognostics - Ovarian cancer": {
"prognostic type": "favorable",
"is_prognostic": false,
"p_val": "1.19e-1"
},
"Pathology prognostics - Pancreatic cancer": {
"prognostic type": "favorable",
"is_prognostic": false,
"p_val": "9.33e-2"
},
"Pathology prognostics - Prostate cancer": {
"prognostic type": "favorable",
"is_prognostic": false,
"p_val": "2.65e-1"
},
"Pathology prognostics - Renal cancer": {
"prognostic type": "unfavorable",
"is_prognostic": true,
"p_val": "4.51e-4"
},
"Pathology prognostics - Stomach cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "1.33e-1"
},
"Pathology prognostics - Testis cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "2.50e-2"
},
"Pathology prognostics - Thyroid cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "1.81e-1"
},
"Pathology prognostics - Urothelial cancer": {
"prognostic type": "unfavorable",
"is_prognostic": false,
"p_val": "4.92e-2"
}
}
]