How to change the value of a property in a database row? about notion-sdk-php

[mariosimao]

Sorry for the delay, I have been quite busy lately.

First of all, it is necessary to understand that database rows on Notion are essentially pages where the parent is the database.

Add a row to a database

<?php

require "vendor/autoload.php";

$token = "your_secret_here";
$notion = \Notion\Notion::create($token);

$databaseId = "your_database_id_here";
$parent = \Notion\Pages\PageParent::database($databaseId);

$title    = \Notion\Pages\Properties\Title::create("Superbad");
$release  = \Notion\Pages\Properties\Date::create(new DateTimeImmutable("2007-10-19"));
$category = \Notion\Pages\Properties\Select::fromName("Comedy")
    ->withColor(\Notion\Pages\Properties\Option::COLOR_BROWN);

$page = \Notion\Pages\Page::create($parent)
    ->withAddedProperty("Title", $title)
    ->withAddedProperty("Release date", $release)
    ->withAddedProperty("Category", $category);

$notion->pages()->create($page);

Before:

After:

Change the value of a property

<?php

require "vendor/autoload.php";

$token = "your_secret_here";
$notion = \Notion\Notion::create($token);

$pageId = "your_page_id_here";
$page = $notion->pages()->find($pageId);

$updatedRelease = \Notion\Pages\Properties\Date::create(new DateTimeImmutable("2008-11-04"));
$updatedPage = $page->withAddedProperty("Release date", $updatedRelease);

$notion->pages()->update($updatedPage);

Before:

After:

Since there are no examples of adding rows to a database and updating properties, I will leave this issue open.

Thanks for your feedback!

[mariosimao]

Documentation is available on v0.6.2

• https://mario.engineering/notion-sdk-php/how-to/add-row-to-database.html
• https://mario.engineering/notion-sdk-php/how-to/update-a-page.html#update-properties