How to write return value to table columns?


I’m facing some challenges in my automation process. I’m using a bot to perform a webhook get, and I expect to write the return value from an external database into specific columns of a designated table.

If the returned value looks like this:
{
“data”:
[
{“package_id”: “1”, “quantity”: 20, “name”: “Sam”},
{“package_id”: “2”, “quantity”: 25, “name”: “Max”},
{“package_id”: “3”, “quantity”: 10, “name”: “Ken”}
]
}

For the next step, should I choose “Run a data action: add new rows”? How do I fill in the expressions in the column fields to sequentially write multiple array data into the table?



Source link

Leave a Comment