API Documentation

Last Update: 28 December 2022

GET api/MSSQLDatabaseStoredProcedure/{id}



Request Information


URI Parameters
Name Description Type Additional information
id

integer

Required
Body Parameters

None.

Response Information


Resource Description
MSSQLDatabaseStoredProcedure
Name Description Type Additional information
ID

integer

None.
ReportDate

date

None.
DatabaseLocalID

integer

None.
HostID

integer

None.
DatabaseGuid

string

None.
Name

string

None.
AnsiNullsStatus

string

None.
IsEncrypted

string

None.
IsSchemaBound

string

None.
IsSchemaOwned

string

None.
Recompile

string

None.
Startup

string

None.
CreateDate

date

None.
DateLastModified

date

None.
RecordStatus

integer

None.
Response Formats
application/json, text/json
Sample: 
{
  "ID": 1,
  "ReportDate": "2024-11-21T06:21:00.0486766+00:00",
  "DatabaseLocalID": 3,
  "HostID": 4,
  "DatabaseGuid": "sample string 5",
  "Name": "sample string 6",
  "AnsiNullsStatus": "sample string 7",
  "IsEncrypted": "sample string 8",
  "IsSchemaBound": "sample string 9",
  "IsSchemaOwned": "sample string 10",
  "Recompile": "sample string 11",
  "Startup": "sample string 12",
  "CreateDate": "2024-11-21T06:21:00.0486766+00:00",
  "DateLastModified": "2024-11-21T06:21:00.0486766+00:00",
  "RecordStatus": 15
}