BMW RIS Source
RIS (Retail Information System) provides feature/option data including packages and phrases. RIS endpoints: options, packages, phrases, prices.
BmwFeatureEntity field mapping (RIS)
Composite primary key: feature_code + model_code
Note on RIS availability: RIS is credential-scoped rather than inherently limited
to a fixed market list. Credentials are currently provisioned for Serbia (sr-rs)
with source=datafox; other markets need credential validation.
Field × source matrix (RIS columns)
| Entity field | BQ column | RIS options path | RIS prices path | manual check | note |
|---|---|---|---|---|---|
| feature_code | code | options map key | options map key | ✓ | codes are 5-char alphanumeric (S05DM, P0C6R); format consistent across all sources |
| model_code | product_code | request param model_id | request param model_id | ✓ | supplied as request parameter |
| brand | — | request param brand | request param brand | ✓ | not in BQ raw_feature_metadata — must be set from request context |
| name | name | — | — | ✓ | from phrases — <code>.phrases.description, never null; localized, so English and Serbian both appear |
| description | long_description | — | — | ✓ | from phrases — <code>.phrases.longDescription; either equal to description or null, so it carries nothing extra in sr-rs |
| feature_type | type | — | — | ✓ | options entries carry type and optionType |
| family_code | family_code | — | — | ✓ | options entries carry familyCode |
| is_standard | is_standard | — | — | ✓ | options entries carry std |
| price_gross | list_price | — | — | ✓ | options[code].prices is a validFrom/validTo history, not a scalar |
| price_net | — | — | — | ✓ | not available from RIS |
| currency | — | — | — | ✓ | each price entry carries currency; the request pins EUR |
Notes
- RIS provides per-option pricing for Serbia.
S-prefix option codes are globally consistent between EU and US — codes from RIS (sr-rs) will match BQ option codes.
Response envelopes
Verified against _partition_date = 2026-09-09 (sr-rs):
| Endpoint | Envelope | Values |
|---|---|---|
options | {options: {<code>: {...}}} | option attributes (type, optionType, familyCode, std, salesGroupCodes) — no display text |
packages | {packages: {<code>: {...}}} | packageComponents[{default, alternatives, deselectable}], causesAdditions |
phrases | none — the body is the code map | {option, phrases: {description, mediumDescription, longDescription}}, localized via Accept-Language; mediumDescription is null throughout sr-rs |
prices | {modelCode, prices: [...], options: {<code>: {...}}} | model-level price series plus per-option prices[{validFrom, validTo, price, currency}] |
Code coverage
Distinct (feature_code, model_code) pairs on 2026-09-09, and each endpoint's code set against options:
| Endpoint | Responses | Pairs | vs options codes |
|---|---|---|---|
options | 152 | 41,819 | — |
packages | 152 | 1,613 | 69 of 926 (7.5%), adds none |
phrases | 159 | 45,122 | 926 of 926 (100%), adds 42 |
prices | 159 | 46,037 | 918 of 926 (99.1%), adds 79 |
packages codes are a strict subset of options. phrases covers every options pair and is the only endpoint carrying display text. (feature_code, model_code) is unique within each endpoint — a single day's responses contain no duplicate pairs.