$schemaversion=2.1 for nested functions using the Odata API

(0) Share

Report

Posted on by Community member

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.

Categories:

Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

$schemaversion=2.1 for nested functions using the Odata API

Hi, this is inherently case-insensitive if you use 'eq' method.

For example,

?$filter=Name eq 'adatum corporation'

Hope this helps.

Thanks.

ZHU