Hi,
I am working on BC V24.5 and just playing around with Simple Object Designer.
I tried to expose data as web service API. In between I changed some general settings as Object Prefix, and Extension Name.
When I tried to inspect the Dataverse Table, I recognized that to tables with the same name and different API-Routes are listed.
When I tried to make the first service_item (hougaard/BF/v2.0) visible, I get the error:
Failed to create entity with logical name dyn365bc_service_item_hougaard_bf_v2_0 and object type code -1. Exception: Microsoft.Crm.CrmException: An entity with the specified name service_Item already exists for data source
When I tried to delete the other one there is no error message, but the table ist still there.
I already tried to uninstall the extension, to deactivate Dataverse Synchronisation in BC, but nothing helps.
How can i get rid of the table with the obviously wrong API-Route: item/hougaard/bf//v2.0
Thanks for any help.
Best, Frank
Please check the following:
- That you only have service_item exposed on a single API
- Extension Management, it could almost sound like you have two separate apps exposing the API
This sounds like a Dataverse issue, if you go into Power BI or something else that looks directly at the exposed API, I bet you’ll only see the ones that are live.
That´s right – so you think, I can ignore it?
Thank for your fast anwser. I appreciate that very much.
I checked it – the Service Item List is exposed on only one API and there is only one app exposing APIs.
I did another test:
– I create more APIs for the tables “Service Line” and “Service Items Log”.
– They are working as expected.
– Then I delete these APIs in Simple Object Designer and publish again.
– Now, I got to PowerApps – Tables and open the table “Available Business Central-Tables”. There are still 2 tables with strange API-Routes: service_line: line/hougaard/bf/v2.0 and service_item_log: item/log/hougaard/bf/v2.0.
– Then I try to delete these tables and get the error that there exists dependencies:
1.
Name: Business Central Configuration
Object Type: Siteübersicht
Managed Solution: Dynamics 365 Business Central-ERP-Katalog
2.
Name: dyn365bc_BusinessCentralConfiguration
Object Type: Modellgesteuerte App
Managed Solution: Dynamics 365 Business Central-ERP-Katalog
3.
Name: Microsoft.Dynamics.BCVirtualEntityGeneration.Plugins.GenerateVirtualEntityPlugin: Update of dyn365bc_businesscentralentity
Microsoft.Dynamics.BCVirtualEntityGeneration.Plugins.GenerateVirtualEntityPlugin: Update of dyn365bc_businesscentralentity
Object Type: SDK-Nachrichtenverarbeitungsschritt
Managed Solution: Dynamics 365 Business Central-ERP-Katalog
Hope, these informations can help.
Best, Frank