Groovy Script for JDE Orchestrator: Custom Request Generator

import com.oracle.e1.common.OrchestrationAttributes;
import java.text.SimpleDateFormat;

// Purpose: Split uploaded CSV text into rows for an iteration over Sales Order Entry
// Inputs: csvText (text with a header line), delimiter (single character, default comma)
// Outputs: rows (array of rows keyed by header names), RowCount
HashMap<String, Object> main(OrchestrationAttributes orchAttr, HashMap inputMap)
{
  HashMap<String, Object> returnMap = new HashMap<String, Object>();

  String csvText = (String) inputMap.get("csvText");
  String delimiter = (String) inputMap.get("delimiter");
  if (delimiter == null || delimiter.isEmpty()) {
    delimiter = ",";
  }

  List<HashMap<String, Object>> rows = new ArrayList<HashMap<String, Object>>();
  if (csvText == null || csvText.trim().isEmpty()) {
    orchAttr.writeWarn("CSV_SPLIT: no input text received");
    returnMap.put("rows", rows);
    returnMap.put("RowCount", "0");
    return returnMap;
  }

  List<String> lines = csvText.readLines();
  String[] headers = lines.get(0).split(java.util.regex.Pattern.quote(delimiter), -1);

  for (int i = 1; i < lines.size(); i++) {
    String line = lines.get(i);
    if (line.trim().isEmpty()) {
      continue;
    }
    String[] cells = line.split(java.util.regex.Pattern.quote(delimiter), -1);
    HashMap<String, Object> row = new HashMap<String, Object>();
    for (int c = 0; c < headers.length; c++) {
      row.put(headers[c].trim(), c < cells.length ? cells[c].trim() : "");
    }
    rows.add(row);
  }

  orchAttr.writeDebug("CSV_SPLIT: parsed " + rows.size() + " rows");
  returnMap.put("rows", rows);
  returnMap.put("RowCount", String.valueOf(rows.size()));
  return returnMap;
}

csvText:
Customer,Branch,Item,Quantity
4242,30,220,10
4243,30,240,5

delimiter:
,