Get Scenarios
/essbase/rest/v1/scenarios
Get scenarios matching search criteria. Response includes links to all basic scenario attributes, excluding approvers, participants, comments, and scripts.
Request
-
application(optional): string
Application name.
-
approvalPending(optional): boolean
Scenario is in submitted state, and approval is pending from logged in user.
Default Value:false
-
count(optional): boolean
If
true
, response contains only the count of scenarios, and not actual scenarios.Default Value:false
-
database(optional): string
Database name.
-
filter(optional): string
Scenario name wildcard pattern.
-
limit(optional): integer(int64)
Maximum number of scenarios to return. Default is 50.
Default Value:50
-
offset(optional): integer(int64)
Number of scenarios to omit from the start of the result set. Default is 0.
Default Value:0
-
orderBy(optional): string
Order-by field and order for the result set. The value of this parameter must follow the format of
fieldName:asc|desc
. For example:name:asc
. Default value iscreatedTime:desc
, meaning that scenarios are listed with the most recently created scenarios first.Default Value:createdTime:desc
-
overdue(optional): boolean
If true, returns all scenarios past the due date. Default is false, meaning all scenarios are returned.
-
role(optional): string
Optional user role by which to filter the scenario list. Value can be
owner
,participant
, orapprover
. If role is specified asapprover
, this API returns all scenarios for which the logged in user is the approver. By default, all scenarios are returned for which the logged in user is either an owner, a participant, or an approver. -
state(optional): string
Scenario state.
Response
- application/json
- application/xml
200 Response
OK
Scenario list and details returned successfully.
object
-
application(optional):
string
-
appliedTime(optional):
integer(int64)
-
approvers(optional):
array approvers
-
commentsCount(optional):
integer(int32)
-
createdTime(optional):
integer(int64)
-
database(optional):
string
-
description(optional):
string
-
dueDate(optional):
integer(int64)
-
id(optional):
integer(int64)
-
links(optional):
array links
-
name(optional):
string
-
overdue(optional):
boolean
-
owner(optional):
string
-
participants(optional):
array participants
-
priority(optional):
string
Allowed Values:
[ "LOW", "MEDIUM", "HIGH" ]
-
refreshedTime(optional):
integer(int64)
-
sandbox(optional):
string
-
scenarioUser(optional):
boolean
-
scripts(optional):
array scripts
-
state(optional):
string
Allowed Values:
[ "NEW", "SUBMITTED", "APPROVED", "REJECTED", "APPLIED" ]
-
submittedTime(optional):
integer(int64)
-
useCalculatedValues(optional):
boolean
object
-
content(optional):
string
-
type(optional):
string
Allowed Values:
[ "REFRESH", "CLEAR", "APPLY" ]
400 Response
Bad Request
Failed to get scenarios.
500 Response
Internal Server Error.