apostrophe
Affected
- introduced
0, fixed4.29.0(semver)
Fixed versions
4.29.0
Fix
- Fixed version
4.29.0npm install [email protected]
Advisory
Also known as: CVE-2026-39857
ApostropheCMS: Information Disclosure via choices/counts Query Parameters Bypassing publicApiProjection Field Restrictions
Summary
The choices and counts query parameters in the Apostrophe CMS REST API allow unauthenticated users to extract distinct field values for any schema field that has a registered query builder, completely bypassing publicApiProjection restrictions that are intended to limit which fields are exposed publicly. Fields protected by viewPermission are similarly exposed.
Details
When a piece type configures publicApiProjection to enable public API access while restricting visible fields, the restriction is enforced via a MongoDB projection on the main query (piece-type/index.js:1130-1134). However, the choices and counts query builders bypass this protection through a separate code path.
The vulnerable flow:
getRestQuery at piece-type/index.js:1120 calls applyBuildersSafely(req.query) (line 1122), which processes query parameters including choices and counts since both have launder methods (doc-type/index.js:2627-2628 and 2675-2676).publicApiProjection is applied afterward (line 1130-1134) as a MongoDB projection on the main query.choices builder's after handler (doc-type/index.js:2636-2668) iterates over requested field names. The only validation is:_.has(query.builders, filter) at line 2651)launder method (line 2656) All schema field types (string, integer, float, select, boolean, date, slug, relationship) register query builders with launder methods via addQueryBuilder in addFieldTypes.js.
toChoices (line 2661) calls the field's choices function, which typically calls sortedDistinct → toDistinct. The toDistinct method (doc-type/index.js:2811) executes db.distinct(property, criteria) — a MongoDB operation that returns all distinct values for the given property matching the criteria. MongoDB's `distinct` operation does not respect projections; it operates directly on the specified field regardless of any projection set on the query.query.set('choicesResults', choices) (line 2666) and returned directly in the API response at piece-type/index.js:292-296 without any filtering against publicApiProjection or removeForbiddenFields.The same bypass applies to viewPermission-protected fields: removeForbiddenFields (doc-type/index.js:1585-1611) only processes document results from toArray(), not the separate choices/counts data.
The page REST API has the same issue at page/index.js:371-376.
PoC
# Prerequisites:
# - An Apostrophe 4.x instance with a piece type configured with publicApiProjection
# - Example: an 'article' piece type with:
# publicApiProjection: { title: 1, slug: 1, _url: 1 }
# and additional schema fields like 'status' (select), 'priority' (integer),
# or 'internalNotes' (string) NOT in the projection
# 1. Verify normal API access only returns projected fields
curl -s 'http://localhost:3000/api/v1/article' | python3 -m json.tool
# Response results contain only: title, slug, _url (as configured)
# 2. Extract distinct values of a non-projected field via choices
curl -s 'http://localhost:3000/api/v1/article?choices=status' | python3 -m json.tool
# Response includes:
# "choices": {"status": [{"value": "draft", "label": "draft"}, {"value": "published", "label": "published"}, ...]}
# 3. Extract distinct values with document counts via counts
curl -s 'http://localhost:3000/api/v1/article?counts=priority' | python3 -m json.tool
# Response includes:
# "counts": {"priority": [{"value": 1, "label": "1", "count": 15}, {"value": 2, "label": "2", "count": 8}, ...]}
# 4. Multiple fields can be extracted at once
curl -s 'http://localhost:3000/api/v1/article?choices=status,priority,internalNotes'
Impact
publicApiProjection configured, even when those fields are explicitly excluded from the projection.counts variant additionally reveals how many documents have each distinct value, providing statistical information about the dataset.viewPermission (intended for role-based field access) are also exposed via this path.Recommended Fix
In the choices builder's after handler (doc-type/index.js:2636-2668), add validation to skip fields not permitted by publicApiProjection and viewPermission:
// doc-type/index.js, in the choices builder's after handler (line 2644 area)
for (const filter of filters) {
if (!_.has(query.builders, filter)) {
continue;
}
if (!query.builders[filter].launder) {
continue;
}
// NEW: Enforce publicApiProjection restrictions on choices/counts
const publicApiProjection = query.get('project');
if (publicApiProjection && !publicApiProjection[filter]) {
continue;
}
// NEW: Enforce viewPermission field restrictions
const field = self.schema.find(f => f.name === filter);
if (field && field.viewPermission &&
!self.apos.permission.can(query.req, field.viewPermission.action, field.viewPermission.type)) {
continue;
}
const _query = baseQuery.clone();
_query[filter](null);
choices[filter] = await _query.toChoices(filter, { counts: query.get('counts') });
}
Additionally, apply the same fix in the page REST API handler (page/index.js) for consistency.
Medium Basis: The source's own band: MODERATE
0, fixed 4.29.0 (semver)4.29.0
4.29.0npm install [email protected]Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.
Check your own computer: guard packages check
Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0