Plaza 365
Plaza 365

No results found for your search

RegisterLog in

8

Dynamics 365 Business Central: Power Automate Find Records action demistified.

Visit article

#action

#automate

#records

Dynamics 365 Business Central

Category

Nov 17, 2024

Published date

Text

Article Type

AI Summary

  • The Find records action in Power Automate or Azure Logic Apps returns a collection of records matching applied filters, even if there's only one record.
  • Understanding the syntax of the OData query is crucial when using the Find records action.
  • Business Central APIs apply paging to OData responses to optimize performance and prevent overwhelming the server or client program.
  • Business Central online defaults to a maximum of 20,000 entities per page, while on-premises configurations can adjust page size.
  • The Find records (V3) action in Power Automate has a hard limit of returning 1000 records per page.
  • The Find records (V3) action provides an @odata.nextLink URL for retrieving the next page of records.
  • Using the HTTP action in Power Automate allows for retrieving larger amounts of records from Business Central in a more performant manner.
  • Acquiring a token via OAuth 2 and performing a GET operation to the API endpoint can help in efficiently retrieving all records from Dynamics 365 Business Central.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.