---
title: "Explode the column with JSON"
method: POST
path: "/explode-json/{handle}/{column}"
tags: ["data"]
---

# Explode the column with JSON

`POST /explode-json/{handle}/{column}`

This endpoint extracts all keys in the request from JSON in the given column and adds a new column for each. If there was no key provided it will proceed with the most common keys up to 2000.

## Path parameters

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

## Request body

- ExplodejsonRequest
  - `indices` integer[]
  - `keys` string[]

## 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)