Skip to content

Implement endpoints to support GeoChem -> Physical Chemistry data

Implement POST/api/rafs-ddms/PhysChem/{record_id}/data is implemented and available on Swagger

  • record_id is the SamplesAnalysis WPC which was created previously
  • User should be able to fill the SamplesAnalysis report with measurements taken in this analysis
  • Successful response (200 status code) should update SamplesAnalysis record and include DDMSDatasets array with GET endpoint to the linked bulk data of PhysChem
  • Validation cases should be covered with appropriate status codes
  • Request & response structure should correspond to populated JSON

Implement GET/api/rafs-ddms/PhysChem/{record_id}/data endpoint is implemented and available on Swagger

  • record_id is the SamplesAnalysis WPC
  • User should be able to retrieve bulk data of Extraction using new endpoint
  • Successful response (200 status code) should retrieve all existing PhysChem Measurements (bulk data) linked to specified record id (SamplesAnalysis WPC)
  • Validation cases should be covered with appropriate status codes
  • Structure of request and response should correspond to populated JSON content schema
Content Schema 
"SamplesAnalysisID": "osdu:work-product-component--SamplesAnalysis:dd76cf6c-226f-5636-ad1b-1ca0f8249cc8",
"SamplesID": "osdu:master-data--Samples:dd76cf6c-226f-5636-ad1b-1ca0f8249c787845c8",
"ApiGravity": {
    "Value": 32.5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:dAPI"
},
"ApiQualifier": "Measured",
"ApiGravityRemarks": "No specific notes or comments available.",
"VolatileContentOfOil": {
    "Value": 1.8,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"PourPoint": {
    "Value": -15,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"PourPointQualifier": "Below zero",
"WaxContent": {
    "Value": 0.9,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"WaxContentQualifier": "Low",
"WaterContent": {
    "Value": 0.05,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"WaterContentQualifier": "Trace",
"SulphurContent": {
    "Value": 1.2,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"SulphurContentDataQualifier": "Standard analysis",
"NickelContent": {
    "Value": 10,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"NickelContentDataQualifier": "Standard analysis",
"VanadiumContent": {
    "Value": 5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"VanadiumContentDataQualifier": "Standard analysis",
"CloudPointMethod": "ASTM D2500",
"CloudPoint": {
    "Value": -5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"CloudPointUnits": {
    "Value": "opendes:reference-data--UnitOfMeasure:degC"
},
"PourPointMethod": "ASTM D97",
"MeltingPointMethod": {
    "Value": "ASTM D127"
},
"MeltingPoint": {
    "Value": 35,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"GasOilRatio": {
    "Value": 1200,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ft3/bbl"
},
"ReservoirTemperature": {
    "Value": 75,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degF"
},
"IronContent": {
    "Value": 15,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"SodiumContent": {
    "Value": 3,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"NickelVanadiumRatio": 2.5,
"AsphalteneContent": {
    "Value": 0.5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"SpecificGravityQualifier": "Greater than",
"SpecificGravityOfUnspecifiedOrigin": 0.85,
"TotalAcidNumber": {
    "Value": 1.8,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:mg/g"
},
"MethodOfAnalysisForSpecificGravity": "ASTM D4052",
"MethodOfAnalysisForViscosity": "ASTM D445",
"MethodOfAnalysisForSulphurContent": "ASTM D4294",
"MethodOfAnalysisForNitrogenConcentration": "ASTM D4629",
"NitrogenConcentration": {
    "Value": 0.02,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"CarbonConcentration": {
    "Value": 85,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"HydrogenConcentration": {
    "Value": 12,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"OxygenConcentration": {
    "Value": 0.2,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%[mass]"
},
"NickelVanadiumRatioAsPercentage": {
    "Value": 5.5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%"
},
"VanadiumNickelRatio": 1.8,
"VanadiumNickelRatioAsPercentage": {
    "Value": 2.7,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%"
},
"ViscositiesMeasurements": [
    {
        "Viscosity": {
            "Value": 50,
            "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:cSt"
        },
        "TemperatureOfViscosityMeasurement": {
            "Value": 111,
            "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
        }
    },
    {
        "Viscosity": {
            "Value": 111,
            "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:cSt"
        },
        "TemperatureOfViscosityMeasurement": {
            "Value": 15,
            "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
        }
    }
],
"SilverConcentration": {
    "Value": 0.2,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"AluminiumConcentration": {
    "Value": 2.5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"BoronConcentration": {
    "Value": 0.1,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"BariumConcentration": {
    "Value": 0.5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"CalciumConcentration": {
    "Value": 100,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"CadmiumConcentration": {
    "Value": 0.02,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"ChromiumConcentration": {
    "Value": 1,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"CopperConcentration": {
    "Value": 5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"PotassiumConcentration": {
    "Value": 10,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"LithiumConcentration": {
    "Value": 0.05,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"MagnesiumConcentration": {
    "Value": 20,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"ManganeseConcentration": {
    "Value": 2,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"MolybdenumConcentration": {
    "Value": 0.1,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"PhosphorusConcentration": {
    "Value": 100,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"LeadConcentration": {
    "Value": 0.1,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"SiliconConcentration": {
    "Value": 50,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"TinConcentration": {
    "Value": 0.05,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"TitaniumConcentration": {
    "Value": 0.2,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"ZincConcentration": {
    "Value": 10,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"MeasuredAverageMolarWeight": {
    "Value": 250,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:g/mole"
},
"MeasuredDensityAt60F": {
    "Value": 0.85,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:g/cm3"
},
"PercentOfMudContamination": {
    "Value": 2.5,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%"
},
"SampleDensityAt60DegreesCelsius": {
    "Value": 0.82,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:g/cm3"
},
"SampleDensityAt15DegreesCelsius": {
    "Value": 0.85,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:g/cm3"
},
"MolecularWeight": {
    "Value": 200,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:g/mole"
},
"WaterSediment": {
    "Value": 0.05,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:%"
},
"MercaptanSulphurConcentration": {
    "Value": 1.2,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"NitrogenQualifier": "Less than",
"BasicNitrogenConcentration": {
    "Value": 0.03,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
},
"ColourStabilityFlag": "red",
"PenetrationPoint": {
    "Value": 30,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:m"
},
"SofteningPointQualifier": "Greater than",
"SofteningPoint": {
    "Value": 80,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"SmokePoint": {
    "Value": 200,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"FreezePointQualifier": "Less than",
"FreezePoint": {
    "Value": -10,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"CetaneIndex": 45,
"RefractiveIndexAt70DegreesCelsius": 1.4,
"DieselFuelRating": "Premium",
"AnilineLubricantMiscibility": {
    "Value": -25,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:degC"
},
"ChromiumQualifier": "Greater than",
"CopperQualifier": "Less than",
"ManganeseQualifier": "Greater than",
"SodiumQualifier": "Less than",
"MolybdenumQualifier": "Greater than",
"LeadQualifier": "Less than",
"IronQualifier": "Greater than",
"CalciumQualifier": "Less than",
"ZincQualifier": "Greater than",
"TotalMercury": {
    "Value": 0.01,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ug/g"
},
"FilteredMercuryConcentration": {
    "Value": 0.005,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ug/g"
},
"SaltConcentration": {
    "Value": 100,
    "UnitOfMeasure": "opendes:reference-data--UnitOfMeasure:ppm[mass]"
}

}

Edited by Mykhailo Buriak