We created a new feature with the API.
I used the API link that is in the create feature in PowerBI. However, it’s not working as an oData feed. I can use the “web source” to get the data in PowerBI.
When we try to get the data in PostMan using that API, we cannot access the API. It gives us an error.
If I try to add the tables that SOD created in to the regular Web Services page in Business Central, I get an error when I try to use that oData link.
Are we doing something wrong? Or is there another way to access the data through oData?
hougaard Answered question 13 hours ago
BTW: The “add it to the web services” trick should never be used.
hougaard Answered question 13 hours ago
Ok. In PowerBI, if I choose oData to access the API:
Details: “OData: The property ‘periodics’ does not exist on type ‘Microsoft.NAV.site_csp_vendor’. Make sure to only use property names that are defined by the type or mark the type as open type.”
I can use the web source just fine:
Json.Document(Web.Contents(“https://api.businesscentral.dynamics.com/v2.0/xxxxxxxxxxxx/Production/api/hougaard/SOD/v2.0/site_csp_vendors?company=xxxxxxxxx”))