cancel
Showing results for 
Search instead for 
Did you mean: 

Using OData and Browsers concerns

So when I started looking at using OData all looked really good.  However I am seeing some issues now.  If I request data for all departments

http://Servername/CAReporting/OData/Departments(customerID=15)

It returns information just for department 15 in customerID 15

{
  "odata.metadata":"http://ushouxevca01v/CAReporting/OData/$metadata#Departments","value":[
    {
      "CustomerID":15,"DepartmentID":15,"DepartmentName":"ABC1233","Status":"Open","CreatedDate":"2016-11-03T11:44:24.163","ModifiedDate":"2017-11-13T11:33:05.297"
    }
  ]
}

I deleted the browser cache and even entered the query in a browser on another desktop that I have never used but still get the same result.

Anyone seen this?

 

Nirender Aggarwal

1 Reply

Re: Using OData and Browsers concerns

Hi Nirender,

I just try it on my CA and that's OK, I have all Departments for my Customer, I do it with Excel "Power Query > From Other Sources > From OData Feed" and I have three differents DepartmentsID in the result.
Have you try with a different CustomerID ?
Youy can use this query for have a liste of your CustomerID :
http://Servername/CAReporting/OData/Customers

Antoine