Automatic upload json files via API using R

Question

I want take financial data using API. I do so.

#load jsons
library("rjson")
json_file <- "https://api.coindesk.com/v1/bpi/currentprice/USD.json"
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

#get json content as data.frame
x = data.frame(json_data$time$updated,json_data$time$updatedISO,json_data$time$updateduk,json_data$bpi$USD)
x

But the main problem is that information changes every minute, so i can't gather history. Are there ways to make R independently connect every minute(i.e. in real time mode) to this site and collect data every minute. So collected data must be saved in C:/Myfolder. Is it possible to do it?

niko · Accepted Answer · 2019-01-16 12:46:11Z

1

Something like this could do it

library("rjson")
json_file <- "https://api.coindesk.com/v1/bpi/currentprice/USD.json"

numOfTimes <- 2L # how many times to run in total
sleepTime <- 60L  # time to wait between iterations (in seconds)
iteration <- 0L
while (iteration < numOfTimes) {
  # gather data
  json_data <- fromJSON(paste(readLines(json_file), collapse=""))
  # get json content as data.frame
  x = data.frame(json_data$time$updated,json_data$time$updatedISO,json_data$time$updateduk,json_data$bpi$USD)
  # create file to save in 'C:/Myfolder' 
  # alternatively, create just one .csv file and update it in each iteration
  nameToSave <- nameToSave <- paste('C:/Myfolder/', 
                                     gsub('\\D','',format(Sys.time(),'%F%T')), 
                                    'json_data.csv', sep = '_')
  # save the file
  write.csv(x, nameToSave)
  # update counter and wait 
  iteration <- iteration + 1L
  Sys.sleep(sleepTime)
}

Note that this requires to have an R session opened (you could create a .exe or .bat file and have it run in the background).

edited Jan 16, 2019 at 12:46

answered Jan 16, 2019 at 12:39

niko

5,2911 gold badge14 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

psysky Over a year ago

great. In my server rsession is always open. Do I have to create run file? If yes, is there a topic on the SO?

Collectives™ on Stack Overflow

Automatic upload json files via API using R

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related