inRiver JSONL Export Format Decisions

Date: Thu, 05 Feb 2026 15:20:26 -0600 Participants: Brandon Spor (Aperture Labs), Randy Gonthier (Watsco VP)

Decision 1: Multi-Select CVL Format

Context: How to structure multi-select Controlled Value Lists in JSONL exports

Decision: Use separate arrays for keys and values with matching ordinal positions

Format:

{
  "keys": ["key1", "key2", "key3"],
  "values": ["value1", "value2", "value3"]
}

Rationale: Requested by Randy Gonthier to maintain key-value relationships while supporting multiple selections

Example Field: ItemCountryofOrigin (multiselect CVL)

---

Decision 2: Single-Select CVL Format

Context: How to structure single-select Controlled Value Lists in JSONL exports

Decision: Use object format with key and value properties

Format:

{
  "key": "key1",
  "value": "value1"
}

Example Field: ItemItemQuantityType (single-select CVL)

---

Decision 3: CVL Structure Update

Context: Previous export format needed updating to distinguish between single and multi-select CVLs

Decision: Implement distinct structures for single vs multi-select CVLs to make the distinction explicit in the payload

Status: Sample payload provided for approval before full export

---

Next Steps

• Randy to review sample payload
• If approved, Brandon will proceed with full export
• Full export will use updated CVL structure across all fields