Separate data from Notion node (array)

sidney27 · March 19, 2024, 3:40pm

Describe the problem/error/question

I use the n8n in queue mode with the following settings:
1 main
1 postgresql
1 redis
1 rabbitmq
2 workers
Nginx Proxy Manager (reverse proxy)

What is the error message (if any)?

I use Notion to document my infrastructure, with various information.
I want to create a flow that goes through the entire playbook and takes only the text and writes it to a database.
I’m using the Notion node to get some information.
It is returning me a single JSON but with the “blocks” separated.

This is the return of the Notion node.
object list
results
results[0]
results[1]
results[2]
results[3]
next_cursor[null]
has_more false
request_id 28abea4c-c391-4bba-be4b-569aa2edd428

Inside each “results” of these “results[0], results[1], results[2], results[3]” is the data that I want to access individually. I want to get the block ID and use it in the next Notion node to extract the text.
I tried using the loop node, but it sends all the “results” instead of one by one.
How do I resolve this?

If I’m going down the wrong path, please let me know.