how to write to a page with "Date" parameters from a string in dd/mm/yyyy hh:mm:ss?

[albertlau128]

I wish to populate the record with a property list, but how should this property be coded?
What I have:

{'Message time': {
"type": "date",
"date": datum,
},}

but the API refuses to allow this. I have a datetime object datum, a string in dd/mm/yyyy HH:mm:ss readily available too.

[ramnes]

A datetime object won't work, you have to transform it to something that's friendlier to JSON (for now).

Also, Notion expects a JSON object as a value for date, so your datum variable has to be a dictionary, e.g.:

{"start": "2021-05-11T11:00:00.000-04:00"}

Have a look at the documentation (and its examples) here to see what kind of format Notion expects: https://developers.notion.com/reference/property-value-object#date-property-values

Hope that helps!

[albertlau128]

Thanks heaps @ramnes

[jg33]

heya- great work with the package! It's coming in really handy on the project I'm working on!

I'm having some trouble handling dates coming in from Notion. It seems like it's having difficulty parsing the response. I'm creating the page with:

    notion_client.pages.create(**{
        "parent": {
            "type": "database_id",
            "database_id": main_db_id
        },
        "properties": {
            "Body":{
                "title":[
                    {"text":{
                        "content": new_text
                    }
                    }
                ]
        },
           "Status": {
               "select": {
                   "name": SubmissionStatus.QUEUED.value[0]
               }

           },
            "Submitted": {
                "date": {"start": "2021-05-11T11:00:00.000-04:00"}
            }
       }}
    )

It works fine if I don't include the Submitted (date) property, but it fails to parse it whenever I do. I also get the same error when I query a db and get page back that has a date property attached.

The above date in the example is just to demonstrate I used your recommended format. I also tried datetime.now().isoformat(), also to no avail.

Any thoughts? Thanks again!

[ramnes]

What's the error?

[jg33]

 ...........
File "/Users/jesse/PycharmProjects/unfinishedLive/venv/lib/python3.8/site-packages/notion/endpoints/sync.py", line 94, in query
    return PaginatedList[Page].parse_obj(
  File "pydantic/main.py", line 521, in pydantic.main.BaseModel.parse_obj
  File "pydantic/main.py", line 341, in pydantic.main.BaseModel.__init__
pydantic.error_wrappers.ValidationError: 32 validation errors for PaginatedList[Page]
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.TITLE: 'title'> (type=value_error.const; given=date; permitted=[<PropertyValueType.TITLE: 'title'>])
results -> 0 -> properties -> Submitted -> title
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.RICH_TEXT: 'rich_text'> (type=value_error.const; given=date; permitted=[<PropertyValueType.RICH_TEXT: 'rich_text'>])
results -> 0 -> properties -> Submitted -> rich_text
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.NUMBER: 'number'> (type=value_error.const; given=date; permitted=[<PropertyValueType.NUMBER: 'number'>])
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.SELECT: 'select'> (type=value_error.const; given=date; permitted=[<PropertyValueType.SELECT: 'select'>])
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.MULTI_SELECT: 'multi_select'> (type=value_error.const; given=date; permitted=[<PropertyValueType.MULTI_SELECT: 'multi_select'>])
results -> 0 -> properties -> Submitted -> multi_select
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> date -> start
  invalid date format (type=value_error.date)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.FORMULA: 'formula'> (type=value_error.const; given=date; permitted=[<PropertyValueType.FORMULA: 'formula'>])
results -> 0 -> properties -> Submitted -> formula
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.ROLLUP: 'rollup'> (type=value_error.const; given=date; permitted=[<PropertyValueType.ROLLUP: 'rollup'>])
results -> 0 -> properties -> Submitted -> rollup
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.PEOPLE: 'people'> (type=value_error.const; given=date; permitted=[<PropertyValueType.PEOPLE: 'people'>])
results -> 0 -> properties -> Submitted -> people
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.FILES: 'files'> (type=value_error.const; given=date; permitted=[<PropertyValueType.FILES: 'files'>])
results -> 0 -> properties -> Submitted -> files
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.CHECKBOX: 'checkbox'> (type=value_error.const; given=date; permitted=[<PropertyValueType.CHECKBOX: 'checkbox'>])
results -> 0 -> properties -> Submitted -> checkbox
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.URL: 'url'> (type=value_error.const; given=date; permitted=[<PropertyValueType.URL: 'url'>])
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.EMAIL: 'email'> (type=value_error.const; given=date; permitted=[<PropertyValueType.EMAIL: 'email'>])
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.PHONE_NUMBER: 'phone_number'> (type=value_error.const; given=date; permitted=[<PropertyValueType.PHONE_NUMBER: 'phone_number'>])
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.CREATED_TIME: 'created_time'> (type=value_error.const; given=date; permitted=[<PropertyValueType.CREATED_TIME: 'created_time'>])
results -> 0 -> properties -> Submitted -> created_time
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.CREATED_BY: 'created_by'> (type=value_error.const; given=date; permitted=[<PropertyValueType.CREATED_BY: 'created_by'>])
results -> 0 -> properties -> Submitted -> created_by
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.LAST_EDITED_TIME: 'last_edited_time'> (type=value_error.const; given=date; permitted=[<PropertyValueType.LAST_EDITED_TIME: 'last_edited_time'>])
results -> 0 -> properties -> Submitted -> last_edited_time
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  unexpected value; permitted: <PropertyValueType.LAST_EDITED_BY: 'last_edited_by'> (type=value_error.const; given=date; permitted=[<PropertyValueType.LAST_EDITED_BY: 'last_edited_by'>])
results -> 0 -> properties -> Submitted -> last_edited_by
  field required (type=value_error.missing)
results -> 0 -> properties -> Submitted -> type
  value is not a valid dict (type=type_error.dict)
results -> 0 -> properties -> Submitted -> files
  field required (type=value_error.missing)

[ramnes]

We don't use pydantic so the error most likely comes from somewhere else. :)