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?