Stored Procedures

List Stored Procedures

Get a list of stored procedures, optionally filtered by databaseSchema it belongs to. Use fields parameter to get only necessary fields. Use cursor-based pagination to limit the number entries in the list using limit and before or after query params.

get/v1/storedProcedures

Request

  • Base URL: https://demo.getcollate.io/api
  • URL: https://demo.getcollate.io/api/v1/storedProcedures
  • Auth: HTTP bearer

Query parameters

fieldsstring
Example:owners,tags,followers,votes,extension,domains,sourceHash

Fields requested in the returned resource

databaseSchemastring
Example:customerDatabaseSchema

Filter stored procedures by database schema

limitinteger

Limit the number schemas returned. (1 to 1000000, default = 10)

beforestring

Returns list of schemas before this cursor

afterstring

Returns list of schemas after this cursor

include'all' | 'deleted' | 'non-deleted'

Include all, deleted, or non-deleted entities.

Response

List of stored procedures

warningsCountinteger

Changes

No recorded changes to this operation across all 1 revision of this API.