How to append Notion Database Item Content?

[jpfrut]

What are you trying to achieve?

Hi guys. My goal is to get a note from a markdown file and put it in a Notion database page (inside the page, not properties).

Steps taken so far

The steps I have taken so far are the following:

1. Using chatGPT to create a Notion Compatible Block JSON that transforms the note into a Notion compatible JSON.
2. Parse the JSON into a JSON object using a structure that chatGPT recommended to validate the JSON structure.
3. Connect to Notion Append Database Item module where I use the JSON output as input and try to update the page content.

The problem: It worked for 3 notes, and on the fourth it broke and says I have an error regarding “Type”.

Could you please help me out to figure out how to do this?

Screenshots: scenario setup, module configuration, errors

Alpha Library Updater.blueprint.json (355 KB)
JSON Output.txt (26 KB)

[Simo]

Hi Jose,
The JSON output looks good, but I am unsure whether the [ bracket at the start could create issues. When looking at the API documentation, notice how the request body starts with {"children": [ instead of [{"children": [ as in the JSON output attached in your original message.

So, this is one thing you can try to change and see if it solves the issue.
Otherwise, another solution you can try is to use the “Make an API call” module, with the Append Block Children endpoint

[jpfrut]

Hey @Simo , thank you so much for the pointers. I cannot manage to make the body to get the children key wrapper… my Parse JSON is only getting me the array of blocks without the key…

I tried using the API Call module, but it give me the same error…

Then, I tried structuring my Parse JSON to get me all kinds of blocks, but now I get a type validation error, but I am going crazy trying to find the actual error…

[Simo]

Did you eventually solve this as I see my reply was marked as the solution?

[jpfrut]

Hi Simo, thank you so much for the follow up. The API Call worked. Here’s what I did:

The only problem is that the chatGPT that creates the JSON string sometimes hallucinates breaking the scenario… I tried modifying the temperature, P-value and the prompt to help it be more precise, but sometimes a ’ or a “json” text at the beginning will break the scenario flow.