I am trying to import some JSON data and pondering why it is not working as I had hoped.
This is a link to JSON data published by the National Library of Medicine:
https://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=pubmed&id=29706724
This is an attempt to import the data into Coda:
https://coda.io/d/URL-Expansion-Pubmed-Test_dWcSCL8hyM8/Section-1_suSv1#Table-1_tuvHo/r1
Questions which arise are:
(1) How do I import into Coda the actual JSON data at the URL rather than just a link to the data? I could not figure out how to bring the actual data into Coda to be parsed by the PARSEJSON function. For test purposes. I manually copied and pasted it into a new field. What would a better way be?
(2) I could not figure out a JSON Path to import all of the assorted variables in the JSON data - is that possible? Some online JSON converters reported that the JSON is not in proper format. Yet if I import the same JSON data into Coda using Zapier, it is able to parse it. Is there a way to parse this with the ParseJSON function in Coda?