---
title: "Explode the column with an array into multiple rows"
method: POST
path: "/unroll-delimited-column/{handle}/{column}"
tags: ["data"]
---

# Explode the column with an array into multiple rows

`POST /unroll-delimited-column/{handle}/{column}`

Explodes the arrays in a column into multiple rows. Each element of the array creates a new record. All other fields are kept.

## Path parameters

- `handle` string, required
- `column` string, required

## Request body

- ExplodearrayRequest
  - `numSkipEnd` integer — Optional number of characters to skip at end
  - `numSkipStart` integer — Optional number of characters to skip at beginning
  - `splitBy` string, required — Separator

## Response `200`

OK

- unknown

## Other responses

- `400` — Bad Request
- `500` — Internal Server Error

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/versions/d1e5cbb24557/schema)