Share
Report
2Hello Everyone,
I'm currently working on querying the OData v4 /Customer endpoint for Business Central in order to retrieve customers based on a user's search criteria for either name or customer number.
I can successfully make a call to:
https:/api.businesscentral.dynamics.com/v2.0/{_businessCentralOptions.TenantId}/{_businessCentralOptions.Environment}/ODataV4/Company('{_businessCentralOptions.CompanyName}')/Customer
This call retrieves all customers, and I can narrow down the results by adding a filter, for example:
/Customer?$filter=contains(Search_Name,'TESTING')However, I encountered an issue when attempting to search through both the
Search_Name and No fields simultaneously, like this:/Customer?$filter=contains(Search_Name,'TESTING') or contains(No,'50000')This query returns a 501 not implemented error.
In my testing, I found that chaining multiple contains together works if I'm searching within the same field:
/Customer?$filter=contains(Search_Name,'TESTING1') or contains(Search_Name,'TESTING2')My question is: How can I perform a search on both the
Search_Name and No fields simultaneously? I came across an article suggesting the use of the $search option, but it seems to be ignored in my case. Any guidance on this matter would be greatly appreciated.
Categories:
I have the same question (0)
All responses (
Answers (
