queryStoredProcedure

Executes a stored procedure and returns the query result.

Parameters

1. procedureName - The name of the stored procedure

2. procedure parameters - If you need to add parameters, you can use this json object to set them

3. queryOptions - (optional) a json object with options for the request

   • timeout - (optional) timeout for the request. Default is 30 seconds

   • connectionKey - (optional) a key to a custom settings entry with the connection string to an external MSSQL database

Example Usages

1. Simple (pay attention to the await keyword)

   let myResult = await brixxApi.queryStoredProcedure("procedureName");

2. With parameters (pay attention to the await keyword)

   let parameterJson = {
      myCustomSqlParameter: 12345
   };
   let myResult = await brixxApi.queryStoredProcedure("procedureName", parameterJson);

3. Short version (pay attention to the await keyword)

   let myResult = await brixxApi.queryStoredProcedure("procedureName", {
      myCustomSqlParameter: 12345
   });

4. Using a timeout

   let myResult = await brixxApi.queryStoredProcedure("procedureName", {
      myCustomSqlParameter: 12345
   },{
      timeout: 45
   });