The goal of this assignment is to load an API from the NYT and to constuct an interface to read it into a data frame. I chose the books API. This particular call retrieves the best seller names. The defualt parameters were used for this call.
install.packages('httr')Installing httr [1.4.5] ...
OK [linked cache]library(httr)
install.packages("xml2")Installing xml2 [1.3.3] ...
OK [linked cache]library(xml2)
install.packages("jsonlite")Installing jsonlite [1.8.4] ...
OK [linked cache]library(jsonlite)
library(dplyr)
install.packages("dplyr")Installing dplyr [1.1.1] ...
OK [linked cache]install.packages("kableExtra")Installing kableExtra [1.3.4] ...
OK [linked cache]library(kableExtra)key <- "HQAkLpV2K1ddJm8g1Qzfuj9Nk8vIgSKg"
jsonFile <- 'https://api.nytimes.com/svc/books/v3/lists/names.json?api-key=HQAkLpV2K1ddJm8g1Qzfuj9Nk8vIgSKg'jsonR <- tbl_df(as.data.frame(fromJSON(jsonFile)))
jsonR %>% kable() %>%
kable_styling( font_size = 10, latex_options = 'basic') %>%
scroll_box(height = "500px", width = "100%")| status | copyright | num_results | results.list_name | results.display_name | results.list_name_encoded | results.oldest_published_date | results.newest_published_date | results.updated |
|---|---|---|---|---|---|---|---|---|
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Combined Print and E-Book Fiction | Combined Print & E-Book Fiction | combined-print-and-e-book-fiction | 2011-02-13 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Combined Print and E-Book Nonfiction | Combined Print & E-Book Nonfiction | combined-print-and-e-book-nonfiction | 2011-02-13 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Hardcover Fiction | Hardcover Fiction | hardcover-fiction | 2008-06-08 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Hardcover Nonfiction | Hardcover Nonfiction | hardcover-nonfiction | 2008-06-08 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Trade Fiction Paperback | Paperback Trade Fiction | trade-fiction-paperback | 2008-06-08 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Mass Market Paperback | Paperback Mass-Market Fiction | mass-market-paperback | 2008-06-08 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Paperback Nonfiction | Paperback Nonfiction | paperback-nonfiction | 2008-06-08 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | E-Book Fiction | E-Book Fiction | e-book-fiction | 2011-02-13 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | E-Book Nonfiction | E-Book Nonfiction | e-book-nonfiction | 2011-02-13 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Hardcover Advice | Hardcover Advice & Misc. | hardcover-advice | 2008-06-08 | 2013-04-21 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Paperback Advice | Paperback Advice & Misc. | paperback-advice | 2008-06-08 | 2013-04-21 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Advice How-To and Miscellaneous | Advice, How-To & Miscellaneous | advice-how-to-and-miscellaneous | 2013-04-28 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Hardcover Graphic Books | Hardcover Graphic Books | hardcover-graphic-books | 2009-03-15 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Paperback Graphic Books | Paperback Graphic Books | paperback-graphic-books | 2009-03-15 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Manga | Manga | manga | 2009-03-15 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Combined Print Fiction | Combined Hardcover & Paperback Fiction | combined-print-fiction | 2011-02-13 | 2013-05-12 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Combined Print Nonfiction | Combined Hardcover & Paperback Nonfiction | combined-print-nonfiction | 2011-02-13 | 2013-05-12 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Chapter Books | Children’s Chapter Books | chapter-books | 2008-06-08 | 2012-12-09 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Childrens Middle Grade | Children’s Middle Grade | childrens-middle-grade | 2012-12-16 | 2015-08-23 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Childrens Middle Grade E-Book | Children’s Middle Grade E-Book | childrens-middle-grade-e-book | 2015-08-30 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Childrens Middle Grade Hardcover | Children’s Middle Grade Hardcover | childrens-middle-grade-hardcover | 2015-08-30 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Childrens Middle Grade Paperback | Children’s Middle Grade Paperback | childrens-middle-grade-paperback | 2015-08-30 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Paperback Books | Children’s Paperback Books | paperback-books | 2008-06-08 | 2012-12-09 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Picture Books | Children’s Picture Books | picture-books | 2008-06-08 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Series Books | Children’s Series | series-books | 2008-06-08 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Young Adult | Young Adult | young-adult | 2012-12-16 | 2015-08-23 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Young Adult E-Book | Young Adult E-Book | young-adult-e-book | 2015-08-30 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Young Adult Hardcover | Young Adult Hardcover | young-adult-hardcover | 2015-08-30 | 2023-04-02 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Young Adult Paperback | Young Adult Paperback | young-adult-paperback | 2015-08-30 | 2017-01-29 | WEEKLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Animals | Animals | animals | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Audio Fiction | Audio Fiction | audio-fiction | 2018-03-11 | 2023-03-12 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Audio Nonfiction | Audio Nonfiction | audio-nonfiction | 2018-03-11 | 2023-03-12 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Business Books | Business | business-books | 2013-11-03 | 2023-03-12 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Celebrities | Celebrities | celebrities | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Crime and Punishment | Crime and Punishment | crime-and-punishment | 2014-10-12 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Culture | Culture | culture | 2014-10-12 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Education | Education | education | 2014-10-12 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Espionage | Espionage | espionage | 2014-12-14 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Expeditions Disasters and Adventures | Expeditions | expeditions-disasters-and-adventures | 2014-12-14 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Fashion Manners and Customs | Fashion, Manners and Customs | fashion-manners-and-customs | 2014-10-12 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Food and Fitness | Food and Diet | food-and-fitness | 2013-09-01 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Games and Activities | Games and Activities | games-and-activities | 2014-10-12 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Graphic Books and Manga | Graphic Books and Manga | graphic-books-and-manga | 2019-10-13 | 2023-03-12 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Hardcover Business Books | Hardcover Business Books | hardcover-business-books | 2011-07-03 | 2013-10-13 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Health | Health | health | 2014-10-12 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Humor | Humor | humor | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Indigenous Americans | Indigenous Americans | indigenous-americans | 2014-12-14 | 2016-01-10 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Relationships | Love and Relationships | relationships | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Mass Market Monthly | Mass Market | mass-market-monthly | 2019-10-13 | 2023-03-12 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Middle Grade Paperback Monthly | Middle Grade Paperback | middle-grade-paperback-monthly | 2019-10-13 | 2023-03-12 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Paperback Business Books | Paperback Business Books | paperback-business-books | 2011-07-03 | 2013-10-13 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Family | Parenthood and Family | family | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Hardcover Political Books | Politics and American History | hardcover-political-books | 2011-07-03 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Race and Civil Rights | Race and Civil Rights | race-and-civil-rights | 2014-12-14 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Religion Spirituality and Faith | Religion, Spirituality and Faith | religion-spirituality-and-faith | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Science | Science | science | 2013-04-14 | 2019-09-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Sports | Sports and Fitness | sports | 2014-03-02 | 2019-09-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Travel | Travel | travel | 2014-09-07 | 2017-01-15 | MONTHLY |
| OK | Copyright (c) 2023 The New York Times Company. All Rights Reserved. | 59 | Young Adult Paperback Monthly | Young Adult Paperback | young-adult-paperback-monthly | 2019-10-13 | 2023-03-12 | MONTHLY |
This assignment was not too tricky to figure out. NYT provides sufficient documentation on how to make calls with their APIs, although each API seems to have their own unique syntax. The also provide details on how to specify different parameters for each call, which is nice.