GET api/DatabaseSchema/StoredProcedures/{procedureName}

Request Information

URI Parameters

Name	Description	Type	Additional information
procedureName		string	Required

Body Parameters

None.

Response Information

Resource Description

StoredProcedure

Name	Type	Additional information
ObjectId	integer	None.
Name	string	None.
Schema	string	None.
Owner	string	None.
LastUpdated	date	None.
Definition	string	None.
Parameters	Collection of Parameter	None.

Response Formats

application/json, text/json

Sample:

{
  "ObjectId": 1,
  "Name": "sample string 2",
  "Schema": "sample string 3",
  "Owner": "sample string 4",
  "LastUpdated": "2026-06-05T19:45:33.6928567-04:00",
  "Definition": "sample string 6",
  "Parameters": {
    "$id": "2",
    "$values": [
      {
        "$id": "3",
        "$type": "WebPortalRTFAPI.Models.Schema.Parameter, WebPortalRTFAPI",
        "IsOutput": true,
        "DefaultValue": {
          "$id": "4",
          "$type": "System.Object, mscorlib"
        },
        "Name": "sample string 3",
        "DataType": "sample string 4",
        "MaxLength": 5
      },
      {
        "$ref": "3"
      }
    ]
  }
}