Skip to content
HALOWERK

File Formats and Conversion

csv wide metric columns to long rows

CSV unpivot returns one row per selected metric and input record. Use it when an agent needs to turn separate measurement columns into a tidy table.

POST https://format.halowerk.com/v1/csv-wide-metric-columns-to-long-rows

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
textstringYes
id_columnsarrayYes
metric_columnsarrayYes
Show full input schema
{
  "type": "object",
  "properties": {
    "text": {
      "type": "string",
      "maxLength": 7500,
      "minLength": 1
    },
    "id_columns": {
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 90,
        "minLength": 1
      },
      "maxItems": 12,
      "minItems": 1
    },
    "metric_columns": {
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 90,
        "minLength": 1
      },
      "maxItems": 12,
      "minItems": 1
    }
  },
  "required": [
    "text",
    "id_columns",
    "metric_columns"
  ],
  "additionalProperties": false
}

Open original schema

Published input example

{
  "text": "date,bills,notes,bonds\n2025-09-30,4.187,3.112,3.327\n",
  "id_columns": [
    "date"
  ],
  "metric_columns": [
    "bills",
    "notes",
    "bonds"
  ]
}

Result & documentation

Machine-readable documentation of this hub

Source of this page: the published HALOWERK catalog. Updated: 2026-11-19 UTC.

More endpoints in this hub

All endpoints in this hub โ†’