Small and medium business | Business Central, N...

Dimension API missing values

(1) Share

Report

Posted on by itoledo

Hi, we are building an integration for sales and purchase orders via API 2.0. Customer has configured dimensions for cost center, department, and others.

We can obtain the dimensions with no problem using API: https:/api.businesscentral.dynamics.com/v2.0/sandbox/api/v2.0/dimensions?company=XXX

We can also get all the values for every dimension calling the Dimension Values API: https:/api.businesscentral.dynamics.com/v2.0/sandbox/api/v2.0/dimensionValues?company=XXX

However, most of the returned dimension values have an empty GUID as dimensionId, like this:

    {      /@odata.etag/: /W////JzIwOzEzNTIwMzczMTc4NTMxMDcyMzc2MTswMDsn////,      /id/: /454805ba-9a58-ee11-8df1-00224835c63a/,      /code/: /1/,      /dimensionId/: /00000000-0000-0000-0000-000000000000/,      /displayName/: /Camanchaca/,      /consolidationCode/: //,      /lastModifiedDateTime/: /2023-09-21T16:20:12.467Z/    },

So if we try to get all the cost centers, we get almost no/missing results: https:/api.businesscentral.dynamics.com/v2.0/sandbox/api/v2.0/dimensions(8d0b0213-78a6-ee11-a56b-000d3ac148df)/dimensionValues?company=XXX

Customer swears they can see the dimensions fine in BC. We can use them when creating sales orders and purchase orders, it's just that we can't obtain all dimension values from the API if we try to filter dimensions.

Any hints? Thanks in advance.

Ivan

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I tested it and didn't encounter your problem. It is recommended that you export all records in Dimension Value (349) in the configuration package and check again.

Test Endpoint: https://api.businesscentral.dynamics.com/v2.0/c8558e71-6ad8-4fcd-9f29-3ca165b41bbe/Sandbox223/api/v2.0/companies(554f4f15-9c8e-ee11-be3e-6045bde96b9a)/dimensions(14be2193-90ab-ee11-a56a-6045bd686202)/dimensionValues

Thanks

ZHU

Was this reply helpful? Yes No
itoledo 6 on at

Like (0)

Report

Hi Zhu:

Thanks for your help. I tried many combinations but it seems that there's a problem with the data. Unfortunately, the customer already has rolled out to production so they won't change/reimport anything right now until "the dust settles".

I've a couple of questions though. There seems to be another API (the "Finance Reports API") that supposedly shows the correct information: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/api-overview

Customer is using PowerBI to connect to those reports and they sent me the correct dimension values. Unfortunately I haven't been able to find any documentation/examples on how to query that API, do you know any?

Best regards

Ivan

Was this reply helpful? Yes No
DM-22051448-0 4 on at

Like (1)

Report

Hello,

I'm encountering the same problem within our setup. Could someone propose a solution for this?

Was this reply helpful? Yes No
Suggested answer

dylan_ramp 9 on at

Like (0)

Report

We recently ran into the same issue while building an integration, and I thought I would share some insight since it was also frustrating for us. It turns out that the dimensionId field of dimension values was added relatively recently. This field was populated for all existing dimension values via an "API Data Migration". Apparently, some users skip these data migrations to minimize downtime during upgrades, so it's essentially expected behavior that this field may be null. Our solution was to replicate the dimensionValues API page in our extension and add the dimensionCode field. You can then filter on dimensionCode and this field will always be populated.

Was this reply helpful? Yes No
Suggested answer

NK-11091512-0 on at

Like (0)

Report

You are most likely missing upgrade. To mitigate the issue go to the API Data Upgrade page.

Select first the Default Dimensions, then Dimension Values and invoke Reset. Invoke the Schedule upgrades. This should fix the data. The status on the API Data Upgrade page should change to completed for both entries.

You can repeat the steps for all entities, it may take time.

The steps need to be done per company that is affected.

Was this reply helpful? Yes No