lnrs-data-document.qmd

---
title: "Local Nature Recovery Strategy"
author: "West of England Combined Authority"
format: html
---

```{r libraries, include = FALSE}

u <- "https://opendata.westofengland-ca.gov.uk/explore/dataset/area-measures-tbl/"

pacman::p_load(tidyverse, httr2, janitor, glue, gt, gtExtras)

```


```{r set_params, include = FALSE}

base_url <-  "https://opendata.westofengland-ca.gov.uk"
endpoint_start <- "catalog/dataset"
endpoint_end <- "records"
dataset <- "area-measures-tbl"
select <- "area_name,area_description,measure,biodiversity_priority,theme,stakeholder,core_supplementary,measure_type"


```

```{r run_api}

response <- httr2::request("https://opendata.westofengland-ca.gov.uk/api/explore/v2.1") |> 
  req_url_path("api", "explore", "v2.1") |> 
  req_url_path_append(endpoint_start) |> 
  req_url_path_append(dataset) |>
  req_url_path_append(endpoint_end) |>
  req_url_query("select" = select,
                "group_by" = select,
                "limit" = 99) |>
  # req_perform()
  req_dry_run()
  
```



```{r}
url_parse( 'https://opendata.westofengland-ca.gov.uk/api/explore/v2.1/catalog/datasets/area-measures-tbl/records?select=area_name%2C%20area_description%2C%20measure%2C%20biodiversity_priority%2C%20theme%2C%20stakeholder%2C%20core_supplementary%2C%20measure_type&group_by=area_name%2C%20area_description%2C%20measure%2C%20biodiversity_priority%2C%20theme%2C%20stakeholder%2C%20core_supplementary%2C%20measure_type&limit=0&offset=0&timezone=UTC&include_links=false&include_app_metas=false')

```