GET https://api.businesscentral.dynamics.com/v2.0/production/api/v2.0/$metadatacompanies({id})/dimensions({id})/dimensionValues
Unfortunately, this endpoint returns only a small subset of Departments values; comparing them with the list shared by the customer it appears that only 23 out of 168 are returned by Dynamics API.
After more digging, we found out that by querying the full list of dimension values, without specifying the dimension ID of the Department, we get the full list!
GET https://api.businesscentral.dynamics.com/v2.0/production/api/v2.0/$metadatacompanies({id})/dimensionValues
However, all the departments that are missing from the previous call have one thing in common, the dimension_id field appears as "00000000-0000-0000-0000-000000000000".
Missing from GET ../companies({id})/dimensions({id})/dimensionValues
{
"@odata.etag": "W/\"JzIwOzE1MzQwNjUxMTc5NTE3NTExMDE0MTswMDsn\"",
"id": "8d1ba80f-7ba5-ec11-80f1-000d3a870012",
"code": "01C",
"dimensionId": "00000000-0000-0000-0000-000000000000",
"displayName": "XXXXX",
"consolidationCode": "01C",
"lastModifiedDateTime": "2023-08-27T20:28:55.48Z"
}
Available from ../companies({id})/dimensions({id})/dimensionValues
{
"@odata.etag": "W/\"JzE5OzQ2NzAwNDA2MjgwNzA1OTI0MzgxOzAwOyc=\"",
"id": "e8b99a37-3cb1-ee11-a56a-002248436b28",
"code": "03D",
"dimensionId": "e1c652f0-7aa5-ec11-80f1-000d3a870012",
"displayName": "YYYYY",
"consolidationCode": "",
"lastModifiedDateTime": "2024-01-15T09:38:16.86Z"
}
Therefore, it appears that the issue resides on Dynamics, without the dimensionId field populated accordingly we’re not able to retrieve the full list of values for a specific dimension via GET ../companies({id})/dimensions({id})/dimensionValues API.
Also, we can't use the GET ../companies({id})/dimensions({id})/dimensionValues API as we would not be able to identify to which dimension a value belongs to in case the dimension_id field appears as "00000000-0000-0000-0000-000000000000".
Looking around, we found out that this issue might be related to a recent Dynamics upgrade where some data migrations were not completed successfully, please see here to find out more.
Thanks
