DanielW
New Contributor III

Hi probably one to pick up next week.  but I attempted to parametise  me SQL statement and it was painful!

parameters:
        - name: body
          in: body
          required: true
          schema:
            type: object
            properties:
              warehouse_id:
                type: string
                description: The ID of the warehouse to retrieve.
                default: <warehouse_id>
                x-ms-visibility: important
              statement:
                type: string
                description: SQL statement to execute.
                default: >
                  SELECT * FROM cycle_shops WHERE shop_id = :shop_id
                x-ms-visibility: important
              shop_id:
                type: string
                description: The ID of the shop I  to filter by.
              wait_timeout:
                type: string
                description: Timeout for the SQL execution.
                default: 5s

DanielW_0-1747409745711.png