11-13-2017 09:18 AM
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
11-20-2017 02:31 AM
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