Create WPC GET Method for Saturation Function Set schema

As an OSDU data definitions member, I want the GET method to be created to support the Saturation Function Set WPC. The method must fetch the record and throw the corresponding messages,(Check AC section).

Dependencies before start the development :

Task Status (Y / N)
Proposal document revised Y
Multi – company review Y
OSDU Forum approval Y

Acceptance criteria:

The following acceptance criteria are verifiable via Postman collection, based strictly on the provided FastAPI code implementation.

AC Completed
The user can send a GET request to the endpoint /{record_id}.
Path parameter validation: Valid record_id passes, Invalid record_id returns 422 Unprocessable Entity.
If the specified ID does not exist, the system should return a 404 Not Found status
Response: 200 OK with JSON body.
Caching: Same response within TTL.
No extra fields beyond service output. Postman Tests: Send valid GET ® 200 OK. Invalid record_id ® 422. Repeat ® consistent cached response.
If the user is not authorized to access the saturation function set, the system should return a 403 Forbidden status.

End point:

/api/rafs-ddms/v2/saturationfunctionset/{record_id}

SCHEMA and reference links

You can access the json example file here: https://gitlab.opengroup.org/osdu/subcommittees/data-def/projects/ResMngmtTeam/docs/-/blob/main/Dynamic%20Reservoir%20Modeling/Jan2025_Workshop/Workshops_Outcomes_Proposals/JSON%20examples/wpc-saturationfunction.json

Proposal Doc: https://gitlab.opengroup.org/osdu/subcommittees/data-def/projects/ResMngmtTeam/docs/-/blob/main/Dynamic%20Reservoir%20Modeling/Jan2025_Workshop/Workshops_Outcomes_Proposals/SaturationFunctionSet.1.0.0.xlsx

Source data sample:

Reference list(s):

Reference Data Name Schema Reference Value List
ThreePhaseRelativePermeabilityModelType https://gitlab.opengroup.org/osdu/subcommittees/data-def/projects/ResMngmtTeam/docs/-/blob/main/Dynamic%20Reservoir%20Modeling/Jan2025_Workshop/Workshops_Outcomes_Proposals/Reference-Data-Schema-And-Values/schema-ThreePhaseRelativePermeabilityModelType.1.0.0.json https://gitlab.opengroup.org/osdu/subcommittees/data-def/projects/ResMngmtTeam/docs/-/blob/main/Dynamic%20Reservoir%20Modeling/Jan2025_Workshop/Workshops_Outcomes_Proposals/Reference-Data-Schema-And-Values/ThreePhaseRelativePermeabilityModelType.1.json
SaturationFunctionUsageType https://gitlab.opengroup.org/osdu/subcommittees/data-def/projects/ResMngmtTeam/docs/-/blob/main/Dynamic%20Reservoir%20Modeling/Jan2025_Workshop/Workshops_Outcomes_Proposals/Reference-Data-Schema-And-Values/schema-SaturationFunctionUsageType.1.0.0.json https://gitlab.opengroup.org/osdu/subcommittees/data-def/projects/ResMngmtTeam/docs/-/blob/main/Dynamic%20Reservoir%20Modeling/Jan2025_Workshop/Workshops_Outcomes_Proposals/Reference-Data-Schema-And-Values/SaturationFunctionUsageType.1.json
WorkflowUsageType (Published) https://community.opengroup.org/osdu/data/data-definitions/-/blob/master/E-R/reference-data/WorkflowUsageType.1.0.1.md?ref_type=heads
Edited Nov 26, 2025 by Raul Isunza
Assignee Loading
Time tracking Loading