REST API for Oracle Healthcare Translational Research

Retrieve Export Definitions for Export Identifiers

get

/HSDataService-web/api/3.2.0/exports

This endpoint supports the retrieval of Export Definitions for an Export Identifier, Start Date or End Date.

Request

Supported Media Types

application/json
application/xml

Query Parameters

endDate

Type: string

File Export End Date

id

Type: array

Required: true

Collection Format: multi

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

List of File Export Row IDs

Items

Type: integer (int64)

startDate

Type: string

File Export Start Date

Response

Supported Media Types

application/json
application/xml

200 Response

successful operation

Body

Root Schema : /paths/~1exports/get/responses/200/schema

Type: array

Items

Type: object OmicsExportDefinition

Nested Schema : OmicsExportDefinition

Type: object

Properties

alignmentId: Type: integer (int64)

Required: true

Alignment id.

Example: "alignmentId": 1
allDataOption: Type: boolean

Default Value: false

Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).

Example: false
anatomicalSiteCodes: Type: array anatomicalSiteCodes

List of anatomical site codes.
bedFileNameUploadService: Type: string

BED file contains genomic positions. Can be specified as {bucket name}/{object name} or {file name}. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).

Example: BedFileBucket/BedFileObjectName or BedFileName.txt
context: Type: string

Required: true

Sets the context as Patient or Subject.

Example: PATIENT or SUBJECT
fileWids: Type: array fileWids

List of file load record ids.
geneHugoNames: Type: array geneHugoNames

List of gene hugo names. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).
geneSetIds: Type: array geneSetIds

List of gene set ids. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).
genomicPosition: Type: array genomicPosition

Genomic positions. CHROMOSOME ID, START POSITION, END POSITION. START POSITION, END POSITION are optional. Can be sourced from Gene reference APIs or Genomic position APIs. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).
id: Type: object OdbIdentifier

Identifier assigned by a given system
link: Type: string

A link containing href to submit the file export job

Example: {rel: 'submit',href: '/exports/{exportId}/jobs'}
pathwayNames: Type: array pathwayNames

List of pathway names. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).
patientSubjectCohortListId: Type: integer (int64)

Record id of a saved list of patients or subjects. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence

Example: "patientSubjectCohortListId": 10000000635009
patientSubjectId: Type: array patientSubjectId

List of patient or subject record ids. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence
queryCriteria: Type: object OracleDBQueryDS

Contains all the Query Criteria
queryCriteriaJson: Type: string

Used to transfer query criteria JSON representation from web layer to ejb layer so the JSON can be persisted to support the Retrieve Export Definition API's the @GET export definition API's will return the JSON bound to this property as well as queryCriteria
queryName: Type: string

Cohort Explorer Query Name. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence

Example: "queryName" : "Variant_multipleRegions"
serviceProviderIdentifier: Type: string

The service provider identifier (a.k.a. namespace) to be used to find alias values.

Example: "serviceProviderIdentifier": "vcf"
specimenIdsCdm: Type: array specimenIdsCdm

List of specimen ids from CDM schema. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence
specimenIdsOdb: Type: array specimenIdsOdb

List of specimen ids from ODB schema. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence
specimenTypeCodes: Type: array specimenTypeCodes

List of specimen type codes.
studyNames: Type: array studyNames

List of study names.

Nested Schema : anatomicalSiteCodes

Type: array

List of anatomical site codes.

Example

"anatomicalSiteCodes": ["SPCMN_ANA_SITE_CD_CODE_7", "SPCMN_ANA_SITE_CD_CODE_4"]

Items

Type: string

Nested Schema : fileWids

Type: array

List of file load record ids.

Example

"fileWids" : [1,2]

Items

Type: integer (int64)

Nested Schema : geneHugoNames

Type: array

List of gene hugo names. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).

Example

"geneHugoNames": ["CASZ1","CAMTA1-IT1","RP3-453P22.2"]

Items

Type: string

Nested Schema : geneSetIds

Type: array

List of gene set ids. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).

Example

"geneSetIds" : [1,2]

Items

Type: integer (int64)

Nested Schema : genomicPosition

Type: array

Genomic positions. CHROMOSOME ID, START POSITION, END POSITION. START POSITION, END POSITION are optional. Can be sourced from Gene reference APIs or Genomic position APIs. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).

Example

"genomicPosition": [{
        "chromosomeId": 10,
        "startPosition": 89682891,
        "endPosition": 100682893
    }, {
        "chromosomeId": 7,
        "startPosition": 89682891
    }, {
        "chromosomeId": 5
    }]

Items

Type: object GenomicPositionFileExport

Nested Schema : OdbIdentifier

Type: object

Identifier assigned by a given system

Properties

system: Type: string

System which assigned this identifier
value: Type: string

Identifier value

Nested Schema : pathwayNames

Type: array

List of pathway names. Export definition must have either allDataOption or genomicPosition/bedFileNameUploadService or set of genes (geneHugoNames, pathwayNames, geneSetIds).

Example

"pathwayNames": ["PATHWAY1","PATHWAY2"]

Items

Type: string

Nested Schema : patientSubjectId

Type: array

List of patient or subject record ids. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence

Example

"patientSubjectId" : [1,2]

Items

Type: integer (int64)

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 : specimenIdsCdm

Type: array

List of specimen ids from CDM schema. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence

Example

"specimenIdsCdm" : [1,2]

Items

Type: integer (int64)

Nested Schema : specimenIdsOdb

Type: array

List of specimen ids from ODB schema. The export definition must have either a source of patients/subjects or a source of specimens. If both are provided the specimen source takes precedence

Example

"specimenIdsOdb" : [1,2]

Items

Type: integer (int64)

Nested Schema : specimenTypeCodes

Type: array

List of specimen type codes.

Example

"specimenTypeCodes": ["SPCMN_TYP_CD_FECAL", "SPCMN_TYP_CD_URNE"]

Items

Type: string

Nested Schema : studyNames

Type: array

List of study names.

Example

"studyNames": ["STUDY1","STUDY2"]

Items

Type: string

Nested Schema : GenomicPositionFileExport

Type: object

Properties

chromosomeId: Type: integer (int64)

Record identifier of the chromosome.
endPosition: Type: integer (int64)

Optional. End location of sequence
startPosition: Type: integer (int64)

Optional. Start location of sequence

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

Examples

The following example submits a GET request.

Example 1

http://localhost:7001/HSDataService-web/api/3.2.0/exports

Example of Response Body

The following example shows the response returned in JSON format.

[
  {
    "id": {
      "system": "ODB",
      "value": "940"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "ANKRD30BL"
    ],
    "alignmentId": 1,
    "patientSubjectId": [
      841,
      838
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/940/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "942"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "CCDC3",
      "OPTN"
    ],
    "versionId": 3,
    "alignmentId": 1,
    "patientSubjectId": [
      841
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/942/jobs"
    }
  }
]

Example 2

http://localhost:7001/HSDataService-web/api/3.2.0/exports?startDate=02/09/2017

Example of Response Body

The following example shows the response returned in JSON format.

[
  {
    "id": {
      "system": "ODB",
      "value": "1267"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "ANKRD30BL"
    ],
    "alignmentId": 1,
    "patientSubjectId": [
      841,
      838
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1267/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1268"
    },
    "context": "SUBJECT",
    "geneHugoNames": [
      "VAV2",
      "TTC34",
      "SLC9A1",
      "NSFP1",
      "EGFR"
    ],
    "alignmentId": 1,
    "specimenTypeCodes": [
      "SPCMN_TYP_CD_BLOOD"
    ],
    "anatomicalSiteCodes": [
      "SPCMN_ANA_SITE_CD_CODE_3"
    ],
    "studyNames": [
      "study1"
    ],
    "patientSubjectId": [
      1622,
      1634,
      1700,
      1682,
      1701
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1268/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1270"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "PIK3C2G",
      "RERGL"
    ],
    "alignmentId": 1,
    "specimenIdsOdb": [
      58
    ],
    "patientSubjectId": [
      817
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1270/jobs"
    }
  }
]

Example 3

http://localhost:7001/HSDataService-web/api/3.2.0/exports?startDate=02/09/2017&endDate=02/10/2017

Example of Response Body

The following example shows the response returned in JSON format.

[
  {
    "id": {
      "system": "ODB",
      "value": "1267"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "ANKRD30BL"
    ],
    "alignmentId": 1,
    "patientSubjectId": [
      841,
      838
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1267/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1268"
    },
    "context": "SUBJECT",
    "geneHugoNames": [
      "VAV2",
      "TTC34",
      "SLC9A1",
      "NSFP1",
      "EGFR"
    ],
    "alignmentId": 1,
    "specimenTypeCodes": [
      "SPCMN_TYP_CD_BLOOD"
    ],
    "anatomicalSiteCodes": [
      "SPCMN_ANA_SITE_CD_CODE_3"
    ],
    "studyNames": [
      "study1"
    ],
    "patientSubjectId": [
      1622,
      1634,
      1700,
      1682,
      1701
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1268/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1270"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "PIK3C2G",
      "RERGL"
    ],
    "alignmentId": 1,
    "specimenIdsOdb": [
      58
    ],
    "patientSubjectId": [
      817
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1270/jobs"
    }
  }
]

Example 4

http://localhost:7001/HSDataService-web/api/3.2.0/exports?id=1235&id=1236&startDate=02/01/2017&endDate=02/10/2017

Example of Response Body

The following example shows the response returned in JSON format.

[
  {
    "id": {
      "system": "ODB",
      "value": "1235"
    },
    "context": "SUBJECT",
    "genomicPosition": [
      {
        "chromosomeId": 12,
        "startPosition": 109578044,
        "endPosition": 109629995
      },
      {
        "chromosomeId": 12,
        "startPosition": 32866557,
        "endPosition": 32890685
      },
      {
        "chromosomeId": 12,
        "startPosition": 93210312,
        "endPosition": 93214560
      },
      {
        "chromosomeId": 12,
        "startPosition": 123327143,
        "endPosition": 123333065
      },
      {
        "chromosomeId": 12,
        "startPosition": 68646871,
        "endPosition": 68646914
      },
      {
        "chromosomeId": 12,
        "startPosition": 4935808,
        "endPosition": 4943097
      }
    ],
    "alignmentId": 1,
    "studyNames": [
      "study1"
    ],
    "patientSubjectCohortListId": 10000000630009,
    "bedFileNameUploadService": "julian-test/julian-chrMT-test.txt",
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1235/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1236"
    },
    "context": "SUBJECT",
    "genomicPosition": [
      {
        "chromosomeId": 25,
        "startPosition": 30,
        "endPosition": 30
      },
      {
        "chromosomeId": 1,
        "startPosition": 149029121,
        "endPosition": 149029121
      },
      {
        "chromosomeId": 1,
        "startPosition": 148805730,
        "endPosition": 148805730
      },
      {
        "chromosomeId": 1,
        "startPosition": 148794984,
        "endPosition": 148794984
      },
      {
        "chromosomeId": 1,
        "startPosition": 145700000,
        "endPosition": 145700000
      },
      {
        "chromosomeId": 1,
        "startPosition": 121485435,
        "endPosition": 121485435
      },
      {
        "chromosomeId": 1,
        "startPosition": 55199420,
        "endPosition": 55199420
      },
      {
        "chromosomeId": 1,
        "startPosition": 42104031,
        "endPosition": 42104031
      },
      {
        "chromosomeId": 1,
        "startPosition": 18514685,
        "endPosition": 18514685
      },
      {
        "chromosomeId": 1,
        "startPosition": 17097664,
        "endPosition": 17097664
      },
      {
        "chromosomeId": 1,
        "startPosition": 7289606,
        "endPosition": 7289606
      },
      {
        "chromosomeId": 1,
        "startPosition": 6955905,
        "endPosition": 6955905
      },
      {
        "chromosomeId": 1,
        "startPosition": 5644647,
        "endPosition": 5644647
      },
      {
        "chromosomeId": 1,
        "startPosition": 4882351,
        "endPosition": 4882351
      },
      {
        "chromosomeId": 1,
        "startPosition": 4249151,
        "endPosition": 4249151
      },
      {
        "chromosomeId": 1,
        "startPosition": 4248463,
        "endPosition": 4248463
      },
      {
        "chromosomeId": 1,
        "startPosition": 4000001,
        "endPosition": 4000001
      },
      {
        "chromosomeId": 1,
        "startPosition": 3418614,
        "endPosition": 3418614
      },
      {
        "chromosomeId": 1,
        "startPosition": 3000001,
        "endPosition": 3000001
      },
      {
        "chromosomeId": 1,
        "startPosition": 2827695,
        "endPosition": 2827695
      },
      {
        "chromosomeId": 1,
        "startPosition": 2241376,
        "endPosition": 2241376
      },
      {
        "chromosomeId": 1,
        "startPosition": 2000000,
        "endPosition": 2000000
      },
      {
        "chromosomeId": 1,
        "startPosition": 1654038,
        "endPosition": 1654038
      },
      {
        "chromosomeId": 1,
        "startPosition": 1273278,
        "endPosition": 1273278
      },
      {
        "chromosomeId": 1,
        "startPosition": 1142720,
        "endPosition": 1142720
      },
      {
        "chromosomeId": 1,
        "startPosition": 1000101,
        "endPosition": 1000101
      },
      {
        "chromosomeId": 1,
        "startPosition": 1000001,
        "endPosition": 1000001
      },
      {
        "chromosomeId": 1,
        "startPosition": 847250,
        "endPosition": 847250
      },
      {
        "chromosomeId": 1,
        "startPosition": 807302,
        "endPosition": 807302
      },
      {
        "chromosomeId": 1,
        "startPosition": 805474,
        "endPosition": 805474
      },
      {
        "chromosomeId": 1,
        "startPosition": 738636,
        "endPosition": 738636
      },
      {
        "chromosomeId": 1,
        "startPosition": 723819,
        "endPosition": 723819
      },
      {
        "chromosomeId": 1,
        "startPosition": 714040,
        "endPosition": 714040
      },
      {
        "chromosomeId": 1,
        "startPosition": 714019,
        "endPosition": 714019
      },
      {
        "chromosomeId": 1,
        "startPosition": 87190,
        "endPosition": 87190
      },
      {
        "chromosomeId": 1,
        "startPosition": 13502,
        "endPosition": 13502
      },
      {
        "chromosomeId": 1,
        "startPosition": 13302,
        "endPosition": 13302
      }
    ],
    "alignmentId": 1,
    "studyNames": [
      "study1"
    ],
    "patientSubjectId": [
      1622,
      1682
    ],
    "bedFileNameUploadService": "thulasi/subject_chr1.txt",
    "link": {
      "rel": "SUBMITJOB",
      "href": "/HSDataService-web/api/3.2.0/exports/1236/jobs"
    }
  }
]