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

Business Central API 2.0 GUID

(3) Share

Report

Posted on by rickykyc

I have created a API with sales shipment header table in business central. I cannot use the original virtual table provided because I have many customized fields. I saw that there are field called customer ID and Bill-customer customer ID field (GUID field) that can be used to in powerpages for contact access. However, after I published the extension to Business Central and refreshed the virtual table in Power Apps. I cannot find all the GUID fields. May I know any idea all lookup GUID fields of custom API cannot be found in virtual table? If it cannot be used, then how can I do the control with contact access without this key to link customer GUID with sales shipment, sales order, etc. Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (0)

Report

Moved the question from the General to the Business Central forum.

Was this reply helpful? Yes No
BR-24120642-0 80 on at

Like (0)

Report

Hi Ricky,

Can you relate the Custom GUID to Customer No., then use that to link to the Sales Shipment, Sales Order, etc.?

Benito

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Systemid

Deep insert with Business Central APIs (part 2) – Kauffmann @ Dynamics 365 Business Central

Developing a custom API - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (0)

Report

Did you add this field to the API page?

Virtual Tables are linked through APIs. You need to first confirm whether the API contains the required fields.

Business Central virtual tables FAQ - Business Central | Microsoft Learn

Microsoft Power Platform integration with Business Central via virtual tables - Business Central | Microsoft Learn

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
rickykyc 28 on at

Like (0)

Report

This all for your information. The situation is that I can different GUID field in the sales shipment header table like below "Customer Id" and "Bill-to customer id".

Then I fresh the table schema in the Business Central configuration App in the Powerapp

Afterwards, I go to check the table column of shipheaderAPI, again, all the fields I added in the API are there except all those GUID field, which i need to use to build the relationship with the contact access.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,956 Super User 2025 Season 2 on at

Like (1)

Report

Hope this help you: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/limits-tshoot-virtual-tables?tabs=sql

Was this reply helpful? Yes No