Date/DateTime columns not updating via API despite success response

[mpaim]

Hello Seatable community,

I’m having trouble updating Date/DateTime columns via the REST API and would appreciate your help.

What I’m Trying to Do

Update a Date column called assigned_at (type: Date and Time, accurate to minute) in my Messages table using the PUT /rows/ endpoint.

What I’m Sending

PUT https://cloud.seatable.io/api-gateway/api/v2/dtables/{base_uuid}/rows/

{
  "table_name": "Messages",
  "row_id": "CfbbPm8VT8uhlmU9Lmjgpw",
  "row": {
    "assigned_at": "2026-02-25 19:16"
  }
}

What Happens

• API returns: 200 OK {"success": true}
• But the column remains empty in Seatable
• Manual input in the UI works fine (I can type a date and it saves)

What I’ve Tried

Different date formats:

• "2026-02-25 19:16" → Success response, but no update
• "2026-02-25T19:16:00Z" → Success response, but no update
• "2026-02-25T19:16:00" → Success response, but no update

Column recreation:

• Deleted and recreated the column as “Date and Time” type
• Still same issue

Other columns work fine:

• Link columns (via /links/ endpoint) update correctly
• Text columns update correctly
• Only Date/DateTime columns have this problem

Column Configuration

• Type: Date and Time
• Format: ISO (2026-02-25)
• Accurate to: Minute
• Column name: assigned_at

Questions

1. What is the correct datetime format for the PUT /rows/ API?
2. Is there a special requirement for Date/DateTime columns that I’m missing?
3. Could this be a permissions issue even though the API returns success?
4. Do Date/DateTime columns have any special restrictions via API?

Additional Context

• Using Seatable Cloud (cloud.seatable.io)
• All other API operations work correctly
• Using proper authentication (base token)

Any help would be greatly appreciated! Thank you!

[rdb]

Worked like a charm:

Hint: I tested with a test system, but it is running the same version as SeaTable Cloud.

[mpaim]

Hi rdb,
Thanks for checking. Folowing your test, I have found that I was sending:

{
“table_name”: “Messages”,
“row_id”: “XXXXXXm8VT8uhlmU9Lmjgpw”,
“row”: {
“assigned_at”: “2026-02-25 19:30”
}
}

And not the correct one:
{
“table_name”: “Messages”,
“updates”: [
{
“row_id”: “CfbbPm8VT8uhlmU9Lmjgpw”,
“row”: {
“assigned_at”: “2026-02-25 19:30”
}
}
]
}

Now, having updates as an array, as you said, works like a charm.

Your help is very appreaciated. Thanks a lot!

MP