Retrieve Business View data using filter

post

/OracleBAMREST/bam/api/projects/{projectname}/businessviews/{businessviewname}/data

Retrieve the records which are by obtained by filtering the query results based on groups,parameters or filters.

Request

Supported Media Types
  • application/json
  • application/xml
Body Parameter
Root Schema : http://jsonschema.net
Type: object
Nested Schema : filters
Type: array
Nested Schema : groups
Type: array
Nested Schema : parameters
Type: array
Nested Schema : filters-items[0]
Type: object
Nested Schema : parameters-items[0]
Type: object
Example application/json

{
    "groups":[
        "Country"
    ],
    "filters":[
        {
            "name":"Dept",
            "value":"HR"
        },
        {
            "name":"Salary_int",
            "value":"150"
        }
    ],
    "parameters":[
        {
            "name":"Dept",
            "value":"HR"
        },
        {
            "name":"Salary_int",
            "value":"150"
        }
    ]
}

Response

Supported Media Types
  • application/json
  • application/xml
200 Response
Success
Body
Root Schema : /paths/~1projects~1{projectname}~1businessviews~1{businessviewname}~1data/post/responses/200/schema
Example application/json

[
    {
        "DATAOBJECT_MODIFIED":"2014-03-11T14:54:57.821+0000",
        "DATAOBJECT_CREATED":"2014-03-11T14:54:57.821+0000",
        "Salary_decimal":1000.555,
        "Dept":"HR",
        "Salary_float":100.55,
        "Salary_int":100
    },
    {
        "DATAOBJECT_MODIFIED":"2014-03-11T14:54:57.821+0000",
        "DATAOBJECT_CREATED":"2014-03-11T14:54:57.821+0000",
        "Salary_decimal":200.22,
        "Dept":"HR",
        "Salary_float":150.323,
        "Salary_int":150
    }
]