You have to help us a bit, what is the error you’re getting?

2 Responses

  1. 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”))

  2. Sorry, the error is saying that your table doesn’t have a field called periodic … Do it?

Leave a Reply