Created a new feature, but API is “different”

8 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?

3. It does. The Periodics field is a lookup field. The type is Lookup and the size is 20

4. Is the API exposed with the “Force lowercase” setting enabled? Otherwise field names are case sensitive.

5. Where do I mark the setting to Force Lowercase? I think I have looked everywhere and cannot find that setting.

6. It’s on the API card, right column. Make sure you’re running a recent version of SOD.

7. I am on the latest version.

   From the SOD menu, I click on Create New Features to give me a list of the features.
   From there I see the features and click on the feature that I want to fix

   But I cannot find an API card for the feature.

   I cannot find where you are referring to. Sorry about that.

8. Ooohh… You’re talking about APIs from Features… they do not have the lowercase option..

   You might need to change your field names to lowercase on the Feature.