Glide Datetime sync to Gsheets issue

Ask for Help
1

I noticed when I use the Glide API to send in a Datetime, it adds the row to gsheets with a singlequote char at the beginning of the cell.

curl --request POST 'https://api.glideapp.io/api/function/mutateTables' \
    --header 'Content-Type: application/json' \
    --header 'Authorization: Bearer [redacted]' \
    --data-raw '{
    "appID": "[redacted]",
    "mutations": [
        {
            "kind": "add-row-to-table",
            "tableName": "TableName",
            "columnValues": {
                "Datetime": "2022/01/09 12:04:43"
            }
        }
    ]
}'

Becomes this in gsheets: '2022/01/09 12:04:43

How can I avoid having this singlequote char show up in gsheets?

2

Are you filling a date/time column, or a text column?

3

Datetime column.

4

I’m not familiar with using the glide api’s, but it appears that you are passing the date/time as a string. If possible, you may need to pass it in a date format. Sorry, can’t really help much beyond that.

@Mark_Turrell and/or @Darren_Murphy may have more experience with that.

5

I use integromat mostly to write back to Glide and I don’t have this problem with time stamps. I format time as YYYY-MM-DD HH:mm always too. Also have you tried with another column first, in case it’s getting confused when it writes in a row… otherwise not sure!

1 Like
6

I agree!

That single quote char means that the cell value must be treated as Text. It’s a MS Excel legacy.

JSON does not have this kind of data type (Date) so, it must be transformed to Text to be sent.

Saludos a todos!

2 Likes
7

In my experience, any time you see timestamps appearing as strings in the Google Sheet, it inevitably means that the associated column in Glide isn’t correctly configured as a Datetime type.

So that’s the first thing I would check. Edit the column in the GDE and ensure that it’s correctly set as a datetime type.

Note that just eyeballing the column header is not good enough. Sometimes you’ll see the calendar icon next to the column name that indicates a datetime type, but when you edit the column, you’ll find that the column has a type of ‘None’. This only ever happens if the column was originally created in the Google Sheet and then synced to Glide. It would never happen if the column was created in the GDE.

3 Likes
8

When passing dates to Integromat, I sometimes use parsedate() in Integromat to get the date to function properly with GSheet.