Small and medium business | Business Central, N...

Is Business central table id 5872 and 5870 available?

(1) Share

Report

Posted on by SC666

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:

Categories:

Business Central

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (0)

Report

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 12,167 Most Valuable Professional on at

Like (0)

Report

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 9,536 Super User 2024 Season 2 on at

Like (0)

Report

Is Business central table id 5872 and 5870 available?

Hi @shine666,

I guess that table is buffer (temporary).

Best regards,

Mohamed Amine MAHMOUDI
Agazziz 195 on at

Like (0)

Report

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: