Set a Row to JSON

Updates a row in the table using values from a JSON object.

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.

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

Last updated

Was this helpful?