Hi JMP Community,
I need to retrieve biological information from the Human Protein Atlas public website based on a unique identifier.
So far, I can easily retrieve and parse the JSON file from the website using the simple code below.
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);
The problem arises when I try to collect only a selected portion of the JSON document (see attached):
1) The Command "js_par << Get Keys" only retrieves the top-level keys, leaving "sub-keys" unavailable
2) The command "js_par << Get Values" does not return the actual values, but the format of data "containers"
Hence, how can I break down the JSON document to enable the retrieval of specific Keys and Values?
Any hint would be welcome.
Thank you.
Best,
TS
