Forum Discussion

nirender's avatar
nirender
Level 3
8 years ago

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

  • Titoine31's avatar
    Titoine31
    Moderator
    8 years ago

    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