[R] Get XML or JSON data from api into data frame

Hadley Wickham hadley at rice.edu
Thu Jul 26 17:10:22 CEST 2012

On Thu, Jul 26, 2012 at 4:18 AM, Richard Ohrvall
<richard.ohrvall at gmail.com> wrote:
> 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
> according to IMDB standard. To give just a few:
> ids <-c("tt0110074", "tt0096184", "tt0081568", "tt0448134", "tt0079367")
> Now, I want to create a data frame where each of the movies refer to
> one line and the other information is retrieved from the api. This can
> be retrieved either as XML data or JSON data, e.g.
> http://www.imdbapi.com/?i=tt0110074&tomatoes=TRUE
> XML:
> http://www.imdbapi.com/?i=tt0110074&r=XML&tomatoes=TRUE
> Where i refer to the movie-id, i.e. the information I have in my
> vector. They are all in the format ttXXXXXXX



This will be a bit easier in the next version of httr

  type = "application/json")

See also https://github.com/hadley/data-movies, which I suspect is a
faster approach than using an API.


Assistant Professor / Dobelman Family Junior Chair
Department of Statistics / Rice University

More information about the R-help mailing list