Pre-General Availability: 2022-08-18. This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Jump to

• Request
• Response

List Work Requests

get

/20211130/workRequests

Lists the work requests in a compartment.

Request

Query Parameters

• compartmentId: string
  Minimum Length: 1

  Maximum Length: 255

  The OCID of the compartment.
• limit: integer
  Minimum Value: 1

  Maximum Value: 1000

  The maximum number of items to return.

  Default Value: 100
• page: string
  Minimum Length: 1

  The page token representing the page at which to start retrieving results. This is usually retrieved from a previous list call.
• resourceId: string
  The ID of the resource affected by the work request.
• sortBy: string
  The field to sort by. Only one sort order may be provided. Default order for timeCreated is descending. Default order for displayName is ascending. If no value is specified timeCreated is default.

  Default Value: timeCreated

  Allowed Values: [ "timeCreated", "displayName" ]
• sortOrder: string
  The sort order to use, either 'asc' or 'desc'.

  Default Value: ASC

  Allowed Values: [ "ASC", "DESC" ]
• workRequestId: string
  The ID of the asynchronous work request.

Header Parameters

• opc-request-id: string
  The client request ID for tracing.

Back to Top

Response

Supported Media Types

• application/json

200 Response

The list is being retrieved.

Headers

• opc-next-page: string
  For pagination of a list of items. When paging through a list, if this header appears in the response, then a partial list might have been returned. Include this value as the `page` parameter for the subsequent GET request to get the next batch of items.
• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : WorkRequestSummaryCollection

Type: object

Results of a workRequest search. Contains both WorkRequest items and other information, such as metadata.

Show Source

• items: array items
  List of workRequestSummary objects.

{
    "type":"object",
    "description":"Results of a workRequest search. Contains both WorkRequest items and other information, such as metadata.",
    "required":[
        "items"
    ],
    "properties":{
        "items":{
            "description":"List of workRequestSummary objects.",
            "type":"array",
            "items":{
                "$ref":"#/definitions/WorkRequestSummary"
            }
        }
    }
}

Nested Schema : items

Type: array

List of workRequestSummary objects.

Show Source

• Array of: object WorkRequestSummary
  A summary of the status of a work request.

{
    "description":"List of workRequestSummary objects.",
    "type":"array",
    "items":{
        "$ref":"#/definitions/WorkRequestSummary"
    }
}

Nested Schema : WorkRequestSummary

Type: object

A summary of the status of a work request.

Show Source

• compartmentId: string
  The ocid of the compartment that contains the work request. Work requests should be scoped to the same compartment as the resource the work request affects. If the work request affects multiple resources, and those resources are not in the same compartment, it is up to the service team to pick the primary resource whose compartment should be used
• id: string
  The id of the work request.
• operationType: string
  Allowed Values: [ "CREATE_PROJECT", "UPDATE_PROJECT", "DELETE_PROJECT", "MOVE_PROJECT", "CREATE_TABLE", "UPDATE_TABLE", "DELETE_TABLE" ]

  Type of the work request
• percentComplete: number(float)
  Percentage of the request completed.
• resources: array resources
  The resources affected by this work request.
• status: string
  Allowed Values: [ "ACCEPTED", "IN_PROGRESS", "WAITING", "FAILED", "SUCCEEDED", "CANCELING", "CANCELED" ]

  Status of current work request.
• timeAccepted: string(date-time)
  The date and time the request was created, as described in [RFC 3339](https://tools.ietf.org/rfc/rfc3339), section 14.29.
• timeFinished(optional): string(date-time)
  The date and time the object was finished, as described in [RFC 3339](https://tools.ietf.org/rfc/rfc3339).
• timeStarted(optional): string(date-time)
  The date and time the request was started, as described in [RFC 3339](https://tools.ietf.org/rfc/rfc3339), section 14.29.

{
    "description":"A summary of the status of a work request.",
    "properties":{
        "operationType":{
            "type":"string",
            "x-obmcs-top-level-enum":"#/definitions/OperationType",
            "enum":[
                "CREATE_PROJECT",
                "UPDATE_PROJECT",
                "DELETE_PROJECT",
                "MOVE_PROJECT",
                "CREATE_TABLE",
                "UPDATE_TABLE",
                "DELETE_TABLE"
            ],
            "description":"Type of the work request"
        },
        "status":{
            "type":"string",
            "x-obmcs-top-level-enum":"#/definitions/OperationStatus",
            "enum":[
                "ACCEPTED",
                "IN_PROGRESS",
                "WAITING",
                "FAILED",
                "SUCCEEDED",
                "CANCELING",
                "CANCELED"
            ],
            "description":"Status of current work request."
        },
        "id":{
            "type":"string",
            "description":"The id of the work request."
        },
        "compartmentId":{
            "type":"string",
            "description":"The ocid of the compartment that contains the work request. Work requests should be scoped to\nthe same compartment as the resource the work request affects. If the work request affects multiple resources,\nand those resources are not in the same compartment, it is up to the service team to pick the primary\nresource whose compartment should be used\n"
        },
        "resources":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/WorkRequestResource"
            },
            "description":"The resources affected by this work request."
        },
        "percentComplete":{
            "type":"number",
            "format":"float",
            "description":"Percentage of the request completed."
        },
        "timeAccepted":{
            "type":"string",
            "format":"date-time",
            "description":"The date and time the request was created, as described in\n[RFC 3339](https://tools.ietf.org/rfc/rfc3339), section 14.29.\n"
        },
        "timeStarted":{
            "type":"string",
            "format":"date-time",
            "description":"The date and time the request was started, as described in [RFC 3339](https://tools.ietf.org/rfc/rfc3339),\nsection 14.29.\n"
        },
        "timeFinished":{
            "type":"string",
            "format":"date-time",
            "description":"The date and time the object was finished, as described in [RFC 3339](https://tools.ietf.org/rfc/rfc3339).\n"
        }
    },
    "required":[
        "operationType",
        "status",
        "id",
        "compartmentId",
        "resources",
        "percentComplete",
        "timeAccepted"
    ]
}

Nested Schema : resources

Type: array

The resources affected by this work request.

Show Source

• Array of: object WorkRequestResource
  A resource created or operated on by a work request.

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/WorkRequestResource"
    },
    "description":"The resources affected by this work request."
}

Nested Schema : WorkRequestResource

Type: object

A resource created or operated on by a work request.

Show Source

• actionType: string
  Allowed Values: [ "CREATED", "UPDATED", "DELETED", "IN_PROGRESS", "RELATED", "FAILED" ]

  The way in which this resource is affected by the work tracked in the work request. A resource being created, updated, or deleted will remain in the IN_PROGRESS state until work is complete for that resource at which point it will transition to CREATED, UPDATED, or DELETED, respectively.
• entityType: string
  The resource type the work request affects.
• entityUri(optional): string
  The URI path that the user can do a GET on to access the resource metadata
• identifier: string
  The identifier of the resource the work request affects.

{
    "description":"A resource created or operated on by a work request.",
    "properties":{
        "entityType":{
            "type":"string",
            "description":"The resource type the work request affects."
        },
        "actionType":{
            "description":"The way in which this resource is affected by the work tracked in the work request.\nA resource being created, updated, or deleted will remain in the IN_PROGRESS state until\nwork is complete for that resource at which point it will transition to CREATED, UPDATED,\nor DELETED, respectively.\n",
            "x-obmcs-top-level-enum":"#/definitions/ActionType",
            "enum":[
                "CREATED",
                "UPDATED",
                "DELETED",
                "IN_PROGRESS",
                "RELATED",
                "FAILED"
            ],
            "type":"string"
        },
        "identifier":{
            "type":"string",
            "description":"The identifier of the resource the work request affects."
        },
        "entityUri":{
            "type":"string",
            "description":"The URI path that the user can do a GET on to access the resource metadata"
        }
    },
    "required":[
        "actionType",
        "entityType",
        "identifier"
    ]
}

400 Response

Bad Request

Headers

• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : DefaultError

Type: object

Error Information.

Show Source

• code: string
  Minimum Length: 1

  Maximum Length: 255

  A short error code that defines the error, meant for programmatic parsing.
• message: string
  Minimum Length: 1

  Maximum Length: 1024

  A human-readable error string.

{
    "description":"Error Information.",
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "description":"A short error code that defines the error, meant for programmatic parsing.",
            "type":"string",
            "minLength":1,
            "maxLength":255
        },
        "message":{
            "description":"A human-readable error string.",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        }
    }
}

401 Response

Unauthorized

Headers

• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : DefaultError

Type: object

Error Information.

Show Source

• code: string
  Minimum Length: 1

  Maximum Length: 255

  A short error code that defines the error, meant for programmatic parsing.
• message: string
  Minimum Length: 1

  Maximum Length: 1024

  A human-readable error string.

{
    "description":"Error Information.",
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "description":"A short error code that defines the error, meant for programmatic parsing.",
            "type":"string",
            "minLength":1,
            "maxLength":255
        },
        "message":{
            "description":"A human-readable error string.",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        }
    }
}

404 Response

Not Found

Headers

• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : DefaultError

Type: object

Error Information.

Show Source

• code: string
  Minimum Length: 1

  Maximum Length: 255

  A short error code that defines the error, meant for programmatic parsing.
• message: string
  Minimum Length: 1

  Maximum Length: 1024

  A human-readable error string.

{
    "description":"Error Information.",
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "description":"A short error code that defines the error, meant for programmatic parsing.",
            "type":"string",
            "minLength":1,
            "maxLength":255
        },
        "message":{
            "description":"A human-readable error string.",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        }
    }
}

429 Response

Too Many Requests

Headers

• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : DefaultError

Type: object

Error Information.

Show Source

• code: string
  Minimum Length: 1

  Maximum Length: 255

  A short error code that defines the error, meant for programmatic parsing.
• message: string
  Minimum Length: 1

  Maximum Length: 1024

  A human-readable error string.

{
    "description":"Error Information.",
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "description":"A short error code that defines the error, meant for programmatic parsing.",
            "type":"string",
            "minLength":1,
            "maxLength":255
        },
        "message":{
            "description":"A human-readable error string.",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        }
    }
}

500 Response

Internal Server Error

Headers

• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : DefaultError

Type: object

Error Information.

Show Source

• code: string
  Minimum Length: 1

  Maximum Length: 255

  A short error code that defines the error, meant for programmatic parsing.
• message: string
  Minimum Length: 1

  Maximum Length: 1024

  A human-readable error string.

{
    "description":"Error Information.",
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "description":"A short error code that defines the error, meant for programmatic parsing.",
            "type":"string",
            "minLength":1,
            "maxLength":255
        },
        "message":{
            "description":"A human-readable error string.",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        }
    }
}

Default Response

Unknown Error

Headers

• opc-request-id: string
  Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.

Body ()

Root Schema : DefaultError

Type: object

Error Information.

Show Source

• code: string
  Minimum Length: 1

  Maximum Length: 255

  A short error code that defines the error, meant for programmatic parsing.
• message: string
  Minimum Length: 1

  Maximum Length: 1024

  A human-readable error string.

{
    "description":"Error Information.",
    "required":[
        "code",
        "message"
    ],
    "properties":{
        "code":{
            "description":"A short error code that defines the error, meant for programmatic parsing.",
            "type":"string",
            "minLength":1,
            "maxLength":255
        },
        "message":{
            "description":"A human-readable error string.",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        }
    }
}

Back to Top