# Set a Row to JSON

### Overview

This procedure updates a row in the table using values from a JSON object. It's a way to update a table with data in JSON format, such as that from an API response or another part of your automation.

### Input Concepts

| Concept      | Type   | Description                                                                          | Default    | Required |
| ------------ | ------ | ------------------------------------------------------------------------------------ | ---------- | -------- |
| `row number` | number | Row number of the row to update (1-based). It is specified with the `where` keyword. | No default | Yes      |
| `json`       | dict   | The JSON object containing the new values.                                           | No default | Yes      |

### Output Concepts

| Concept | Description        |
| ------- | ------------------ |
| `table` | The updated table. |

### Examples

#### 1. Set the Row to the JSON

In this example, the first row is set to the JSON.

{% tabs %}
{% tab title="Automation" %}

```
create a sample table
the json is {"name": "alexis", "Number": + 1 (415) 998 7742, "Address": "987 south street", City: "Atlanta"}
set the row to the json where
    the row number is 1
    the table is the sample table
```

{% endtab %}

{% tab title="Results" %}

| Name          | Number             | Address          | City          |
| ------------- | ------------------ | ---------------- | ------------- |
| alexis        | + 1 (415) 998 7742 | 987 south street | Atlanta       |
| john          | + 1 (415) 691 9426 | 123 east street  | San Francisco |
| joe           | + 1 (415) 691 1234 | 321 west street  | San Jose      |
| jack          | + 1 (415) 691 4595 | 213 north street | San Francisco |
| {% endtab %}  |                    |                  |               |
| {% endtabs %} |                    |                  |               |