Business Central API - Create Custom API Page for Sales Invoice Lines

(0) Share

Report

Posted on by MikeScally

I need to create a custom API Page for Business Central on Dynamics 365. I need to get a the AL source for the API Method

api.businesscentral.dynamics.com/.../salesInvoiceLines

Does anyone know where I can find the AL source for the SalesInvoiceLines method above?

I have copied the AL source from my Docker Windows Container to a directory C:\bcSandbox\applications\APIV1\Source_Exclude_APIV1_.Source

I can only find the AL source for a ListPart for the SalesInvoiceLines (see below), I may be wrong but not sure how I can POST new records to BC using a ListPart.

page 20043 "APIV1 - Sales Invoice Lines"
{
    DelayedInsert = true;
    PageType = ListPart;
    SourceTable = "Sales Invoice Line Aggregate";
    SourceTableTemporary = true;
    ODataKeyFields = Id;
    Extensible = false;

Would appreciate any help you can provide please as this change needs to go live urgently.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Rehan Satti 636 on at

Like (2)

Report
Copy link

Link copied!

Hi MikeScally,

I am not sure weather it would help or not, But you can try make custom api page of the by extending or replicating the stander-ad sales invoice line page 47 "Sales Invoice Subform" .

Now the question how to get the source code of this page. hare are the steps.

1) Go to AL projects workspace and look for the .alpackages folder as follows.

2) Open it in file explorer. copy the highlighted base app package in some other directory. change the file type to zip. extract the files from the zip file. You will find the all source code of the base app in the src folder.

Was this reply helpful? Yes No
MikeScally 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Rehan,

Thanks for your suggestion, the subform you have suggested is also a ListPart like the one I have below.

I am looking to deploy a custom api page for integration with another application via the REST api

is it possible to insert records to Business Central using a ListPart?

page 20043 "APIV1 - Sales Invoice Lines"

{

DelayedInsert = true;

PageType = ListPart;

SourceTable = "Sales Invoice Line Aggregate";

SourceTableTemporary = true;

ODataKeyFields = Id;

Extensible = false;

layout

{

area(content)

{

repeater(Group)

{

field(id; Id)

{

.....

Was this reply helpful? Yes No
Suggested answer

Rehan Satti 636 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

API page type is a new page type in business central. from which you can add the data using REST api.

docs.microsoft.com/.../devenv-api-pagetype

this is how you can define it:

page 50001 ChangeLogs

{

PageType = API;

SourceTable = "Change Log";

APIPublisher = 'Dynamics-inspire';

APIGroup = 'LifaGroup';

APIVersion = 'v1.0';

EntityName = 'ChangeLogs';

EntitySetName = 'ChangeLogs';

DelayedInsert = true;

Caption = 'ChangeLogs';

Permissions = TableData 50504 = r;

layout

{

area(content)

{

repeater(General)

{

field(EnteryNo; "Entery No")

{

Caption = 'EnteryNo';

ApplicationArea = All;

}

field(EntityID; "Entity ID")

{

Caption = 'EntityID';

ApplicationArea = All;

}

field(EntityType; "Entity Type")

{

Caption = 'EntityType';

ApplicationArea = All;

}

}

}

}

}

Regarding your other question: I have used the standard job task page to insert the records using REST API

Was this reply helpful? Yes No
MikeScally 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Rehan,

Thanks for your help, yes I would like to make a Custom API Page as per your example above.

I have already deployed a custom API Page for the Sales Invoice (header) and this is working nicely.

The issue I have is I need the AL code for the standard API Page SalesInvoiceLines. The only AL source I can find is for a SalesInvloceLines ListPart which doesn't seem like what I need to POST invoice lines from the API.

I can't seem to find the AL source for the API Page for SalesInvoiceLines, I really need this urgently.

Do you know where I can get the source for the SalesInvoiceLines API method (see API Uri below?)

api.businesscentral.dynamics.com/.../salesInvoiceLines

Thanks for your support,

Mike

Was this reply helpful? Yes No
Verified answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

The objects you are looking for is page 5475 "Sales Invoice Entity" and page 5476 "Sales Invoice Line Entity"

You can find it in base app source file

Was this reply helpful? Yes No