The WFM adherence pull for the Snowflake warehouse is failing on the dimension definition. Endpoint is POST /api/v2/analytics/details/query. Payload looks standard enough.
{
"entityType": "schedule",
"interval": "PT15M",
"dimensions": ["wfm_adherence_type", "user_id"],
"metrics": ["adherence_percent"]
}
Response comes back 400 immediately.
{
"code": "invalid_request",
"message": "Dimension 'wfm_adherence_type' is not supported for entity type 'schedule'. Valid dimensions: [user_id, group_id]"
}
This is blocking the nightly load. Doing jack all while the queue backs up.
Docs say this dimension is valid for schedule details since the Q3 update. Time range is set to 2023-10-01T00:00:00.000Z/2023-10-02T00:00:00.000Z. Chicago time, so that covers the full shift block.
Stripping the dimension down to just user_id results in empty rows for metrics. Adherence data just vanishes.
Switching entityType to wfm_adherence fails. That endpoint doesn’t exist.
Checked the API version header. Set to v2.
Snowflake task is failing because the stage has no files from the last export run.
Retried with a smaller window. PT1H. Same error.
requests.post(url, headers=headers, json=body)
# Output: 400
The schema validator seems to think adherence types aren’t part of the schedule entity anymore.