Custom Test
Custom/Execute
Executes a local procedure defined in TR_LOCAL_PROCEDURE. This will only return a collection of the first result set in a registered procedure. For the result set, null values in each data row are not returned as properties.
Http Verb POST
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/Custom/Execute

URI Parameters

This resource has no URI (Query) parameters.

Request Body

Request object type : LocalProcedureRequest

Request object type LocalProcedureRequest has the following properties.
Property Name Data Type Length Required Readonly Notes
Parameters (DEPRECATED) string List of procedure parameters in the form "@param1_name=value&@param2_name=value&@param3_name=value".The parameter values that contain & or = should be escaped with a backslash(\\).Obsolete: Will be removed in V16. Use ParameterValues collection instead.
ParameterValues Collection of ParameterValue Collection of procedure parameters as name/value pairs.
ProcedureId integer Id of procedure in TR_LOCAL_PROCEDURE to execute.
ProcedureName string Name of procedure in TR_LOCAL_PROCEDURE to execute. 
{
  "ProcedureId": 1,
  "ProcedureName": "sample string 1",
  "Parameters": "sample string 2",
  "ParameterValues": [
    {
      "Name": "sample string 1",
      "Value": "sample string 2"
    },
    {
      "Name": "sample string 1",
      "Value": "sample string 2"
    }
  ]
}
<LocalProcedureRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <ParameterValues>
    <ParameterValue>
      <Name>sample string 1</Name>
      <Value>sample string 2</Value>
    </ParameterValue>
    <ParameterValue>
      <Name>sample string 1</Name>
      <Value>sample string 2</Value>
    </ParameterValue>
  </ParameterValues>
  <Parameters>sample string 2</Parameters>
  <ProcedureId>1</ProcedureId>
  <ProcedureName>sample string 1</ProcedureName>
</LocalProcedureRequest>

Response object type : HttpResponseMessage

Response object type HttpResponseMessage has the following properties.
Property Name Data Type Length Required Readonly Notes
Content HttpContent
Headers Collection of Object
IsSuccessStatusCode boolean
ReasonPhrase string
RequestMessage HttpRequestMessage
StatusCode HttpStatusCode
Version Version

No response body. Please check http status code header for success (200 OK) or failure. It there are error(s), a collection of ErrorMessages will be returned.

Change Version Description Contract Old New
Parameter Added 15.0.0 New parameter added localProcedureRequest localProcedureRequest
Parameter Removed 15.0.0 Parameter request removed. request