REST API for Oracle Fusion Cloud Enterprise Data Management

Gets the views

get

/epm/rest/v1/views

Returns a list of all the views the user has access to.

Request

Query Parameters

q: array[string]
Collection Format: multi

filters views by statuses and/or a dimension
- Allowed Values: [ "objectStatus::{list of object statuses separated by comma(DRAFT", "ACTIVE", "ARCHIVED)}", "dimension::dimensionId" ]

Response

Supported Media Types

application/json

200 Response

successful operation

Root Schema : ItemsView

Type: object

Show Source

count: integer(int32)
hasMore: boolean
items: array items

Read Only: true
limit: integer(int32)
links: array links

Read Only: true
offset: integer(int32)
totalResults: integer(int32)

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "readOnly":true,
            "items":{
                "$ref":"#/definitions/View"
            }
        },
        "links":{
            "type":"array",
            "readOnly":true,
            "items":{
                "$ref":"#/definitions/Link"
            }
        },
        "hasMore":{
            "type":"boolean"
        },
        "totalResults":{
            "type":"integer",
            "format":"int32"
        },
        "limit":{
            "type":"integer",
            "format":"int32"
        },
        "count":{
            "type":"integer",
            "format":"int32"
        },
        "offset":{
            "type":"integer",
            "format":"int32"
        }
    }
}

Nested Schema : items

Type: array

Read Only: true

Show Source

Array of: object View

{
    "type":"array",
    "readOnly":true,
    "items":{
        "$ref":"#/definitions/View"
    }
}

Nested Schema : links

Type: array

Read Only: true

Show Source

Array of: object Link

{
    "type":"array",
    "readOnly":true,
    "items":{
        "$ref":"#/definitions/Link"
    }
}

Nested Schema : View

Type: object

Show Source

attachRequestFile: boolean
createdBy: string

This property is now deprecated. Use createdByUser instead.
createdByUser: object User
description: string
id: string(uuid)
links: array links
master: boolean
modifiedBy: string

This property is now deprecated. Use modifiedByUser instead.
modifiedByUser: object User
name: string
objectStatus: string

Allowed Values: [ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
permittedActions: array permittedActions

Unique Items Required: true
requestDescription: string

Allowed Values: [ "DEFAULT", "REQUIRED" ]
requestPlaceholder: string
timeCreated: integer(int64)
timeModified: integer(int64)
usersBrowseFilter: object UsersBrowseFilter

{
    "type":"object",
    "properties":{
        "id":{
            "type":"string",
            "format":"uuid"
        },
        "name":{
            "type":"string"
        },
        "description":{
            "type":"string"
        },
        "timeCreated":{
            "type":"integer",
            "format":"int64"
        },
        "timeModified":{
            "type":"integer",
            "format":"int64"
        },
        "createdBy":{
            "type":"string",
            "description":"This property is now deprecated. Use createdByUser instead."
        },
        "modifiedBy":{
            "type":"string",
            "description":"This property is now deprecated. Use modifiedByUser instead."
        },
        "master":{
            "type":"boolean"
        },
        "objectStatus":{
            "type":"string",
            "enum":[
                "DRAFT",
                "ACTIVE",
                "SUNSET",
                "ARCHIVED",
                "DELETED"
            ]
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Link"
            }
        },
        "permittedActions":{
            "type":"array",
            "uniqueItems":true,
            "items":{
                "type":"string",
                "enum":[
                    "CREATE_CONSTRAINT",
                    "CREATE_NODETYPE",
                    "CREATE_HIERARCHYSET",
                    "CREATE_NODESET",
                    "CREATE_VIEWPOINT",
                    "CREATE_REQUEST",
                    "CREATE_PROPERTY",
                    "ASSIGN_REQUEST",
                    "SUBMIT_REQUEST",
                    "PUSHBACK_REQUEST",
                    "REJECT_REQUEST",
                    "APPROVE_REQUEST",
                    "WITHDRAW_REQUEST",
                    "COMMIT_REQUEST",
                    "ADD_REQUEST_COMMENT",
                    "ADD_REQUEST_ATTACHMENT",
                    "EDIT_REQUEST_HEADER",
                    "VALIDATE",
                    "EDIT_METADATA",
                    "REINDEX",
                    "EDIT",
                    "COPY_VIEWPOINT",
                    "LOAD_VIEWPOINT",
                    "ARCHIVE",
                    "DELETE",
                    "CLOSE",
                    "IMPORT",
                    "EXPORT",
                    "MANAGE_GRANTS",
                    "DELETE_NODE",
                    "ADD_NODE",
                    "INSERT_NODE",
                    "REORDER_NODE",
                    "REMOVE_NODE",
                    "MOVE_NODE",
                    "RECALL_REQUEST",
                    "COPY_EXTRACT",
                    "COPY_LOAD_PROFILE",
                    "UPDATE_VISIBILITY",
                    "COPY",
                    "QUERY",
                    "RUN_EXTRACT_PACKAGE",
                    "CREATE_EXTRACT_PACKAGE"
                ]
            }
        },
        "createdByUser":{
            "$ref":"#/definitions/User"
        },
        "modifiedByUser":{
            "$ref":"#/definitions/User"
        },
        "usersBrowseFilter":{
            "$ref":"#/definitions/UsersBrowseFilter"
        },
        "requestDescription":{
            "type":"string",
            "enum":[
                "DEFAULT",
                "REQUIRED"
            ]
        },
        "requestPlaceholder":{
            "type":"string"
        },
        "attachRequestFile":{
            "type":"boolean"
        }
    }
}

Nested Schema : User

Type: object

Show Source

artifactAssignments: array artifactAssignments
associatedRoles: array associatedRoles
dataManagerOnAny: boolean
emailAddresses: array emailAddresses
epmIdleSessionTimeout: integer(int32)
firstName: string
fullName: string
grantPermission: string

Allowed Values: [ "OWNER", "DATAMANAGER", "PARTICIPANT", "APPROVER", "NOTIFIED", "COMMITTER", "NONE", "METADATAMANAGER" ]
homePageLayoutName: string
id: string(uuid)
lastName: string
links: array links
nameInitials: string
preferences: object Preferences
ssoToken: string
userName: string
userServiceAdministrator: boolean

{
    "type":"object",
    "properties":{
        "id":{
            "type":"string",
            "format":"uuid"
        },
        "userName":{
            "type":"string"
        },
        "fullName":{
            "type":"string"
        },
        "firstName":{
            "type":"string"
        },
        "lastName":{
            "type":"string"
        },
        "ssoToken":{
            "type":"string"
        },
        "emailAddresses":{
            "type":"array",
            "items":{
                "type":"string"
            }
        },
        "associatedRoles":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Role"
            }
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Link"
            }
        },
        "preferences":{
            "$ref":"#/definitions/Preferences"
        },
        "nameInitials":{
            "type":"string"
        },
        "grantPermission":{
            "type":"string",
            "enum":[
                "OWNER",
                "DATAMANAGER",
                "PARTICIPANT",
                "APPROVER",
                "NOTIFIED",
                "COMMITTER",
                "NONE",
                "METADATAMANAGER"
            ]
        },
        "dataManagerOnAny":{
            "type":"boolean"
        },
        "userServiceAdministrator":{
            "type":"boolean"
        },
        "epmIdleSessionTimeout":{
            "type":"integer",
            "format":"int32"
        },
        "homePageLayoutName":{
            "type":"string"
        },
        "artifactAssignments":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/ArtifactAssignment"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object Link

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

Nested Schema : permittedActions

Type: array

Unique Items Required: true

Show Source

Array of: string

Allowed Values: [ "CREATE_CONSTRAINT", "CREATE_NODETYPE", "CREATE_HIERARCHYSET", "CREATE_NODESET", "CREATE_VIEWPOINT", "CREATE_REQUEST", "CREATE_PROPERTY", "ASSIGN_REQUEST", "SUBMIT_REQUEST", "PUSHBACK_REQUEST", "REJECT_REQUEST", "APPROVE_REQUEST", "WITHDRAW_REQUEST", "COMMIT_REQUEST", "ADD_REQUEST_COMMENT", "ADD_REQUEST_ATTACHMENT", "EDIT_REQUEST_HEADER", "VALIDATE", "EDIT_METADATA", "REINDEX", "EDIT", "COPY_VIEWPOINT", "LOAD_VIEWPOINT", "ARCHIVE", "DELETE", "CLOSE", "IMPORT", "EXPORT", "MANAGE_GRANTS", "DELETE_NODE", "ADD_NODE", "INSERT_NODE", "REORDER_NODE", "REMOVE_NODE", "MOVE_NODE", "RECALL_REQUEST", "COPY_EXTRACT", "COPY_LOAD_PROFILE", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]

{
    "type":"array",
    "uniqueItems":true,
    "items":{
        "type":"string",
        "enum":[
            "CREATE_CONSTRAINT",
            "CREATE_NODETYPE",
            "CREATE_HIERARCHYSET",
            "CREATE_NODESET",
            "CREATE_VIEWPOINT",
            "CREATE_REQUEST",
            "CREATE_PROPERTY",
            "ASSIGN_REQUEST",
            "SUBMIT_REQUEST",
            "PUSHBACK_REQUEST",
            "REJECT_REQUEST",
            "APPROVE_REQUEST",
            "WITHDRAW_REQUEST",
            "COMMIT_REQUEST",
            "ADD_REQUEST_COMMENT",
            "ADD_REQUEST_ATTACHMENT",
            "EDIT_REQUEST_HEADER",
            "VALIDATE",
            "EDIT_METADATA",
            "REINDEX",
            "EDIT",
            "COPY_VIEWPOINT",
            "LOAD_VIEWPOINT",
            "ARCHIVE",
            "DELETE",
            "CLOSE",
            "IMPORT",
            "EXPORT",
            "MANAGE_GRANTS",
            "DELETE_NODE",
            "ADD_NODE",
            "INSERT_NODE",
            "REORDER_NODE",
            "REMOVE_NODE",
            "MOVE_NODE",
            "RECALL_REQUEST",
            "COPY_EXTRACT",
            "COPY_LOAD_PROFILE",
            "UPDATE_VISIBILITY",
            "COPY",
            "QUERY",
            "RUN_EXTRACT_PACKAGE",
            "CREATE_EXTRACT_PACKAGE"
        ]
    }
}

Nested Schema : UsersBrowseFilter

Type: object

Show Source

filterType: string

Allowed Values: [ "INCLUDE", "EXCLUDE", "NONE" ]
userGroups: array userGroups

Unique Items Required: true
users: array users

Unique Items Required: true

{
    "type":"object",
    "properties":{
        "users":{
            "type":"array",
            "uniqueItems":true,
            "items":{
                "type":"string",
                "format":"uuid"
            }
        },
        "userGroups":{
            "type":"array",
            "uniqueItems":true,
            "items":{
                "type":"string",
                "format":"uuid"
            }
        },
        "filterType":{
            "type":"string",
            "enum":[
                "INCLUDE",
                "EXCLUDE",
                "NONE"
            ]
        }
    }
}

Nested Schema : artifactAssignments

Type: array

Show Source

Array of: object ArtifactAssignment

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/ArtifactAssignment"
    }
}

Nested Schema : associatedRoles

Type: array

Show Source

Array of: object Role

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Role"
    }
}

Nested Schema : emailAddresses

Type: array

Show Source

Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object Link

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

Nested Schema : Preferences

Type: object

Show Source

actAsThisRole: string

Allowed Values: [ "USER", "SERVICE_ADMINISTRATOR" ]
delegateToUserId: string(uuid)
languageTag: string
links: array links
outOfOffice: boolean
profilePictureId: string(uuid)
timeZone: object TimeZone

{
    "type":"object",
    "properties":{
        "profilePictureId":{
            "type":"string",
            "format":"uuid"
        },
        "timeZone":{
            "$ref":"#/definitions/TimeZone"
        },
        "languageTag":{
            "type":"string"
        },
        "outOfOffice":{
            "type":"boolean"
        },
        "delegateToUserId":{
            "type":"string",
            "format":"uuid"
        },
        "actAsThisRole":{
            "type":"string",
            "enum":[
                "USER",
                "SERVICE_ADMINISTRATOR"
            ]
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Link"
            }
        }
    }
}

Nested Schema : ArtifactAssignment

Type: object

Show Source

artifact: object Artifact
sortOrder: integer(int32)
visible: boolean

{
    "type":"object",
    "properties":{
        "artifact":{
            "$ref":"#/definitions/Artifact"
        },
        "sortOrder":{
            "type":"integer",
            "format":"int32"
        },
        "visible":{
            "type":"boolean"
        }
    }
}

Nested Schema : Artifact

Type: object

Show Source

id: string(uuid)
name: string
type: string

Allowed Values: [ "CLUSTER", "CARD" ]

{
    "type":"object",
    "properties":{
        "type":{
            "type":"string",
            "enum":[
                "CLUSTER",
                "CARD"
            ]
        },
        "id":{
            "type":"string",
            "format":"uuid"
        },
        "name":{
            "type":"string"
        }
    }
}

Nested Schema : Role

Type: object

Show Source

id: string
name: string

{
    "type":"object",
    "properties":{
        "id":{
            "type":"string"
        },
        "name":{
            "type":"string"
        }
    }
}

Nested Schema : Link

Type: object

Show Source

href: string
method: string
rel: string
templated: boolean

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        },
        "templated":{
            "type":"boolean"
        },
        "method":{
            "type":"string"
        }
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object Link

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

Nested Schema : TimeZone

Type: object

Show Source

displayName: string
dstsavings: integer(int32)
id: string
rawOffset: integer(int32)

{
    "type":"object",
    "properties":{
        "displayName":{
            "type":"string"
        },
        "id":{
            "type":"string"
        },
        "rawOffset":{
            "type":"integer",
            "format":"int32"
        },
        "dstsavings":{
            "type":"integer",
            "format":"int32"
        }
    }
}

Nested Schema : userGroups

Type: array

Unique Items Required: true

Show Source

Array of: string(uuid)

{
    "type":"array",
    "uniqueItems":true,
    "items":{
        "type":"string",
        "format":"uuid"
    }
}

Nested Schema : users

Type: array

Unique Items Required: true

Show Source

Array of: string(uuid)

{
    "type":"array",
    "uniqueItems":true,
    "items":{
        "type":"string",
        "format":"uuid"
    }
}

Examples

The following example shows how to retrieve all the views by submitting a GET request on the REST resource using cURL.

curl --user edmcs_cloud_user -X GET https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views

Example of the Response Body

The following example shows the contents of the response body in JSON format,including:

{
  "items": [
    {
      "id": "91fab006-5185-478f-9d3c-c1b4548a0b10",
      "name": "Corporate Planning (EPBCS)",
      "description": "Corporate Planning dimensions",
      "timeCreated": "2017-11-08T22:13:01.060Z",
      "timeModified": "2017-11-10T03:46:23.515Z",
      "createdBy": "demoadmin",
      "modifiedBy": "demoadmin",
      "master": false, 
      "objectStatus": "ACTIVE",
      "links": [
        {
          "rel": "self",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/91fab006-5185-478f-9d3c-c1b4548a0b10"
        },
        {
          "rel": "viewpoints",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/91fab006-5185-478f-9d3c-c1b4548a0b10/viewpoints"
        },
        {
          "rel": "create",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/91fab006-5185-478f-9d3c-c1b4548a0b10/viewpoints",
          "method": "POST"
        },
        {
          "rel": "requests",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests?q=views%3A%3A91fab006-5185-478f-9d3c-c1b4548a0b10",
          "templated": true
        },
        {
          "rel": "createRequest",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests",
          "method": "POST"
        },
        {
          "rel": "delete",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/91fab006-5185-478f-9d3c-c1b4548a0b10",
          "method": "DELETE"
        },
        {
          "rel": "edit",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/91fab006-5185-478f-9d3c-c1b4548a0b10",
          "method": "PUT"
        },
        {
          "rel": "grants",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/91fab006-5185-478f-9d3c-c1b4548a0b10/grants"
        }
      ],
      "permittedActions": [
        "CREATE_REQUEST",
        "ARCHIVE",
        "EDIT_METADATA",
        "CREATE_VIEWPOINT",
        "MANAGE_GRANTS",
        "DELETE"
      ]
    },
    {
      "id": "9f9d7689-44ce-4e0a-8f37-33ed54e703c4",
      "name": "Acquired GL (Legacy)",
      "description": "Acquired GL Chart of Accounts",
      "timeCreated": "2017-11-10T04:43:30.049Z",
      "timeModified": "2017-11-10T04:58:33.958Z",
      "createdBy": "Casey.Brown",
      "modifiedBy": "Casey.Brown",
      "master": false,
      "objectStatus": "ACTIVE",
      "links": [
        {
          "rel": "self",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/9f9d7689-44ce-4e0a-8f37-33ed54e703c4"
        },
        {
          "rel": "viewpoints",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/9f9d7689-44ce-4e0a-8f37-33ed54e703c4/viewpoints"
        },
        {
          "rel": "create",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/9f9d7689-44ce-4e0a-8f37-33ed54e703c4/viewpoints",
          "method": "POST"
        },
        {
          "rel": "requests",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests?q=views%3A%3A9f9d7689-44ce-4e0a-8f37-33ed54e703c4",
          "templated": true
        },
        {
          "rel": "createRequest",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests",
          "method": "POST"
        },
        {
          "rel": "delete",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/9f9d7689-44ce-4e0a-8f37-33ed54e703c4",
          "method": "DELETE"
        },
        {
          "rel": "edit",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/9f9d7689-44ce-4e0a-8f37-33ed54e703c4",
          "method": "PUT"
        },
        {
          "rel": "grants",
          "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/9f9d7689-44ce-4e0a-8f37-33ed54e703c4/grants"
        }
      ],
      "permittedActions": [
        "CREATE_REQUEST",
        "ARCHIVE",
        "EDIT_METADATA",
        "CREATE_VIEWPOINT",
        "MANAGE_GRANTS",
        "DELETE"
      ]
    }
  ]
}