Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Having trouble connect...
Business Central forum
Answered

Having trouble connecting using Odata

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I am having trouble connecting to Dynamics 365 for Financials via odata. I took a look at the documentation and I'm pretty sure the url is correct. Could someone please advise on what I should look at next? We are using a custom application that is trying to connect. 

The username that we are inputting is the one found from searching Users -> selected_user -> User ID. 

The password is the web service access key that is generated on that same screen.

The URL is in the format of "mybusiness.financials.dynamics.com/.../Company('CRONUS%20US')". I even tried it with a space instead of the %20. 

This is off of the demo database that Dynamics provided. If someone can point me to the right documentation too, that would be helpful. I'm not sure why this would not be working. 

Categories:
Other
  • Chris Bulson Profile Picture
    Chris Bulson on at
    RE: Having trouble connecting using Odata

    It's highly unlikely that you're blocking that port unless you've specifically done so.  You should start a new thread with the details of your issue.  What you're trying to do specifically, what the error is and what you have done to try and mitigate the problem.  There are multiple problems listed in this thread and I'm not even sure which one you're referring to when you say you're having the "same problem".

    Thanks,

    Chris

  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Having trouble connecting using Odata

    Chris,

    Is there a way for me to check that? It's just me... No IT team to help. :)

    Thanks!

    Amanda

  • Verified answer
    Chris Bulson Profile Picture
    Chris Bulson on at
    RE: Having trouble connecting using Odata

    Hello,

    I worked with the original thread starter on a support case and we determined that their IT team had blocked port 7048.  This is what was causing the original problem that this thread was started for.

    Thanks,
    Chris

  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    RE: Having trouble connecting using Odata

    I'm very curious about the solution to this, as I ran into the same problem.

  • RTIBobV Profile Picture
    RTIBobV 125 on at
    RE: Having trouble connecting using Odata

    Using the Dynamics 365 for Financials Content Packs for Power BI has explicit instructions for connecting to Financials from PowerBI.  This instructions state "Delete any text after the company name in parenthesis." After following the listed steps PowerBI returns an "Unable to connect" error with the message "Details: 'The feed's metadata document appears to be invalid.'"

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Having trouble connecting using Odata

    I tried using Postman to send a query but I get the same message. I have submitted a support ticket and will update this thread when a solution is resolved for future references.

  • Chris Bulson Profile Picture
    Chris Bulson on at
    RE: Having trouble connecting using Odata

    You could check to see if you're able to query the Web Service using Excel or Power BI desktop.  In Excel you can just go to Data > Get Data > From other sources > From OData Feed.  Use Basic authentication with the credentials you've specified above and see if you can pull the data.  Same thing works in Power BI Desktop.

    Thanks,

    Chris

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Having trouble connecting using Odata

    My pleasure. I'm fresh out of ideas (at least for now).

    As a Dynamics 365 for Financials subscriber, you could open a formal support request from Microsoft by going to your Office 365 Admin portal, and clicking on Support in the menu on the left hand side, and following the steps to open a request.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Having trouble connecting using Odata

    First off, thank you AJ for the help!

    Unfortunately, this didn't work either.

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Having trouble connecting using Odata

    Hi again EChen,

    I went back and looked at your URL and the standard ODATAv4 URL in Dynamics 365, and notice that your is missing the tenant id.

    In my case, when I want to expose a Web Service called Items, here is my construct:

    ODATAv4.JPG

    Here, my tenant id is 'interdyn', my company name 'NAVTeamCo', and as noted above, the Web Service is named 'Items'.

    When I compare this the ODATAv4 URL you had pasted, you are missing the portion after the company name where it specifically references the Web Service name and re-lists the tenant information.

    The last portion is likely because Dynamics 365 for Financials is a multi-tenant environment,

    Please try again with this construct and let me know if that makes a difference.

    If it resolves the issue, please take a moment and verify my response by clicking Yes next to "Did this answer your question?"

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans