The API and date fields

I am trying to create a row via API (using Integromat).

One of the fields is a time field.

I am struggling to populate that field with either a programmatic value or a static value.

I am using the format as per the API docs of HH:mm:ss

image

My value looks like this…
image

Each time I get the error Invalid date in parameter ‘Payment Time’.

Anyone got any experience with this? Or got any suggestions please?

For whatever reason, Integromat requires a date + time when updating a time field. You can use any date, or change your field type to date + time and include the correct date.

Format should be this 01/01/1900 03:16 PM

Tadabase stores the time correctly and ditches the date.

Many thanks @tim.young

You were spot on!

1 Like