openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_XML_PLAN:
    post:
      tags:
      - SFMSS_PERF
      summary: MS SQL server function to get statistics, showplan for SQL stmt execution.
      operationId: /rfc/MSS_XML_PLAN
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name of a Database Connection
                PLAN_HANDLE:
                  type: string
                  maxLength: 128
                  description: handle pointing to plan used in execution of sql stmt/proc
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Schema name
                OBJ_REFS:
                  type: array
                  items:
                    type: object
                    properties:
                      DB_NAME:
                        type: string
                        maxLength: 128
                        description: Database name
                      SCH_NAME:
                        type: string
                        maxLength: 128
                        description: Schema name
                      TABLE_NAME:
                        type: string
                        maxLength: 128
                        description: Table name
                PAR_VALUES:
                  type: array
                  items:
                    type: object
                    properties:
                      PAR_NAME:
                        type: string
                        maxLength: 30
                        description: MS SQL server - stored procedure parameter name
                      PAR_TYPE:
                        type: string
                        maxLength: 30
                        description: MS SQL server - stored procedure parameter type
                      PAR_VALUE:
                        type: string
                        maxLength: 255
                        description: MS SQL server  stored procedure parameter value
              required:
              - PLAN_HANDLE
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  XML_SHOWPLAN:
                    type: string
                    description: Output of set showplan_xml on
                  OBJ_REFS:
                    type: array
                    items:
                      type: object
                      properties:
                        DB_NAME:
                          type: string
                          maxLength: 128
                          description: Database name
                        SCH_NAME:
                          type: string
                          maxLength: 128
                          description: Schema name
                        TABLE_NAME:
                          type: string
                          maxLength: 128
                          description: Table name
                  PAR_VALUES:
                    type: array
                    items:
                      type: object
                      properties:
                        PAR_NAME:
                          type: string
                          maxLength: 30
                          description: MS SQL server - stored procedure parameter name
                        PAR_TYPE:
                          type: string
                          maxLength: 30
                          description: MS SQL server - stored procedure parameter type
                        PAR_VALUE:
                          type: string
                          maxLength: 255
                          description: MS SQL server  stored procedure parameter value
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
