row_filters doesn't work in an odd scenario

[Moohan]

I'm trying to extract HB pops using this code:

all <- get_resource(
  res_id = "27a72cc8-d6d8-430c-8b4f-3109a9ceadb1",
  row_filters = list("Sex" = "All"),
  col_select = c("Year", "HB", "AllAges", "Sex")
)

However it just returns an empty tibble i.e. the request was successful, it just didn't return any data.

Weirdly the row_filters works fine for "Male" (or "Female")

male <- get_resource(
  res_id = "27a72cc8-d6d8-430c-8b4f-3109a9ceadb1",
  row_filters = list("Sex" = "Male"),
  col_select = c("Year", "HB", "AllAges", "Sex")
)

I can also return all the data and then filter in which case Sex == "All" works.

all_after <- get_resource(
  res_id = "27a72cc8-d6d8-430c-8b4f-3109a9ceadb1",
  col_select = c("Year", "HB", "AllAges", "Sex")
) |>
  dplyr::filter(Sex == "All")

I'm wondering if this is possibly an issue with CKAN / the data as phsopendata seems to be generating the correct API query in both cases.
All - https://www.opendata.nhs.scot/api/3/action/datastore_search?id=27a72cc8-d6d8-430c-8b4f-3109a9ceadb1&limit=99999&q={\"Sex\":\"All\"}&fields=Year,HB,AllAges,Sex
Male - https://www.opendata.nhs.scot/api/3/action/datastore_search?id=27a72cc8-d6d8-430c-8b4f-3109a9ceadb1&limit=99999&q={\"Sex\":\"Male\"}&fields=Year,HB,AllAges,Sex