You’re offline. This is a read only version of the page.
2
Hello everyone,
I'm using the following web address to request information from our Business Central instance, specifically to find a customer by name:
https:/api.businesscentral.dynamics.com/v2.0/{_businessCentralOptions.TenantId}/{_businessCentralOptions.Environment}/ODataV4/Company('{_businessCentralOptions.CompanyName}')/Customer
Currently, I use ?$filter=contains(Name, '{customerName}') to look up a customer based on a part of their name. However, I also want the search to be case-insensitive. According to this documentation: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris, I should be able to achieve this by nesting tolower() and contains() like this: ?$filter=contains(tolower(Name), '{customerName}'), using schema version 2.1. But I'm having trouble figuring out how to use version 2.1, as changing it in the URL or in Business Central under Web Services doesn't seem to work.
Share
Report
All responses (
Answers (
