Skip to content
Prev 374503 / 398513 Next

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

Hello

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 
[1] https://www.tutorialspoint.com/r/r_json_files.htm