Skip to main content

Notifications

Business Central forum
Suggested answer

Is Business central table id 5872 and 5870 available?

Posted on by 30
Hello,
 
May I know if table 5872 and 5870 is available?
 
I created page 5872 and 5870 page under Business central web services. When using Power BI to get the data by connecting to Business central, it showed error as below:
 
 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 61,112 Super User on at
    Is Business central table id 5872 and 5870 available?
    Hi, if SourceTableTemporary = true;, if you open this page directly through Web Service, there will be no data. There are many similar pages in BC. If you want data, you need to customize the logic of the data it retrieves.
     
    Hope this helps as well.
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 3,219 Super User on at
    Is Business central table id 5872 and 5870 available?
    Hi
    The name of the field you indicate or the URL. are they correct?
    BR
    GR
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 4,442 User Group Leader on at
    Is Business central table id 5872 and 5870 available?
    Hi @shine666,
     
    I guess that table is buffer (temporary).
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Agazziz Profile Picture
    Agazziz 193 on at
    Is Business central table id 5872 and 5870 available?
    Unfortunately, no - you won't be able to query that data.  Notice how under the Table name in Page Inspection, it says "The source table of this page is temporary."  This means that Business Central is creating a temporary table that isn't stored anywhere, so the data can't be queried.
      
     
    Another example of this is the Effective Permissions Page:
     

Helpful resources

Quick Links

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,418 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,631 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Featured topics

Product updates

Dynamics 365 release plans