Good Morning/Afternoon/Evening (or whenever this may find you),
I am relatively new to Business Central, and I am encountering a problem related to Execute Permissions on pulling certain API/Web Services/ODATA out of our Business Central environment. Our Business Central environment is a SaaS, and not on Prem. Basically we have Azure Data Factory, and are using that service to pull data out of Business Central and into our ODS Layer. A few generic questions that I have for the group, and I will try to be as descriptive as possible, but given the nature of the organization that I work for, I cannot be super granular when it comes to details and screenshots.
Question #1:
When I am trying to pull data out of Business Central using ADF, I am getting a Permission error on Page object that I do not have Execute Permission in order to pull that page/view/table. I have verified with my Business Central Admin that I am a SUPER, SUPER (DATA), and SECURITY on this particular company (and basically the whole platform). However, I am not certain of how to resolve this issue because I am not super well versed in BC, because I have never worked with this service before. After validating that the permissions were right, I checked Web Service URL's and they all appear to be correct based on the "Web Services" list that is inside of Business Central. We have tried giving me variations of permissions and rights, but to no prevail has it worked. So I was wondering if anyone had any experience with this? I saw on some forum posts online related to this, and basically the solution is seemingly to create your own Permission Set to overcome this, but I find this hard to believe because a few months ago I was able to look at this data using Postman. Any help here would be greatly appreciated.
Error:
{"code":"Internal_ServerError","message":"You do not have the following permissions on Page (insert page name here): Execute.\r\n\r\nTo view details about your permissions, see the Effective Permissions page...}
Question #2:
Is there anyway to access the underlying table schema for these objects? One of the components of this project that I am working on, requires us to be able to join these Page's together and marry them with data from another platform. However, from a minimal understanding of the platform, I do not see any type of keys or values that will allow us to join these together. So my assumption is that I would need to create an AL extension in order to create some Primary Keys in order to do these joins, but I wanted to verify before going down the road of doing that. I understand that you cannot access BC SaaS backend database objects from Azure, but I was hoping that there was some way that we would be able to pull some type of schema, or something similar, in order to help better integrate this process.
