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!
Thank you very much!
That is what I was searching for.
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
You can follow below link, which will guide to put the filters in API
learn.microsoft.com/.../use-filter-expressions-in-odata-uris
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.
Hi,
you need to create a API page for that, for more information and lean you can follow the below link
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156