GET
/
reviews
/
{id}
curl --request GET \
  --url https://use.hoop.dev/api/reviews/{id}
{
  "access_duration": 0,
  "created_at": "2024-07-25T15:56:35.317601Z",
  "id": "9F9745B4-C77B-4D52-84D3-E24F67E3623C",
  "input": "SELECT NOW()",
  "input_clientargs": [
    "-x"
  ],
  "org": "A72CF2A0-12D0-4E0D-A732-E34FFA3D9417",
  "review_connection": {
    "id": "20A5AABE-C35D-4F04-A5A7-C856EE6C7703",
    "name": "pgdemo"
  },
  "review_groups_data": [
    {
      "group": "sre",
      "id": "20A5AABE-C35D-4F04-A5A7-C856EE6C7703",
      "review_date": "2024-07-25T19:36:41Z",
      "reviewed_by": {
        "email": "john.wick@bad.org",
        "id": "D5BFA2DD-7A09-40AE-AFEB-C95787BA9E90",
        "name": "John Wick",
        "slack_id": "U053ELZHB53"
      },
      "status": "APPROVED"
    }
  ],
  "review_owner": {
    "email": "john.wick@bad.org",
    "id": "D5BFA2DD-7A09-40AE-AFEB-C95787BA9E90",
    "name": "John Wick",
    "slack_id": "U053ELZHB53"
  },
  "revoke_at": "",
  "session": "35DB0A2F-E5CE-4AD8-A308-55C3108956E5",
  "status": "PENDING",
  "type": "onetime"
}

Path Parameters

​
id
string
required

Resource identifier of the review

Response

200
application/json
OK
​
access_duration
integer
default:1800000000000

The amount of time (nanoseconds) to allow access to the connection. It's valid only for jit type reviews`

Example:

0

​
created_at
string

The time the resource was created

Example:

"2024-07-25T15:56:35.317601Z"

​
id
string

Reousrce identifier

Example:

"9F9745B4-C77B-4D52-84D3-E24F67E3623C"

​
input
string

The input that was issued when the resource was created

Example:

"SELECT NOW()"

​
input_clientargs
string[]

The client arguments when the resource was created

Example:
["-x"]
​
org
string

Organization identifier

Example:

"A72CF2A0-12D0-4E0D-A732-E34FFA3D9417"

​
review_connection
object

The review connection information

​
review_groups_data
object[]

Contains the groups that requires to approve this review

​
review_owner
object

Contains information about the owner of this resource

​
revoke_at
string

The time when this review was revoked

Example:

""

​
session
string

The id of session

Example:

"35DB0A2F-E5CE-4AD8-A308-55C3108956E5"

​
status
enum<string>

The status of the review

  • PENDING - The resource is waiting to be reviewed
  • APPROVED - The resource is fully approved
  • REJECTED - The resource is fully rejected
  • REVOKED - The resource was revoked after being approved
  • PROCESSING - The review is being executed
  • EXECUTED - The review was executed
  • UNKNOWN - Unable to know the status of the review
Available options:
PENDING,
APPROVED,
REJECTED,
REVOKED,
PROCESSING,
EXECUTED,
UNKNOWN
​
type
enum<string>

The type of this review

  • onetime - Represents a one time execution
  • jit - Represents a time based review
Available options:
jit,
onetime