Skip to content

Notion Plugin returning null Dates (created and last edited work OK) #25

@gigena-git

Description

@gigena-git

Hello! I've recently come across this project and wanted to give it a try to solve an issue I'm working on. So far results have been promising. While testing with a database of mine I observed the following:

According to the notion plugin guide after I import a Notion database into Anyquery, I should see dates with the following format:

  • YYYY-MM-DDTHH:MM:SSZ for single dates.
  • YYYY-MM-DDTHH:MM:SSZ/YYYY-MM-DDTHH:MM:SSZ for double dates.

However, after I connect a database that has two Date property fields, I always get null on the dates. Lets say, when I do:

anyquery - q "SELECT `Review Date`, `Timeline Dates` FROM notion_database;"

I get this as a result:

+-------------+----------------+
| Review Date | Timeline Dates |
+-------------+----------------+
| <null>      | <null>         |
| <null>      | <null>         |
+-------------+----------------+

even though all 4 cells contain non null values. I get the same result whenever I run anyquery -q "SELECT * FROM notion_database;".
It should be noted that both _created_time and _last_edited_time do work ok, since when I run:

anyquery -q "SELECT _created_time, _last_edited_time FROM notion_database;"

I get non-null results:

+----------------------+----------------------+
| _created_time        | _last_edited_time    |
+----------------------+----------------------+
| 2022-08-05T21:32:00Z | 2024-11-13T20:41:00Z |
| 2022-08-05T21:32:00Z | 2024-11-25T18:10:00Z |
+----------------------+----------------------+

I don't know if this is an issue with my database or if I forgot to configure something.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions