Hi all,
if you want to update a notion database item text property field you may hit this error, becasue there is a 2000 character limit for rich text fields:
[400] body failed validation: body.properties.Newsletter.rich_text[0].text.content.length should be ≤ `2000`, instead was `3704`.
I created a solution - the text has to be split down into a collection of shorter rich text elements. Just want to share it with the community:
Blueprint attached incl. notes. You can use this as a subscenario.
Cheers, Stefan
Notion update property - long text.blueprint.json (13.8 KB)
3 Likes
Hi @stefanmueller.ai, this is great! I’m surprise this does not get more love from the community.
I have a small tweak, as I ran into issues when the string wasn’t longer than 2000 characters. The repeater appended an {"type": "text", "text": {"content": null, "link": null}} at the end of text aggregator, and the "content": null gave an errror in Notion API call.
My solution: add a simple text parser that will replace the problematic string, only in the case that the repeater “runs empty”, see image: