odata-query | OData v4 query builder | Autocomplete library

Should it be possible to provide an $expand=singleValueExtendedProperties... query parameter on an events delta request? My approach returns an error that I wasn't quite expecting.

The request looks like this:

I am trying to query my OData service for a data with a datetime greater or equal to given value. It is not working as expected

I have read the documentation:

https://docs.microsoft.com/en-us/odata/webapi/datetime-support#filter-datetime

Assemblies:

• Microsoft.AspNetCore.OData 7.4.0
• NET Core 3
• EF Core

Reproduce steps

I have tried the following query formats:

1. https://myurl/api/resource?$filter=city eq 'Kigali' and purchaseDateTime gt 2020-01-01T23:59:59.99Z &$orderby=purchaseDateTime desc HTTP 500 - Conversion failed when converting date and/or time from character string.

2. https://myurl/api/resource?$filter=city eq 'Kigali' and purchaseDateTime gt cast(2020-01-01T23:59:59.99Z,Edm.DateTimeOffset) &$orderby=purchaseDateTime desc returns HTTP 500 - Internal Server Error

3. https://myurl/api/resource?$filter=city eq 'Kigali' and purchaseDateTime gt datetime'2020-01-01T23:59:59.99Z' &$orderby=purchaseDateTime desc

On the OData site, this works

https://services.odata.org/V4/OData/OData.svc/Products?$filter=ReleaseDate%20gt%202002-12-30T23:59:59.99Z

Expected result

Return the data according to the query in the same way that the the http://services.odata.org responds

Actual results

HTTP Bad Request or HTTP 500

Microsoft says this should work:

I'm building a Spring Boot project making use of S/4HANA custom OData Service and Java VDM. I have been following various tutorials on SAP Blog, developer.sap.com or S4H13 course - the approach is pretty much the same. I managed to successfully generate VDM for my Custom OData Service based on the edmx file, created all necessary commands, methods in the controller and so on.

Unfortunately, I'm encountering an issue when launching the project locally. I use the following command first: mvn clean package and later, when I'm in the application directory want to run the project: mvn spring-boot:run.

The project build fails with the following errors and exceptions:

2020-07-31 12:45:20.941 ERROR 70176 --- [main] o.a.c.c.C.[Tomcat].[localhost].[/] : Exception sending context initialized event to listener instance of class [com.sap.cloud.sdk.s4hana.connectivity.ErpDestination]

I am not able to move forward due to an exception thrown by Cloud SDK. EdmNamedImpl class of cloud SDK is throwing an error due to incorrect SF Metadata property name. The property name of the SF entity is "goto-url", so due to hyphen in field name is not being accepted by PATTER_VALID_NAME matcher. I have tried many approaches but could not get around this exception. I guess Cloud SDK either should provide a way to suppress name validation or a way to pass path of local metadata file to execute method of FluentHelper.

The way I am constructing Query is:

I need to modify the $filter on the server-side of .NET core 2.1 API. I have looked at these:

https://entityframework.net/knowledge-base/33660648/odata-v4-modify--filter-on-server-side

OData V4 modify $filter on server side

The best way to modify a WebAPI OData QueryOptions.Filter

(and a couple of others)

They all do something along the lines of:

Using this SharePoint OData query:

I am getting the issue described up above when running integration tests.

The full error message follows: