Problem copying Notion rich text fields with formatting and hyperlinks using Make

[Clara_Atalis]

Hello,

I am trying a simple schema that watches a Notion database and, when the scenario is met, it copies the relevant rows to another Notion database. The logic works, but I am having trouble with the rich text fields. My main field usually has hyperlinks, and other columns have bolds, etc. I’ve tryed extracting the content+link, the whole text, and the rich_text, but I get weird results like:

{“content”:“International Research Challenge on Women’s Cardiovascular Health - Global Cardiovascular Research Funders Forum (GCRFF)”,“link”:{“url”:“International Research Challenge on Women’s Cardiovascular Health - BHF”}}

or

{“type”:“text”,“text”:{“content”:“International Research Challenge on Women’s Cardiovascular Health - Global Cardiovascular Research Funders Forum (GCRFF)”,“link”:{“url”:“https://www.bhf.org.uk/for-professionals/global-cardiovascular-research-funders-forum/research-funding-competition"}},“annotations”:{“bold”:false,“italic”:false,“strikethrough”:false,“underline”:false,“code”:false,“color”:“default”},“plain_text”:"International Research Challenge on Women’s Cardiovascular Health - Global Cardiovascular Research Funders Forum (GCRFF)”,“href”:“International Research Challenge on Women’s Cardiovascular Health - BHF”}, {“type”:“text”,“text”:{“content”:“(3)”,“link”:null},“annotations”:{“bold”:false,“italic”:false,“strikethrough”:false,“underline”:false,“code”:false,“color”:“default”},“plain_text”:“(3)”,“href”:null}

I understand I might be missing a step, but I can’t figure out which one!

Thanks in advance!

[Simo]

Hello Clara, this may need a custom api call using the “Make an API call” module. Just to check, wouldn’t it be possible for you to do this via a Notion database automation or do you require using Make?