Add status information to conservation lists

[daxkellie]

When working with conservation status lists like the EPBC list, one usually wants a list of species and each species' conservation status. However, this information isn't returned when using show_values() to see the contents of that list.

library(galah)
galah_config(verbose = FALSE)

search_all(lists, "dr656") |> # epbc list uid
  show_values() |>
  head(10L)
#> • Showing values for 'dr656'.
#> # A tibble: 10 × 6
#>         id name                  commonName scientificName lsid  dataResourceUid
#>      <int> <chr>                 <chr>      <chr>          <chr> <chr>          
#>  1 6525472 Abutilon julianae     Norfolk I… Abutilon juli… http… dr656          
#>  2 6526268 Acacia ammophila      <NA>       Acacia ammoph… http… dr656          
#>  3 6525401 Acacia anomala        Grass Wat… Acacia anomala http… dr656          
#>  4 6526330 Acacia aphylla        Leafless … Acacia aphylla http… dr656          
#>  5 6525993 Acacia aprica         Blunt Wat… Acacia aprica  http… dr656          
#>  6 6525879 Acacia araneosa       Spidery W… Acacia araneo… http… dr656          
#>  7 6525536 Acacia aristulata     Watheroo … Acacia aristu… http… dr656          
#>  8 6524965 Acacia ataxiphylla s… Largefrui… Acacia ataxip… http… dr656          
#>  9 6526045 Acacia attenuata      <NA>       Acacia attenu… http… dr656          
#> 10 6525843 Acacia auratiflora    Orangeflo… Acacia aurati… http… dr656

^{Created on 2025-04-07 with reprex v2.1.1}

It looks like this information is stored in a nested API endpoint, but this isn't in galah's API query call. It would be very nice to add this to galah output for at least the EPBC list.
https://api.ala.org.au/specieslist/ws/speciesListItems/dr655?includeKVP=true

[daxkellie]

Just noting that the above commit makes accessing additional information in lists possible using show_values(). At the moment this is only implemented for lists.

search_all(lists, "dr656") |>
  show_values(all_fields = TRUE)

But in a conversation between @mjwestgate and I, we agreed that a more complete solution is to add select.metadata_request() functionality to galah to support adding additional groups of columns (like you can with for data_request objects). This would look something like:

request_metadata() |>
  filter(lists == "dr656") |>
  select(group = "raw_fields") |>
  unnest() |>
  collect()

This piped workflow with select() is better aligned with galah architecture, and is more flexible for any future add-ons. We could still keep the show_values() argument solution as well