Provider CbsNl: Centraal Bureau voor de Statistiek. |
Centraal Bureau voor de Statistiek.
Code for use in settings.xml: CbsNl
Alias: cbsnl
Status: Production
Available in Editions: Paid, Open Data, Community
Technical Documentation: https://www.cbs.nl/nl-nl/onze-diensten/open-data/statline-als-open-data
Provider Attributes
The following provider attributes are available for CbsNl:
Code |
Description |
Default Value |
Set from Connection String |
Set from Set SQL-Statement |
Set from Providers File |
---|---|---|---|---|---|
api-url |
URL to access the API. |
|
✓ |
|
✓ |
download-error-internet-down-max-tries |
Maximum number of tries when the Internet connection seems down during retrieval of data. |
|
✓ |
✓ |
✓ |
download-error-internet-down-sleep-initial-ms |
Initial sleep in milliseconds between retries when the Internet connection seems down during retrieval of data. |
|
✓ |
✓ |
✓ |
download-error-internet-down-sleep-max-ms |
Maximum sleep in milliseconds between retries when the Internet connection seems down during retrieval of data. |
|
✓ |
✓ |
✓ |
download-error-internet-down-sleep-multiplicator |
Multiplication factor for sleep between retries when the Internet connection seems down during retrieval of data. |
|
✓ |
✓ |
✓ |
force-case-sensitive-identifiers |
Consider identifiers as case-sensitive independent of the platform capabilities. |
False |
✓ |
✓ |
✓ |
forced-casing-identifiers |
Forced casing of identifiers. Choose from Unset, Lower, Upper and Mixed. |
|
✓ |
✓ |
✓ |
http-disk-cache-compression-level |
Compression level for the HTTP disk cache, ranging from 1 (little) to 9 (intense). Default is 5. |
5 |
✓ |
✓ |
✓ |
http-disk-cache-directory |
Directory where HTTP cache is stored. |
C:\Users\gle3\Invantive\Cache |
✓ |
✓ |
✓ |
http-disk-cache-max-age-sec |
Maximum acceptable age in seconds for use of data in the HTTP disk cache. |
2592000 |
✓ |
✓ |
✓ |
http-get-timeout-ms |
HTTP GET timeout (ms). |
300000 |
✓ |
✓ |
✓ |
http-memory-cache-compression-level |
Compression level for the HTTP memory cache, ranging from 1 (little) to 9 (intense). Default is 5. |
5 |
✓ |
✓ |
✓ |
http-memory-cache-max-age-sec |
Maximum acceptable age in seconds for use of data in the HTTP memory cache. |
14400 |
✓ |
✓ |
✓ |
http-post-timeout-ms |
HTTP POST timeout (ms). |
300000 |
✓ |
✓ |
✓ |
ignore-http-400-errors |
Ignore HTTP 400 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
ignore-http-403-errors |
Ignore HTTP 403 errors when exchanging results with the OData endpoint. |
False |
✓ |
✓ |
✓ |
invantive-sql-forward-filters-to-data-containers |
Whether to forward filters to data containers. |
True |
✓ |
✓ |
✓ |
invantive-sql-shuffle-fetch-results-data-containers |
Whether to shuffle results fetched from data containers. |
False |
✓ |
✓ |
✓ |
invantive-use-cache |
Whether to cache the results of a query. |
True |
✓ |
✓ |
✓ |
join-set-points-per-request |
Maximum number of values in a request when executing a join set. |
60 |
✓ |
✓ |
✓ |
maximum-length-identifiers |
Non-default maximum length in characters of identifier names. |
|
✓ |
✓ |
✓ |
pre-request-delay-ms |
Pre-request delay in milliseconds per request. |
0 |
✓ |
✓ |
✓ |
requests-parallel-max |
Maximum number of parallel data requests from individual partitions on the data container. |
32 |
✓ |
✓ |
✓ |
slot-based-rate-limit-length-ms |
Length in ms of a slot-based rate limit. |
60000 |
✓ |
|
✓ |
slot-based-rate-limit-slots |
Number of slots of a slot-based rate limit. Null means no slot-based rate limit |
|
✓ |
|
✓ |
standardize-identifiers |
Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers. |
True |
✓ |
✓ |
✓ |
standardize-identifiers-casing |
Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform. |
True |
✓ |
✓ |
✓ |
trace-native-calls |
Trace native calls to data container backend. |
False |
✓ |
✓ |
✓ |
use-http-disk-cache-read |
Whether to use HTTP responses from previous queries stored on disk to answer the current query. |
True |
✓ |
✓ |
✓ |
use-http-disk-cache-write |
Whether to memorize HTTP responses on disk. |
True |
✓ |
✓ |
✓ |
use-http-memory-cache-read |
Whether to use HTTP responses from previous queries stored in memory that can answer the current query. |
True |
✓ |
✓ |
✓ |
use-http-memory-cache-write |
Whether to memorize HTTP responses from previous queries for use by future queries. |
True |
✓ |
✓ |
✓ |
Generated 11-01-2019 21:08 on version 17.30.0-PROD+1821.