Statistics Latvia - RUI020m - bad request

[mapdek]

Dear All,

I am trying to extract data from this table from Statistics Latvia using PXweb, but receive an error Bad request (HTTP 400), please see the image below:

Is there something wrong on the side of the syntax?

library(pxweb)

pxweb_query_list <-
  list("NACE_MIG" = c("B_C_D"),
       "ContentsCode" = c("RUI020m"),
       "TIME" = c("*"))
 
px_data <-
  pxweb_get(url = "https://data.stat.gov.lv/api/v1/en/OSP_PUB/NOZ/RU/RUI/RUI020m",
            query = pxweb_query_list)  

[pitkant]

@mapdek It seems that currently the query should look more like this:

pxweb_query_list <-
  list("NACE_MIG" = c("B_C_D_X_D353"),
       "ContentsCode" = c("RUI020m"),
       "TIME" = c("*"))

but I got the same error as you.

In the web page there is the following section:

"Api-V2:
Send a GET request to the URL below to access this table."

with the URL

https://api.stat.gov.lv/api/v2/tables/RUI020m/data?lang=en&valueCodes[NACE_MIG]=B_C_D_X_D353&valueCodes[ContentsCode]=RUI020m&valueCodes[TIME]=2025M08&codelist[NACE_MIG]=vs_VS_NACE2_BCD

which downloads the correct .px dataset.

The JSON query from the webpage looks like this:

{
  "query": [
    {
      "code": "NACE_MIG",
      "selection": {
        "filter": "vs:VS_NACE2_BCD",
        "values": [
          "B_C_D_X_D353"
        ]
      }
    },
    {
      "code": "ContentsCode",
      "selection": {
        "filter": "item",
        "values": [
          "RUI020m"
        ]
      }
    },
    {
      "code": "TIME",
      "selection": {
        "filter": "item",
        "values": [
          "2025M08"
        ]
      }
    }
  ],
  "response": {
    "format": "json-stat2"
  }
}

and immediately I am wondering about why "code": "NACE_MIG" has a "filter": "vs:VS_NACE2_BCD" instead of the regularly seen "filter": "item". Maybe this is the cause? When I use the json_query as input to pxweb_query and download the data

json_query_path <- "path/to/query.json"
pxq2 <- pxweb_query(json_query_path)
px_data <- pxweb_get(url = "https://data.stat.gov.lv/api/v1/en/OSP_PUB/START/NOZ/RU/RUI/RUI020m", query = pxq2)

However, for some reason pxweb_advanced_get() and pxweb_c() don't assign the class pxweb_data to this json class object making the call to method as.data.frame.pxweb_data fail. @MansMeg any idea why this would be in this case, compared to other json examples?