Happy to say I solved this, been working on it for hours lol. The solution involves a few steps and you'll need a Notion token with access to your workspace or specific database you're writing to.
First, you'll need to parse your multi-select values into a format that produces an array like this in clay:
[{"name":"test"}, {"name":"test2"}]
where "test" and "test2" are the values that will become your multi_select options.
You'll also need a column that corresponds to your notion page id.
Then, instead of using the native 'Update database item' column in notion, make an HTTP API column with the following properties:
{
"properties": {
"NAME OF NOTION PROPERTY": {
"multi_select": {{YOUR ARRAY OF FORMATTED MULTI SELECT VALUES}}
}
}
}You'll also need the following headers:
Content-Type: application/json
Authorization: Bearer YOUR_NOTION_TOKEN
Notion-Version: 2022-06-28
You should receive a 200 response status and the property should have it's multiple values correctly added to it upon a successful run.
.png){kind=logo}
