Every shipment more than four hours past ETA
curl -X POST https://oc-acme.ap-south-1.originchain.ai/v1/sql \
-H "Authorization: Bearer $OC_TOKEN" \
-H "Content-Type: application/json" \
-d '{"sql":"SELECT shipment_id, src, dst, EXTRACT(EPOCH FROM (now() - expected_eta))/60 AS late_min FROM shipments WHERE status <> ''delivered'' AND expected_eta < now() - interval ''4 hours'' ORDER BY late_min DESC"}' {
"rows": [
{ "shipment_id": "SH-9021", "src": "MUM-03", "dst": "BLR-01", "late_min": 412 },
{ "shipment_id": "SH-9108", "src": "DEL-01", "dst": "HYD-02", "late_min": 267 }
],
"meta": { "latency_ms": 44 }
}