Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2025 08:36 AM
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