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
- filters
-
Type:
array
filters - groups
-
Type:
array
groups - parameters
-
Type:
array
parameters
Nested Schema : filters
Type:
array
-
Type:
object
filters-items[0]
Nested Schema : groups
Type:
array
-
Type:
string
Nested Schema : parameters
Type:
array
-
Type:
object
parameters-items[0]
Nested Schema : filters-items[0]
Type:
object
- name
-
Type:
string
- value
-
Type:
string
Nested Schema : parameters-items[0]
Type:
object
- name
-
Type:
string
- value
-
Type:
string
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
}
]