Friday, July 9, 2021

Business Central - How to connect to an ODATA web service with filters

 https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-flowfilters-in-odata-uris

  • Business Central Administration>ODATA>Enable OData Services
  • Web Services>Enable Web Service for your object
  • Access ODATA Link with filters in link, example COA with Date filter range
    • http://desktop-tr74u66:7048/BC180/ODataV4/Company('CRONUS%20USA%2C%20Inc.')/Chart_of_Accounts?filter=date_filter%20gt%2001011900%20lt%20t
    • http://desktop-tr74u66:7048/BC180/ODataV4/Company('CRONUS%20USA%2C%20Inc.')/Chart_of_Accounts?filter=date_filter gt 01011900 lt 01012023

No comments:

Post a Comment