I've created a Postman collection to represent a custom OData API that we have published for Business Central.
I uploaded this Postman collection to the Custom Connector builder and this correctly created my OpenAPI spec file. The request/response have been correctly defined and I can test my API via the test tool (screenshot attached).
I've tried with both basic and OAuth2.0 authentication and whilst both work in Postman and in the API test tool within the Custom Connector builder, these do not work in the PowerApp.
I've also tried with a simple public API that returns some basic JSON - this requires no authentication and this works correctly in the PowerApp.
Whenever I consume the Custom Connector via the app builder I get a 404 error (also attached).
I've tried this with parameters, without parameters, with different authentication methods etc etc, no matter what I do I can't get PowerApps to talk to a custom BC OData API.
I'm baffled as to why I get a 404 - though I notice that if I try to call my API after leaving one of the parameters blank in the test tool I also get a 404 in the response, so I have a gut feeling this may be related to request parameters.
Has anyone had this issue/seen this working? I can't use the out-of-the-box BC connector as it doesn't support custom APIs.
I'm having the exact same problem.
Before the latest updates in October (both Powerapps and Business Central), I could easily create custom connectors from a Odata Business Central webservice, and use them in PowerApps.
Now i get this 404 whatever i do. And strangely enough, when I test the connector, it gives me at 200 response, telling me everything is okay.
I don't have anything further to this issue. But I'm totally pissed that the Standard Business Central Connector cannot work with other tables, than those that Microsoft has chosen. Any information about this will be appreciated. Workarounds, when will it work like before, etc.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand