Get Viewpoint Extracts
get
/epm/rest/v1/extracts
Returns a list of all the extracts the user has access to.
Request
Query Parameters
-
q: array[string]
Collection Format:
multi
filters Extracts-
Allowed Values:
[ "view::{view Id to match extract view}", "integration_only::{TRUE or FALSE}", "viewpoint::{viewpoint Id to match extract viewpoint}", "application::{application Id to match validation}", "dimension::{dimension Id to match validation}", "scope::{PUBLIC or PRIVATE}" ]
-
Response
Supported Media Types
- application/json
200 Response
successful operation
Root Schema : ItemExtract
Type:
Show Source
object
-
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)
Nested Schema : SimpleExtract
Type:
Show Source
object
-
application:
object IdNameLink
-
createdByUser:
object User
-
description:
string
-
dimension:
object Dimension
Dimension model that would be returned as response
-
extractConnection:
object ExtractConnection
-
extractType:
string
-
fileName:
string
-
id:
string(uuid)
-
integrationOnly:
boolean
-
lastExtractInfo:
object ExtractHistory
-
links:
array links
-
modifiedByUser:
object User
-
name:
string
-
profileOwner:
object User
-
public:
boolean
-
timeCreated:
integer(int64)
-
timeModified:
integer(int64)
-
view:
object View
-
viewpoint:
object Viewpoint
Nested Schema : IdNameLink
Type:
Show Source
object
-
description:
string
Read Only:
true
-
id:
string(uuid)
-
links:
array links
-
name:
string
Nested Schema : User
Type:
Show Source
object
-
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
Nested Schema : Dimension
Type:
object
Dimension model that would be returned as response
Show Source
-
applicationLink:
object IdNameLink
-
applicationTypeId:
string(uuid)
Read Only:
true
-
bindings:
array bindings
Read Only:
true
-
blockoutConfiguration:
object BlockoutConfiguration
-
canAddBinding:
boolean
Read Only:
true
-
canAddMappingBinding:
boolean
Read Only:
true
-
connected:
boolean
Read Only:
true
-
createdBy:
string
Read Only:
true
This property is now deprecated and will be removed in 10/2020. Use createdByUser instead. -
createdByUser:
object User
-
description:
string
Read Only:
true
-
dimensionType:
string
Read Only:
true
-
externalName:
string
Read Only:
true
-
id:
string(uuid)
Read Only:
true
-
importExportSettings:
object DimensionImportExportSettings
Discriminator:
type
Dimension Import/Export settings -
isBound:
boolean
Read Only:
true
-
links:
array links
Read Only:
true
-
modifiedBy:
string
Read Only:
true
This property is now deprecated and will be removed in 10/2020. Use modifiedByUser instead. -
modifiedByUser:
object User
-
name:
string
Read Only:
true
-
objectStatus:
string
Read Only:
true
Allowed Values:[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Read Only:
true
Unique Items Required:true
-
supportedDirection:
string
Read Only:
true
Allowed Values:[ "BOTH", "IMPORT", "EXPORT", "NONE" ]
-
supportsExtracts:
boolean
Read Only:
true
-
supportsMapping:
boolean
Read Only:
true
-
supportsMappingExport:
boolean
Read Only:
true
-
supportsTemplateExport:
boolean
Read Only:
true
-
timeCreated:
integer(int64)
Read Only:
true
-
timeModified:
integer(int64)
Read Only:
true
-
validationSettings:
array validationSettings
Read Only:
true
Nested Schema : ExtractHistory
Type:
Show Source
object
-
connectionName:
string
-
endTime:
integer(int64)
-
extractType:
string
Allowed Values:
[ "DEFAULT", "INCREMENTAL", "GENERATIONAL" ]
-
links:
array links
-
messages:
array messages
-
packageFlag:
boolean
-
packageId:
string(uuid)
-
packageName:
string
-
publicApiFlag:
boolean
-
ranBy:
string
-
startTime:
integer(int64)
-
status:
string
Allowed Values:
[ "PENDING", "COMPLETED", "ERROR", "RUNNING" ]
-
success:
boolean
Nested Schema : View
Type:
Show Source
object
-
createdBy:
string
This property is now deprecated and will be removed in 10/2020. Use createdByUser instead.
-
createdByUser:
object User
-
description:
string
-
id:
string(uuid)
-
links:
array links
-
master:
boolean
-
modifiedBy:
string
This property is now deprecated and will be removed in 10/2020. 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
Nested Schema : Viewpoint
Type:
Show Source
object
-
applicationLink:
object IdNameLink
-
bindingType:
string
Allowed Values:
[ "BOUND", "NODE_SET_BOUND", "HIERARCHY_SET_BOUND", "NODE_TYPE_BOUND", "PARTIAL_NODE_TYPE_BOUND", "MAPPING_BOUND", "UNBOUND" ]
-
blockoutConfiguration:
object BlockoutConfiguration
-
compatibleDimensions:
array compatibleDimensions
Unique Items Required:
true
-
completenessError:
string
-
createdBy:
string
This property is now deprecated and will be removed in 10/2020. Use createdByUser instead.
-
createdByUser:
object User
-
description:
string
-
dimensionLink:
object IdNameLink
-
hasHierarchy:
boolean
-
hierarchySetLink:
object IdNameLink
-
id:
string(uuid)
-
isBound:
boolean
Read Only:
true
-
label:
string
-
layoutOptions:
object layoutOptions
Additional Properties Allowed: additionalProperties
-
links:
array links
-
loadHistory:
array loadHistory
-
modifiedBy:
string
This property is now deprecated and will be removed in 10/2020. Use modifiedByUser instead.
-
modifiedByUser:
object User
-
name:
string
-
nodeSetLink:
object IdNameLink
-
nodeTypeAssignments:
array nodeTypeAssignments
-
objectStatus:
string
Allowed Values:
[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Unique Items Required:
true
-
properties:
array properties
-
propertiesByNodeType:
array propertiesByNodeType
-
propertyOverrides:
object propertyOverrides
Additional Properties Allowed: ViewpointPropertyOverride
- related: object Related
-
scope:
string
Allowed Values:
[ "MASTER", "APPLICATION" ]
-
sortOrder:
integer(int32)
-
timeCreated:
integer(int64)
-
timeLabel:
object IdNameDescription
-
timeLabelUri:
string
-
timeModified:
integer(int64)
-
usesCustomSortOrder:
boolean
-
viewDescription:
string
-
viewId:
string(uuid)
-
viewName:
string
-
viewpointClass:
string
Allowed Values:
[ "NORMAL", "TIME_LABELED" ]
-
viewStatus:
string
Allowed Values:
[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
Nested Schema : Artifact
Type:
Show Source
object
-
id:
string(uuid)
-
name:
string
-
type:
string
Allowed Values:
[ "CLUSTER", "CARD" ]
Nested Schema : BlockoutConfiguration
Type:
Show Source
object
-
enableBlockout:
boolean
-
end:
integer(int64)
-
grantPermissionsAllowedToCommit:
array grantPermissionsAllowedToCommit
-
lockUnboundObjects:
boolean
-
recurringBlockoutData:
object RecurringBlockoutData
-
source:
string
Allowed Values:
[ "APPLICATION", "DIMENSION" ]
-
start:
integer(int64)
-
timeZone:
object ZoneId
-
type:
string
Allowed Values:
[ "SPECIFIED", "RECURRING" ]
Nested Schema : DimensionImportExportSettings
Type:
object
Discriminator:
type
Dimension Import/Export settings
Show Source
-
type(required):
string
Read Only:
true
Allowed Values:[ "DEFAULT", "FCGL" ]
Type is set to "DEFAULT" for standard settings, "FCGL" for Financial Cloud Import/Export options.
Nested Schema : permittedActions
Type:
array
Read Only:
true
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : DimensionBinding
Type:
Show Source
object
-
bindingType:
string
Read Only:
true
-
description:
string
Read Only:
true
-
id:
string(uuid)
Read Only:
true
-
lastExportInfo:
object DimensionSyncHistory
-
lastImportInfo:
object DimensionSyncHistory
-
links:
array links
Read Only:
true
-
name:
string
Read Only:
true
-
slotAnswers:
string
Read Only:
true
-
supportsSettings:
boolean
Read Only:
true
-
view:
object IdNameLink
-
viewpoint:
object IdNameLink
Nested Schema : DimensionSyncHistory
Type:
Show Source
object
-
connectionId:
string(uuid)
-
connectionName:
string
-
direction:
string
Allowed Values:
[ "BOTH", "IMPORT", "EXPORT", "NONE" ]
-
endTime:
integer(int64)
-
importOption:
string
Allowed Values:
[ "ResetDimension", "ReplaceNodes", "Merge" ]
-
links:
array links
-
messages:
array messages
-
publicApiFlag:
boolean
-
ranBy:
string
-
requestId:
string(uuid)
-
requestSummary:
object Request
A Request models changes to apply to a View
-
startTime:
integer(int64)
-
status:
string
Allowed Values:
[ "PENDING", "COMPLETED", "ERROR", "RUNNING" ]
-
success:
boolean
-
syncDescription:
string
-
syncId:
string(uuid)
-
syncType:
string
Allowed Values:
[ "FULL", "INCREMENTAL" ]
-
taskHistory:
array taskHistory
Nested Schema : Request
Type:
object
A Request models changes to apply to a View
Show Source
-
actionCount:
integer(int32)
Read Only:
true
-
ageInDays:
integer(int64)
Read Only:
true
-
approvalUsers:
array approvalUsers
Read Only:
true
-
assignedTo:
string
Read Only:
true
This property is now deprecated and will be removed in 10/2020. Use assignedToUser instead. -
assignedToUser:
object User
-
attachmentCount:
integer(int32)
Read Only:
true
-
autoSubmitted:
boolean
-
blockedUntil:
integer(int64)
Read Only:
true
-
commentCount:
integer(int32)
Read Only:
true
-
commitUsers:
array commitUsers
Read Only:
true
-
consolidationRequest:
object IdNameDescription
-
consolidationRequestNumber:
integer(int32)
Read Only:
true
-
consolidationRequestStatus:
string
Read Only:
true
Allowed Values:[ "DRAFT", "IN_FLIGHT", "PULLED_BACK", "PUSHED_BACK", "COMPLETED", "REJECTED", "WITHDRAWN", "RECALLED", "BLOCKED", "CONSOLIDATED" ]
-
createdBy:
string
Read Only:
true
This property is now deprecated and will be removed in 10/2020. Use createdByUser instead. -
createdByUser:
object User
-
description:
string
Read Only:
true
-
hasViewAccess:
boolean
Read Only:
true
-
id:
string(uuid)
Read Only:
true
-
initialSubmit:
integer(int64)
Read Only:
true
-
inviteeUsers:
array inviteeUsers
Read Only:
true
-
itemCount:
integer(int32)
Read Only:
true
-
links:
array links
Read Only:
true
-
modifiedBy:
string
Read Only:
true
This property is now deprecated and will be removed in 10/2020. Use modifiedByUser instead. -
modifiedByUser:
object User
-
notes:
string
Read Only:
true
-
origin:
string
Read Only:
true
Allowed Values:[ "DEFINED", "INSTRUCTIVE", "INTERACTIVE", "MEMBERSHIP", "NOTIFICATION", "REMEDIATION", "SUBSCRIPTION", "CONSOLIDATION", "IMPORT", "LOAD" ]
-
owner:
object User
-
priority:
string
Read Only:
true
Allowed Values:[ "NONE", "LOW", "MEDIUM", "HIGH" ]
-
requestNumber:
integer(int32)
Read Only:
true
-
requestType:
string
Read Only:
true
Allowed Values:[ "DEFINED", "INSTRUCTIVE", "INTERACTIVE", "MEMBERSHIP", "NOTIFICATION", "REMEDIATION", "SUBSCRIPTION", "CONSOLIDATION", "IMPORT", "LOAD" ]
-
sourceRequest:
object IdNameLink
-
stage:
string
Read Only:
true
Allowed Values:[ "SUBMIT", "REVIEW", "ENRICH", "APPROVE", "COMMIT", "CLOSED" ]
-
status:
string
Read Only:
true
Allowed Values:[ "DRAFT", "IN_FLIGHT", "PULLED_BACK", "PUSHED_BACK", "COMPLETED", "REJECTED", "WITHDRAWN", "RECALLED", "BLOCKED", "CONSOLIDATED" ]
-
submittedBy:
string
Read Only:
true
This property is now deprecated and will be removed in 10/2020. Use submittedByUser instead. -
submittedByUser:
object User
-
subscriptions:
array subscriptions
Read Only:
true
-
timeCreated:
integer(int64)
Read Only:
true
-
timeModified:
integer(int64)
Read Only:
true
-
timeSubmitted:
integer(int64)
Read Only:
true
-
title:
string
Read Only:
true
-
validationErrorCount:
integer(int32)
Read Only:
true
-
validTransitionActions:
array validTransitionActions
Read Only:
true
-
valWarningCountOnClose:
integer(int32)
Read Only:
true
If the request is closed, the number of validation warnings that existed, and were allowed, at the time it was closed. -
viewId:
string(uuid)
Read Only:
true
-
viewName:
string
Read Only:
true
-
viewStatus:
string
Read Only:
true
Allowed Values:[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
Nested Schema : validTransitionActions
Type:
array
Read Only:
Show Source
true
-
Array of:
string
Allowed Values:
[ "SUBMIT", "APPROVE", "PUSHBACK", "REJECT", "WITHDRAW", "RECALL", "COMMIT", "CLOSE" ]
Nested Schema : DimensionSyncTaskHistory
Type:
Show Source
object
-
duration:
string
Read Only:
true
-
endTime:
integer(int64)
-
messages:
array messages
-
startTime:
integer(int64)
-
status:
string
Allowed Values:
[ "PENDING", "COMPLETED", "ERROR", "RUNNING" ]
-
syncId:
string(uuid)
-
taskKey:
string
Read Only:
true
-
taskName:
string
Nested Schema : grantPermissionsAllowedToCommit
Type:
Show Source
array
-
Array of:
string
Allowed Values:
[ "OWNER", "DATAMANAGER", "PARTICIPANT", "APPROVER", "NOTIFIED", "COMMITTER", "NONE", "METADATAMANAGER" ]
Nested Schema : RecurringBlockoutData
Type:
Show Source
object
-
beginOffset:
integer(int32)
-
end:
integer(int64)
-
endOffset:
integer(int32)
-
rollingUnit:
string
Allowed Values:
[ "NONE", "END_OF_MONTH", "END_OF_YEAR", "END_OF_QUARTER", "FISCAL_QUARTER_END", "FISCAL_YEAR_END" ]
-
start:
integer(int64)
-
timeOfDay:
string
Nested Schema : ZoneOffsetTransitionRule
Type:
Show Source
object
-
dayOfMonthIndicator:
integer(int32)
-
dayOfWeek:
string
Allowed Values:
[ "MONDAY", "TUESDAY", "WEDNESDAY", "THURSDAY", "FRIDAY", "SATURDAY", "SUNDAY" ]
-
localTime:
object LocalTime
-
midnightEndOfDay:
boolean
-
month:
string
Allowed Values:
[ "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" ]
-
offsetAfter:
object ZoneOffset
-
offsetBefore:
object ZoneOffset
-
standardOffset:
object ZoneOffset
-
timeDefinition:
string
Allowed Values:
[ "UTC", "WALL", "STANDARD" ]
Nested Schema : ValidationSetting
Type:
Show Source
object
-
approveSeverity:
string
Allowed Values:
[ "ERROR", "WARNING", "IGNORE" ]
-
commitSeverity:
string
Allowed Values:
[ "ERROR", "WARNING", "IGNORE" ]
-
description:
string
-
executionState:
string
Allowed Values:
[ "ENABLED", "DISABLED" ]
-
id:
string
-
name:
string
-
submitSeverity:
string
Allowed Values:
[ "ERROR", "WARNING", "IGNORE" ]
-
validationScope:
string
Allowed Values:
[ "APPLICATION", "NODE_TYPE", "HIERARCHY_SET", "DIMENSION", "ADAPTER" ]
-
viewpointSeverity:
string
Allowed Values:
[ "ERROR", "WARNING", "IGNORE" ]
Nested Schema : JsonNode
Type:
object
Nested Schema : GlobalConnection
Type:
Show Source
object
-
connectionDetails:
object Global Connection Details
Discriminator:
type
The details specific to this connection type. All connection types include "type", the type of the connection, see the 'type' object for allowed values, "url", the updated url for the connection, "username", the updated username for the connection, and "password", the updated password for the connection. EPM connections also include "identityDomain", the updated identity domain for the connection, and "folder", the updated epm folder. UCM connections also include "identityDomain", the updated identity domain for the connection, and "defaultDocumentAccount", the updated default document account. Oracle Object Store connections also include "defaultBucket", the updated name of the default target bucket and "defaultBucket", an optional parameter for the sub folder in the target bucket. -
connectionType:
string
Read Only:
true
Allowed Values:[ "ORACLE_OBJECT_STORE", "UCM", "EPM" ]
-
createdByUser:
object User
-
description:
string
Read Only:
true
-
id:
string(uuid)
Read Only:
true
-
links:
array links
Read Only:
true
-
modifiedByUser:
object User
-
name:
string
Read Only:
true
-
supportedApplications:
array supportedApplications
Read Only:
true
-
timeCreated:
integer(int64)
Read Only:
true
-
timeModified:
integer(int64)
Read Only:
true
Nested Schema : Global Connection Details
Type:
object
Discriminator:
type
The details specific to this connection type. All connection types include
"type", the type of the connection, see the 'type' object for allowed values,
"url", the updated url for the connection,
"username", the updated username for the connection, and
"password", the updated password for the connection.
EPM connections also include
"identityDomain", the updated identity domain for the connection, and
"folder", the updated epm folder.
UCM connections also include
"identityDomain", the updated identity domain for the connection, and
"defaultDocumentAccount", the updated default document account.
Oracle Object Store connections also include
"defaultBucket", the updated name of the default target bucket and
"defaultBucket", an optional parameter for the sub folder in the target bucket.
Show Source
-
type(required):
string
Read Only:
true
Allowed Values:[ "ORACLE_OBJECT_STORE", "EPM", "UCM" ]
Type is set to "EPM" for Oracle EPM Cloud connections, "UCM" for Oracle ERP Cloud connections and "ORACLE_OBJECT_STORE" for Oracle Object Store connections.
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : UsersBrowseFilter
Type:
Show Source
object
-
filterType:
string
Allowed Values:
[ "INCLUDE", "EXCLUDE", "NONE" ]
-
userGroups:
array userGroups
Unique Items Required:
true
-
users:
array users
Unique Items Required:
true
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : Related
Type:
Show Source
object
-
hierarchySets:
array hierarchySets
Unique Items Required:
true
-
nodeSets:
array nodeSets
Unique Items Required:
true
-
nodeTypes:
array nodeTypes
Unique Items Required:
true
-
viewpoints:
array viewpoints
Unique Items Required:
true
Nested Schema : ViewpointLoadHistory
Type:
Show Source
object
-
connectionId:
string(uuid)
-
connectionName:
string
-
endTime:
integer(int64)
-
importOption:
string
Allowed Values:
[ "ResetDimension", "ReplaceNodes", "Merge" ]
-
links:
array links
-
loadId:
string(uuid)
-
messages:
array messages
-
ranBy:
string
-
startTime:
integer(int64)
-
status:
string
Allowed Values:
[ "PENDING", "COMPLETED", "ERROR", "RUNNING" ]
-
syncDescription:
string
-
syncId:
string(uuid)
Nested Schema : Property
Type:
Show Source
object
-
aggregateDefaultType:
string
Read Only:
true
-
aggregateInheritanceMode:
string
Read Only:
true
Allowed Values:[ "NONE", "POSITIONAL" ]
-
allowBlankEntry:
boolean
Read Only:
true
-
allowedValues:
array allowedValues
Read Only:
true
-
allowedValuesUsed:
boolean
Read Only:
true
-
dataType:
string
Read Only:
true
-
defaultOnly:
boolean
Read Only:
true
-
defaultType:
string
Read Only:
true
-
defaultValue:
object defaultValue
Read Only:
true
-
description:
string
-
hasDerivedOverride:
boolean
-
id:
string(uuid)
Read Only:
true
-
inheritanceMode:
string
Read Only:
true
Allowed Values:[ "NONE", "POSITIONAL" ]
-
isValidForConstraint:
boolean
Read Only:
true
-
level:
string
Read Only:
true
-
links:
array links
Read Only:
true
-
name:
string
-
namespace:
string
Read Only:
true
-
overrides:
array overrides
-
parameters:
array parameters
Read Only:
true
-
permittedActions:
array permittedActions
Unique Items Required:
true
-
sortOrder:
integer(int32)
Read Only:
true
-
templateMode:
string
Read Only:
true
Nested Schema : defaultValue
Type:
object
Read Only:
true
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : AllowedPropertyValue
Type:
Show Source
object
-
label:
string
Read Only:
true
-
value:
object value
Read Only:
true
Nested Schema : value
Type:
object
Read Only:
true
Nested Schema : ApplicationOverride
Type:
Show Source
object
-
allowBlankEntry:
boolean
Read Only:
true
-
allowedPropertyValues:
array allowedPropertyValues
-
allowedValuesUsed:
boolean
Read Only:
true
-
application:
object IdNameLink
-
defaultOnly:
boolean
Read Only:
true
-
defaultType:
string
Read Only:
true
Allowed Values:[ "NONE", "SPECIFIED", "SYSTEM", "DERIVED", "CALC_AND_STORE", "DERIVED_AND_STORED" ]
-
defaultValue:
object defaultValue
Read Only:
true
-
inheritanceMode:
string
Read Only:
true
Allowed Values:[ "NONE", "POSITIONAL" ]
-
links:
array links
Read Only:
true
-
lockOnCommit:
boolean
Read Only:
true
-
nodeTypeOverrides:
array nodeTypeOverrides
Read Only:
true
-
parameterValues:
array parameterValues
Nested Schema : defaultValue
Type:
object
Read Only:
true
Nested Schema : value
Type:
object
Nested Schema : NodeTypeProperties
Type:
Show Source
object
-
nodeTypeUri:
string
-
propertyIds:
array propertyIds
Unique Items Required:
true
Nested Schema : hierarchySets
Type:
array
Unique Items Required:
Show Source
true
-
Array of:
object HierarchySet
Hierarchy Set model that would be returned as response
Nested Schema : nodeSets
Type:
array
Unique Items Required:
Show Source
true
-
Array of:
object NodeSet
Node Set model that would be returned as response
Nested Schema : HierarchySet
Type:
object
Hierarchy Set model that would be returned as response
Show Source
- allowSharedNodes: boolean
-
application:
object Application
-
assignedNodeTypes:
array assignedNodeTypes
-
bindingType:
string
Allowed Values:
[ "BOUND", "NODE_SET_BOUND", "HIERARCHY_SET_BOUND", "NODE_TYPE_BOUND", "PARTIAL_NODE_TYPE_BOUND", "MAPPING_BOUND", "UNBOUND" ]
-
bottomNodeSort:
string
Allowed Values:
[ "ALPHANUMERIC", "CUSTOM" ]
-
completenessError:
string
-
createdByUser:
object User
-
description:
string
-
dimension:
object Dimension
Dimension model that would be returned as response
- dimensionSectionAllowedSharedNodes: boolean
-
groupingType:
string
Allowed Values:
[ "DEFAULT", "PARENT_NODE_FIRST" ]
-
id:
string(uuid)
-
isBound:
boolean
Read Only:
true
-
links:
array links
-
mappingBound:
boolean
-
modifiedByUser:
object User
-
name:
string
-
objectStatus:
string
Allowed Values:
[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Unique Items Required:
true
- related: object Related
-
scope:
string
Allowed Values:
[ "MASTER", "APPLICATION" ]
-
timeCreated:
integer(int64)
-
timeModified:
integer(int64)
-
useCustomSortOrder:
boolean
Nested Schema : Application
Type:
Show Source
object
-
applicationMetadata:
object ApplicationMetadata
-
blockoutConfiguration:
object BlockoutConfiguration
-
connections:
string
-
createdBy:
string
This property is now deprecated and will be removed in 10/2020. Use createdByUser instead.
-
createdByUser:
object User
-
description:
string
-
dimensions:
array dimensions
-
hasPermissionToPrimaryView:
boolean
-
hasUnappliedAnswers:
boolean
-
id:
string(uuid)
-
inProgressSlotAnswers:
string
-
isBound:
boolean
Read Only:
true
-
links:
array links
-
modifiedBy:
string
This property is now deprecated and will be removed in 10/2020. Use modifiedByUser instead.
-
modifiedByUser:
object User
-
name:
string
-
objectStatus:
string
Allowed Values:
[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Unique Items Required:
true
-
primaryConnection:
object IdNameDescription
-
primaryView:
object IdNameLink
-
slotAnswers:
string
-
supportedDirection:
string
Allowed Values:
[ "BOTH", "IMPORT", "EXPORT", "NONE" ]
-
supportsConnections:
boolean
-
timeCreated:
integer(int64)
-
timeModified:
integer(int64)
-
type:
object ApplicationType
-
upgradeTargets:
array upgradeTargets
-
workflowDisabledOption:
object WorkflowDisabledOption
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : ApplicationMetadata
Type:
object
Nested Schema : dimensions
Type:
Show Source
array
-
Array of:
object Dimension
Dimension model that would be returned as response
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : WorkflowDisabledOption
Type:
Show Source
object
-
enabled:
boolean
-
submittedBy:
array submittedBy
Unique Items Required:
true
Nested Schema : HierarchySetNodeTypeAssignment
Type:
Show Source
object
-
allowedAsRoot:
boolean
Read Only:
true
-
allowedChildNodeTypes:
array allowedChildNodeTypes
Read Only:
true
-
alternateQualifiers:
array alternateQualifiers
-
application:
object Application
-
bindingType:
string
Read Only:
true
Allowed Values:[ "BOUND", "NODE_SET_BOUND", "HIERARCHY_SET_BOUND", "NODE_TYPE_BOUND", "PARTIAL_NODE_TYPE_BOUND", "MAPPING_BOUND", "UNBOUND" ]
-
childNodeTypeOption:
string
Read Only:
true
Allowed Values:[ "ALL", "NONE", "SPECIFIED" ]
-
class:
string
Read Only:
true
Allowed Values:[ "LOOKUP", "LEGACY_GL", "NORMAL", "USER", "USER_ROLLUP" ]
-
combination:
boolean
-
compatibleBoundHierarchySets:
array compatibleBoundHierarchySets
Unique Items Required:
true
-
compatibleBoundNodeSets:
array compatibleBoundNodeSets
Unique Items Required:
true
-
converters:
array converters
-
createdByUser:
object User
-
defaultQualifier:
string
-
description:
string
Read Only:
true
-
dimension:
object Dimension
Dimension model that would be returned as response
-
id:
string(uuid)
Read Only:
true
-
isBound:
boolean
Read Only:
true
-
links:
array links
Read Only:
true
-
modifiedByUser:
object User
-
name:
string
Read Only:
true
-
objectStatus:
string
Read Only:
true
Allowed Values:[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Unique Items Required:
true
-
propertyDefinitions:
array propertyDefinitions
-
qualifierPosition:
string
Allowed Values:
[ "PREFIX", "SUFFIX" ]
- related: object Related
-
scope:
string
Read Only:
true
Allowed Values:[ "MASTER", "APPLICATION" ]
-
sortOrder:
integer(int32)
Read Only:
true
-
timeCreated:
integer(int64)
Read Only:
true
-
timeModified:
integer(int64)
Read Only:
true
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : SimpleNodeType
Type:
Show Source
object
-
application:
object IdNameLink
-
description:
string
Read Only:
true
-
id:
string(uuid)
-
links:
array links
-
name:
string
-
nodeTypeClass:
string
Allowed Values:
[ "LOOKUP", "LEGACY_GL", "NORMAL", "USER", "USER_ROLLUP" ]
-
properties:
array properties
Nested Schema : NodeTypeProperty
Type:
Show Source
object
-
dataType:
string
Read Only:
true
-
defaultOnly:
boolean
Read Only:
true
-
deletable:
boolean
Read Only:
true
-
description:
string
Read Only:
true
-
id:
string(uuid)
Read Only:
true
-
links:
array links
Read Only:
true
-
name:
string
Read Only:
true
-
namespace:
string
Read Only:
true
-
queryable:
boolean
Read Only:
true
-
required:
boolean
Read Only:
true
-
sortOrder:
integer(int32)
Read Only:
true
Nested Schema : NodeSet
Type:
object
Node Set model that would be returned as response
Show Source
-
application:
object Application
-
bindingType:
string
Allowed Values:
[ "BOUND", "NODE_SET_BOUND", "HIERARCHY_SET_BOUND", "NODE_TYPE_BOUND", "PARTIAL_NODE_TYPE_BOUND", "MAPPING_BOUND", "UNBOUND" ]
-
completenessError:
string
-
createdByUser:
object User
-
description:
string
-
dimension:
object Dimension
Dimension model that would be returned as response
-
hierarchySet:
object HierarchySet
Hierarchy Set model that would be returned as response
-
id:
string(uuid)
-
isBound:
boolean
Read Only:
true
-
links:
array links
-
modifiedByUser:
object User
-
name:
string
-
nodeTypes:
array nodeTypes
-
objectStatus:
string
Allowed Values:
[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Unique Items Required:
true
-
predicate:
string
- related: object Related
-
scope:
string
Allowed Values:
[ "MASTER", "APPLICATION" ]
-
sourceType:
string
-
timeCreated:
integer(int64)
-
timeModified:
integer(int64)
-
topNodes:
array topNodes
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : NodeType
Type:
Show Source
object
-
alternateQualifiers:
array alternateQualifiers
-
application:
object Application
-
bindingType:
string
Allowed Values:
[ "BOUND", "NODE_SET_BOUND", "HIERARCHY_SET_BOUND", "NODE_TYPE_BOUND", "PARTIAL_NODE_TYPE_BOUND", "MAPPING_BOUND", "UNBOUND" ]
-
class:
string
Read Only:
true
Allowed Values:[ "LOOKUP", "LEGACY_GL", "NORMAL", "USER", "USER_ROLLUP" ]
-
combination:
boolean
-
compatibleBoundHierarchySets:
array compatibleBoundHierarchySets
Unique Items Required:
true
-
compatibleBoundNodeSets:
array compatibleBoundNodeSets
Unique Items Required:
true
-
converters:
array converters
-
createdByUser:
object User
-
defaultQualifier:
string
-
description:
string
-
dimension:
object Dimension
Dimension model that would be returned as response
-
id:
string(uuid)
-
isBound:
boolean
Read Only:
true
-
links:
array links
-
modifiedByUser:
object User
-
name:
string
-
objectStatus:
string
Allowed Values:
[ "DRAFT", "ACTIVE", "SUNSET", "ARCHIVED", "DELETED" ]
-
permittedActions:
array permittedActions
Unique Items Required:
true
-
propertyDefinitions:
array propertyDefinitions
-
qualifierPosition:
string
Allowed Values:
[ "PREFIX", "SUFFIX" ]
- related: object Related
-
scope:
string
Allowed Values:
[ "MASTER", "APPLICATION" ]
-
timeCreated:
integer(int64)
-
timeModified:
integer(int64)
Nested Schema : permittedActions
Type:
array
Unique Items Required:
Show Source
true
-
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", "UPDATE_VISIBILITY", "COPY", "QUERY", "RUN_EXTRACT_PACKAGE", "CREATE_EXTRACT_PACKAGE" ]
Nested Schema : Node
Type:
Show Source
object
-
childCount:
integer(int32)
-
description:
string
-
hasChildren:
boolean
-
id:
string(uuid)
-
links:
array links
-
location:
string
This property is now deprecated and will be removed in 10/2020. Use path instead.
-
locationsByParentId:
object locationsByParentId
Additional Properties Allowed: additionalPropertiesThis property is now deprecated and will be removed in 10/2020. Use path instead.
-
name:
string
-
nodeType:
object IdNameLink
-
parentName:
string
-
parentNodeId:
string(uuid)
-
parentNodeTypeId:
string(uuid)
-
path:
array path
-
relationshipId:
string(uuid)
-
requestItem:
object RequestItem
A Request Item is a collection of actions to apply to a particular node as part of aRequest
-
targetForNodeProperty:
boolean
Nested Schema : locationsByParentId
Type:
object
Additional Properties Allowed
Show Source
This property is now deprecated and will be removed in 10/2020. Use path instead.
Nested Schema : RequestItem
Type:
object
A Request Item is a collection of actions to apply to a particular node as part of aRequest
Show Source
-
actionCount:
integer(int32)
-
actions:
array actions
-
actionSummary:
string
-
applicationName:
string
-
createdBy:
string
-
description:
string
-
id:
string(uuid)
-
links:
array links
-
modifiedBy:
string
-
name:
string
-
nodeTypeId:
string(uuid)
-
nodeTypeName:
string
-
policies:
array policies
-
timeCreated:
integer(int64)
-
timeModified:
integer(int64)
-
validations:
array validations
Nested Schema : validations
Type:
Show Source
array
-
Array of:
object ValidationResult
The result of validation
Nested Schema : Action
Type:
Show Source
object
-
extendedProperties:
object JsonNode
-
id:
string(uuid)
Read Only:
true
-
layoutOptions:
object layoutOptions
Additional Properties Allowed: additionalProperties
-
links:
array links
-
nodeTypeName:
string
-
parentName:
string
-
parentNodeId:
string(uuid)
id of the parent node this action was performed under, if any
-
propertyLevel:
string
-
summary:
string
-
type:
string
Read Only:
true
Allowed Values:[ "addNode", "insertNode", "removeNode", "moveNode", "deleteNode", "renameNode", "updateNodeProp", "reorderNode" ]
-
viewpointId:
string(uuid)
-
viewpointName:
string
-
viewpointUri:
string
Read Only:
true
Nested Schema : PolicyInfo
Type:
Show Source
object
-
policyId:
string(uuid)
-
policyType:
string
Allowed Values:
[ "APPROVAL", "NOTIFY", "COMMIT" ]
Nested Schema : ValidationResult
Type:
object
The result of validation
Show Source
-
code:
string
-
links:
array links
-
message:
string
-
responsibleUserId:
string(uuid)
-
severity:
string
Allowed Values:
[ "ERROR", "WARNING", "IGNORE" ]
The severity of the validation issue (ERROR or WARNING) for the stage at which the validation failed. -
timeCreated:
integer(int64)
-
type:
string
Allowed Values:
[ "ERROR" ]
-
userCanResolve:
boolean
Examples
The following example shows how to update an extract's connection by submitting a GET request on the REST resource using cURL.
cURL Command
curl --user epm_cloud_user -X GET -H 'Content-Type: application/json' -d
@example_request_payload.json https://servername.fa.us2.oraclecloud.com/epm/rest/v1/extracts/?q=view::71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0
Example of Response Body
The following shows an example of the response body in JSON format.
{ "items": [ { "id": "791de1e6-4a1a-4ead-93b5-c5492f608fde", "name": "AHC Account - non cash", "description": "AHC_ACCOUNT_NON_CASH Map natural account by line type and loan type", "extractConnection": { "connectionSummary": { "id": "b3ee4f46-9b49-4422-b8b5-7113038e7015", "name": "Fusion", "description": "Fusion", "connectionType": "UCM", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/globalConnections/b3ee4f46-9b49-4422-b8b5-7113038e7015" }, { "rel": "delete", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/globalConnections/b3ee4f46-9b49-4422-b8b5-7113038e7015", "method": "DELETE" } ] }, "connectionOptions": { "defaultDocumentAccount": "fin/fusionAccountingHub/import" } }, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/791de1e6-4a1a-4ead-93b5-c5492f608fde" }, { "rel": "runExtract", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/791de1e6-4a1a-4ead-93b5-c5492f608fde/run", "method": "POST" }, { "rel": "extractHistory", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/791de1e6-4a1a-4ead-93b5-c5492f608fde/extractHistory?q=limit%3A%3A5", "templated": true }, { "rel": "edit", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/791de1e6-4a1a-4ead-93b5-c5492f608fde", "method": "PUT" }, { "rel": "delete", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/791de1e6-4a1a-4ead-93b5-c5492f608fde", "method": "DELETE" }, { "rel": "copy", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/791de1e6-4a1a-4ead-93b5-c5492f608fde/copy", "method": "POST" } ], "viewpoint": { "id": "a7556e2e-2c76-47b4-a18a-db576de1e92c", "name": "AHC Loans Non Cash", "description": "AHC Loans: Non Cash Mapping Sets", "hasHierarchy": true, "sortOrder": 3, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0/viewpoints/a7556e2e-2c76-47b4-a18a-db576de1e92c" } ], "usesCustomSortOrder": false, "isBound": false }, "view": { "id": "71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0", "name": "Mapping Sets", "description": "Mapping Sets", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0" } ] }, "application": { "id": "a3d7a580-17f1-4b0f-9549-cc9c16232f9e", "name": "Financials Cloud", "description": "Financials Cloud GL", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/applications/a3d7a580-17f1-4b0f-9549-cc9c16232f9e" } ] }, "dimension": { "id": "14b18bb1-945d-41d2-85c2-30bf3209ccbe", "name": "Mapping Sets", "description": "Mapping Sets", "dimensionType": "Unbound", "connected": false, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe" } ], "isBound": false, "canAddBinding": false, "supportsMapping": false, "supportsMappingExport": false, "supportsTemplateExport": true, "supportsExtracts": true }, "extractType": "DEFAULT", "fileName": "AHC-MapImport.csv", "createdByUser": { "id": "d93d33f8-f24e-4eaa-8c14-df45501d949a", "userName": "Casey.Brown", "fullName": "Casey.Brown", "firstName": "", "lastName": "", "emailAddresses": [], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/users/d93d33f8-f24e-4eaa-8c14-df45501d949a" } ], "nameInitials": "", "dataManagerOnAny": false }, "timeCreated": "2021-06-16T08:58:59.079Z", "modifiedByUser": { "id": "d93d33f8-f24e-4eaa-8c14-df45501d949a", "userName": "Casey.Brown", "fullName": "Casey.Brown", "firstName": "", "lastName": "", "emailAddresses": [], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/users/d93d33f8-f24e-4eaa-8c14-df45501d949a" } ], "nameInitials": "", "dataManagerOnAny": false }, "timeModified": "2021-10-26T23:39:45.293Z", "lastExtractInfo": { "ranBy": "Kerry.Lane", "startTime": "2021-07-17T01:52:48.772Z", "endTime": "2021-07-17T01:52:49.494Z", "success": true, "status": "PENDING", "connectionName": "Fusion", "messages": [ "0 records extracted." ], "extractType": "DEFAULT", "publicApiFlag": false }, "profileOwner": { "id": "83ed6845-5299-4dce-ad3f-81a92bcc0853", "userName": "@@sysadmin", "fullName": "System User", "firstName": "", "lastName": "", "emailAddresses": [], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/users/83ed6845-5299-4dce-ad3f-81a92bcc0853" } ], "nameInitials": "", "dataManagerOnAny": false }, "public": true }, { "id": "9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6", "name": "Cost Management Expense", "description": "CST_EXPENSE Mapping set created for account rule: Expense", "extractConnection": { "connectionSummary": { "id": "b3ee4f46-9b49-4422-b8b5-7113038e7015", "name": "Fusion", "description": "Fusion", "connectionType": "UCM", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/globalConnections/b3ee4f46-9b49-4422-b8b5-7113038e7015" }, { "rel": "delete", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/globalConnections/b3ee4f46-9b49-4422-b8b5-7113038e7015", "method": "DELETE" } ] }, "connectionOptions": { "defaultDocumentAccount": "fin/fusionAccountingHub/import" } }, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6" }, { "rel": "runExtract", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6/run", "method": "POST" }, { "rel": "extractHistory", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6/extractHistory?q=limit%3A%3A5", "templated": true }, { "rel": "edit", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6", "method": "PUT" }, { "rel": "delete", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6", "method": "DELETE" }, { "rel": "copy", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe/extracts/9beb7ffb-3779-4bb4-b8b9-6fe5b3f347a6/copy", "method": "POST" } ], "viewpoint": { "id": "58ef4757-c3c0-452e-873e-38d926a4b8c8", "name": "Cost Mgmt Expenses", "description": "Cost Management: Expenses Mapping Set", "hasHierarchy": true, "sortOrder": 5, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0/viewpoints/58ef4757-c3c0-452e-873e-38d926a4b8c8" } ], "usesCustomSortOrder": false, "isBound": false }, "view": { "id": "71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0", "name": "Mapping Sets", "description": "Mapping Sets", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/views/71ad7f6b-d313-4a82-956c-ecdbbc7b0ce0" } ] }, "application": { "id": "a3d7a580-17f1-4b0f-9549-cc9c16232f9e", "name": "Financials Cloud", "description": "Financials Cloud GL", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/applications/a3d7a580-17f1-4b0f-9549-cc9c16232f9e" } ] }, "dimension": { "id": "14b18bb1-945d-41d2-85c2-30bf3209ccbe", "name": "Mapping Sets", "description": "Mapping Sets", "dimensionType": "Unbound", "connected": false, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/dimensions/14b18bb1-945d-41d2-85c2-30bf3209ccbe" } ], "isBound": false, "canAddBinding": false, "supportsMapping": false, "supportsMappingExport": false, "supportsTemplateExport": true, "supportsExtracts": true }, "extractType": "DEFAULT", "fileName": "CMExp-MapImport.csv", "createdByUser": { "id": "d93d33f8-f24e-4eaa-8c14-df45501d949a", "userName": "Casey.Brown", "fullName": "Casey.Brown", "firstName": "", "lastName": "", "emailAddresses": [], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/users/d93d33f8-f24e-4eaa-8c14-df45501d949a" } ], "nameInitials": "", "dataManagerOnAny": false }, "timeCreated": "2021-06-16T09:57:25.631Z", "modifiedByUser": { "id": "d93d33f8-f24e-4eaa-8c14-df45501d949a", "userName": "Casey.Brown", "fullName": "Casey.Brown", "firstName": "", "lastName": "", "emailAddresses": [], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/users/d93d33f8-f24e-4eaa-8c14-df45501d949a" } ], "nameInitials": "", "dataManagerOnAny": false }, "timeModified": "2021-10-27T02:10:54.930Z", "lastExtractInfo": { "ranBy": "Casey.Brown", "startTime": "2021-06-16T21:28:34.831Z", "endTime": "2021-06-16T21:28:35.124Z", "success": true, "status": "PENDING", "messages": [ "55 records extracted." ], "extractType": "DEFAULT", "publicApiFlag": false }, "profileOwner": { "id": "83ed6845-5299-4dce-ad3f-81a92bcc0853", "userName": "@@sysadmin", "fullName": "System User", "firstName": "", "lastName": "", "emailAddresses": [], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/users/83ed6845-5299-4dce-ad3f-81a92bcc0853" } ], "nameInitials": "", "dataManagerOnAny": false }, "public": true } ], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/extracts" } ], "hasMore": false, "totalResults": 2, "limit": 0, "count": 2 }