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.

Automation

create a sample table
the json is {"name": "alexis", "Number": + 1 [phone], "Address": "987 south street", City: "Atlanta"}
set the row to the json where
    the row number is 1
    the table is the sample table

Results

Name	Number	Address	City
alexis	+ 1 [phone]	987 south street	Atlanta
john	+ 1 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco