# Convert JSONs to Table

### Overview

Converts a specified non-empty JSON array of objects (or single object) into a table. This is a specialized conversion procedure for JSON data that explicitly creates tables from JSON arrays.

### Syntax

```
convert the jsons to a table
```

### Parameters

* **jsons** (required): A JSON array of objects or a single JSON object to be converted into a table.

### Returns

A table where:

* Each object in the array becomes a row
* Object keys become column names
* Object values become cell values

### Examples

#### 1. Convert Simple JSON Array to Table

```
the foos is "[ { \"a\": 1, \"b\": 2 }, { \"a\": 10, \"b\": 20 } ]"
the foos is a json
convert the foos to a table
```

**Result**: Table with columns "a" and "b"

| a  | b  |
| -- | -- |
| 1  | 2  |
| 10 | 20 |

#### 2. Convert JSON with Nested Objects

```
the foos is [
    {"name": "Obj 0", "val": {"bar": "baz"}, "arr": [0, 1, 2]},
    {"name": "Obj 1", "val": {"bar": "busy"}, "arr": [1, 2, 3]},
    {"name": "Obj 2", "val": {"bar": "booze"}, "arr": [2, 3, 4]}
]
the foos is a json
convert the foos to a table
```

**Result**: Table preserving nested structures

| name  | val              | arr        |
| ----- | ---------------- | ---------- |
| Obj 0 | {"bar": "baz"}   | \[0, 1, 2] |
| Obj 1 | {"bar": "busy"}  | \[1, 2, 3] |
| Obj 2 | {"bar": "booze"} | \[2, 3, 4] |

#### 3. Round-Trip Conversion

```
the foos is [
    {"name": "Obj 0", "val": "val 0"},
    {"name": "Obj 1", "val": "val 1"},
    {"name": "Obj 2", "val": "val 2"}
]
convert the foos to a table
convert the table to a json
```

**Result**: Original JSON structure preserved

#### 4. Single JSON Object

```
the person is {"name": "Alice", "age": 30, "city": "NYC"}
convert the person to a table
```

**Result**: Single-row table

| name  | age | city |
| ----- | --- | ---- |
| Alice | 30  | NYC  |

#### 5. Complex JSON from External Source

```
the results are [
    {
        "Customer": "TTX Company Inc. Chicago - IL EDI-WHL",
        "Shop Name": "Corporate",
        "Invoice Date": "",
        "InvoiceId": "",
        "Sales ID #": "",
        "Current Balance": -9671.33
    },
    {
        "Customer": "TTX Company Inc. Chicago - IL EDI-WHL",
        "Shop Name": "Corporate Total",
        "Invoice Date": None,
        "InvoiceId": None,
        "Current Balance": -9671.33
    }
]
get the results as a json
convert the results to a table
```

**Result**: Table with all fields, None/null values preserved