Need help retrieving Array-type information from a Notion CRM

Hello everyone,

I’m having difficulties retrieving certain information from a Notion database in a Make scenario.

  1. Filter on a “Selection” field from an aggregation
    I want to add a filter when the “Selection” field contains the value “CAF”. However, since “CAF” is an aggregation, it appears that this information is stored as an Array.
    How can I correctly retrieve and filter this data?


  1. Retrieving the email address from an aggregation
    Next, I would like to extract the email address from another database to add it as a recipient. As with the first point, this information is also stored as an Array. I assume that solving the first issue will help resolve this one as well.

Thank you in advance for your help and advice!

Best regards,
Baptiste

Hello @Baptiste1! Welcome to the Make Community!

In fact, these two fields are a collection that contain an “array” field. But from you screenshots, we can’t see how it’s provided by Notion. Can you please send a screenshot of the Output of your Notion module? Hiding any PII of course.

Benjamin

Hello Benjamin,

Thank you very much for your response. In the meantime, I managed to find the solution. It turns out I hadn’t selected the correct data, but everything is working perfectly now.

Thanks again for your help!

Baptiste

1 Like