Custom API table not accessible via Power Automate

(7) Share

Report

Posted on by AmitK-BHub

251

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 (4)

Answers (1)

Verified answer

Dhiren Nagar 2,898 Super User 2026 Season 1 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
Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Namaste @AK-17121107-0

Can you verify odatakeyfields Property

Please verfiy the sample article

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

Warm Regards

Pallavi Phade

www.linkedin.com/in/pallaviphade131116

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints as well.

Dynamics 365 Business Central Blog Series: REST API web services (APIs)

https://yzhums.com/63801/

Thanks.

ZHU

Was this reply helpful? Yes No
AmitK-BHub 251 on at

Like (0)

Report
Copy link

Link copied!

Thanks Everyone, I am glad everyone here had a correct answer. I also found an alternative approach to share with everyone via Event subscriber especially around sending out email when assembly order is released. It uses a hardcoded email.

I had a lot of issue with permission for API registration created so I used the below code.

codeunit 50129 "Asm Order Release Email"

{

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Release Assembly Document",

'OnAfterReleaseAssemblyDoc', '', false, false)]

local procedure OnAfterReleaseAssemblyDoc(var AssemblyHeader: Record "Assembly Header")

var

Email: Codeunit "Email";

EmailMessage: Codeunit "Email Message";

BodyText: Text;

SubjectText: Text;

begin

SubjectText := 'Assembly Order ' + AssemblyHeader."No." + ' Released';

BodyText :=

'Assembly Order Details:' + '\'

+ 'Order No.: ' + AssemblyHeader."No." + '\'

+ 'Item No.: ' + AssemblyHeader."Item No." + '\'

+ 'Quantity: ' + Format(AssemblyHeader.Quantity);

EmailMessage.Create(

'XXXXXXX Enter email',

SubjectText,

BodyText,

false

);

Email.Send(EmailMessage);

end;

}

Was this reply helpful? Yes No