Getting SSL Connect error from R Studio

[skhatri]

I am getting SSL Connect error while runnin ghte below code from RStusio 2024 version:

url_btc <- "https://www.coingecko.com/price_charts/export/1/usd.csv"

btc=read.csv(file=url_btc)

test.csv <- read.csv("https://stats.idre.ucla.edu/stat/data/test.csv", header = TRUE)

################Ultimate Test

crypto_list() %>% filter(id=="1")

---

I can go to the Browser and have no issues but from RStudio, i get error

Any advice on how to update ssl certificates on R ?

[skhatri]

Here is the full error i get:

l_btc <- "http://www.coingecko.com/price_charts/export/1/btc-usd-max.csv"
btc=read.csv(file=url_btc)
Error in file(file, "rt") :
cannot open the connection to 'http://www.coingecko.com/price_charts/export/1/btc-usd-max.csv'
In addition: Warning message:
In file(file, "rt") :
URL 'https://www.coingecko.com/price_charts/export/1/btc-usd-max.csv': status was 'SSL connect error'

[craig.parylo]

Hi @skhatri, thank you for your question. Welcome.

I'm able to read data from the URL you listed in your first post:

url_btc <- "https://www.coingecko.com/price_charts/export/1/usd.csv"
btc <- read.csv(file = url_btc)
str(btc)
#> 'data.frame':    4174 obs. of  4 variables:
#>  $ snapped_at  : chr  "2013-04-28 00:00:00 UTC" "2013-04-29 00:00:00 UTC" "2013-04-30 00:00:00 UTC" "2013-05-01 00:00:00 UTC" ...
#>  $ price       : num  135 142 135 117 103 ...
#>  $ market_cap  : num  1.50e+09 1.58e+09 1.50e+09 1.30e+09 1.15e+09 ...
#>  $ total_volume: num  0 0 0 0 0 0 0 0 0 0 ...

^{Created on 2024-10-02 with reprex v2.1.0}

However, the URL listed in your error message begins withhttp and not https.
If you use https://www.coingecko.com/price_charts/export/1/usd.csv does the file load for you?

[skhatri]

Still same error and it works from personal laptop, but not from my work laptop. Not sure if there are issues with Firewall or SSL Certificate