Get User Variable Values Defined in the Application by Value

Administrators can use this REST API to retrieve user variable values for all users where the value is set to a specific member name. Other users can use this REST API to retrieve user variable values for themselves where the value is set to a specific member name.

Required Roles

Service Administrator, Power User, User, Viewer

REST Resource

GET       /HyperionPlanning/rest/{api_version}/applications/{application}/uservariablesvalues?q={"member":"member_name"}

Request

Supported Media Types: application/json

Parameters

The following table summarizes the client request.

Table 8-104 Parameters

Name	Description	Type	Required	Default
api_version	Version of the API you are developing with	Path	Yes	None
application	The name of the application	Path	Yes	None
member	Name of the member	Query	Yes	None
offset	Indicates the actual index from which the records are returned. It is a 0 based non-negative integer.	Query	No	0
limit	Controls how many items to return. A limit of 0 or -1 will return all records starting from the index defined by the offset.	Query	No	25

Example URL

https://<BASE-URL>/HyperionPlanning/rest/v3/applications/Vision/uservariablevalues?q={"member":"Apr"}

Optionally specifying paging with an offset and limit:

https://<BASE-URL>/HyperionPlanning/rest/v3/applications/Vision/uservariablevalues?q={"member":"Apr"}&offset=0&limit=5

Response

Supported Media Types: application/json

Parameters

The following table summarizes the parameters.

Table 8-105 Parameters

Name	Description
items	Collection of information about the resource
userName	Name of the user for whom the user variable value is set
name	Name of the user variable, such as Account View
dimension	Name of the dimension to which the member belongs, such as Account
member_name	Name of the member that is set for the user variable value, such as Units

Example of Response Body

The following shows an example of the response body.

{
    "items": [
        {
            "userName": "testuser1",
            "name": "Period",
            "dimension": "Period",
            "member": "Apr"
        },
        {
            "userName": "testuser2",
            "name": "uservar2",
            "dimension": "Period",
            "member": "Apr"
        }
    ],
    "links": [
        {
            "rel": "self",
            "href": "https://<BASE-URL>/HyperionPlanning/rest/v3/applications/Vision/uservariablevalues",
            "action": "GET",
            "data": null
        }
    ]
}