Inconsistencies with Get Data Node API are found when compared against the Query Node API.

• When retrieving all the data nodes under root node xpath "/" a list of all parent nodes is returned. But when the same operation is performed to retrieve all the list items in a List Data node then a 404 error is sent as response
• Similarly, when a query is performed to retrieve all the list items in a List data node then the whole list is returned
• A detailed report is documented here: CPS core Get Data Node Inconsistencies
• A change in how the data nodes are queried using SQL can help retrieve the list of data nodes

A/C:

• All the list items should be retrieved when a Get request is executed for a list data node. 
  • Expected response for xpath: /bookstore/categories, where categories is a list data node (sample file below):

[
  {
    "stores:categories": [
      {
        "name": "Test book",
        "price": 100,
        "stock": false,
        "book-category": "SciFi"
      },
      {
        "name": "Kids book",
        "price": 200,
        "stock": true,
        "book-category": "Kids"
      }
    ]
  }
]

• Demo