Stored Procedures

Allows to execute a database stored procedure

POST calls

Execute stored procedure

post

Allows to execute a stored procedure from the database, passing parameters to it In the case of calls to stored procedures they will execute the code they have without restrictions Only stored procedures that have been created in any dictionary other than JNCAPI can be executed.

Parámetros de ruta

procedimientostringRequerido

The name of the stored procedure in SQL server

Parámetros de encabezado

AuthorizationstringRequerido

Bearer + JWT_token

Cuerpo

application/json

Respuestas

200

Result of the stored procedure that has been selected.

Sin contenido

post

/procalm/{procedimiento}

HTTPcURLJavaScriptPython

POST /api/procalm/{procedimiento} HTTP/1.1
Host: server:<port>
Authorization: text
Content-Type: application/json
Accept: */*
Content-Length: 131

{
  "json": {
    "parametros": [
      {
        "nombre": "text",
        "tipo": "string",
        "direccion": "entrada",
        "longitud": "text",
        "defecto": "text",
        "valor": "text"
      }
    ]
  }
}

200

Result of the stored procedure that has been selected.

Sin contenido

Stored Procedure Body

Executing a stored procedure

https://server:5555/api/procalm/procedimientodeprueba

The possible values for the datatype are: string/integer/boolean/float/currency/word/date/time

The possible values for the address are: entrada/salida/entradasalida/retorno

{
    "parametros":
        [
            {
            "nombre": "codigo",
            "tipo": "string",
            "direccion": "entrada",
            "longitud": "8",
            "defecto": "",
            "valor": " 1"
            },
            {
            "nombre": "riesgo",
            "tipo": "float",
            "direccion": "salida",
            "longitud": "0",
            "defecto": "0",
            "valor": "0"
            }
        ]
}