Recently a user complained that on the production platform of BC SaaS he used the "Edit in Excel" share option for the Items List, but the generated Excel file wouldn't properly connect and download the list, raising error
Error Loading Metadata
Details:
Please check server connection, verify the current user has proper access, and try again. Error message: 'Metadata was unable to be retrieved for entity Item_Card_Excel as it was not found.'
I tried in my dev sandbox ad got the same issue.
Copilot advised to change language to English and retry. I was already using "English (UK)" but changed to "English (US)", just in case. Also the regional setting was changed accordingly. Repeated my tests. Same error.
Checked the Web Services, located the "Item_Card_Excel" web service (page 30) and it was there. Deleted the web service, repeated the "Edit in Excel" from the Items List. The web service was automatically recreated and published, but the newly generated "Item Card (2).xlsx" also didn't connect, raising the same error.
Tried the "Item_Card_Excel" Web Service hyperlink in Postman. Got error 404.
tried the "Vendor_Card_Excel" Web Service hyperlink in Postman. Got a complete valid XML response.
On another hand, "Open in Excel" for Items List works perfectly. Also, "Edit in Excel" for the Vendors List works perfectly. This one also uses its published web service on BC.
Checked the metadata document that one can download on the Web Services page. Found:
<NavigationProperty Name="Vendor_Card_Excel" Type="Collection(NAV.Vendor_Card_Excel)" ContainsTarget="true"/>
But nothing there, about "Item_Card_Excel". It looks now pretty obvious why the thing doesn't work. When the "Item_Card_Excel" web service is created, it isn't providing any metadata, getting confused.
Any ideas, please?
