web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Custom API table not a...

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

Suggested Answer

Custom API table not accessible via Power Automate

(1) Share

Report

Report

Posted on by AK-17121107-0

127

Hi Folks,

I have created a custom API using AZ AL wizard, and it created the API successfully for me. I have created and published my app and can see that in the Installed extentions, Thanks to the community here.

The problem now I am trying to solve is why the table is not being displayed. The API can be seen through the power Automate and can be selected, but the table section is blank.

Please see the power automate screen shot. I have also attached my AL code in notepad. Am i missing something very basic I am not sure.

Any guidance would be appreciated please.

page 50149 APIAssemblyOrders
{
    APIGroup = 'AssemblyOrders';
    APIPublisher = 'BusinessHub';
    APIVersion = 'v1.0';
    ApplicationArea = All;
    Caption = 'apiAssemblyOrders';
    DelayedInsert = true;
    EntityName = 'Assembly';
    EntitySetName = 'Assemblies';
    PageType = API;
    SourceTable = "Assembly Header";

namespace APIAsse...

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Dhiren Nagar 1,836 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please define ODataKeyfields ( https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-odatakeyfields-property) property for this API page? Also make sure that your EntityName and EntitySameName are unique.

Check detailed steps on how to create custom API here - https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api#to-create-api-pages-to-display-car-brand-and-car-model

You can check a similar post here - https://community.dynamics.com/forums/thread/details/?threadid=289bc806-5c52-f011-877b-6045bdeb8a5d

✅ Tick the box below to mark the answer as verified if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 2,069

#2

Dhiren Nagar 1,222

#3

YUN ZHU 1,033 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans