Thanks for the question and using MS Q&A platform.
As I understand that you are trying to use Azure Data Factory to automate the process of posting data from a CSV file to the Purchase Header and Purchase Lines tables in your Dynamics 365 Business Central environment. You have configured an ADF pipeline with a REST sink that uses an API call to write data to Business Central. However, you are receiving a 403 Forbidden error, indicating a permissions issue.
Based on the error message - "Sorry, the current permissions prevented the action. (TableData 5109 Purchase Header Archive Read: Base Application)" This part of the message is crucial and explains that the user or application making the request (ADF in this case) doesn't have the necessary permissions to create a new record in the Purchase Header table.
- Check the permissions for your user account in Business Central. Ensure that you have the necessary permissions, and they are correctly set. For additional information please refer: Permissions on Database Objects.
Here are few additional troubleshooting steps that might help you in resolving your query:
Extension Installation: Although you mentioned installing the .app file, it's possible that the extension is not properly installed or configured, leading to permissions issues. Sometimes, re-publishing the extension can resolve permission issues.
Authentication: Ensure that the authentication method you are using in ADF is correctly configured. If you are using OAuth, make sure the token has the necessary scopes to access the Business Central API.
For more details please refer: Troubleshooting web service errors.
I hope this information helps! Please do let us know if you have any further questions.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.