OECD
OECD copied to clipboard
get_dataset returns error message
Dear Eric,
this package could be incredibly helpful for me, thanks for publishing it.
Unfortunately, the code at the bottom of my post returns an error when I try to run it. I'm using R-4.1.3 in RStudio. get_datasets() works fine, but get_dataset() returns the following error message:
> df <- get_dataset("PATS_REGION", filter = "PCT_A.INVENTORS.BEL+BE10.TOTAL+BIOTECH", pre_formatted = TRUE)
Error in download.file(path, destfile, method, quiet, mode, ...) :
cannot open URL 'https://stats.oecd.org/restsdmx/sdmx.ashx/GetData/PATS_REGION/PCT_A.INVENTORS.BEL+BE10.TOTAL+BIOTECH/all'
In addition: Warning message:
In download.file(path, destfile, method, quiet, mode, ...) :
URL 'https://stats.oecd.org/restsdmx/sdmx.ashx/GetData/PATS_REGION/PCT_A.INVENTORS.BEL+BE10.TOTAL+BIOTECH/all': status was 'Couldn't connect to server'
Here's the script I tried to run:
library(OECD)
library(httr)
httr::set_config(httr::use_proxy("192.168.78.10", port = 8080, auth = "basic"))
datasets <- get_datasets()
df <- get_dataset("PATS_REGION", filter = "PCT_A.INVENTORS.BEL+BE10.TOTAL+BIOTECH", pre_formatted = TRUE)
Like I mentioned, get_dataset() returns the expected data frame. I suspect there may have been a change in the API?
I think this project is not mantained anymore because I have a similar problem but I don't know how to build a package. Check the other issues and take into account that this repo contains the 0.24 version, #25 .If you want you can use the following code to extract the data:
library(readsdmx)
library(tibble)
data <- read_sdmx(path = "https://stats.oecd.org/restsdmx/sdmx.ashx/GetData/PATS_REGION/PCT_A.INVENTORS.BEL+BE10.TOTAL+BIOTECH/all")
data |> as_tibble()
#> # A tibble: 148 × 9
#> KINDPATENT KINDREGION ObsValue POWERCODE REGIONS TECHNO TIME_FORMAT Time
#> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 PCT_A INVENTORS 1 0 BEL TOTAL P1Y 1977
#> 2 PCT_A INVENTORS 0 0 BEL TOTAL P1Y 1978
#> 3 PCT_A INVENTORS 1.5 0 BEL TOTAL P1Y 1979
#> 4 PCT_A INVENTORS 9.8667 0 BEL TOTAL P1Y 1980
#> 5 PCT_A INVENTORS 24.5 0 BEL TOTAL P1Y 1981
#> 6 PCT_A INVENTORS 27.8333 0 BEL TOTAL P1Y 1982
#> 7 PCT_A INVENTORS 23.8333 0 BEL TOTAL P1Y 1983
#> 8 PCT_A INVENTORS 29.5024 0 BEL TOTAL P1Y 1984
#> 9 PCT_A INVENTORS 41.25 0 BEL TOTAL P1Y 1985
#> 10 PCT_A INVENTORS 33.3 0 BEL TOTAL P1Y 1986
#> # ℹ 138 more rows
#> # ℹ 1 more variable: UNIT <chr>
Created on 2023-12-06 with reprex v2.0.2
Also OCDE stat is changing the API and there is a new website, https://data-explorer.oecd.org/.