Get the result body of the job run with the given id

get

/epm/rest/v1/jobRuns/{jobRunId}/result

Request

Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Job result returned
Body ()
Information about the execution of a particular job
Root Schema : JobRunResult
Type: object
Information about the execution of a particular job
Show Source
Nested Schema : JsonNode
Type: object
Show Source

404 Response

Job result not found
Back to Top

Examples

The following example shows how to retrieve the results of a job run by submitting a get request on the REST resource using cURL.

cURL Command

curl --user epm_cloud_user -X GET \
  https://servername.fa.us2.oraclecloud.com/epm/rest/v1/jobRuns/c9f63edd-d2c8-4712-a1a0-43fc3a410f97/result

Example of Response Body

The following shows an example of the response body in JSON format.

{
    "id": "c9f63edd-d2c8-4712-a1a0-43fc3a410f97",
    "description": "Importing file 'RequestFileTest.xlsx' into request Automated Request (e1847bbc-f2d2-46a2-af3d-2dadcf9d7bd4) in view Corporate Planning (EPBCS)",
    "origin": "IMPORT_REQUEST",
    "status": "COMPLETED",
    "result": {
        "fileName": "RequestFileTest.xlsx",
        "sheets": [
            {
                "viewpointName": "Account",
                "viewpointDescription": "Account dimension for EPBCS",
                "sheetName": "Account",
                "invalidForLoad": false,
                "rowCount": 5,
                "columnCount": 5,
                "columns": [
                    {
                        "label": "Name",
                        "status": "OK",
                        "validationMessage": ""
                    },
                    {
                        "label": "Parent",
                        "status": "OK",
                        "validationMessage": ""
                    },
                    {
                        "label": "Description",
                        "status": "OK",
                        "validationMessage": ""
                    },
                    {
                        "label": "Node Type",
                        "status": "OK",
                        "validationMessage": ""
                    },
                    {
                        "label": "Parent Node Type",
                        "status": "OK"
                    }
                ],
                "rows": [
                    [
                        {
                            "value": "Acct1",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "A_All_Corp_Acct_V1",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK"
                        }
                    ],
                    [
                        {
                            "value": "Acct2",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "A_All_Corp_Acct_V1",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Acct2 Desc",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK"
                        }
                    ],
                    [
                        {
                            "value": "Acct3",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "A_All_Corp_Acct_V1",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Acct3 Desc",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK"
                        }
                    ],
                    [
                        {
                            "value": "Acct4",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "A_All_Corp_Acct_V1",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Acct4 Desc",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK"
                        }
                    ],
                    [
                        {
                            "value": "Acct5",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "A_All_Corp_Acct_V1",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Acct5 Desc",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK",
                            "validationMessage": ""
                        },
                        {
                            "value": "Account",
                            "status": "OK"
                        }
                    ]
                ]
            }
        ],
        "links": [
            {
                "rel": "request",
                "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests/e1847bbc-f2d2-46a2-af3d-2dadcf9d7bd4"
            },
            {
                "rel": "validate",
                "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests/e1847bbc-f2d2-46a2-af3d-2dadcf9d7bd4/validations"
            },
            {
                "rel": "attachment",
                "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/requests/e1847bbc-f2d2-46a2-af3d-2dadcf9d7bd4/attachments/b70919e7-5c07-466f-9989-6063fc59bf3e"
            }
        ]
    },
    "created": "2018-04-02T20:08:30.786Z",
    "createdBy": "dd3dd761-1a0e-4aea-9256-b2252145d9a6",
    "lastModified": "2018-04-02T20:08:31.407Z",
    "lastModifiedBy": "dd3dd761-1a0e-4aea-9256-b2252145d9a6",
    "links": [
        {
            "rel": "self",
            "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/jobRuns/c9f63edd-d2c8-4712-a1a0-43fc3a410f97/result"
        },
        {
            "rel": "jobRun",
            "href": "https://servername.fa.us2.oraclecloud.com/epm/rest/v1/jobRuns/c9f63edd-d2c8-4712-a1a0-43fc3a410f97"
        }
    ]
}
Back to Top