Views and Excel

A view is a product list configured in fmcgProducts (columns, filters, sort). The API exposes those views by name.

Access is view-restricted: the instance can allow public reads, or require an API key or a logged-in user.

JSON

GET /api/view/{viewname}

GET /api/view/{viewname}/{exportProfileId}

curl -sS -H "X-Api-Key: YOUR_KEY" \
  "https://{instance}.fmcgproducts.dk/api/view/all?limit=100&offset=0"

Query parameters:

Parameter	Meaning
limit	Number of products
offset	Start position
modifiedsince	Only products changed in this many minutes
fieldnames	fmcg (default), gs1, epd or datatables
gridsToArray	Grid values as arrays
allergensToBold	Allergen formatting
displayValues	Keyword display text

With an export profile in the path, field names follow that profile. xml is not a valid profile id here because /view/{viewname}/xml is a separate route.

Active version

GET /api/view/activeversion/{viewname}

Same idea as activeVersion on details: values from the date in grid X9200 where X9202 is yes. Supports limit, offset and modifiedsince.

XML

GET /api/view/{viewname}/xml

JSON view payload converted to XML. Supports limit, offset, modifiedsince and fieldnames.

Excel

GET /api/view/excel/{viewname}/{exportProfileId}

Returns an Excel file for that view and export profile. This route is public. The Content-Disposition filename comes from the profile.