[R] help with json data from the web into data frame in R

Evans, Richard K. (GRC-H000) r|ch@rd@k@ev@n@ @end|ng |rom n@@@@gov
Tue May 8 17:36:39 CEST 2018

I’ve been tinkering and discovered that the link I need to read json data from is ‘https’ and there is a certificate warning that I have to click through from a browser. That might be my issue. Is there any way in the json package to tell it to ignore self-signed cert errors in a url?


From: Eric Berger [mailto:ericjberger using gmail.com]
Sent: Tuesday, May 08, 2018 11:31 AM
To: Evans, Richard K. (GRC-H000)
Cc: r-help using r-project.org
Subject: Re: [R] help with json data from the web into data frame in R

Hi Rich,
Take a look at the function fromJSON found in the rjson package.
Note that the Usage in the help page: ?fromJSON
names the second argument 'file' but if you look at the description the argument can be a URL.


On Tue, May 8, 2018 at 6:16 PM, Evans, Richard K. (GRC-H000) <richard.k.evans using nasa.gov<mailto:richard.k.evans using nasa.gov>> wrote:

I am able to construct a url that points to some data online in the JSON format.  See an example at [0].

I would like to work with this data as a dataframe in R.

I know that there is a package for handling json data [1] but it assumes the data is in a local file but It is not clear to me how to request the data from the web in an R script and get the json data converted into a data frame in R.

Can anyone provide a basic example or some guidance please?

-Rich (revansx)

[0] https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]&format=json<https://www.semantic-mediawiki.org/w/api.php?action=ask&query=%5b%5bCategory:City%5d%5d&format=json>
[1] https://www.tutorialspoint.com/r/r_json_files.htm

R-help using r-project.org<mailto:R-help using r-project.org> mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

	[[alternative HTML version deleted]]

More information about the R-help mailing list