connector: Katana (Lite)

Description

The Fivetran Katana connector's batch table syncs data from the /batch_stocks endpoint. However, Katana's API excludes rows with zero or negative inventory quantities by default unless the include_empty=true parameter is passed.

Currently, Fivetran does not pass this parameter, meaning rows with zero or negative quantity_in_stock are silently excluded from the destination.

Expected/Required behaviour:
The batch table should include all inventory rows regardless of quantity, including zero and negative values.

Katana API reference:

• Endpoint: GET /batch_stocks
• Parameter: include_empty (boolean) — "Include empty batches in result"
• Docs: https://developer.katanamrp.com/reference/getbatchstock

Business Impact

Zero and negative inventory quantities are valid and business-critical states in inventory management workflows (e.g., backorders, adjustments, write-offs). Excluding them causes incomplete data in downstream reporting.

Workaround

None currently available within Fivetran.