OData Query error: The query specified in the URI is not valid. The limit of '0' for Top query has been exceeded. The value from the incoming request is '100'

After configuration my OData service, I tried to do a first call by using a $top parameter to get the first 100 results. However this didn’t turned out to a big success. Instead of some data, I got the following error message back:

{"error":{"code":"","message":"The query specified in the URI is not valid. The limit of '0' for Top query has been exceeded. The value from the incoming request is '100'.","innererror":{"message":"The limit of '0' for Top query has been exceeded. The value from the incoming request is '100'.","type":"Microsoft.OData.ODataException","stacktrace":" at System.Web.OData.Query.Validators.TopQueryValidator.Validate(TopQueryOption topQueryOption, ODataValidationSettings validationSettings)\r\n at System.Web.OData.Query.TopQueryOption.Validate(ODataValidationSettings validationSettings)\r\n at System.Web.OData.Query.Validators.ODataQueryValidator.Validate(ODataQueryOptions options, ODataValidationSettings validationSettings)\r\n at System.Web.OData.Query.ODataQueryOptions.Validate(ODataValidationSettings validationSettings)\r\n at System.Web.OData.EnableQueryAttribute.ValidateQuery(HttpRequestMessage request, ODataQueryOptions queryOptions)\r\n at System.Web.OData.EnableQueryAttribute.ExecuteQuery(Object response, HttpRequestMessage request, HttpActionDescriptor actionDescriptor, ODataQueryContext queryContext)\r\n at System.Web.OData.EnableQueryAttribute.OnActionExecuted(HttpActionExecutedContext actionExecutedContext)"}}}

Since Web API OData V6.0.0 you need to explicitly enable query options. This can be done globally in the WebApiConfig.Register(HttpConfiguration config):


    
      
        
  
    
    

        


  


  
        
          
          public static void Register(HttpConfiguration config)
        
        
          
          {
        
        
          
              // Web API routes(should be invoked first to avoid errors)
        
        
          
              config.MapHttpAttributeRoutes();
        
        
          
          

        
        
          
              // OData config
        
        
          
              ODataModelBuilder builder = new ODataConventionModelBuilder();
        
        
          
              builder.EntitySet<Product>("Products");
        
        
          
          

        
        
          
              config.MapODataServiceRoute(
        
        
          
                          routeName: "ODataRoute",
        
        
          
                          routePrefix: null,
        
        
          
                          model: builder.GetEdmModel());
        
        
          
          

        
        
          
              //Configure allowed query operators
        
        
          
              config.Select().MaxTop(100);
        
        
          
          }
        
  



    

  


      
      
        view raw
        
          WebApiConfig.cs
        
        hosted with ❤ by GitHub

Kubernetes–Limit your environmental impact

Reducing the carbon footprint and CO2 emission of our (cloud) workloads, is a responsibility of all of us. If you are running a Kubernetes cluster, have a look at Kube-Green . kube-green is a simple Kubernetes operator that automatically shuts down (some of) your pods when you don't need them. A single pod produces about 11 Kg CO2eq per year( here the calculation). Reason enough to give it a try! Installing kube-green in your cluster The easiest way to install the operator in your cluster is through kubectl. We first need to install a cert-manager: kubectl apply -f https://github.com/cert-manager/cert-manager/releases/download/v1.14.5/cert-manager.yaml Remark: Wait a minute before you continue as it can take some time before the cert-manager is up & running inside your cluster. Now we can install the kube-green operator: kubectl apply -f https://github.com/kube-green/kube-green/releases/latest/download/kube-green.yaml Now in the namespace where we want t...

The art of simplicity

Search This Blog

OData Query error: The query specified in the URI is not valid. The limit of '0' for Top query has been exceeded. The value from the incoming request is '100'

Labels

Popular posts from this blog

Kubernetes–Limit your environmental impact

Azure DevOps/ GitHub emoji

.NET 9 - Goodbye sln!

	public static void Register(HttpConfiguration config)
	{
	// Web API routes(should be invoked first to avoid errors)
	config.MapHttpAttributeRoutes();

	// OData config
	ODataModelBuilder builder = new ODataConventionModelBuilder();
	builder.EntitySet<Product>("Products");

	config.MapODataServiceRoute(
	routeName: "ODataRoute",
	routePrefix: null,
	model: builder.GetEdmModel());

	//Configure allowed query operators
	config.Select().MaxTop(100);
	}