Collection within an array and trying to map

I am using a canva call to examine the contents of folder. I aggregate this into an array. A typical array elements looks like this

 "array": [
            {
                "design": {
                    "id": "DAGYJMeGaiE",
                    "title": "insta influencer blue tick square",
                    "thumbnail": {
                        "width": 447,
                        "height": 447,
                        "url": "xxx"
                    },
                    "urls": {
                        "edit_url": "xx",
                        "view_url": "xxx"
                    },
                    "created_at": "2024-12-02T12:44:57.000Z",
                    "updated_at": "2024-12-02T13:22:37.000Z",
                    "page_count": 41
                }

What I want is to search this array and find “id” within the collection design, where “title” equals a string variable I have defined. I want to avoid having to loop through the canva direct output as that potentially could be 100s of bundles long.

I have tried a few map options but they are failing. Either I get an empty output or it complains I having selected a valid array.

I suspect the solution lies within get and map but I am really struggling to get my head around those functions

Your map formula would be Map(array ; design.id ; design.title ; (STRING VARIABLE))

1 Like

thank you. Thought I had done that but must have slightly done it different.