Skip to main content
GET
https://sandbox.getcollate.io/api
/
v1
/
storedProcedures
/
{id}
/
versions
GET /v1/storedProcedures/{id}/versions
from metadata.sdk import configure
from metadata.sdk.entities import StoredProcedures

configure(
    host="https://your-company.getcollate.io/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}")

{
  "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\"}"
  ]
}

​
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

​
id
string
required
UUID of the stored procedure.

​
Get Specific Version

Use GET /v1/storedProcedures/{id}/versions/{version} to retrieve a specific version.
​
id
string
required
UUID of the stored procedure.
​
version
string
required
Version number to retrieve (e.g., 0.2).
GET /v1/storedProcedures/{id}/versions
from metadata.sdk import configure
from metadata.sdk.entities import StoredProcedures

configure(
    host="https://your-company.getcollate.io/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}")

{
  "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\"}"
  ]
}

​
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

CodeError TypeDescription
401UNAUTHORIZEDInvalid or missing authentication token
404NOT_FOUNDStored procedure or version does not exist