search

hougaard / Simple-Object-Designer

Issue tracking for the Simple Object Designer for Business Central
7 stars 0 forks source link

API - _x0020_ instead of space #358

Open HVF1234 opened 1 month ago

HVF1234 commented 1 month ago

After updating to Business Central 24.0 I have the following issue with the data when I import in Power BI or Excel (I use Simple Object Designer 11.0.0.450 to export data from Business Central) The value of several fields are changed, so instead of 'SPACE' the code "x0020" is added fx. Firm_x0020_Planned = Firm Planned In_x0020_Progress = In Progress Machine_x0020_Center = Machine Center Work_x0020_Center = Work Center

_x0020_

hougaard commented 1 month ago

This is a planned Microsoft change: https://youtu.be/600q1uTMIuk

hougaard commented 1 month ago

I am working on some "counter measures" :)

HVF1234 commented 1 month ago

Thanks for the answer.

If it is a web source, it works if I add "?$schemaversion=1.0" to the URL. But do you have a suggestion to how I integrate it in "Dynamics365BusinessCentral.ApiContentsWithOptions()" ?