REST API for Oracle Healthcare Translational Research

Retrieve Subject Queries Status

get

/HSDataService-web/api/3.2.0/subjectapi/subjects/queries

This end point supports the retrieval of Subject Queries Status, Error Code, Error Message and other Status associated information.

Request

Supported Media Types

application/json
application/xml

Query Parameters

limit: Type: integer (int32)

Pagination query params: ?limit=2&offset=0
offset: Type: integer (int32)

Pagination query params: ?limit=2&offset=0

Response

Supported Media Types

application/json
application/xml

200 Response

successful operation

Body

Root Schema : APIQueryStatus

Type: object

Properties

cohortQueryName: Type: string
createdOnDate: Type: string (date-time)
executeAsync: Type: boolean

Default Value: false
minRetentionPeriodDays: Type: integer (int64)

Minimum Value: 0
queryCriteria: Type: object OracleDBQueryDS

Contains all the Query Criteria
queryExecutionStatus: Type: object QueryExecutionStatus
queryId: Type: integer (int64)
retentionDate: Type: string (date-time)

Nested Schema : OracleDBQueryDS

Type: object

Contains all the Query Criteria

Properties

allCriteriaList: Type: array allCriteriaList

Required: true

Minimum Number of Items: 1

Maximum Number of Items: 2147483647

List of Criteria Eg.DemographicsCriteria,MedicationCriteria,DiagnosisCriteria,SequenceVariantsCriteria,ConsentCriteria,DiagnosisCriteria,EncounterCriteria,ObservationCriteria,HistoryCriteria,ProceduresCriteria,SpecimenCriteria,StudyCriteria,MicroarrayExpressionCriteria,RNASeqExpressionCriteria,CopyNumberVariationCriteria,RelativeTimeEventsCriteria

Nested Schema : QueryExecutionStatus

Type: object

Properties

error: Type: object QueryJobError
links: Type: array links

A collection of links containing hrefs to query status and results
queryId: Type: integer (int64)
status: Type: string

Nested Schema : allCriteriaList

Type: array

Minimum Number of Items: 1

Maximum Number of Items: 2147483647

List of Criteria Eg.DemographicsCriteria,MedicationCriteria,DiagnosisCriteria,SequenceVariantsCriteria,ConsentCriteria,DiagnosisCriteria,EncounterCriteria,ObservationCriteria,HistoryCriteria,ProceduresCriteria,SpecimenCriteria,StudyCriteria,MicroarrayExpressionCriteria,RNASeqExpressionCriteria,CopyNumberVariationCriteria,RelativeTimeEventsCriteria

Items

Type: object criteria

Discriminator: type

Nested Schema : criteria

Type: object

Discriminator: type

Properties

exclude: Type: boolean

Default Value: false

Nested Schema : QueryJobError

Type: object

Properties

errorCode: Type: string
errorMessage: Type: string

Nested Schema : links

Type: array

A collection of links containing hrefs to query status and results

Example

{rel: 'status',href: '/patientapi/patients/queries/{id}'}

Items

Type: string

400 Response

Invalid request parameters

404 Response

Query status not found

Examples

The following example submits a GET request.

API URL

http://localhost:7001/HSDataService-web/api/3.2.0/subjectapi/subjects/queries

Example of Response Body

The following example shows the response returned in JSON format.

{
  "items": [
    {
      "createdOnDate": "02/10/2017",
      "retentionDate": "02/15/2017",
      "queryId": 1064,
      "queryExecutionStatus": {
        "status": "DONE",
        "links": [
          {
            "rel": "status",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1064"
          },
          {
            "rel": "result",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1064/data"
          }
        ]
      }
    },
    {
      "createdOnDate": "02/10/2017",
      "retentionDate": "02/15/2017",
      "queryId": 1063,
      "queryExecutionStatus": {
        "status": "DONE",
        "links": [
          {
            "rel": "status",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1063"
          },
          {
            "rel": "result",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1063/data"
          }
        ]
      }
    },
    {
      "createdOnDate": "02/10/2017",
      "retentionDate": "02/15/2017",
      "queryId": 1032,
      "queryExecutionStatus": {
        "status": "DONE",
        "links": [
          {
            "rel": "status",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1032"
          },
          {
            "rel": "result",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1032/data"
          }
        ]
      }
    },
    {
      "createdOnDate": "02/10/2017",
      "retentionDate": "02/15/2017",
      "queryId": 1031,
      "queryExecutionStatus": {
        "status": "DONE",
        "links": [
          {
            "rel": "status",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1031"
          },
          {
            "rel": "result",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/1031/data"
          }
        ]
      }
    },
    {
      "createdOnDate": "02/14/2017",
      "retentionDate": "02/19/2017",
      "queryId": 997,
      "queryExecutionStatus": {
        "status": "DONE",
        "links": [
          {
            "rel": "status",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/997"
          },
          {
            "rel": "result",
            "href": "/HSDataService-web/api/3.2.0/subjectapi/subjects/queries/997/data"
          }
        ]
      }
    }
  ],
  "count": 5,
  "hasMore": true,
  "links": [
    {
      "rel": "self",
      "href": "http://localhost:7001/HSDataService-web/api/3.2.0/subjectapi/subjects/queries?limit=5"
    },
    {
      "rel": "next",
      "href": "http://localhost:7001/HSDataService-web/api/3.2.0/subjectapi/subjects/queries?offset=5&limit=5"
    }
  ]
}