Update statement
Update data without writing any code
Update
{
"type": "sql-update",
"id": "order-set-status-update",
"connection": "sample-database-connection",
"table": "order",
"whereCondition": "`id` = :id",
"params": [
{
"column": "status",
"name": "status",
"type": "string",
"required": true
},
{
"name": "id",
"type": "int",
"column": "id",
"required": true
},
{
"name": "createdAt",
"column": "created_at",
"sqlValue": "NOW()"
}
]
}
sqlValue - use database specific values
whereCondition - update conditions