Hi everyone,
My goal is to have a list of book names out of a Notion DB. I then use an array aggregator to be able to map the name property I need (plain text here as you can see in red below).
I tried to map the book names with several formulas but I haven’t found any way to do it.
According the correct fomula should be this one: {{map(73.array; “properties_value.Name.plain_text”)}}. However, this doesn’t output anything and I don’t understand why:
Can anybody help me on this please? 
Welcome to the Make community!
To allow us to assist you with your scenario, please provide the following:
Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!
Here is the blueprint:
Notion Integration Tools Blueprint.json (74.8 KB)
Here is the output of the array aggregator:
[
{
“array”: [
{
“properties_value”: {
“Files & media”: [
{
“name”: “Integromat”,
“type”: “external”,
“external”: {
“url”: “https://oaidalleapiprodscus.blob.core.windows.net/private/org-GK0LgrWEELfaecgXoZUJgNJB/user-4JD90xJpelG4XD61GBqnhu1w/img-kqA2rUOSKrUuifTDZqZjY1Wm.png?st=2025-02-16T21%3A09%3A07Z&se=2025-02-16T23%3A09%3A07Z&sp=r&sv=2024-08-04&sr=b&rscd=inline&rsct=image/png&skoid=d505667d-d6c1-4a0a-bac7-5c84a87759f8&sktid=a48cca56-e6da-484e-a814-9c849652bcb3&skt=2025-02-16T10%3A54%3A28Z&ske=2025-02-17T10%3A54%3A28Z&sks=b&skv=2024-08-04&sig=AkngJMNFLUMjBQvlE43iubA0mI/NfhO4uzDGJKHkuCA%3D”
}
}
],
“Author”: {
“id”: “277d78bc-eb32-4e01-8ba9-929044d3448d”,
“name”: “Jacques Prévert”,
“color”: “brown”
},
“Année de lecture”: null,
“Tags”: ,
“Status”: {
“id”: “43ee69e0-74de-47d3-8ae2-d3e6864de35d”,
“name”: “In progress”,
“color”: “blue”
},
“Current Page”: 75,
“
Resources”: ,
“Progress”: {
“type”: “number”,
“number”: 0.29
},
“Total Pages”: 256,
“Name”: [
{
“type”: “text”,
“text”: {
“content”: “Paroles de Prévert”,
“link”: null
},
“annotations”: {
“bold”: false,
“italic”: false,
“strikethrough”: false,
“underline”: false,
“code”: false,
“color”: “default”
},
“plain_text”: “Paroles de Prévert”,
“href”: null
}
]
}
},
{
“properties_value”: {
“Files & media”: ,
“Author”: null,
“Année de lecture”: null,
“Tags”: [
{
“id”: “2b2bfab0-9a7e-4699-9f73-517a7e92f870”
}
],
“Status”: {
“id”: “43ee69e0-74de-47d3-8ae2-d3e6864de35d”,
“name”: “In progress”,
“color”: “blue”
},
“Current Page”: 5,
“ Resources”: ,
“Progress”: {
“type”: “number”,
“number”: 0.02
},
“Total Pages”: 290,
“Name”: [
{
“type”: “text”,
“text”: {
“content”: "100 fiches de micro et macro-économique ",
“link”: null
},
“annotations”: {
“bold”: false,
“italic”: false,
“strikethrough”: false,
“underline”: false,
“code”: false,
“color”: “default”
},
“plain_text”: "100 fiches de micro et macro-économique ",
“href”: null
}
]
}
},
{
“properties_value”: {
“Files & media”: [
{
“name”: “9782702168523-001-X.webp”,
“type”: “file”,
“file”: {
“url”: “https://prod-files-secure.s3.us-west-2.amazonaws.com/ad2f2cb2-3f1d-412f-893e-2c1860dc48a3/5a4ef87e-7bf9-49d6-9631-9c5d16ce8c7c/9782702168523-001-X.webp?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB4665DR7GKK5%2F20250225%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20250225T142933Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEA4aCXVzLXdlc3QtMiJHMEUCIFjYsMgxfP4G4yyl9zLDNaiHEZjK7fTXnHwtYDTaBihVAiEA60RH9dhBFNKwUVWANZh2roPejqEWTeF%2BjoCWRdlh7ukq%2FwMIRxAAGgw2Mzc0MjMxODM4MDUiDA7jmbbTq7CffOuU0yrcA4orksEr4N%2BlCKvGdxh198%2F306RpbhRjLTcSppVfGYprhk4tQj0v5qlVKZn7WqzO4zAs%2FLEMUAUdTmhhEf2qXgEHK8C5ckCHyndFuqolGmWYfPfeFOQMP00quQIOJGYur%2FcPAoDsjMRS2miG1g9%2BzNO8LNyDx3ICVYjR9UkY05fIE2scg5p%2B40%2B7mhq6Ay%2BSaWjsR7f53E7xAwKzZbaC3%2BN47X8IyWZtl0KG3pcEnuTUWxRjoguncKAib52AYBtxoTVRNqtiM4lwS3sjN0tcy6rtNOegGschpxMUiLIArerIYs7S5UzhO5ck6rLgkcgkR8P3iBYH0f1fURzumWrBTACHXHQ8kBskfsijp%2Fcs1YWD7IFbVdvq9XmNgVUFj2AQFkjftFTlEe2qru%2FrKzNVLbp0Q0raLb2CG1%2BsfRgiz%2FqD%2FNqK8Ffss%2BiPFrtoHdD3Kwd6%2FPavAzcQeNEgEHSy51Nsf40PjjK8iVOJw2LEW9r7JibgTGQcj%2F4HZ9OLhqzCnipB2Jl3NCE9rgBfc7y4v%2FclRlk0KRUzgcR%2BlfBtwPgCD9%2FBYqDoClR8wpbRKjKj3u%2BRcpvvr%2F4BLD%2FKbEDYM47Z6fwCzDAo%2FZyLBEORoYGbO6SSNHNGEhLXI7v2MJeW970GOqUBpALnKiDeF5cYs%2FaN1XX7ukp71gb3BdGIL0RDRJkzZYkqidjsiUoXQ33MlbDBk6JUvRXDfE8uWf7P2WVfyv7K2BNUBEybZhuwfX4NyMuU8ipONB%2FEh5jV%2B8Tymba3Xt3wl0VEghI25sA225O3dkp6ChmgG98t02ldlq%2FOXs9%2Br14%2F%2Fg%2BpDLeOtAbCdDPVRD5xT5FMxAz9X%2F1m5Cp6NuiQcu7JQwQl&X-Amz-Signature=f0b3d96cae7c822fde50b0d19f26c83e665ed940a24735f77b42e7839551b6d3&X-Amz-SignedHeaders=host&x-id=GetObject”,
“expiry_time”: “2025-02-25T15:29:33.395Z”
}
}
],
“Author”: {
“id”: “19852cb9-5fd4-48c5-90a9-6a8abf85998b”,
“name”: “Greta Thunberg”,
“color”: “gray”
},
“Année de lecture”: null,
“Tags”: [
{
“id”: “fd9bd232-d41e-425c-a83c-665a5acc3b5e”
}
],
“Status”: {
“id”: “43ee69e0-74de-47d3-8ae2-d3e6864de35d”,
“name”: “In progress”,
“color”: “blue”
},
“Current Page”: 3,
“ Resources”: ,
“Progress”: {
“type”: “number”,
“number”: 0.01
},
“Total Pages”: 437,
“Name”: [
{
“type”: “text”,
“text”: {
“content”: “Le Grand Livre du Climat”,
“link”: null
},
“annotations”: {
“bold”: false,
“italic”: false,
“strikethrough”: false,
“underline”: false,
“code”: false,
“color”: “default”
},
“plain_text”: “Le Grand Livre du Climat”,
“href”: null
}
]
}
}
],
“IMTAGGLENGTH”: 3
}
]
Here is the input of the set variable module (I don’t understand why it’s empty 
):
[
{
“scope”: “roundtrip”,
“variables”: [
{
“name”: “Get book names”,
“value”: [
null,
null,
null
]
}
]
}
]
And so here is the output of the set variable module:
[
{
“Get book names”: [
null,
null,
null
]
}
]
When pasting text into this forum, you should format the example text using the rich-text editor, otherwise the forum software might modify the displayed text, and you might get incorrect answers from others because of it.
Some things this forum software might do to mangle your text:
– remove extra spaces (which may be necessary)
– convert links to titles (when copied is incorrect)
– incorrect joined links
– convert single and double quotes to smart angled quotes (“ ”)
– emojis
– etc.
This interferes with you receiving correct answers, because it:
– makes JSON invalid (you can verify your post above if you copy-paste into https://jsonformatter.org)
– makes incorrect text examples when we need to build a pattern for text parsing
These are the two ways to format text so that it won’t be modified by the forum:
Method 1: Type code block manually
Add three backticks ``` before and after the content/bundle, like this:
```
content goes here
```
Method 2. Highlight and click the format button in the editor
Once the post has been submitted, it’s too late to format it since it’s already butchered, and you need to make a re-copy of the text, and format it before submitting the forum post.
Please let us know once you have corrected the issue. This will avoid others potentially providing wrong answers based on incorrect text in your question.
Thank you!
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Yes sorry I realised right after sending my message. Here is the same message but with the code blocks.
Here is the blueprint:
Notion Integration Tools Blueprint.json (74.8 KB)
Here is the output from the array aggregator:
[
{
"array": [
{
"properties_value": {
"Files & media": [
{
"name": "Integromat",
"type": "external",
"external": {
"url": "https://oaidalleapiprodscus.blob.core.windows.net/private/org-GK0LgrWEELfaecgXoZUJgNJB/user-4JD90xJpelG4XD61GBqnhu1w/img-kqA2rUOSKrUuifTDZqZjY1Wm.png?st=2025-02-16T21%3A09%3A07Z&se=2025-02-16T23%3A09%3A07Z&sp=r&sv=2024-08-04&sr=b&rscd=inline&rsct=image/png&skoid=d505667d-d6c1-4a0a-bac7-5c84a87759f8&sktid=a48cca56-e6da-484e-a814-9c849652bcb3&skt=2025-02-16T10%3A54%3A28Z&ske=2025-02-17T10%3A54%3A28Z&sks=b&skv=2024-08-04&sig=AkngJMNFLUMjBQvlE43iubA0mI/NfhO4uzDGJKHkuCA%3D"
}
}
],
"Author": {
"id": "277d78bc-eb32-4e01-8ba9-929044d3448d",
"name": "Jacques Prévert",
"color": "brown"
},
"Année de lecture": null,
"Tags": [],
"Status": {
"id": "43ee69e0-74de-47d3-8ae2-d3e6864de35d",
"name": "In progress",
"color": "blue"
},
"Current Page": 75,
"🖇️ Resources": [],
"Progress": {
"type": "number",
"number": 0.29
},
"Total Pages": 256,
"Name": [
{
"type": "text",
"text": {
"content": "Paroles de Prévert",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Paroles de Prévert",
"href": null
}
]
}
},
{
"properties_value": {
"Files & media": [],
"Author": null,
"Année de lecture": null,
"Tags": [
{
"id": "2b2bfab0-9a7e-4699-9f73-517a7e92f870"
}
],
"Status": {
"id": "43ee69e0-74de-47d3-8ae2-d3e6864de35d",
"name": "In progress",
"color": "blue"
},
"Current Page": 5,
"🖇️ Resources": [],
"Progress": {
"type": "number",
"number": 0.02
},
"Total Pages": 290,
"Name": [
{
"type": "text",
"text": {
"content": "100 fiches de micro et macro-économique ",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "100 fiches de micro et macro-économique ",
"href": null
}
]
}
},
{
"properties_value": {
"Files & media": [
{
"name": "9782702168523-001-X.webp",
"type": "file",
"file": {
"url": "https://prod-files-secure.s3.us-west-2.amazonaws.com/ad2f2cb2-3f1d-412f-893e-2c1860dc48a3/5a4ef87e-7bf9-49d6-9631-9c5d16ce8c7c/9782702168523-001-X.webp?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB4665DR7GKK5%2F20250225%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20250225T142933Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEA4aCXVzLXdlc3QtMiJHMEUCIFjYsMgxfP4G4yyl9zLDNaiHEZjK7fTXnHwtYDTaBihVAiEA60RH9dhBFNKwUVWANZh2roPejqEWTeF%2BjoCWRdlh7ukq%2FwMIRxAAGgw2Mzc0MjMxODM4MDUiDA7jmbbTq7CffOuU0yrcA4orksEr4N%2BlCKvGdxh198%2F306RpbhRjLTcSppVfGYprhk4tQj0v5qlVKZn7WqzO4zAs%2FLEMUAUdTmhhEf2qXgEHK8C5ckCHyndFuqolGmWYfPfeFOQMP00quQIOJGYur%2FcPAoDsjMRS2miG1g9%2BzNO8LNyDx3ICVYjR9UkY05fIE2scg5p%2B40%2B7mhq6Ay%2BSaWjsR7f53E7xAwKzZbaC3%2BN47X8IyWZtl0KG3pcEnuTUWxRjoguncKAib52AYBtxoTVRNqtiM4lwS3sjN0tcy6rtNOegGschpxMUiLIArerIYs7S5UzhO5ck6rLgkcgkR8P3iBYH0f1fURzumWrBTACHXHQ8kBskfsijp%2Fcs1YWD7IFbVdvq9XmNgVUFj2AQFkjftFTlEe2qru%2FrKzNVLbp0Q0raLb2CG1%2BsfRgiz%2FqD%2FNqK8Ffss%2BiPFrtoHdD3Kwd6%2FPavAzcQeNEgEHSy51Nsf40PjjK8iVOJw2LEW9r7JibgTGQcj%2F4HZ9OLhqzCnipB2Jl3NCE9rgBfc7y4v%2FclRlk0KRUzgcR%2BlfBtwPgCD9%2FBYqDoClR8wpbRKjKj3u%2BRcpvvr%2F4BLD%2FKbEDYM47Z6fwCzDAo%2FZyLBEORoYGbO6SSNHNGEhLXI7v2MJeW970GOqUBpALnKiDeF5cYs%2FaN1XX7ukp71gb3BdGIL0RDRJkzZYkqidjsiUoXQ33MlbDBk6JUvRXDfE8uWf7P2WVfyv7K2BNUBEybZhuwfX4NyMuU8ipONB%2FEh5jV%2B8Tymba3Xt3wl0VEghI25sA225O3dkp6ChmgG98t02ldlq%2FOXs9%2Br14%2F%2Fg%2BpDLeOtAbCdDPVRD5xT5FMxAz9X%2F1m5Cp6NuiQcu7JQwQl&X-Amz-Signature=f0b3d96cae7c822fde50b0d19f26c83e665ed940a24735f77b42e7839551b6d3&X-Amz-SignedHeaders=host&x-id=GetObject",
"expiry_time": "2025-02-25T15:29:33.395Z"
}
}
],
"Author": {
"id": "19852cb9-5fd4-48c5-90a9-6a8abf85998b",
"name": "Greta Thunberg",
"color": "gray"
},
"Année de lecture": null,
"Tags": [
{
"id": "fd9bd232-d41e-425c-a83c-665a5acc3b5e"
}
],
"Status": {
"id": "43ee69e0-74de-47d3-8ae2-d3e6864de35d",
"name": "In progress",
"color": "blue"
},
"Current Page": 3,
"🖇️ Resources": [],
"Progress": {
"type": "number",
"number": 0.01
},
"Total Pages": 437,
"Name": [
{
"type": "text",
"text": {
"content": "Le Grand Livre du Climat",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Le Grand Livre du Climat",
"href": null
}
]
}
}
],
"__IMTAGGLENGTH__": 3
}
]```
Here is the input of the set variable module (I don’t understand why it’s empty ):
[
{
"scope": "roundtrip",
"variables": [
{
"name": "Get book names",
"value": [
null,
null,
null
]
}
]
}
]
And so here is the output of the set variable module:
[
{
"Get book names": [
null,
null,
null
]
}
]
I hope everything is in a correct format now 
Hey @samliew ! Have you been able to have a look at my problem? I still haven’t been able to solve it 
Best,
Gauthier
You’ll need to add a “1.” because “Names” is an array, and you want to get the first book name of the book.
{{ map(3.array; "properties_value.Name.1.plain_text") }}
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
hi @samliew,
I already tried this solution and I just realised that it didn’t work cause I mapped the word “propierties” instead of properties 
Sorry for making you loose time and thanks a lot for taking the time to help me 
