Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

Fetching OData query filters on the page exposed as web service

Posted on by 55
Greetings,
 
we currently have a page which loads data into the temporary record every time page is opened (this is required since data dynamically changes all the time and we can't keep everything permanently in actual DB table).
 
Our client requested from us to open this page as API endpoint, which we did through  "Web Services" BC page. Issue is now that API response is slow since data is loaded into the temp. record every time API call is made. We can send the OData query filters, but they are only applied AFTER data is loaded into the temp. record.
 
Is there any way we can fetch those filters on page in code as soon as request arrives? We would like to get those filters and then set the filters on our own before loading of the data into the temp. table stars.
 
For example, let's say we have next URL with filters: 
  • https://api.businesscentral.dynamics.com/v2.0/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/Client-Environment/ODataV4/Company('SomeCompany')/OpenQuantitiesOverview?$filter=Location_Code eq '61-ZAGREB'
 
Can we fetch the value '61-ZAGREB' directly on the page?
 
Thank you.
  • YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Fetching OData query filters on the page exposed as web service
    In addition to the API, I think the performance may be greatly improved if you use Query.
    And obviously your logic when the page is opened is very complicated. So in your case, it is not recommended to use temporary tables, as this will generate data from scratch each time. You can save the data on a real table and then modify this table each time. But if your logic is too complicated, it may be the same, anyway, you can try it.
     
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    Fetching OData query filters on the page exposed as web service
    Create an API page, its much faster than a regular page exposed as a web service. 
     
  • gdrenteria Profile Picture
    gdrenteria 12,183 Most Valuable Professional on at
    Fetching OData query filters on the page exposed as web service

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans