similar to: help with json data from the web into data frame in R

Right. I'm trying to access a server within my organization which has a cert error that I cannot fix. The example link I provided was to a site on the web that does not have the cert error. From the linux shell I use the "-k" switch with cURL to ignore cert errors.. is there an equivalent in the R world? -Rich -----Original Message----- From: David Winsemius [mailto:dwinsemius

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? -Rich From: Eric Berger [mailto:ericjberger at gmail.com] Sent: Tuesday, May 08, 2018 11:31 AM To: Evans,

> On May 8, 2018, at 9:03 AM, Evans, Richard K. (GRC-H000) <richard.k.evans at nasa.gov> wrote: > > That said, I have two issues to ask for help with: > > 1) how to ignore cert errors with a fromJSON call If you can do it with curl, then why aren't you doing one of a) a system call, b) installing and loading RCurl, c) installing and loading curl (the R package with that

That said, I have two issues to ask for help with: 1) how to ignore cert errors with a fromJSON call And 2) why the json data from the example link doesn't convert to a data frame. As seen in the following example library("rjson") result <- fromJSON(file =

Hi David, .. I think I've got it :-) Please let me know if you see anything glaringly wrong with this: library(RCurl) zWebObj <- postForm("https://www.semantic-mediawiki.org/w/api.php", "action" = "ask", "query" = "[[Category:City]]|?Capital%20of|?Has%20area", "format" = "json" .opts = list(ssl.verifypeer =

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. HTH, Eric On Tue, May 8, 2018 at 6:16 PM, Evans, Richard K. (GRC-H000) < richard.k.evans at nasa.gov> wrote: > Hello > > I am able to construct a url that

> On May 8, 2018, at 8:36 AM, Evans, Richard K. (GRC-H000) <richard.k.evans at nasa.gov> wrote: > > 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

[non-tabular json data] -- ok.. so I think I need to figure out how to make it tabular. Thanks! [curl] -- I was hoping there was a cleaner way to do it.. using R to evoke cURL to get the data as text and then passing it into getJSON seems to be what I need to do. Do you by chance have an simple example of using RCurl to get a response ignoring cert errors? ty -Rich -----Original Message-----

Regarding the question: From the linux shell I use the "-k" switch with cURL to ignore cert errors.. is there an equivalent in the R world? I have (sometimes) had success by creating a .curlrc file and putting the necessary curl options in it. When R invokes curl, curl picks up the options. [my context was running install.packages( method='curl' ) pointing to a local

> On May 8, 2018, at 10:08 AM, Evans, Richard K. (GRC-H000) <richard.k.evans at nasa.gov> wrote: > > Hi David, .. I think I've got it :-) > Please let me know if you see anything glaringly wrong with this: > > library(RCurl) > zWebObj <- postForm("https://www.semantic-mediawiki.org/w/api.php", > "action" = "ask", >

Hello All - I am trying to use RJSONIO to read in some JSON files. I was wondering if anyone could please comment on the level of complexity of the files it can be used to read, exports from or directly from NoSQL DBMS like MongoDB and such. Also, i understand that in reading the JSON file RJSONIO will automatically create the necessary structures. However I cannot seem to use to to read the

I'm trying to read two data sets in json format from a single .js file. I've tried fromJSON() in both RJSONIOIO and RJSON packages, but they require that the lines be pre-parsed somehow in ways I don't understand. Can someone help? > wheat <- readLines("http://mbostock.github.com/protovis/ex/wheat.js") > str(wheat) chr [1:70] "var wheat = [" "

Dear all, I am new to R in general and ways to retrieve XML or JSON data in particular. I have tried to get information through the XML package and various websites without being able to do exactly what I want. I hope someone of you can give me some help. I want to retrieve information about movies from IMDB or rather the unofficial api, www.imdbapi.com. I have a vector with a lot movie-ids

Hello, I'm trying to use rjson to parse a JSON object. The object can be found here http://pastebin.com/np0s5hgM (you'll probably need to add quotes around the content) fromJSON returns the error glibc detected home/sguha/lib64/R/bin/exec/R: realloc(): invalid next size: 0x000000000209e210 *** Is there a fix coming soon? Maybe CRAN should also have an outstanding bug field -

Hello to everybody, I need to convert a json dataset in an R dataframe. I suppose that I'd need to use rjson or rjsonio package. The json dataset is: http://apistat.istat.it/?q=getdatajson&dataset=DCIS_POPSTRBIL&dim=1,0,0,0&lang=1&tr=&te= It would be nice if someone can help me to create a function like the one below:

Hi, I have a very rudimentary kind of question on using unlist(). I am parsing a bunch of JSON text using rjson package. Some data elements in a dictionary happen to be null which rjson parses correctly. > fromJSON(json_str='{"query":{"A":10, "B":null, "C":"hello"}, "query":{"A":20, "B":null,

Dear all, I have a data.frame with a column like the x shown below myDF<-data.frame(cbind(x=c("[[1, 0, 0], [0, 1]]", "[[1, 1, 0], [0, 1]]","[[1, 0, 0], [1, 1]]", "[[0, 0, 1], [0, 1]]"))) > myDF x 1 [[1, 0, 0], [0, 1]] 2 [[1, 1, 0], [0, 1]] 3 [[1, 0, 0], [1, 1]] 4 [[0, 0, 1], [0, 1]] As you can see my x column is composed of

I have come across an issue converting a JSON string in R (with either the package 'rjson' or 'RJSONIO') when big integers are included in the JSON string. A simple example of the problem is: > options(scipen=999) # To prevent representing the answer in scientific notation > json.str <- '{"bigInt":123456789123456789}' # Sample JSON string with big

Is there a *fast* converter between JSON and R? I'm aware of the rjson package, but it is implemented in R, and it is too slow for my purposes. TIA! kynn [[alternative HTML version deleted]]

Hi all: I struggle a lot scraping web data. I still haven't got a handle on the XML package. I'd like to get particular exchange rates from this table: https://raw.github.com/currencybot/open-exchange-rates/master/latest.json This is the code that I'm working with: library(RCurl) library(XML)