Hello
I am super confused about how to work an api query or page table. I understand how to get all of the data from my custom api page and query, but I am trying to have an input that will only get one row of the table. Right now, I am entering a No in the header (what material I want the information for). The code is below
What do I need to do to filter this so I only get a specific input that is specified in the header???
Hi, If you read Query data in AL, you can use the following method to filter.
Query.SetFilter(Any, Text [, Any,...]) Method: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/query/queryinstance-setfilter-method
Query.SetRange(Any [, Any] [, Any]) Method: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/query/queryinstance-setrange-method
For example,
If you're in an API, this requires the API's filter method.
For example,
api.businesscentral.dynamics.com/.../VendorLedgerEntries?$filter=Vendor_No eq '20000'
More details: https://yzhums.com/6117/#toc8 (please replace the single quotation marks)
Hope this helps.
Thanks.
ZHU
That is extremely helpful! Do you know where the inputs go when calling a query? Like if I want to filter based on a variable that is being passed in the header? (ex. a specific item that is subject to change between calls)
Hi, If you want to filter the query results directly, you can use the DataItemTableFilter Property.
For example:
Hope this helps.
Thanks.
ZHU
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
