Skip to main content
To homepage To homepage
Solved

Business Central Online Data Source Connection Error

  • August 13, 2024
  • 7 replies
  • 112 views
P
Participant
Forum|alt.badge.img

Hi All,

I am trying to connect a Business Central - Online Datasource and I completed all the Prerequisites as per the Training Documents, but when I am testing the connection on the Portal, it’s not giving me success and following is the error. Need your help

Error opening connection to BC Cloud: System.ApplicationException: User must authenticate connection. at Jet.NavMetadataPlugin.ApiHelper.GetAccessToken(String filePath) at Jet.NavMetadataPlugin.ApiHelper.GenerateRequest(String url, String method) at Jet.NavMetadataPlugin.ApiHelper.<>c__DisplayClass29_0.<ApiGetResponse>b__0() at Jet.NavMetadataPlugin.ApiHelper.HandleThrottling(Func`1 action) at Jet.NavMetadataPlugin.ApiHelper.ApiGetResponse(Boolean needCompany, String apiName, Boolean& timedOut, String basUrl) at Jet.NavMetadataPlugin.BCCloudMetadata.GetTableViaStandardAPI(Boolean needCompany, String api) at Jet.NavMetadataPlugin.BCCloudMetadata.Initialize() at Jet.NavMetadataPlugin.BCCloudMetadataPlugin.Open(Boolean enableLogging, String logFilePath)

Best answer by Christian Hauggaard

Hi @pkaustubha 

Have you ensured that the API URL is correct?

Did you specify a OAuth setting file path? Can you please make sure that the user running the ODX service has access to this file?

Have you ensured that all the prerequisites outlined below are in place? 

 

https://support.timextender.com/data%2Dsources%2D112/prerequisites%2Dto%2Dconnecting%2Dto%2Ddynamics%2Dbusiness%2Dcentral%2D365%2Donline%2Ddata%2Dsources%2D1431

The prerequisites include:

  • Granting D365 AUTOMATION or SUPER permission in BC under User permission sets
  • Setting up Jet Analytics extension in BC and configuring the extension to allow for HTTP client requests
  • Setting up an Azure app registration and adding BC application permissions to this app registration
  • Giving the Azure app registration “D365 AUTOMATION” User Permission Set in BC
View original
Did this topic help you find an answer to your question?

7 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • August 13, 2024

Hi @pkaustubha 

Have you done this as well?

With the message mentioning that you need to authenticate the connection, the part from the above guide seems like the first thing to try.

P
Participant
Forum|alt.badge.img
  • pkaustubha
  • Author
  • Participant
  • 17 replies
  • August 14, 2024

Hi Thomas, I tried all, but still unable to connect and test the connection successfully.

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • August 14, 2024

Was the OAuth authentication a success?

Do you have a file in the folder that is not empty?

P
Participant
Forum|alt.badge.img
  • pkaustubha
  • Author
  • Participant
  • 17 replies
  • August 14, 2024

OAuth Authentication is not successful. I have a file in folder with some data in it

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • August 15, 2024

Hi @pkaustubha 

I will add a short summary of what we changed to get this to work.

There was an issue with the API URL. This one https://api.businesscentral.dynamics.com/v2.0/{tenantID}, where the tenant id had incorrect characters added. 

Besides this we tried to use Service to Service authentication, but it gave an error about a lack of access. 

Then we changed it to OAuth again and redid the authentication of this. After doing this we got access to the source.

P
1 person likes this
  • P
    pkaustubha
Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @pkaustubha 

Have you ensured that the API URL is correct?

Did you specify a OAuth setting file path? Can you please make sure that the user running the ODX service has access to this file?

Have you ensured that all the prerequisites outlined below are in place? 

 

https://support.timextender.com/data%2Dsources%2D112/prerequisites%2Dto%2Dconnecting%2Dto%2Ddynamics%2Dbusiness%2Dcentral%2D365%2Donline%2Ddata%2Dsources%2D1431

The prerequisites include:

  • Granting D365 AUTOMATION or SUPER permission in BC under User permission sets
  • Setting up Jet Analytics extension in BC and configuring the extension to allow for HTTP client requests
  • Setting up an Azure app registration and adding BC application permissions to this app registration
  • Giving the Azure app registration “D365 AUTOMATION” User Permission Set in BC
Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @pkaustubha is the issue resolved? Please let us know if you have an update on the above questions

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings