Upsert purchase order lines
POST/v1/purchaseorderline
Import or update purchase order line items. Supports both incremental updates and full data replacement.
Upsert Key: source_line_id (ON CONFLICT target)
full_load Behavior:
- false (default): Incremental upsert — updates existing lines (matched by source_line_id), inserts new ones
- true: Full replacement — deletes ALL existing purchase order lines for the customer, then inserts new data
Required Fields: po_number, po_line_number, source_document_id, source_line_id, quantity, unit_price, net_amount
Referential integrity: every source_document_id must reference an existing purchase_order row, or the request is rejected with 400.
Limits: maximum 1000 lines per request.
Request
Responses
- 200
- 400
- 401
- 403
- 500
Purchase order lines processed successfully
Bad request - validation error
Unauthorized - invalid or missing API key
Forbidden - insufficient permissions
Internal server error