Item metadata (parsed) — entropia

Reads items.metadata – JSON-in-TEXT on every item – into tidy rows: one row per item (in the order returned by the base query) with item_id, the parsed __entropia_file_metadata fields original_name, original_path and imported_at (ISO-8601, as POSIXct in UTC), and one list-column per remaining top-level metadata key. Items without metadata get one row with NA in the parsed fields and NULL in the list-columns.

Usage

entropia_metadata(con, items = NULL, parse = TRUE)

Arguments

con: A connection returned by entropia_connect().
items: NULL for all items, a character vector of item ids to keep, or a lazy table of items (must have id and metadata columns). Default NULL.
parse: When TRUE (default) parse metadata into the tidy field columns; when FALSE return the raw metadata text column.

Value

A tibble::tibble() with one row per item.

Details

Unlike the lazy accessors this function materialises: parsing JSON to list-columns is an R-side step. parse = FALSE returns the raw metadata text alongside item_id instead.

Examples

con <- entropia_connect(system.file("extdata", "entropia-example.sqlite",
  package = "entropiaR"
))
entropia_metadata(con)
#> # A tibble: 3 × 5
#>   item_id             original_name original_path imported_at         page_count
#>   <chr>               <chr>         <chr>         <dttm>              <list>    
#> 1 22222222-2222-4222… manifiesto.p… /docs/manifi… 2026-01-15 12:05:00 <int [1]> 
#> 2 22222222-2222-4222… carta.mp3     /docs/carta.… 2026-01-15 12:06:00 <NULL>    
#> 3 22222222-2222-4222… NA            NA            NA                  <NULL>    
entropia_metadata(con, parse = FALSE) # raw metadata text
#> # A tibble: 3 × 2
#>   item_id                              metadata                                 
#>   <chr>                                <chr>                                    
#> 1 22222222-2222-4222-8222-222222222221 "{\"__entropia_file_metadata\":{\"origin…
#> 2 22222222-2222-4222-8222-222222222222 "{\"__entropia_file_metadata\":{\"origin…
#> 3 22222222-2222-4222-8222-222222222223  NA                                      
entropia_disconnect(con)