web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Tables are missing whi...
Small and medium business | Business Central, N...
Answered

Tables are missing while using Logic app connect to Dynamics 365 Business Central

(0) ShareShare
ReportReport
Posted on by amygss 25

Hi,
We're trying logic app to connect to our dynamic business central environment to retrieve data.
The connection can be established , however the tables returned seems uncompleted for unknown reason.
Like the screenshot below, we want to retrieve Contact table but it's not in the dropdown list.
If I hardcode the table name contacts, it'll return Entity set not found: contacts

You can see there are still some returned tables are missing (ex : applyVendorEntries).
Not sure why this happens, already check the connected BC user account is SUPER in BC's permission set.
And also post this issue in logic app forum, they advise me to consult BC expert here.

Also attach our BC contacts in Web Service settings below.

86321_2D00_image.png

pastedimage1618225130462v1.png

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    Just wondering if you did you expose the missing ones like contacts in SaaS?

    Thanks.

  • amygss Profile Picture
    amygss 25 on at

    Hi Marco,

    Thank you for the response. 

    For "expose the missing ones like contacts in SaaS", I'm not sure if I understand your "expose table to cloud SaaS mean".
    Do you mean have we exposed this contacts to D365BC (cloud version) ?

    If so, we use cloud D365BC, and the setting of Web Service for Contacts is like below.

    The OData4 web service works fine (using Basic Authentication).

    pastedimage1618368479322v1.png

    Does that answer your question ? or do you need more information to diagnosis ?

    Thank you

  • amygss Profile Picture
    amygss 25 on at

    Hi Marco,

    I have some findings here and not sure if this is the root cause.

    This is the D365BC version comparison between my personal trial environment and my company's, whose Country/Region is JP.
    pastedimage1618398230675v1.png

    I get the hint from the following post which have similar environment like my company's. (JP region, BC17)
    It list the Standard API objects and has no Contacts as well.
    It says "...Up to now, BC17.1 2020/11/27, there are a total of 54 standard APIs in Business Central...."

    https://yzhums.com/6117/#toc3 

    So I'm not sure if the API supported objects are different between BC17 and BC18, and also have difference between instance (Country/Region) ?

    Do you have any ideas on this ?

     

  • Verified answer
    Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at

    Hello,

    I think I can explain this, actually. These 3 APIs are new in BC18:

    Contacts
    ApplyVendorEntries
    ContactsInformation

    And note that they are implemented by Application, so platform upgrade is not enough. If you are on SaaS then your environments will get updated soon, and then these APIs will become available. I hope this explains the situation?

  • amygss Profile Picture
    amygss 25 on at

    Thank you Lars Lohndorf-Larsen , it helps me a lot. We'll wait for SaaS BC to upgrade to BC18.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,638

#2
YUN ZHU Profile Picture

YUN ZHU 837 Super User 2025 Season 2

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 704 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans