The New York Times web site provides a rich set of APIs, as described here: https://developer.nytimes.com/apis You’ll need to start by signing up for an API key. Your task is to choose one of the New York Times APIs, construct an interface in R to read in the JSON data, and transform it into an R DataFrame.
#Load packages
library(httr2)
library(jsonlite)# API Call
# The API call from NYTs requires API key to be put into the url at the end, and certain parameters for querying eg (lists/names)
api_key <- "HkhZiJEhn1oSfOE6SGZVqKWDyvYsCy7r"
url <- "https://api.nytimes.com/svc/books/v3/lists/names.json?api-key=HkhZiJEhn1oSfOE6SGZVqKWDyvYsCy7r"
req <- request(url) %>%
req_headers(Authorization = paste("Bearer", api_key))
resp <- req_perform(req)
#Reading json data response into a data frame in R
json_data <- resp_body_json(resp)
df <- as.data.frame(json_data)
print(df)## status copyright
## 1 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## num_results results.list_name results.display_name
## 1 59 Combined Print and E-Book Fiction Combined Print & E-Book Fiction
## results.list_name_encoded results.oldest_published_date
## 1 combined-print-and-e-book-fiction 2011-02-13
## results.newest_published_date results.updated
## 1 2024-11-10 WEEKLY
## results.list_name.1 results.display_name.1
## 1 Combined Print and E-Book Nonfiction Combined Print & E-Book Nonfiction
## results.list_name_encoded.1 results.oldest_published_date.1
## 1 combined-print-and-e-book-nonfiction 2011-02-13
## results.newest_published_date.1 results.updated.1 results.list_name.2
## 1 2024-11-10 WEEKLY Hardcover Fiction
## results.display_name.2 results.list_name_encoded.2
## 1 Hardcover Fiction hardcover-fiction
## results.oldest_published_date.2 results.newest_published_date.2
## 1 2008-06-08 2024-11-10
## results.updated.2 results.list_name.3 results.display_name.3
## 1 WEEKLY Hardcover Nonfiction Hardcover Nonfiction
## results.list_name_encoded.3 results.oldest_published_date.3
## 1 hardcover-nonfiction 2008-06-08
## results.newest_published_date.3 results.updated.3 results.list_name.4
## 1 2024-11-10 WEEKLY Trade Fiction Paperback
## results.display_name.4 results.list_name_encoded.4
## 1 Paperback Trade Fiction trade-fiction-paperback
## results.oldest_published_date.4 results.newest_published_date.4
## 1 2008-06-08 2024-11-10
## results.updated.4 results.list_name.5 results.display_name.5
## 1 WEEKLY Mass Market Paperback Paperback Mass-Market Fiction
## results.list_name_encoded.5 results.oldest_published_date.5
## 1 mass-market-paperback 2008-06-08
## results.newest_published_date.5 results.updated.5 results.list_name.6
## 1 2017-01-29 WEEKLY Paperback Nonfiction
## results.display_name.6 results.list_name_encoded.6
## 1 Paperback Nonfiction paperback-nonfiction
## results.oldest_published_date.6 results.newest_published_date.6
## 1 2008-06-08 2024-11-10
## results.updated.6 results.list_name.7 results.display_name.7
## 1 WEEKLY E-Book Fiction E-Book Fiction
## results.list_name_encoded.7 results.oldest_published_date.7
## 1 e-book-fiction 2011-02-13
## results.newest_published_date.7 results.updated.7 results.list_name.8
## 1 2017-01-29 WEEKLY E-Book Nonfiction
## results.display_name.8 results.list_name_encoded.8
## 1 E-Book Nonfiction e-book-nonfiction
## results.oldest_published_date.8 results.newest_published_date.8
## 1 2011-02-13 2017-01-29
## results.updated.8 results.list_name.9 results.display_name.9
## 1 WEEKLY Hardcover Advice Hardcover Advice & Misc.
## results.list_name_encoded.9 results.oldest_published_date.9
## 1 hardcover-advice 2008-06-08
## results.newest_published_date.9 results.updated.9 results.list_name.10
## 1 2013-04-21 WEEKLY Paperback Advice
## results.display_name.10 results.list_name_encoded.10
## 1 Paperback Advice & Misc. paperback-advice
## results.oldest_published_date.10 results.newest_published_date.10
## 1 2008-06-08 2013-04-21
## results.updated.10 results.list_name.11
## 1 WEEKLY Advice How-To and Miscellaneous
## results.display_name.11 results.list_name_encoded.11
## 1 Advice, How-To & Miscellaneous advice-how-to-and-miscellaneous
## results.oldest_published_date.11 results.newest_published_date.11
## 1 2013-04-28 2024-11-10
## results.updated.11 results.list_name.12 results.display_name.12
## 1 WEEKLY Hardcover Graphic Books Hardcover Graphic Books
## results.list_name_encoded.12 results.oldest_published_date.12
## 1 hardcover-graphic-books 2009-03-15
## results.newest_published_date.12 results.updated.12 results.list_name.13
## 1 2017-01-29 WEEKLY Paperback Graphic Books
## results.display_name.13 results.list_name_encoded.13
## 1 Paperback Graphic Books paperback-graphic-books
## results.oldest_published_date.13 results.newest_published_date.13
## 1 2009-03-15 2017-01-29
## results.updated.13 results.list_name.14 results.display_name.14
## 1 WEEKLY Manga Manga
## results.list_name_encoded.14 results.oldest_published_date.14
## 1 manga 2009-03-15
## results.newest_published_date.14 results.updated.14 results.list_name.15
## 1 2017-01-29 WEEKLY Combined Print Fiction
## results.display_name.15 results.list_name_encoded.15
## 1 Combined Hardcover & Paperback Fiction combined-print-fiction
## results.oldest_published_date.15 results.newest_published_date.15
## 1 2011-02-13 2013-05-12
## results.updated.15 results.list_name.16
## 1 WEEKLY Combined Print Nonfiction
## results.display_name.16 results.list_name_encoded.16
## 1 Combined Hardcover & Paperback Nonfiction combined-print-nonfiction
## results.oldest_published_date.16 results.newest_published_date.16
## 1 2011-02-13 2013-05-12
## results.updated.16 results.list_name.17 results.display_name.17
## 1 WEEKLY Chapter Books Children’s Chapter Books
## results.list_name_encoded.17 results.oldest_published_date.17
## 1 chapter-books 2008-06-08
## results.newest_published_date.17 results.updated.17 results.list_name.18
## 1 2012-12-09 WEEKLY Childrens Middle Grade
## results.display_name.18 results.list_name_encoded.18
## 1 Children’s Middle Grade childrens-middle-grade
## results.oldest_published_date.18 results.newest_published_date.18
## 1 2012-12-16 2015-08-23
## results.updated.18 results.list_name.19
## 1 WEEKLY Childrens Middle Grade E-Book
## results.display_name.19 results.list_name_encoded.19
## 1 Children’s Middle Grade E-Book childrens-middle-grade-e-book
## results.oldest_published_date.19 results.newest_published_date.19
## 1 2015-08-30 2017-01-29
## results.updated.19 results.list_name.20
## 1 WEEKLY Childrens Middle Grade Hardcover
## results.display_name.20 results.list_name_encoded.20
## 1 Children’s Middle Grade Hardcover childrens-middle-grade-hardcover
## results.oldest_published_date.20 results.newest_published_date.20
## 1 2015-08-30 2024-11-10
## results.updated.20 results.list_name.21
## 1 WEEKLY Childrens Middle Grade Paperback
## results.display_name.21 results.list_name_encoded.21
## 1 Children’s Middle Grade Paperback childrens-middle-grade-paperback
## results.oldest_published_date.21 results.newest_published_date.21
## 1 2015-08-30 2017-01-29
## results.updated.21 results.list_name.22 results.display_name.22
## 1 WEEKLY Paperback Books Children’s Paperback Books
## results.list_name_encoded.22 results.oldest_published_date.22
## 1 paperback-books 2008-06-08
## results.newest_published_date.22 results.updated.22 results.list_name.23
## 1 2012-12-09 WEEKLY Picture Books
## results.display_name.23 results.list_name_encoded.23
## 1 Children’s Picture Books picture-books
## results.oldest_published_date.23 results.newest_published_date.23
## 1 2008-06-08 2024-11-10
## results.updated.23 results.list_name.24 results.display_name.24
## 1 WEEKLY Series Books Children’s & Young Adult Series
## results.list_name_encoded.24 results.oldest_published_date.24
## 1 series-books 2008-06-08
## results.newest_published_date.24 results.updated.24 results.list_name.25
## 1 2024-11-10 WEEKLY Young Adult
## results.display_name.25 results.list_name_encoded.25
## 1 Young Adult young-adult
## results.oldest_published_date.25 results.newest_published_date.25
## 1 2012-12-16 2015-08-23
## results.updated.25 results.list_name.26 results.display_name.26
## 1 WEEKLY Young Adult E-Book Young Adult E-Book
## results.list_name_encoded.26 results.oldest_published_date.26
## 1 young-adult-e-book 2015-08-30
## results.newest_published_date.26 results.updated.26 results.list_name.27
## 1 2017-01-29 WEEKLY Young Adult Hardcover
## results.display_name.27 results.list_name_encoded.27
## 1 Young Adult Hardcover young-adult-hardcover
## results.oldest_published_date.27 results.newest_published_date.27
## 1 2015-08-30 2024-11-10
## results.updated.27 results.list_name.28 results.display_name.28
## 1 WEEKLY Young Adult Paperback Young Adult Paperback
## results.list_name_encoded.28 results.oldest_published_date.28
## 1 young-adult-paperback 2015-08-30
## results.newest_published_date.28 results.updated.28 results.list_name.29
## 1 2017-01-29 WEEKLY Animals
## results.display_name.29 results.list_name_encoded.29
## 1 Animals animals
## results.oldest_published_date.29 results.newest_published_date.29
## 1 2014-09-07 2017-01-15
## results.updated.29 results.list_name.30 results.display_name.30
## 1 MONTHLY Audio Fiction Audio Fiction
## results.list_name_encoded.30 results.oldest_published_date.30
## 1 audio-fiction 2018-03-11
## results.newest_published_date.30 results.updated.30 results.list_name.31
## 1 2024-10-13 MONTHLY Audio Nonfiction
## results.display_name.31 results.list_name_encoded.31
## 1 Audio Nonfiction audio-nonfiction
## results.oldest_published_date.31 results.newest_published_date.31
## 1 2018-03-11 2024-10-13
## results.updated.31 results.list_name.32 results.display_name.32
## 1 MONTHLY Business Books Business
## results.list_name_encoded.32 results.oldest_published_date.32
## 1 business-books 2013-11-03
## results.newest_published_date.32 results.updated.32 results.list_name.33
## 1 2024-10-13 MONTHLY Celebrities
## results.display_name.33 results.list_name_encoded.33
## 1 Celebrities celebrities
## results.oldest_published_date.33 results.newest_published_date.33
## 1 2014-09-07 2017-01-15
## results.updated.33 results.list_name.34 results.display_name.34
## 1 MONTHLY Crime and Punishment Crime and Punishment
## results.list_name_encoded.34 results.oldest_published_date.34
## 1 crime-and-punishment 2014-10-12
## results.newest_published_date.34 results.updated.34 results.list_name.35
## 1 2017-01-15 MONTHLY Culture
## results.display_name.35 results.list_name_encoded.35
## 1 Culture culture
## results.oldest_published_date.35 results.newest_published_date.35
## 1 2014-10-12 2017-01-15
## results.updated.35 results.list_name.36 results.display_name.36
## 1 MONTHLY Education Education
## results.list_name_encoded.36 results.oldest_published_date.36
## 1 education 2014-10-12
## results.newest_published_date.36 results.updated.36 results.list_name.37
## 1 2017-01-15 MONTHLY Espionage
## results.display_name.37 results.list_name_encoded.37
## 1 Espionage espionage
## results.oldest_published_date.37 results.newest_published_date.37
## 1 2014-12-14 2017-01-15
## results.updated.37 results.list_name.38
## 1 MONTHLY Expeditions Disasters and Adventures
## results.display_name.38 results.list_name_encoded.38
## 1 Expeditions expeditions-disasters-and-adventures
## results.oldest_published_date.38 results.newest_published_date.38
## 1 2014-12-14 2017-01-15
## results.updated.38 results.list_name.39 results.display_name.39
## 1 MONTHLY Fashion Manners and Customs Fashion, Manners and Customs
## results.list_name_encoded.39 results.oldest_published_date.39
## 1 fashion-manners-and-customs 2014-10-12
## results.newest_published_date.39 results.updated.39 results.list_name.40
## 1 2017-01-15 MONTHLY Food and Fitness
## results.display_name.40 results.list_name_encoded.40
## 1 Food and Diet food-and-fitness
## results.oldest_published_date.40 results.newest_published_date.40
## 1 2013-09-01 2017-01-15
## results.updated.40 results.list_name.41 results.display_name.41
## 1 MONTHLY Games and Activities Games and Activities
## results.list_name_encoded.41 results.oldest_published_date.41
## 1 games-and-activities 2014-10-12
## results.newest_published_date.41 results.updated.41 results.list_name.42
## 1 2017-01-15 MONTHLY Graphic Books and Manga
## results.display_name.42 results.list_name_encoded.42
## 1 Graphic Books and Manga graphic-books-and-manga
## results.oldest_published_date.42 results.newest_published_date.42
## 1 2019-10-13 2024-10-13
## results.updated.42 results.list_name.43 results.display_name.43
## 1 MONTHLY Hardcover Business Books Hardcover Business Books
## results.list_name_encoded.43 results.oldest_published_date.43
## 1 hardcover-business-books 2011-07-03
## results.newest_published_date.43 results.updated.43 results.list_name.44
## 1 2013-10-13 MONTHLY Health
## results.display_name.44 results.list_name_encoded.44
## 1 Health health
## results.oldest_published_date.44 results.newest_published_date.44
## 1 2014-10-12 2017-01-15
## results.updated.44 results.list_name.45 results.display_name.45
## 1 MONTHLY Humor Humor
## results.list_name_encoded.45 results.oldest_published_date.45
## 1 humor 2014-09-07
## results.newest_published_date.45 results.updated.45 results.list_name.46
## 1 2017-01-15 MONTHLY Indigenous Americans
## results.display_name.46 results.list_name_encoded.46
## 1 Indigenous Americans indigenous-americans
## results.oldest_published_date.46 results.newest_published_date.46
## 1 2014-12-14 2016-01-10
## results.updated.46 results.list_name.47 results.display_name.47
## 1 MONTHLY Relationships Love and Relationships
## results.list_name_encoded.47 results.oldest_published_date.47
## 1 relationships 2014-09-07
## results.newest_published_date.47 results.updated.47 results.list_name.48
## 1 2017-01-15 MONTHLY Mass Market Monthly
## results.display_name.48 results.list_name_encoded.48
## 1 Mass Market mass-market-monthly
## results.oldest_published_date.48 results.newest_published_date.48
## 1 2019-10-13 2024-10-13
## results.updated.48 results.list_name.49 results.display_name.49
## 1 MONTHLY Middle Grade Paperback Monthly Middle Grade Paperback
## results.list_name_encoded.49 results.oldest_published_date.49
## 1 middle-grade-paperback-monthly 2019-10-13
## results.newest_published_date.49 results.updated.49 results.list_name.50
## 1 2024-10-13 MONTHLY Paperback Business Books
## results.display_name.50 results.list_name_encoded.50
## 1 Paperback Business Books paperback-business-books
## results.oldest_published_date.50 results.newest_published_date.50
## 1 2011-07-03 2013-10-13
## results.updated.50 results.list_name.51 results.display_name.51
## 1 MONTHLY Family Parenthood and Family
## results.list_name_encoded.51 results.oldest_published_date.51
## 1 family 2014-09-07
## results.newest_published_date.51 results.updated.51 results.list_name.52
## 1 2017-01-15 MONTHLY Hardcover Political Books
## results.display_name.52 results.list_name_encoded.52
## 1 Politics and American History hardcover-political-books
## results.oldest_published_date.52 results.newest_published_date.52
## 1 2011-07-03 2017-01-15
## results.updated.52 results.list_name.53 results.display_name.53
## 1 MONTHLY Race and Civil Rights Race and Civil Rights
## results.list_name_encoded.53 results.oldest_published_date.53
## 1 race-and-civil-rights 2014-12-14
## results.newest_published_date.53 results.updated.53
## 1 2017-01-15 MONTHLY
## results.list_name.54 results.display_name.54
## 1 Religion Spirituality and Faith Religion, Spirituality and Faith
## results.list_name_encoded.54 results.oldest_published_date.54
## 1 religion-spirituality-and-faith 2014-09-07
## results.newest_published_date.54 results.updated.54 results.list_name.55
## 1 2017-01-15 MONTHLY Science
## results.display_name.55 results.list_name_encoded.55
## 1 Science science
## results.oldest_published_date.55 results.newest_published_date.55
## 1 2013-04-14 2019-09-15
## results.updated.55 results.list_name.56 results.display_name.56
## 1 MONTHLY Sports Sports and Fitness
## results.list_name_encoded.56 results.oldest_published_date.56
## 1 sports 2014-03-02
## results.newest_published_date.56 results.updated.56 results.list_name.57
## 1 2019-09-15 MONTHLY Travel
## results.display_name.57 results.list_name_encoded.57
## 1 Travel travel
## results.oldest_published_date.57 results.newest_published_date.57
## 1 2014-09-07 2017-01-15
## results.updated.57 results.list_name.58 results.display_name.58
## 1 MONTHLY Young Adult Paperback Monthly Young Adult Paperback
## results.list_name_encoded.58 results.oldest_published_date.58
## 1 young-adult-paperback-monthly 2019-10-13
## results.newest_published_date.58 results.updated.58
## 1 2024-10-13 MONTHLY