SCIM users endpoint returns empty list for SCIM-synced users even when they exist

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 3.42.0
  • App Version: 3.42.0

Describe the bug

The SCIM users endpoint returns an empty list even when SCIM users have been created successfully and can be retrieved individually by ID.

Observed behavior:

• GET /api/global/scim/v2/users returns: {"schemas":["urn:ietf:params:scim:api:messages:2.0:ListResponse"],"totalResults":0,"Resources":[],"startIndex":1,"itemsPerPage":20}
• GET /api/global/scim/v2/users?filter=userName eq "..." returns zero results
• GET /api/global/scim/v2/users?filter=externalId eq "..." returns zero results
• GET /api/global/scim/v2/users?filter=emails.value eq "..." returns zero results
• GET /api/global/scim/v2/users/{id} does return the SCIM user object correctly

Specific to the SCIM users endpoints.

To Reproduce

Steps to reproduce the behavior:

1. Sync users via SCIM 2.GET /api/global/scim/v2/users 3.GET /api/global/scim/v2/users?filter=userName eq "[email protected]" 4.GET /api/global/scim/v2/users?filter=externalId eq "some-external-id" 5.GET /api/global/scim/v2/users?filter=emails.value eq "[email protected]"
2. Observe that all requests return totalResults: 0 and an empty Resources array

Expected behavior The SCIM users endpoint should return SCIM-synced users, and filters such as userName, externalId, and emails.value should match the created user.

cnv_1cr9lxg6