API v2 - Update Row - Clear value

Ask for Help
1

Hi

Im using Big Tables, API v2, Update Row - Glide API Docs

I have a column “vhCd1” thats a date. “vhCd1” on row 1 has value 2025-08-15T14:25:00.000Z

How do i set this values as empty / clear this value - I have tried:

  • “vhCd1”:””
  • “vhCd1”:null
  • “vhCd1”:undefined

If i send a new value “vhCd1”:”2025-09-23T13:03:15.000Z” it updates correctly, but i cant figure out how to clear the value.

2

Maby a bug?

3

Maybe just send a space over, that’ll clear the column up leaving it as a space value. if you filter by it’s empty it won’t pull it though.

{
“columnName“:” “
}

4

Tried, getting Error / wrong format

5

How are you calling the api? Using no-code tools like n8n or make.com?

6

Postman (when testing). Else Glide API or sometimes Apps Script.

7

It might be helpful to open a support ticket from within the app.

1 Like
8

Is there anyone who can verify behavior?

It’s a simple setup.

  1. Create App
  2. Created Big table, with a column “Time & Date”.
  3. Set column Time & Date (in row 1) to value to 2025-09-23T13:03:15.000Z
  4. Via API v2 PATCH , try to set value to ““.
9

Yep I am having this same issue I can’t clear a column with the api v2 patch method, tried passing either null or ““ and it won’t clear – at the moment I’m just passing “null” but not ideal

10

Yeah, im using same workaround. For my Time & Date column (named Date), i send “1900-01-01T00:00:00.000Z” if i need it to be cleared.

And then i have an “If column” name “Fix API Date” with If Date = 1900-01-01T00:00:00.000Z: ““, else: Date.