GET api/DatabaseSchema/StoredProcedures

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of 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:

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