> ## Documentation Index
> Fetch the complete documentation index at: https://docs.open-metadata.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Stored Procedure Versions

> List and retrieve historical versions of a stored procedure

# Stored Procedure Versions

Every change to a stored procedure entity creates a new version. Use these endpoints to view the version history and retrieve specific versions.

## List Versions

<ParamField path="id" type="string" required>
  UUID of the stored procedure.
</ParamField>

## Get Specific Version

Use `GET /v1/storedProcedures/{id}/versions/{version}` to retrieve a specific version.

<ParamField path="id" type="string" required>
  UUID of the stored procedure.
</ParamField>

<ParamField path="version" type="string" required>
  Version number to retrieve (e.g., `0.2`).
</ParamField>

<RequestExample dropdown>
  ```python GET /v1/storedProcedures/{id}/versions theme={null}
  from metadata.sdk import configure
  from metadata.sdk.entities import StoredProcedures

  configure(
      host="https://your-company.open-metadata.org/api",
      jwt_token="your-jwt-token"
  )

  # List all versions
  versions = StoredProcedures.get_versions("770e8400-e29b-41d4-a716-446655440000")
  for v in versions:
      print(f"Version {v.version}: {v.description}")

  # Get a specific version
  sp_v1 = StoredProcedures.get_specific_version(
      "770e8400-e29b-41d4-a716-446655440000",
      "0.1"
  )
  print(f"Original description: {sp_v1.description}")
  ```

  ```java GET /v1/storedProcedures/{id}/versions theme={null}
  import static org.openmetadata.sdk.fluent.StoredProcedures.*;

  // List all versions
  var history = StoredProcedures.getVersions("770e8400-e29b-41d4-a716-446655440000");

  for (var version : history.getVersions()) {
      System.out.println("Version: " + version);
  }

  // Get a specific version
  var v1 = StoredProcedures.getSpecificVersion(
      "770e8400-e29b-41d4-a716-446655440000",
      0.1
  );
  System.out.println("Description: " + v1.getDescription());
  ```

  ```bash GET /v1/storedProcedures/{id}/versions theme={null}
  # List all versions
  curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions" \
    -H "Authorization: Bearer {access_token}"

  # Get a specific version
  curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions/0.1" \
    -H "Authorization: Bearer {access_token}"
  ```
</RequestExample>

<ResponseExample>
  ```json Response (List Versions) theme={null}
  {
    "entityType": "storedProcedure",
    "versions": [
      "{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.2,\"description\":\"Updated procedure to calculate average of integer arrays\",\"serviceType\":\"BigQuery\"}",
      "{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.1,\"description\":\"Procedure to calculate average\",\"serviceType\":\"BigQuery\"}"
    ]
  }
  ```
</ResponseExample>

***

## Returns

**List versions** returns an object with `entityType` and a `versions` array of serialized entity snapshots (newest first).

**Get specific version** returns the full stored procedure object as it existed at that version.

***

## Error Handling

| Code  | Error Type     | Description                                |
| ----- | -------------- | ------------------------------------------ |
| `401` | `UNAUTHORIZED` | Invalid or missing authentication token    |
| `404` | `NOT_FOUND`    | Stored procedure or version does not exist |