René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Issue parsing dates","articleBody":"Hi! Reading `date` columns throws multiple warnings. \r\n\r\nConsider the following table with a couple empty (`None`) rows:\r\n\r\n```\r\n                my_date\r\n0  2021-12-01T00:00:00Z\r\n1  2021-12-01T00:00:00Z\r\n2                  None\r\n3                  None\r\n4                  None\r\n```\r\n\r\nFetching the `my_date` column throws two types of warnings:\r\n\r\n```python\r\n\u003e\u003e\u003e base.query('SELECT my_date FROM MyTable')\r\n[Warning] format date: Invalid isoformat string: '2021-12-01T00:00:00Z'\r\n[Warning] format date: Invalid isoformat string: '2021-12-01T00:00:00Z'\r\n[Warning] format date: fromisoformat: argument must be str\r\n[Warning] format date: fromisoformat: argument must be str\r\n[Warning] format date: fromisoformat: argument must be str\r\n\r\n[{'my_date': '2021-12-01T00:00:00Z'},\r\n {'my_date': '2021-12-01T00:00:00Z'},\r\n {'my_date': None},\r\n {'my_date': None},\r\n {'my_date': None}]\r\n```\r\n\r\n1. Invalid isoformat string:\r\n\r\nThe culprit for this appears to be this line:\r\n\r\nhttps://github.com/seatable/seatable-api-python/blob/992214166a8b52b6838ffcb9f3ae184731448227/seatable_api/utils.py#L139 \r\n\r\nApparently, `datetime.fromisoformat` does not like the trailing `Z` (see [this](https://stackoverflow.com/questions/19654578/python-utc-datetime-objects-iso-format-doesnt-include-z-zulu-or-zero-offset) post on stack overflow): \r\n\r\n2. Argument must be a str:\r\n\r\nThe problem here is that the same try/except block as above does not cater for empty rows. \r\n\r\nThese issues are obviously not show stoppers but since each row will cause a warning (that can't be suppressed because it's a `print` statement) this becomes really annoying for longer tables. \r\n\r\nOn a general note: Is that implicit (re-)formatting strictly necessary? For example, I'm typically converting data into `pandas` data frames anyway and `pandas.to_datetime()` has no issues with the full string - even parses the correct time zone:\r\n\r\n```python\r\n\u003e\u003e\u003e pd.to_datetime('2021-12-01T00:00:00Z')\r\nTimestamp('2021-12-01 00:00:00+0000', tz='UTC')\r\n```\r\n\r\nFYI: This is with `seatable_api` version `2.5.1`.\r\n\r\nI also have a separate question on writing dates to SeaTable: I've tried writing a timestamp back to the table (via batch update) and it appears as if for iso-formatted strings (e.g. `2021-12-01T11:00:05Z`) the date is correct ingested but the time is dropped. Can you tell me what the expected format is?\r\n\r\nThanks,\r\nPhilipp","author":{"url":"https://github.com/schlegelp","@type":"Person","name":"schlegelp"},"datePublished":"2021-12-14T16:08:45.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/53/seatable-api-python/issues/53"}