Retrieve Export Definitions for Export Identifiers

get

/ohfapi/cg/v3.3/exports

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

Request

Supported Media Types
Query Parameters
  • File Export End Date
  • Collection Format: multi
    Minimum Number of Items: 0
    Maximum Number of Items: 2147483647
    List of File Export Row IDs
  • File Export Start Date
Security
Back to Top

Response

Supported Media Types

200 Response

successful operation
Body ()
Root Schema : schema
Type: array
Show Source
Nested Schema : OmicsExportDefinition
Type: object
Show Source
Nested Schema : CodeCodeSysContainerDS
Type: object
Provide a list of code and of system code combinations.
Show Source
Nested Schema : fileWids
Type: array
List of file load record ids.
Show Source
Example:
"fileWids" : [1,2]
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).
Show Source
Example:
"geneHugoNames": ["CASZ1","CAMTA1-IT1","RP3-453P22.2"]
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).
Show Source
Example:
"geneSetIds" : [1,2]
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).
Show Source
Example:
"genomicPosition": [{
        "chromosomeId": 10,
        "startPosition": 89682891,
        "endPosition": 100682893
    }, {
        "chromosomeId": 7,
        "startPosition": 89682891
    }, {
        "chromosomeId": 5
    }]
Nested Schema : OdbIdentifier
Type: object
Identifier assigned by a given system
Show Source
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).
Show Source
Example:
"pathwayNames": ["PATHWAY1","PATHWAY2"]
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(specified in specimenIdsCdm and specimenIdsODB). If both are provided the specimen source takes precedence
Show Source
Example:
"patientSubjectId" : [1,2]
Nested Schema : AllCriteriaList
Type: object
Contains all the Query Criteria
Show Source
  • allCriteriaList
    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(specified in specimenIdsCdm and specimenIdsODB). If both are provided the specimen source takes precedence
Show Source
Example:
"specimenIdsCdm" : [1,2]
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(specified in specimenIdsCdm and specimenIdsODB). If both are provided the specimen source takes precedence
Show Source
Example:
"specimenIdsOdb" : [1,2]
Nested Schema : studyNames
Type: array
List of study names.
Show Source
Example:
"studyNames": ["STUDY1","STUDY2"]
Nested Schema : codeCodeSysList
Type: array
List of code and system code combinations
Show Source
Nested Schema : CodeCodeSysDS
Type: object
Provide a list of codes and a list of system codes.
Show Source
Nested Schema : code
Type: array
List codes
Show Source
Nested Schema : codeSys
Type: array
List system codes
Show Source
Nested Schema : ConditionMetaInfo
Type: object
Keep the meta information in here. This will be used for informational purposes.
Show Source
Nested Schema : GenomicPositionFileExport
Type: object
Show Source
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
Show Source
Nested Schema : criteria
Type: object
Discriminator: type
Show Source
Back to Top

Examples

The following example submits a GET request.

Example 1

API URL

http://localhost:7010/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/exports/940/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "942"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "CCDC3",
      "OPTN"
    ],
    "versionId": 3,
    "alignmentId": 1,
    "patientSubjectId": [
      841
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/ohfapi/cg/v3.3/exports/942/jobs"
    }
  }
]

Example 2

API URL ??? by Date

http://localhost:7010/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/exports/1268/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1270"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "PIK3C2G",
      "RERGL"
    ],
    "alignmentId": 1,
    "specimenIdsOdb": [
      58
    ],
    "patientSubjectId": [
      817
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/ohfapi/cg/v3.3/exports/1270/jobs"
    }
  }
]

Example 3

API URL ??? by Date Range

http://localhost:7010/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/exports/1268/jobs"
    }
  },
  {
    "id": {
      "system": "ODB",
      "value": "1270"
    },
    "context": "PATIENT",
    "geneHugoNames": [
      "PIK3C2G",
      "RERGL"
    ],
    "alignmentId": 1,
    "specimenIdsOdb": [
      58
    ],
    "patientSubjectId": [
      817
    ],
    "link": {
      "rel": "SUBMITJOB",
      "href": "/ohfapi/cg/v3.3/exports/1270/jobs"
    }
  }
]

Example 4

API URL ??? by ID List and Date Range

http://localhost:7010/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/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": "/ohfapi/cg/v3.3/exports/1236/jobs"
    }
  }
]
Back to Top