Update row
Update a row in a contact table
curl --request PATCH \
--url https://api.simpu.co/lists/contact/rows/%3Crow_id%3E \
--header 'Authorization: <api-key>' \
--header 'Content-Type: application/json' \
--data '{
"columns": {
"674535b2b39158b9aae90188fcec23ec": "John Doe",
"674535b2b39158b9aae90188fcec23ed": "john@acme.org",
"674535b2b39158b9aae90188fcec23ee": "9291234567"
}
}'
{
"row": {
"id": "674535b2b39158b9aae90188fcec23eb",
"columns": {
"674535b2b39158b9aae90188fcec23ec": "John Doe",
"674535b2b39158b9aae90188fcec23ed": "john@acme.org",
"674535b2b39158b9aae90188fcec23ee": "9291234567"
},
"created_datetime": "2024-06-28T23:56:38.128604+00:00",
"updated_datetime": "2024-06-28T23:56:38.128604+00:00"
},
"table": {
"id": "674535b2b39158b9aae90188fcec23eb",
"columns": [
{
"id": "674535b2b39158b9aae90188fcec23ec",
"name": "name",
"type": "TEXT"
},
{
"id": "674535b2b39158b9aae90188fcec23ed",
"name": "Email",
"type": "EMAIL"
},
{
"id": "674535b2b39158b9aae90188fcec23ee",
"name": "Mobile",
"type": "PHONE NUMBER"
}
],
"created_datetime": "2024-06-28T23:56:38.128604+00:00",
"updated_datetime": "2024-06-28T23:56:38.128604+00:00"
}
}
Authorizations
An API key to authenticate requests
Path Parameters
The unique ID of the row to update
"674535b2b39158b9aae90188fcec23ec"
Body
The data values with column IDs as keys and their corresponding updated data as values.
{
"674535b2b39158b9aae90188fcec23ec": "John Doe",
"674535b2b39158b9aae90188fcec23ed": "john@acme.org",
"674535b2b39158b9aae90188fcec23ee": "9291234567"
}
Response
ID of the row
"674535b2b39158b9aae90188fcec23eb"
Data values for each column in the row
{
"674535b2b39158b9aae90188fcec23ec": "John Doe",
"674535b2b39158b9aae90188fcec23ed": "john@acme.org",
"674535b2b39158b9aae90188fcec23ee": "9291234567"
}
Date and time the Row was created
"2024-06-28T23:56:38.128604+00:00"
Date and time the Row was last updated, if any
"2024-06-28T23:56:38.128604+00:00"
ID of the Table
"674535b2b39158b9aae90188fcec23eb"
List of column names in the table
ID of the column
"674535b2b39158b9aae90188fcec23ec"
Name of the column
"name"
Type of the column
TEXT
, NUMBER
, DATE
, PHONE NUMBER
, EMAIL
, URL
, SELECT
, MULTI SELECT
"TEXT"
[
{
"id": "674535b2b39158b9aae90188fcec23ec",
"name": "name",
"type": "TEXT"
},
{
"id": "674535b2b39158b9aae90188fcec23ed",
"name": "Email",
"type": "EMAIL"
},
{
"id": "674535b2b39158b9aae90188fcec23ee",
"name": "Mobile",
"type": "PHONE NUMBER"
}
]
Date and time the table was created
"2024-06-28T23:56:38.128604+00:00"
Date and time the table was last updated, if any
"2024-06-28T23:56:38.128604+00:00"
curl --request PATCH \
--url https://api.simpu.co/lists/contact/rows/%3Crow_id%3E \
--header 'Authorization: <api-key>' \
--header 'Content-Type: application/json' \
--data '{
"columns": {
"674535b2b39158b9aae90188fcec23ec": "John Doe",
"674535b2b39158b9aae90188fcec23ed": "john@acme.org",
"674535b2b39158b9aae90188fcec23ee": "9291234567"
}
}'
{
"row": {
"id": "674535b2b39158b9aae90188fcec23eb",
"columns": {
"674535b2b39158b9aae90188fcec23ec": "John Doe",
"674535b2b39158b9aae90188fcec23ed": "john@acme.org",
"674535b2b39158b9aae90188fcec23ee": "9291234567"
},
"created_datetime": "2024-06-28T23:56:38.128604+00:00",
"updated_datetime": "2024-06-28T23:56:38.128604+00:00"
},
"table": {
"id": "674535b2b39158b9aae90188fcec23eb",
"columns": [
{
"id": "674535b2b39158b9aae90188fcec23ec",
"name": "name",
"type": "TEXT"
},
{
"id": "674535b2b39158b9aae90188fcec23ed",
"name": "Email",
"type": "EMAIL"
},
{
"id": "674535b2b39158b9aae90188fcec23ee",
"name": "Mobile",
"type": "PHONE NUMBER"
}
],
"created_datetime": "2024-06-28T23:56:38.128604+00:00",
"updated_datetime": "2024-06-28T23:56:38.128604+00:00"
}
}