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)

fherrscher 15 on at

Like (0)

Report

RE: Create own API with filtered data

Thank you very much!

That is what I was searching for.
Verified answer

liki 50 on at

Like (0)

Report

RE: Create own API with filtered data

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
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Create own API with filtered data

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

learn.microsoft.com/.../use-filter-expressions-in-odata-uris
fherrscher 15 on at

Like (0)

Report

RE: Create own API with filtered data

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,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Create own API with filtered data

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