-
Notifications
You must be signed in to change notification settings - Fork 113
Notion Plugin returning null Dates (created and last edited work OK) #25
Description
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:SSZfor single dates.YYYY-MM-DDTHH:MM:SSZ/YYYY-MM-DDTHH:MM:SSZfor 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.