Using Make with Notion and Joomla

How To
1

Hello,

We’re discovering the Notion universe and its possibilities, and we’d like to use it to manage publications on our website and our social networks.

We’ve managed to automate our daily social network posts from our Notion database, but we’re having trouble doing the same thing for our Joomla5 site.

We’re using the ‘Content Calendar’ template on Notion, which allows us to work with several people.

We’ve added properties to the basic ones, and we manage our articles in sub-pages integrated into a record in the base (page). This is how the model works.

Using Make we’re able to retrieve the property data from the main page, but not the content of the embedded sub-pages (if I’ve understood correctly this sub-page is embedded in a content block on Notion).

I don’t know if that’s clear enough :confused:

Is there a way to associate a property with a specific sub-page? That way we could retrieve the text of our articles via Make like any other property.

Or if anyone knows how to retrieve the sub-page content directly, I’d love to hear from you too.

Thanks in advance for any help you can give.

1 Like
3

Hi David,
You can use the “List page contents” module to retrieve the content of Notion pages

4

Hello Simo
Thank you, I will try this

1 Like
5

So I tried but without any conclusive result, or at least I’m stuck.

My first module is “Notion - Search Objects”.
I do a search in my entire database based on a criterion. For my test there’s only one page that matches this search.

I send the result to a “Notion - List Page Contents” module with “Page ID” as the criterion.
So I see the list of everything on the page found (“Bundles”) and I see that what I’m looking for is in “Bundle 7”.

What I then did was to send the result of this second module to a third module “Notion - List page Contents” but between the 2 I put a filter “Bundle order position=7”.

And then I see a list of “Bundles” containing all the content of my page.

But how can I retrieve all this for each part of the “Joomla - Create an article” module?

For example :

  • Bundle1 for "Title
  • Bundle 2 to 113 for "Text
1 Like
6

Very nice progress - that’s the complications of working with page content with the Notion API; each block type has a different data structure, so you need to take that into account.
To your specific question, I don’t know currently, and I can offer some possibilities/thoughts:

  1. Use an array aggregator to bundle blocks of the same type together before mapping them to the correct fied in Joomla
  2. Use routes based on the block type and map to Joomla accordingly
7

Then you’re speaking Chinese to me :sweat_smile:

I didn’t understand the 2 possibilities you mentioned :smirking_face:

1 Like
8

Ahah got it - here is the documentation about the Array Aggregator

1 Like
9

Thank you, I’m going to study all this and hope to understand everything. :sweat_smile:

3 Likes
10

Hello,
I’ve tried but it just doesn’t work…

So I thought I’d try something else.
So I created a new “text” property in Notion in which I put the HTML code of what I want to put in an article.

And it works… only halfway.
The content sent is truncated as soon as there’s an html tag.
The content stops at <a href=".

In my scenario I retrieve the content with this tag :{{1.properties_value.html[].plain_text}}
But I get the same result with {{1.properties_value.html[].text.content}}

Does anyone have any ideas about this limitation?