query_url: PX-Web API query URL

In PxWebApiData: PX-Web Data by API

PX-Web API query URL

Description

PX-Web API query URL

Usage

query_url(
  url_or_tableid,
  ...,
  url_type = "ssb",
  use_index = FALSE,
  default_query = c(1, -2, -1)
)

Arguments

url_or_tableid	A table id, a PxWebApi v2 URL to data or metadata, or metadata returned by meta_data() or meta_frames().
...	Specification of query for each variable. See ‘Details’ in api_data().
url_type	Currently two possibilities: "ssb" (Norwegian) or "ssb_en" (English).
use_index	Logical. If TRUE, numeric values are matched against the index variable in the metadata, which usually starts at 0. If FALSE (default), numeric values are interpreted as row numbers in the metadata, using standard R indexing. Negative values can be used to specify reversed row numbers.
default_query	Specification for variables not included in .... The default is default_query = c(1, -2, -1), which selects the first and the two last codes listed in the metadata. Use default_query = TRUE and omit specifying individual variables to retrieve entire tables.

Details

The option PxWebApiData.MAX_URL_CHARS sets the threshold for issuing a warning when generated URLs are long. When unset, 2100 is used as a default, following the GET limit documented for PxWebApi v2.

URLs longer than this may fail (typically returning HTTP 404). The option does not affect the URL or the request itself.

The threshold can be changed by the user, for example: options(PxWebApiData.MAX_URL_CHARS = 3000).

Value

A PxWeb API URL to data, with query parameters added according to the input.

Examples

query_url(4861, 
          Region = FALSE, 
          ContentsCode = "Bosatte", 
          Tid = c(1, 5, -1), 
          url_type = "ssb_en")
          
          
query_url("https://data.ssb.no/api/pxwebapi/v2/tables/08991/data?lang=en",
          Fangst2 = FALSE,
          Elver = FALSE,
          ContentsCode = TRUE,  # same as "*"   
          Tid = "top(5)")       # same as 5i
          
          
          
query_url("https://data.ssb.no/api/pxwebapi/v2/tables/07459/data?lang=en",
          Region = FALSE,
          Kjonn = TRUE,
          Alder = list(codelist = "agg_TodeltGrupperingB", 
                       valueCodes = c("H17", "H18"),
                       outputValues = "aggregated"),
         ContentsCode = 1,
         Tid = 4i)

PxWebApiData documentation built on Sept. 9, 2026, 5:07 p.m.