Create own API with filtered data

(0) Share

Report

Posted on by fherrscher

Hi everyone!

I'd like to create an own API for service quotations and service orders. They are written in the same table (Service Header, 5900), so I would like to create two APIs for this table and filter it for quotes and orders.

I'm not an expert in AL so I don't know how to do that. I've this code snippet where I think there must be set a filter.

field(documentType; Rec."Document Type")
                {
                    Caption = 'Document Type';
                }

Thanks for helping!

All responses (5)

Answers (1)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

you need to create a API page for that, for more information and lean you can follow the below link

learn.microsoft.com/.../devenv-api-pagetype
fherrscher 15 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for your response!

Sorry, I was a bit imprecise.

I know how to create a API page with AL, but I just don't know how to filter data in the API page.
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can follow below link, which will guide to put the filters in API

learn.microsoft.com/.../use-filter-expressions-in-odata-uris
Verified answer

liki 5 on at

Like (0)

Report
Copy link

Link copied!

Add in API page settings

-> SourceTableView = where("Document Type" = filter(Quote)) and for another -> "Document Type" = FILTER(Order));

learn.microsoft.com/.../devenv-sourcetableview-pages-property
fherrscher 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much!

That is what I was searching for.

Join the conversation

Community site session details

Create own API with filtered data

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the September Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Create own API with filtered data

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the September Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates