openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_SQLFILES_MSS:
    post:
      tags:
      - SFMSS_CONFIG
      summary: get data on the files of a SQL Server database
      operationId: /rfc/GET_SQLFILES_MSS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: DBCON name
                DBNAME:
                  type: string
                  maxLength: 128
                  description: Database name
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Target Schema
                DBFILES:
                  type: array
                  items:
                    type: object
                    properties:
                      FILEGRPNA:
                        type: string
                        maxLength: 128
                        description: Filegroup name
                      FILEGRPDEF:
                        type: string
                        maxLength: 1
                        description: Default file grp contains objects created w/o defined filegp
                      FGRPRDONLY:
                        type: string
                        maxLength: 1
                        description: The file group is read only
                      LOGFILENA:
                        type: string
                        maxLength: 128
                        description: Logical file name
                      PHYFILENA:
                        type: string
                        maxLength: 520
                        description: Physical file name (full path) of the database file.
                      DEVFREE:
                        type: integer
                        format: int64
                        description: Free space left on file system (partition) in MB.
                      DEVSIZE:
                        type: integer
                        format: int32
                        description: The size in MB of the logical device the file resides upon
                      FLSIZEMB:
                        type: integer
                        format: int64
                        description: File size in MB.
                      FLMAXSZMB:
                        type: integer
                        format: int32
                        description: True Max file size in MB(-1 means file grows till disk full)
                      FLGRWPCT:
                        type: string
                        maxLength: 1
                        description: SQL Server file has growth represented in percentage
                      FLGROWTH:
                        type: integer
                        format: int32
                        description: Growth size of the SQL Server database file
                      FLGROWMB:
                        type: integer
                        format: int32
                        description: True file growth in MB
                      FLEXTENTS:
                        type: integer
                        format: int32
                        description: Total number of extents assigned to a file
                      FLUSDEXTS:
                        type: integer
                        format: int32
                        description: Total no. of used extents(8 contiguous pgs) assigned to file
                      FILEPRMRY:
                        type: string
                        maxLength: 1
                        description: Primary file containing startup information and also data
                      FLDEFDEV:
                        type: string
                        maxLength: 1
                        description: file is on default device
                      FLDISKFILE:
                        type: string
                        maxLength: 1
                        description: file is a disk file
                      FLLOGDEV:
                        type: string
                        maxLength: 1
                        description: file is a log file
                      FLWRITEBU:
                        type: string
                        maxLength: 1
                        description: file has been written to since the last backup was done
                      FLCREATEDB:
                        type: string
                        maxLength: 1
                        description: file was created with a CREATE DB command
                      FLDBCREATE:
                        type: string
                        maxLength: 1
                        description: file created during Database creation
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  DBFILES:
                    type: array
                    items:
                      type: object
                      properties:
                        FILEGRPNA:
                          type: string
                          maxLength: 128
                          description: Filegroup name
                        FILEGRPDEF:
                          type: string
                          maxLength: 1
                          description: Default file grp contains objects created w/o defined filegp
                        FGRPRDONLY:
                          type: string
                          maxLength: 1
                          description: The file group is read only
                        LOGFILENA:
                          type: string
                          maxLength: 128
                          description: Logical file name
                        PHYFILENA:
                          type: string
                          maxLength: 520
                          description: Physical file name (full path) of the database file.
                        DEVFREE:
                          type: integer
                          format: int64
                          description: Free space left on file system (partition) in MB.
                        DEVSIZE:
                          type: integer
                          format: int32
                          description: The size in MB of the logical device the file resides upon
                        FLSIZEMB:
                          type: integer
                          format: int64
                          description: File size in MB.
                        FLMAXSZMB:
                          type: integer
                          format: int32
                          description: True Max file size in MB(-1 means file grows till disk full)
                        FLGRWPCT:
                          type: string
                          maxLength: 1
                          description: SQL Server file has growth represented in percentage
                        FLGROWTH:
                          type: integer
                          format: int32
                          description: Growth size of the SQL Server database file
                        FLGROWMB:
                          type: integer
                          format: int32
                          description: True file growth in MB
                        FLEXTENTS:
                          type: integer
                          format: int32
                          description: Total number of extents assigned to a file
                        FLUSDEXTS:
                          type: integer
                          format: int32
                          description: Total no. of used extents(8 contiguous pgs) assigned to file
                        FILEPRMRY:
                          type: string
                          maxLength: 1
                          description: Primary file containing startup information and also data
                        FLDEFDEV:
                          type: string
                          maxLength: 1
                          description: file is on default device
                        FLDISKFILE:
                          type: string
                          maxLength: 1
                          description: file is a disk file
                        FLLOGDEV:
                          type: string
                          maxLength: 1
                          description: file is a log file
                        FLWRITEBU:
                          type: string
                          maxLength: 1
                          description: file has been written to since the last backup was done
                        FLCREATEDB:
                          type: string
                          maxLength: 1
                          description: file was created with a CREATE DB command
                        FLDBCREATE:
                          type: string
                          maxLength: 1
                          description: file created during Database creation
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
